Query editor
WITH per_event AS (SELECT event_ts, event_date, event_year, event_name,SUM(CASE WHEN asset = 'USDC' AND event_window_hour BETWEEN -24 AND -1 THEN net_flow ELSE 0 END) AS net_usdc_flow_pre_24h,SUM(CASE WHEN asset = 'USDC' AND event_window_hour = 0 THEN net_flow ELSE 0 END) AS net_usdc_flow_h0,SUM(CASE WHEN asset = 'USDC' AND event_window_hour BETWEEN 1 AND 24 THEN net_flow ELSE 0 END) AS net_usdc_flow_post_24h,SUM(CASE WHEN asset = 'WETH' AND event_window_hour BETWEEN 1 AND 24 THEN net_flow ELSE 0 END) AS net_weth_flow_post_24hFROM dune.dykdo0101.result_usdc_whale_fed_hourly_flows_2022_nowGROUP BY 1,2,3,4)SELECT event_ts, event_date, event_year, event_name, net_usdc_flow_pre_24h, net_usdc_flow_h0, net_usdc_flow_post_24h, net_weth_flow_post_24h,CASEWHEN net_usdc_flow_pre_24h > 0 AND net_usdc_flow_post_24h > 0 THEN 'USDC build before and after event'WHEN net_usdc_flow_pre_24h > 0 AND net_usdc_flow_post_24h <= 0 THEN 'Pre-event USDC build, post-event deployment/outflow'WHEN net_usdc_flow_pre_24h <= 0 AND net_usdc_flow_post_24h > 0 THEN 'Post-event USDC build after pre-event deployment/outflow'ELSE 'USDC deployment/outflow around event'END AS interpretationFROM per_eventORDER BY event_ts