Query editor
WITH fx_prices AS (SELECTCAST(date AS DATE) AS day,base_currency AS currency,exchange_rate AS priceFROM prices.fx_exchange_ratesWHERE target_currency = 'USD'),bucketed_transfers AS (SELECTl.name AS symbol,CASEWHEN (p.price * value/POWER(10,l.decimals)) >= 0 AND (p.price * value/POWER(10,l.decimals)) < 10 THEN '0-10'WHEN (p.price * value/POWER(10,l.decimals)) >= 10 AND (p.price * value/POWER(10,l.decimals)) < 100 THEN '010-100'WHEN (p.price * value/POWER(10,l.decimals)) >= 100 AND (p.price * value/POWER(10,l.decimals)) < 1000 THEN '100-1000'WHEN (p.price * value/POWER(10,l.decimals)) >= 1000 THEN '1000+'END AS bucketFROM erc20_base.evt_transfer tINNER JOIN query_7650465 l -- token listON l.address = t.contract_addressINNER JOIN fx_prices pON p.currency = l.currencyAND p.day = date_trunc('day',t.evt_block_time)LEFT JOIN base.creation_traces c1ON c1.address = t."from"LEFT JOIN base.creation_traces c2ON c2.address = t."to"WHEREt.evt_block_time BETWEENtimestamp '2026-04-01'AND timestamp '2026-06-30'AND c1.address IS NULL AND c2.address IS NULL)SELECTsymbol,bucket,COUNT(*) AS quantityFROM bucketed_transfersGROUP BY symbol, bucket