Query editor
WITH target_wallet AS (SELECT 0x492442eab586f242b53bda933fd5de859c8a3782 AS address -- Target Wallet),trades AS (-- 1. Standard Markets (CTF)SELECTevt_block_time,evt_tx_hash,'CTF' as market_type,CASE-- CASE A: Target is MAKERWHEN maker = (SELECT address FROM target_wallet) THENCASE-- Maker gives Asset 0 (USDC) -> BUYING (Outflow)WHEN CAST(makerAssetId AS VARCHAR) = '0' THEN -1 * (makerAmountFilled / 1e6)-- Maker gives Outcome Token -> SELLING (Inflow of USDC from Taker)ELSE (takerAmountFilled / 1e6)END-- CASE B: Target is TAKERWHEN taker = (SELECT address FROM target_wallet) THENCASE-- Taker gives Asset 0 (USDC) -> BUYING (Outflow)WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN -1 * (takerAmountFilled / 1e6)-- Taker gives Outcome Token -> SELLING (Inflow of USDC from Maker)ELSE (makerAmountFilled / 1e6)ENDEND AS usd_flowFROM polymarket_polygon.ctfexchange_evt_orderfilledWHERE maker = (SELECT address FROM target_wallet)OR taker = (SELECT address FROM target_wallet)UNION ALL-- 2. Negative Risk Markets (NegRisk)SELECTevt_block_time,evt_tx_hash,'NegRisk' as market_type,CASE-- CASE A: Target is MAKERWHEN maker = (SELECT address FROM target_wallet) THENCASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN -1 * (makerAmountFilled / 1e6)ELSE (takerAmountFilled / 1e6)END-- CASE B: Target is TAKERWHEN taker = (SELECT address FROM target_wallet) THENCASEWHEN CAST(takerAssetId AS VARCHAR) = '0' THEN -1 * (takerAmountFilled / 1e6)ELSE (makerAmountFilled / 1e6)ENDEND AS usd_flowFROM polymarket_polygon.negriskctfexchange_evt_orderfilledWHERE maker = (SELECT address FROM target_wallet)OR taker = (SELECT address FROM target_wallet)),redemptions AS (-- 3. Winnings (Payouts)