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.

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 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?