Overview

Solana is a high-performance blockchain supporting builders around the world creating crypto apps.

​

Solana Tables

Our Solana data includes the following schemas and tables:

​

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:

​

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

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.