select * from $query('b684cbda-5e0a-48f4-9b2d-1e905c167ec8')

),

price_data as(

select * from $query('ac22238a-6d13-4cff-87bf-1198deb5772d')

),

aggregated as(

datetime,

sum(daily_minted) as daily_minted,

sum(daily_burned) as daily_burned,

sum(daily_supply_change) as daily_supply_change,

sum(net_minted) as net_minted,

sum(net_burned) as net_burned,

sum(net_supply) as net_supply,

sum(net_minted_value) as net_minted_value,

sum(net_burned_value) as net_burned_value,

sum(net_supply_value) as net_supply_value

from base_table

group by datetime)

select

a.*,

p.daily_price

from aggregated a

left join price_data p

on a.datetime = p.day

order by a.datetime desc;