Query editor
-- 1. Robinhood order volume & size distributionwith orders as (selecto.chain,o.orderId,o.evt_block_time,t.amount_usdfrom lifi_multichain.inputsettlerescrowlifi_evt_open oleft join (select symbol, max(amount_usd) as amount_usd, tx_hashfrom tokens.transferswhere blockchain = 'robinhood'and block_time >= cast('2026-05-26' as date) --launchedand tx_hash in (select evt_tx_hash from lifi_multichain.inputsettlerescrowlifi_evt_open)and to = 0x000025c3226C00B2Cdc200005a1600509f4e00C0 --escrowgroup by 1, 3) t on o.evt_tx_hash = t.tx_hashwhere o.evt_block_time >= cast('2026-05-26' as date) --launchedand o.chain = 'robinhood')selectcount(*) as order_count,sum(amount_usd) as total_volume_usd,avg(amount_usd) as avg_order_size_usd,approx_percentile(amount_usd, 0.5) as median_order_size_usd,min(amount_usd) as min_order_size_usd,max(amount_usd) as max_order_size_usdfrom orders