select * from $query('8fd424e0-9c32-4f54-8e81-ae5c5d215c76')

),

aggregated as (

select

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

from base_table

group by datetime

datetime,

round(daily_minted, 2) as daily_minted,

round(daily_burned, 2) as daily_burned,

round(daily_supply_change, 2) as daily_supply_change,

round(net_minted, 2) as net_minted,

round(net_burned, 2) as net_burned,

round(net_supply, 2) as net_supply,

round(net_supply - lag(net_supply, 1) over (order by datetime), 2) as change_24h,

round(

case

when lag(net_supply, 1) over (order by datetime) = 0 then null

else (net_supply - lag(net_supply, 1) over (order by datetime))

/ lag(net_supply, 1) over (order by datetime) * 100

end, 2

) as change_24h_pct,

round(net_supply - lag(net_supply, 7) over (order by datetime), 2) as change_7d,

round(

case

when lag(net_supply, 7) over (order by datetime) = 0 then null

else (net_supply - lag(net_supply, 7) over (order by datetime))