1select date::date as date
2       , max(case when question='Will the federal government be shut down for 1–3 days in 2025?' AND outcome = 'Yes' then price end) as "1-3 days"
3       , max(case when question='Will the federal government be shut down for 4–9 days in 2025?' AND outcome = 'Yes' then price end) as "4-9 days"
4       , max(case when question='Will the federal government be shut down for 10–29 days in 2025?' AND outcome = 'Yes' then price end) as "10-29 days"
5       , max(case when question='Will the federal government be shut down for 30 or more days in 2025?' AND outcome = 'Yes' then price end) as "30+ days"
6from @polymarket.clob.daily_token_prices
7where question like '%federal%gov%shut%down%for%2025%'
8group by date
9order by date