config as (

select

timestamp '2024-04-25 00:01' as start_time,

timestamp '2024-05-08 23:59' as end_time

),

collat_prices as (

select date($1) as date, $2 as symbol,$3 as price, $4 as address

from (

values

('2024-03-02 00:00:00.000','USDB',1.010247609,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-02 00:00:00.000','WETH',3412.112608696,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-03 00:00:00.000','USDB',1.013791667,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-03 00:00:00.000','WETH',3432.254166667,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-04 00:00:00.000','WETH',3520.003333333,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-04 00:00:00.000','USDB',1.003433051,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-05 00:00:00.000','WETH',3650.855,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-05 00:00:00.000','USDB',1.0035145,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-06 00:00:00.000','USDB',1.013594875,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-06 00:00:00.000','WETH',3766.949166667,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-07 00:00:00.000','WETH',3811.887916667,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-07 00:00:00.000','USDB',1.002944833,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-08 00:00:00.000','USDB',1.006530583,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-08 00:00:00.000','WETH',3914.6325,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-09 00:00:00.000','USDB',1.003259833,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-09 00:00:00.000','WETH',3915.625,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-10 00:00:00.000','WETH',3922.822916667,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-10 00:00:00.000','USDB',1.0026065,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-11 00:00:00.000','WETH',3981.23625,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-11 00:00:00.000','USDB',1.009189208,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-12 00:00:00.000','USDB',1.010888833,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-12 00:00:00.000','WETH',3997.372083333,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-13 00:00:00.000','USDB',1.01775,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-13 00:00:00.000','WETH',4015.03875,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),

('2024-03-14 00:00:00.000','USDB',1.013083333,'0xcd732d21c1b23a3f84bb386e9759b5b6a1bcbe39'),

('2024-03-14 00:00:00.000','WETH',3924.82625,'0xb9d94a3490ba2482e2d4f21f0e76b92e5661ded8'),