Sharky

Borrow and lend against your NFTs Instantly.

sharkyfi.txns

This table has similar schema as of Solana transactions table

sharkyfi.parsed

The table contains the parsed instructions data for sharky. Data related to instruction type, executing account, account arguments, arguments, etc. is available here.

Column Name	Column Type	Description
block_date	date	Event date
block_time	timestamp	The (estimated) time this block was produced
block_slot	bigint	This block’s slot index in the ledger
dapp	string	Solana program address
inner_instruction_index	int	The order of inner instruction of an instruction in a txns
input_accounts	array<string>	Ordered list of accounts to pass to the program
instruction_index	int	The order of the instruction in a txns
instruction_type	string	Name of the function of a Solana program invoked via an instruction
is_inner_instruction	boolean	Whether the respective instruction of a txns has an inner instruction
tx_id	string	The first signature in the transaction
args	<STRUCT>	The arguments passed to the invoked function. Generated after decoding the instructions data parameter

Some columns in the above table needs to be explained a bit for better understanding. Let's go into what each one of them contains.

input accounts

Field	Column Type
associatedTokenProgram	string
authority	string
borrower	string
borrowerCollateralAccount	string
collateralMint	string
collector	string
escrow	string
escrowCollateralTokenAccount	string
escrowTokenAccount	string
feeAuthority	string
instructionSysvarAccount	string
issuer	string
issuerCollateralTokenAccount	string
lender	string
lenderCollateralAccount	string
lenderValueTokenAccount	string
loan	string
metadata	string
mintCounter	string
mplTokenMetadataProgram	string
newEscrow	string
newEscrowCollateralTokenAccount	string
newLender	string
newLoan	string
nftList	string
orderBook	string
payer	string
programVersion	string
rent	string
systemProgram	string
tokenManager	string
tokenManagerProgram	string
tokenManagerTokenAccount	string
tokenProgram	string
valueMint	string

args

Field	Data Type
orderBookType	<STRUCT>
apy	<STRUCT>
loanTerms	<STRUCT>
feePermillicentage	int
feeAuthority	string
escrowBump	int
principalLamports	int
termsChoice	<STRUCT>
expectedLoan	string
nftListIndex	int
editionNumber	int
isProgrammable	bool
isCollateralFrozen	bool
collectionName	string
mints	<STRUCT>
version	int

orderBookType

Field	Data Type
name	string
fields	<STRUCT>

fields

Field	Data Type
collection_key	string
list_account	<STRUCT>

apy

Field	Data Type
name	string
fields	<STRUCT>

fields

Field	Data Type
apy	int

loanTerms

Field	Data Type
name	string
fields	<STRUCT>

fields

Field	Data Type
terms	<STRUCT>

terms

Field	Data Type
name	string
fields	<STRUCT>

fields

Field	Data Type
duration	string

termsChoice

Field	Data Type
name	string
fields	<STRUCT>

fields

Field	Data Type
duration	string

mints

Field	Data Type
index	int
mint	string