your-db12 ms

select token, chain, to_post_balance as balance
from token_transfers
where to_address = '0x3f5c…9a21'
order by position desc;

your-db31 ms

select block_time, kind, token, amount, price_usd
from wallet_ledger
where wallet = '0x3f5c…9a21'
  and block_time >= '2025-04-06';

your-clickhouse48 ms

select pair, count() as swaps, sum(value_usd) as volume
from token_swaps
where chain = 'base' and block_time > now() - interval 1 hour
group by pair order by volume desc limit 4;

your-clickhouse0.4 s

select toStartOfMonth(block_time) as month,
       uniq(from_address) as active_senders
from token_transfers
where chain = 'ethereum'
group by month order by month desc limit 4;

your-db22 ms

select chain, sum(minted) as minted, sum(burned) as burned
from token_supply_changes
where token = 'USDC' and block_time > now() - interval '7 days'
group by chain;