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:
SchemaDescriptionTables
RawRaw blockchain data for Solana.blocks, transactions, instructions, inner_instructions, rewards
DecodedDecoded instructionsinstructions
AssetsToken transfers and credit debit of spl-tokens and native SOL.transfers, credit_debit, spl_token_balances, sol_balances
NFTsNFT trades coverage of major marketplaces and NFT mints data.trades, mints
DEXsDEX trades and aggregator trades on Solana. Coverage includes 10+ major DEXs and multiple protocols.trades, aggregator_trades
DeFiDeFi related protocols including loans, rewards and farmsfarms, 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 NameDescriptionTypeExample
tx_base_feethe base fee paid for the transactionnumber5000
tx_priority_feethe priority fee paid for the transaction, if anynumber500
tx_total_feethe total fee paid for the transaction, equivalent to fee column in solana.raw.transactionsnumber5500
tx_account_keysaccount keys involved in the transaction, equivalent to account_keys column in solana.raw.transactionsvariant[{ "pubkey": "Bp9ok7LoJvBmBfGWEWznL4SD1rMqBQqLzTDbAZVkM92f", "signer": true, "source": "transaction", "writable": true }]
tx_mint_to_decimalsa dictionary mapping mint address to mint decimal. parsed from pre/post_token_balances in solana.raw.transactionsvariant{ "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v": 6, "Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB": 6, "So11111111111111111111111111111111111111112": 9 }
tx_token_accountsa 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_amountsa dictionary mapping accounts to details about their native SOL balance, obtained from pre/post_balances in solana.raw.transactionsvariant{ "24tza9jGvvSwL8HEfkjnrL3vUxBukaF6Uj1ufXTu3Hif": { "post_amount": 2039280, "pre_amount": 2039280 }, "5SEpbdjFK5FxwTvfsGMXVQTD2v4M2c5tyRTxhdsPkgDw": { "post_amount": 81771454520, "pre_amount": 81771454520 } }

​
Convenience functions

Several snowflake table functions are provided for convenient querying of specific use cases:
  1. pull solana transactions, instructions, inner_instructions for activites involving a set of addresses This fetches all transactions, instructions, inner instructions for activites involving an address, equivalent to calling getTransaction for each txn_id returned by a getSignaturesForAddress rpc call. It only includes nonvoting transactions. For successful, nonvoting transactions, the contents of instructions are nested in the arrays instructions and inner_instructions. For failed, nonvoting transactions, instructions/inner instructions are not fetched. 
    select * from
table(solana.udfs.sql_table_solana_get_transactions_for_address(
    array_construct('C2gyWTyDz6CK822hLvCMKZ5MBQRkEFjcaF8UoERrYAvy'),
    '2025-01-01'::timestampntz,
    '2025-01-05'::timestampntz
    )
)
  2. pull solana transactions, instructions, inner_instructions for accounts with balance changes 
    select * from
table(solana.udfs.sql_table_solana_get_transactions_from_balances(
    array_construct('C2gyWTyDz6CK822hLvCMKZ5MBQRkEFjcaF8UoERrYAvy'),
    '2025-01-01'::timestampntz,
    '2025-01-05'::timestampntz
    )
)
  3. pull non-voting solana transactions, instructions, inner_instructions for accounts with balance changes, with transfer info if available 
    select * from
table(solana.udfs.sql_table_solana_get_nonvoting_transactions_from_balances_with_transfers(
    array_construct('C2gyWTyDz6CK822hLvCMKZ5MBQRkEFjcaF8UoERrYAvy'),
    '2025-01-01'::timestampntz,
    '2025-01-05'::timestampntz
    )
)
  4. pull non-voting solana sol+spl latest balances as of a certain timestamp 
    select * from
table(solana.udfs.sql_table_solana_get_nonvoting_latest_balances_as_of_time(
    array_construct('2QfBNK2WDwSLoUQRb1zAnp3KM12N9hQ8q6ApwUMnWW2T'),
    '2025-07-09 16:05:19'::timestampntz
    )
)
  5. pull balance changes of an address, with transfer attribution where possible 
    select * from
table(solana.udfs.sql_table_solana_get_balance_change_attribution(
    array_construct('GVJp1bkQgw3QdXBmvWRBK5SaXcr3kzf45SfrvRDobQQE'),
    '2025-07-09'::timestampntz,
    '2025-07-10'::timestampntz
    )
)
  6. pull daily end-of-day balances of a set of addresses in a time range 
    select * from
table(solana.udfs.sql_table_solana_get_daily_balances(
    array_construct('GVJp1bkQgw3QdXBmvWRBK5SaXcr3kzf45SfrvRDobQQE'),
    '2025-07-09'::timestampntz,
    '2025-07-10'::timestampntz
    )
)