Solana
Overview
Allium currently supports Solana data from the Genesis block.
Our Solana data schemas include NFTs, DEXs and assets (transfers/credit debit) data. Support for additional verticals and programs can be made available upon request.
More about the Solana blockchain.
Solana Tables
Our Solana data includes the following schemas and tables:
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_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 |
Transaction-level columns
Some of the datasets have a variant suffixed with _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, false otherwisenew_account is true when the token account appears only in post token balances, false otherwise | 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 } } |