SQL Query Studio
Read-only SELECT against the ChainCrunch mainnet index · 1000 rows max · 8s timeout · audited
Tables & Views
failed_slots
slot integer
error text
retries integer
last_attempt integer
permanent integer
marketplace_activity
slot integer
marketplace_slug text
block_time integer
tx_count integer
fail_count integer
volume_sol real
fees_sol real
unique_signers integer
native_sol_transfers
signature text
idx integer
slot integer
block_time integer
source text
destination text
lamports integer
perf_samples
slot integer
sample_time integer
num_slots integer
num_transactions integer
num_nonvote integer
period_secs integer
program_activity
slot integer
program_id text
block_time integer
tx_count integer
fail_count integer
fees_lamports integer
solana_blocks
slot integer
blockhash text
parent_slot integer
block_time integer
tx_count integer
vote_tx_count integer
nonvote_tx_count integer
failed_tx_count integer
total_fees_lamports integer
compute_units integer
indexed_at integer
solana_transactions
signature text
slot integer
block_time integer
fee_payer text
fee_lamports integer
success integer
error text
compute_units integer
is_vote integer
program_ids text
sol_moved_lamports integer
marketplace_slug text
spl_transfers
signature text
idx integer
slot integer
block_time integer
mint text
owner text
delta_ui real
decimals integer
token_metadata
mint text
symbol text
name text
decimals integer
logo text
token_program text
mint_authority text
freeze_authority text
holder_count integer
total_supply real
usd_price real
mcap real
liquidity real
price_change_24h real
stock_price real
is_tokenized_stock integer
updated_at integer
token_prices
mint text
price_time integer
usd_price real
marketplace_daily_metrics (v)
day
marketplace_slug text
tx_count
fail_count
volume_sol
fees_sol
network_hourly (v)
hour
transactions
nonvote_transactions
slots
program_daily_metrics (v)
day
program_id text
tx_count
fail_count
fees_sol
token_daily_metrics (v)
day
mint text
transfer_events
volume_ui
unique_wallets
ChainCrunch
Results
Run a query to see results — try a template