Query editor
WITH flows AS (SELECTCASEWHEN "to" = 0x1f8E735f424B7A49A885571A2fA104E8C13C26c7 THEN "from"ELSE "to"END AS user_address,ABS(amount_usd) AS volume_usdFROM tokens.transfersWHERE( "to" = 0x1f8E735f424B7A49A885571A2fA104E8C13C26c7OR "from" = 0x1f8E735f424B7A49A885571A2fA104E8C13C26c7 )AND "from" NOT IN (0x3c2269811836af69497e5f486a85d7316753cf62,0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7,0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675,0x4200000000000000000000000000000000000006,0x0000000000000000000000000000000000000000,0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2,0x82af49447d8a07e3bd95bd0d56f35241523fbab1)AND "to" NOT IN (0x3c2269811836af69497e5f486a85d7316753cf62,0xb6319cc6c8c27a8f5daf0dd3df91ea35c4720dd7,0x66a71dcef29a0ffbdbe3c6a460a3b5bc225cd675,0x4200000000000000000000000000000000000006,0x0000000000000000000000000000000000000000,0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2,0x82af49447d8a07e3bd95bd0d56f35241523fbab1)AND blockchain IN ('optimism','ethereum','bnb','base','avalanche_c','arbitrum')AND block_time >= TIMESTAMP '2025-04-01'),user_volume AS (SELECTuser_address,SUM(volume_usd) AS total_volume_usdFROM flowsGROUP BY user_address),bucketed AS (SELECTCASEWHEN total_volume_usd < 10 THEN '<$10'WHEN total_volume_usd < 100 THEN '$10–$100'WHEN total_volume_usd < 1000 THEN '$100–$1k'WHEN total_volume_usd < 10000 THEN '$1k–$10k'WHEN total_volume_usd < 100000 THEN '$10k–$100k'WHEN total_volume_usd < 1000000 THEN '$100k–$1m'ELSE '$1m+'END AS volume_bucketFROM user_volume)SELECTCASE volume_bucketWHEN '<$10' THEN 1WHEN '$10–$100' THEN 2WHEN '$100–$1k' THEN 3