select date_trunc ({{Date_Trunc}},hour) as date2,

median (price) as XSGDPrice

from avalanche.price.ez_prices_hourly

where token_address = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e'

and price > 0

group by 1

order by 1 desc),

mintst as (

select date_trunc ({{Date_Trunc}},block_timestamp) as date1,

sum (amount) as Minted_Volume

from avalanche.core.ez_token_transfers

where contract_address = lower ('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')

and from_address = '0x0000000000000000000000000000000000000000'

group by 1),

burnst as (

select date_trunc ({{Date_Trunc}},block_timestamp) as date1,

sum (amount) as Burned_Volume

from avalanche.core.ez_token_transfers

where contract_address = lower ('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')

and to_address = '0x0000000000000000000000000000000000000000'

group by 1),

maintable as (

select coalesce (date_trunc ({{Date_Trunc}},t1.date1),date_trunc ({{Date_Trunc}},t2.date1)) as date,

coalesce (Minted_Volume,0) as MintedXSGD,

coalesce (Burned_Volume,0)*-1 as BurnedXSGD,

coalesce (MintedXSGD,0) + coalesce (BurnedXSGD,0) AS Net_Volume,

sum (MintedXSGD) over (order by date asc) as Total_MintedXSGD,

sum (BurnedXSGD) over (order by date asc)*-1 as Total_BurnedXSGD,

sum (net_volume) over (order by date asc) as TVL

from burnst t1 full outer join mintst t2 on t1.date1 = t2.date1

order by 1 desc),