(select datetime,

total_mint,

(total_mint/lag(total_mint,1) over (order by datetime) -1)*100 as change_7d,

(total_mint/lag(total_mint,4) over (order by datetime) -1)*100 as change_30d

from

(select date_trunc('week',block_timestamp) as datetime,

sum(VALUE) as total_mint

--sum(sum(VALUE)) over (order by date(block_timestamp)) as total_mint

from berachain.testnet.fact_transactions

where value != 0

and

ORIGIN_FUNCTION_SIGNATURE = '0x298c0733'

group by 1)

)

select *

from full_table

where datetime = (select max(datetime) from full_table) - interval '7 day'