Baselight
select date
       , max(case when outcome = 'Yes' then price end) as yes_price
       , max(case when outcome = 'No' then price end) as no_price
from @polymarket.clob.daily_token_prices
where question = 'Russia x Ukraine ceasefire in 2025?'
group by date
order by date
dateyes_priceno_price
2024-12-30 00:00:00+000.6350.365
2024-12-31 00:00:00+000.6950.305
2025-01-01 00:00:00+000.7050.295
2025-01-02 00:00:00+000.6950.305
2025-01-03 00:00:00+000.640.36
2025-01-04 00:00:00+000.620.38
2025-01-05 00:00:00+000.5950.405
2025-01-06 00:00:00+000.5950.405
2025-01-07 00:00:00+000.60.4
2025-01-08 00:00:00+000.5950.405
2025-01-09 00:00:00+000.5950.405
2025-01-10 00:00:00+000.590.41
2025-01-11 00:00:00+000.5950.405
2025-01-12 00:00:00+000.5550.445
2025-01-13 00:00:00+000.5650.435
2025-01-14 00:00:00+000.5750.425
2025-01-15 00:00:00+000.6050.395
2025-01-16 00:00:00+000.6050.395
2025-01-17 00:00:00+000.610.39
2025-01-18 00:00:00+000.6050.395
2025-01-19 00:00:00+000.6150.385
2025-01-20 00:00:00+000.620.38
2025-01-21 00:00:00+000.650.35
2025-01-22 00:00:00+000.640.36
2025-01-23 00:00:00+000.6550.345
2025-01-24 00:00:00+000.650.35
2025-01-25 00:00:00+000.6550.345
2025-01-26 00:00:00+000.6350.365
2025-01-27 00:00:00+000.640.36
2025-01-28 00:00:00+000.6450.355
2025-01-29 00:00:00+000.6250.375
2025-01-30 00:00:00+000.6250.375
2025-01-31 00:00:00+000.6350.365
2025-02-01 00:00:00+000.6350.365
2025-02-02 00:00:00+000.6350.365
2025-02-03 00:00:00+000.6350.365
2025-02-04 00:00:00+000.6250.375
2025-02-05 00:00:00+000.6150.385
2025-02-06 00:00:00+000.6250.375
2025-02-07 00:00:00+000.6150.385
2025-02-08 00:00:00+000.6550.345
2025-02-09 00:00:00+000.6550.345
2025-02-10 00:00:00+000.6450.355
2025-02-11 00:00:00+000.6150.385
2025-02-12 00:00:00+000.6450.355
2025-02-13 00:00:00+000.6850.315
2025-02-14 00:00:00+000.6850.315
2025-02-15 00:00:00+000.6850.315
2025-02-16 00:00:00+000.7150.285
2025-02-17 00:00:00+000.740.26
2025-02-18 00:00:00+000.7350.265
2025-02-19 00:00:00+000.710.29
2025-02-20 00:00:00+000.670.33
2025-02-21 00:00:00+000.6650.335
2025-02-22 00:00:00+000.6850.315
2025-02-23 00:00:00+000.6850.315
2025-02-24 00:00:00+000.6950.305
2025-02-25 00:00:00+000.7250.275
2025-02-26 00:00:00+000.7350.265
2025-02-27 00:00:00+000.7050.295
2025-02-28 00:00:00+000.7050.295
2025-03-01 00:00:00+000.6650.335
2025-03-02 00:00:00+000.630.37
2025-03-03 00:00:00+000.5950.405
2025-03-04 00:00:00+000.6450.355
2025-03-05 00:00:00+000.7050.295
2025-03-06 00:00:00+000.7350.265
2025-03-07 00:00:00+000.710.29
2025-03-08 00:00:00+000.7150.285
2025-03-09 00:00:00+000.7150.285
2025-03-10 00:00:00+000.720.28
2025-03-11 00:00:00+000.7150.285
2025-03-12 00:00:00+000.7750.225
2025-03-13 00:00:00+000.760.24
2025-03-14 00:00:00+000.7350.265
2025-03-15 00:00:00+000.7550.245
2025-03-16 00:00:00+000.740.26
2025-03-17 00:00:00+000.7350.265
2025-03-18 00:00:00+000.750.25
2025-03-19 00:00:00+000.7350.265
2025-03-20 00:00:00+000.6950.305
2025-03-21 00:00:00+000.6950.305
2025-03-22 00:00:00+000.7050.295
2025-03-23 00:00:00+000.7050.295
2025-03-24 00:00:00+000.7050.295
2025-03-25 00:00:00+000.680.32
2025-03-26 00:00:00+000.6550.345
2025-03-27 00:00:00+000.6350.365
2025-03-28 00:00:00+000.6050.395
2025-03-29 00:00:00+000.5750.425
2025-03-30 00:00:00+000.520.48
2025-03-31 00:00:00+000.5350.465
2025-04-01 00:00:00+000.4950.505
2025-04-02 00:00:00+000.490.51
2025-04-03 00:00:00+000.450.55
2025-04-04 00:00:00+000.4550.545
2025-04-05 00:00:00+000.4350.565
2025-04-06 00:00:00+000.430.57
2025-04-07 00:00:00+000.4350.565
2025-04-08 00:00:00+000.4650.535
2025-04-09 00:00:00+000.480.52
2025-04-10 00:00:00+000.4750.525
2025-04-11 00:00:00+000.4350.565
2025-04-12 00:00:00+000.440.56
2025-04-13 00:00:00+000.4350.565
2025-04-14 00:00:00+000.4250.575
2025-04-15 00:00:00+000.4350.565
2025-04-16 00:00:00+000.440.56
2025-04-17 00:00:00+000.4450.555
2025-04-18 00:00:00+000.4850.515
2025-04-19 00:00:00+000.4650.535
2025-04-20 00:00:00+000.4750.525
2025-04-21 00:00:00+000.510.49
2025-04-22 00:00:00+000.5250.475
2025-04-23 00:00:00+000.6150.385
2025-04-24 00:00:00+000.5850.415
2025-04-25 00:00:00+000.6050.395
2025-04-26 00:00:00+000.6050.395
2025-04-27 00:00:00+000.6450.355
2025-04-28 00:00:00+000.610.39
2025-04-29 00:00:00+000.620.38
2025-04-30 00:00:00+000.5750.425
2025-05-01 00:00:00+000.5750.425
2025-05-02 00:00:00+000.5650.435
2025-05-03 00:00:00+000.4850.515
2025-05-04 00:00:00+000.480.52
2025-05-05 00:00:00+000.50.5
2025-05-06 00:00:00+000.50.5
2025-05-07 00:00:00+000.480.52
2025-05-08 00:00:00+000.460.54
2025-05-09 00:00:00+000.4750.525
2025-05-10 00:00:00+000.5050.495
2025-05-11 00:00:00+000.580.42
2025-05-12 00:00:00+000.5650.435
2025-05-13 00:00:00+000.5650.435
2025-05-14 00:00:00+000.580.42
2025-05-15 00:00:00+000.5450.455
2025-05-16 00:00:00+000.5450.455
2025-05-17 00:00:00+000.490.51
2025-05-18 00:00:00+000.5050.495
2025-05-19 00:00:00+000.5050.495
2025-05-20 00:00:00+000.490.51
2025-05-21 00:00:00+000.490.51
2025-05-22 00:00:00+000.4350.565
2025-05-23 00:00:00+000.4150.585
2025-05-24 00:00:00+000.3950.605
2025-05-25 00:00:00+000.3950.605
2025-05-26 00:00:00+000.4150.585
2025-05-27 00:00:00+000.3850.615
2025-05-28 00:00:00+000.3850.615
2025-05-29 00:00:00+000.4050.595
2025-05-30 00:00:00+000.4050.595
2025-05-31 00:00:00+000.4050.595
2025-06-01 00:00:00+000.4050.595
2025-06-02 00:00:00+000.390.61
2025-06-03 00:00:00+000.380.62
2025-06-04 00:00:00+000.3150.685
2025-06-05 00:00:00+000.2950.705
2025-06-06 00:00:00+000.2650.735
2025-06-07 00:00:00+000.2650.735
2025-06-08 00:00:00+000.2450.755
2025-06-09 00:00:00+000.2450.755
2025-06-10 00:00:00+000.2450.755
2025-06-11 00:00:00+000.2450.755
2025-06-12 00:00:00+000.2350.765
2025-06-13 00:00:00+000.2250.775
2025-06-14 00:00:00+000.2250.775
2025-06-15 00:00:00+000.240.76
2025-06-16 00:00:00+000.2550.745
2025-06-17 00:00:00+000.2450.755
2025-06-18 00:00:00+000.2350.765
2025-06-19 00:00:00+000.2550.745
2025-06-20 00:00:00+000.240.76
2025-06-21 00:00:00+000.240.76
2025-06-22 00:00:00+000.240.76
2025-06-23 00:00:00+000.2350.765
2025-06-24 00:00:00+000.2250.775
2025-06-25 00:00:00+000.2450.755
2025-06-26 00:00:00+000.2450.755
2025-06-27 00:00:00+000.2450.755
2025-06-28 00:00:00+000.2650.735
2025-06-29 00:00:00+000.2550.745
2025-06-30 00:00:00+000.260.74
2025-07-01 00:00:00+000.2350.765
2025-07-02 00:00:00+000.2250.775
2025-07-03 00:00:00+000.2250.775
2025-07-04 00:00:00+000.2350.765
2025-07-05 00:00:00+000.2250.775
2025-07-06 00:00:00+000.240.76
2025-07-07 00:00:00+000.2250.775
2025-07-08 00:00:00+000.2250.775
2025-07-09 00:00:00+000.2250.775
2025-07-10 00:00:00+000.2250.775
2025-07-11 00:00:00+000.220.78
2025-07-12 00:00:00+000.2250.775
2025-07-13 00:00:00+000.2150.785
2025-07-14 00:00:00+000.1950.805
2025-07-15 00:00:00+000.2350.765
2025-07-16 00:00:00+000.2250.775
2025-07-17 00:00:00+000.2250.775
2025-07-18 00:00:00+000.2150.785
2025-07-19 00:00:00+000.2150.785
2025-07-20 00:00:00+000.2450.755
2025-07-21 00:00:00+000.2250.775
2025-07-22 00:00:00+000.2550.745
2025-07-23 00:00:00+000.2550.745

Share link

Anyone who has the link will be able to view this.