Query editor
WITH daily AS (SELECTCAST(date_trunc('day', block_time) AS DATE) AS day,token_symbol,SUM(CASE WHEN LOWER(flow_type) = 'inflow' THEN amount_usd ELSE 0 END) AS inflow_usd,SUM(CASE WHEN LOWER(flow_type) = 'outflow' THEN amount_usd ELSE 0 END) AS outflow_usd,SUM(CASE WHEN LOWER(flow_type) = 'inflow' THEN amount_usd ELSE -amount_usd END) AS netflow_usdFROM cex.flowsWHERE block_time >= CURRENT_DATE - INTERVAL '120' DAYAND blockchain IN ('ethereum','base','arbitrum','optimism','bnb')AND token_symbol IN ('USDT','USDC')AND LOWER(flow_type) IN ('inflow','outflow')GROUP BY 1,2)SELECTday,SUM(CASE WHEN token_symbol='USDT' THEN inflow_usd ELSE 0 END) AS usdt_inflow_usd,SUM(CASE WHEN token_symbol='USDT' THEN outflow_usd ELSE 0 END) AS usdt_outflow_usd,SUM(CASE WHEN token_symbol='USDT' THEN netflow_usd ELSE 0 END) AS usdt_netflow_usd,SUM(CASE WHEN token_symbol='USDC' THEN inflow_usd ELSE 0 END) AS usdc_inflow_usd,SUM(CASE WHEN token_symbol='USDC' THEN outflow_usd ELSE 0 END) AS usdc_outflow_usd,SUM(CASE WHEN token_symbol='USDC' THEN netflow_usd ELSE 0 END) AS usdc_netflow_usd,SUM(netflow_usd) AS total_netflow_usdFROM dailyGROUP BY 1ORDER BY 1