Solana
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.
Solana Tables
Our Solana data includes the following schemas and 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:
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 feecolumn in solana.raw.transactions
number
5500
tx_account_keys
account keys involved in the transaction, equivalent to account_keyscolumn 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_owneris truewhen the token account appears in both pre & post token balances, and has changed, false otherwise
new_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
}
}
Last updated
Was this helpful?