Schema | Description | Tables |
---|---|---|
Raw | Raw blockchain data for Solana. | blocks, transactions, instructions, inner_instructions, rewards |
Decoded | Decoded instructions | instructions |
Assets | Token transfers and credit debit of spl-tokens and native SOL. | transfers, credit_debit, spl_token_balances, sol_balances |
NFTs | NFT trades coverage of major marketplaces and NFT mints data. | trades, mints |
DEXs | DEX trades and aggregator trades on Solana. Coverage includes 10+ major DEXs and multiple protocols. | trades, aggregator_trades |
DeFi | DeFi related protocols including loans, rewards and farms | farms, fees_claimed, lending, lending_tvl, lending_tvl_daily, rewards_claimed |
_w_tx_cols
(e.g. solana.assets.transfers_w_tx_cols
). These are views that combine the enriched data (i.e. transfers) with a couple of transaction-level columns which may be useful for certain analyses. The additional columns are:
Column Name | Description | Type | Example |
---|---|---|---|
tx_base_fee | the base fee paid for the transaction | number | 5000 |
tx_priority_fee | the priority fee paid for the transaction, if any | number | 500 |
tx_total_fee | the total fee paid for the transaction, equivalent to fee column in solana.raw.transactions | number | 5500 |
tx_account_keys | account keys involved in the transaction, equivalent to account_keys column in solana.raw.transactions | variant | [{ "pubkey": "Bp9ok7LoJvBmBfGWEWznL4SD1rMqBQqLzTDbAZVkM92f", "signer": true, "source": "transaction", "writable": true }] |
tx_mint_to_decimals | a dictionary mapping mint address to mint decimal. parsed from pre/post_token_balances in solana.raw.transactions | variant | { "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v": 6, "Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB": 6, "So11111111111111111111111111111111111111112": 9 } |
tx_token_accounts | a dictionary mapping token accounts to details obtained from pre/post_token_balances in solana.raw.transactions . changed_owner is true when the token account appears in both pre & post token balances and has changed. new_account is true when it appears only in post balances. | variant | { "55v6gEq8A342WZSRfycnud9W8fBkKpr6BwnW86GV1YQU": { "changed_owner": false, "decimals": 6, "mint": "jXP7pRyfGgyYhNyu95q1QPWpkMSQ7euBF1ByJJrpump", "new_account": false, "owner": "2ej18rDtQ7nb6BiezjM9vFfotZ7WE6eGKswrWqbWFKCn", "post_amount": "0", "post_owner": "2ej18rDtQ7nb6BiezjM9vFfotZ7WE6eGKswrWqbWFKCn", "pre_amount": "0", "pre_owner": "2ej18rDtQ7nb6BiezjM9vFfotZ7WE6eGKswrWqbWFKCn" } } |
tx_sol_amounts | a dictionary mapping accounts to details about their native SOL balance, obtained from pre/post_balances in solana.raw.transactions | variant | { "24tza9jGvvSwL8HEfkjnrL3vUxBukaF6Uj1ufXTu3Hif": { "post_amount": 2039280, "pre_amount": 2039280 }, "5SEpbdjFK5FxwTvfsGMXVQTD2v4M2c5tyRTxhdsPkgDw": { "post_amount": 81771454520, "pre_amount": 81771454520 } } |