Query editor
WITH input_addresses AS (SELECT DISTINCTCONCAT('0x', REGEXP_REPLACE(LOWER(TRIM(raw_address)), '^0x', '')) AS address,FROM_HEX(REGEXP_REPLACE(LOWER(TRIM(raw_address)), '^0x', '')) AS address_bytesFROM UNNEST(SPLIT('{{addresses}}', ',')) AS t(raw_address)WHERE REGEXP_LIKE(LOWER(TRIM(raw_address)), '^0x[0-9a-f]{40}$')OR REGEXP_LIKE(LOWER(TRIM(raw_address)), '^[0-9a-f]{40}$')),pusd_balance AS (SELECTaddress_bytes,SUM(delta_raw) / 1e6 AS pusd_balanceFROM (SELECT "to" AS address_bytes, CAST(amount AS DECIMAL(38, 0)) AS delta_rawFROM polymarket_v2_polygon.collateraltoken_evt_transferWHERE evt_block_date >= DATE '2026-04-01'AND contract_address = FROM_HEX('c011a7e12a19f7b1f670d46f03b03f3342e82dfb')AND "to" IN (SELECT address_bytes FROM input_addresses)UNION ALLSELECT "from" AS address_bytes, -CAST(amount AS DECIMAL(38, 0)) AS delta_rawFROM polymarket_v2_polygon.collateraltoken_evt_transferWHERE evt_block_date >= DATE '2026-04-01'AND contract_address = FROM_HEX('c011a7e12a19f7b1f670d46f03b03f3342e82dfb')AND "from" IN (SELECT address_bytes FROM input_addresses)) xGROUP BY 1),trades AS (SELECTmaker AS address_bytes,block_time,condition_idFROM polymarket_polygon.market_tradesWHERE block_time >= TIMESTAMP '2020-01-01'AND maker IN (SELECT address_bytes FROM input_addresses)UNION ALLSELECTtaker AS address_bytes,block_time,condition_idFROM polymarket_polygon.market_tradesWHERE block_time >= TIMESTAMP '2020-01-01'AND taker <> makerAND taker IN (SELECT address_bytes FROM input_addresses)),trade_stats AS (SELECTaddress_bytes,COUNT(DISTINCT DATE(block_time)) AS active_days,COUNT(DISTINCT condition_id) AS markets_tradedFROM tradesGROUP BY 1),lp_ranked AS (SELECTaddress_bytes,