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.

Upgrade to the enriched dataset

Skip manual reconstruction. The enriched version packages attribution and methodology so you can move from raw data to insights faster.

​
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.