Query editor
WITH events AS (SELECT DISTINCTevent_ts,CASEWHEN CAST(event_ts AS DATE) = DATE '2023-03-22' THEN 'Financial-stability stress'WHEN CAST(event_ts AS DATE) IN (DATE '2024-09-18', DATE '2024-11-07', DATE '2024-12-18',DATE '2025-03-19', DATE '2025-09-17', DATE '2025-10-29', DATE '2025-12-10') THEN 'Easing / liquidity support'WHEN CAST(event_ts AS DATE) IN (DATE '2022-03-16', DATE '2022-05-04', DATE '2022-06-15', DATE '2022-07-27',DATE '2022-09-21', DATE '2022-11-02', DATE '2022-12-14', DATE '2023-02-01',DATE '2023-05-03', DATE '2023-07-26') THEN 'Restrictive / high-rate pressure'ELSE 'Pause / policy-path uncertainty'END AS policy_categoryFROM dune.dykdo0101.result_usdc_whale_fed_hourly_cohort_2022_nowWHERE CAST(event_ts AS DATE) BETWEEN DATE '2022-01-26' AND CURRENT_DATE),event_hours AS (SELECTe.policy_category,e.event_ts,DATE_FORMAT(e.event_ts, '%Y-%m') AS event_month,hour_offset AS event_window_hourFROM events eCROSS JOIN UNNEST(SEQUENCE(-24, 24)) AS h(hour_offset)WHERE e.policy_category = 'Easing / liquidity support'),hourly_flows AS (SELECT event_ts, event_window_hour, SUM(net_flow) AS net_usdc_flowFROM dune.dykdo0101.result_usdc_whale_fed_hourly_flows_2022_nowWHERE asset = 'USDC'GROUP BY 1, 2),event_paths AS (SELECTh.policy_category,h.event_ts,h.event_month,h.event_window_hour,COALESCE(f.net_usdc_flow, 0) AS hourly_net_usdc_flowFROM event_hours hLEFT JOIN hourly_flows fON h.event_ts = f.event_tsAND h.event_window_hour = f.event_window_hour)SELECTpolicy_category,event_month,event_window_hour,hourly_net_usdc_flow,SUM(CASE WHEN event_window_hour = -24 THEN 0 ELSE hourly_net_usdc_flow END) OVER (PARTITION BY event_tsORDER BY event_window_hourROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_net_usdc_flowFROM event_paths