Query editor
WITH raw_trades AS (-- 1. Standard Markets (CTFExchange)SELECTevt_block_time,maker AS maker_addr,taker AS taker_addr,-- Determine USDC Value involved in the trade-- If makerAssetId is 0, maker gave USDC (Use makerAmount).-- If takerAssetId is 0, taker gave USDC (Use takerAmount).CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN makerAmountFilled / 1e6WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN takerAmountFilled / 1e6ELSE 0END AS usdc_value,-- Identify who gave the USDC (The Buyer)CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN 'MAKER_BUY'WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN 'TAKER_BUY'ELSE 'UNKNOWN'END AS trade_typeFROM polymarket_polygon.ctfexchange_evt_orderfilledWHERE evt_block_time > NOW() - INTERVAL '6' MONTHUNION ALL-- 2. Negative Risk Markets (NegRiskExchange)SELECTevt_block_time,maker AS maker_addr,taker AS taker_addr,CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN makerAmountFilled / 1e6WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN takerAmountFilled / 1e6ELSE 0END AS usdc_value,CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN 'MAKER_BUY'WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN 'TAKER_BUY'ELSE 'UNKNOWN'END AS trade_typeFROM polymarket_polygon.negriskctfexchange_evt_orderfilledWHERE evt_block_time > NOW() - INTERVAL '6' MONTH),wallet_flows AS (-- 3. Calculate Cashflow for MAKERSELECTmaker_addr AS trader,DATE_TRUNC('month', evt_block_time) AS month,CASEWHEN trade_type = 'MAKER_BUY' THEN -1 * usdc_value -- Spent MoneyELSE usdc_value -- Received Money (Sold)END AS usd_flowFROM raw_tradesUNION ALL-- 4. Calculate Cashflow for TAKERSELECTtaker_addr AS trader,