Query editor
WITH addr_transfers AS (SELECTtx_hash,block_time,blockchain,COALESCE(amount_usd, 0) AS amount_usd,CASEWHEN "to" = 0x1f8E735f424B7A49A885571A2fA104E8C13C26c7 THEN "from"WHEN "from" = 0x1f8E735f424B7A49A885571A2fA104E8C13C26c7 THEN "to"END AS counterpartyFROM 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 ('ethereum','base', 'bnb', 'avalanche_c','arbitrum','optimism') -- << pick your setAND block_time >= CURRENT_TIMESTAMP - INTERVAL '30' DAY)SELECTSUM(ABS(amount_usd)) AS total_volume_usd,approx_distinct(tx_hash) AS total_transactions,approx_distinct(counterparty) AS total_usersFROM addr_transfers;