Skip to main content
The stablecoins_solana.transfers table contains curated stablecoin transfer records on Solana. One row represents one transfer instruction call at instruction granularity. Coverage includes both SPL and SPL2022 stablecoin transfers.

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name (solana)
block_monthDATEFirst day of month (partition column)
block_dateDATETransaction date
block_timeTIMESTAMPTransaction timestamp
block_slotBIGINTSolana slot number
tx_idVARCHARTransaction signature
tx_indexBIGINTTransaction index in slot
outer_instruction_indexBIGINTOuter instruction index
inner_instruction_indexBIGINTInner instruction index
token_versionVARCHARToken standard version (spl_token / token2022)
token_mint_addressVARCHARToken mint address
token_symbolVARCHARToken symbol
currencyVARCHARISO 4217 currency code
amount_rawUINT256Raw transfer amount
amountDOUBLEDecimals-adjusted amount
price_usdDOUBLEUSD price used for valuation
amount_usdDOUBLEUSD amount
from_ownerVARCHARSender wallet
to_ownerVARCHARReceiver wallet
from_token_accountVARCHARSource token account
to_token_accountVARCHARDestination token account
tx_signerVARCHARTransaction signer
outer_executing_accountVARCHARProgram executing outer instruction
actionVARCHARTransfer action label
unique_keyVARCHARUnique transfer identifier

​
Sample Queries

SELECT
    t.block_date
    , t.token_symbol
    , SUM(t.amount_usd) AS volume_usd
    , COUNT(*) AS transfers
FROM stablecoins_solana.transfers AS t
WHERE t.block_date >= CURRENT_DATE - INTERVAL '7' DAY
GROUP BY t.block_date, t.token_symbol
ORDER BY t.block_date DESC, volume_usd DESC

​
Notes

  • For partition pruning, filter by block_month.