select

date_day as block_day

from ethereum.core.dim_dates

where date_day > '2022-04-20'

and date_day <= current_date

, mints as (

select

date_trunc('day', block_timestamp) as block_day

-- , contract_address

-- , tx_id

-- , event_inputs

, sum(event_inputs:value::int) / 1e18 as mint_amount

from polygon.core.fact_event_logs

where 1=1

and contract_address in (

'0xc17636e36398602dd37bb5d1b3a9008c7629005f' --Balancer Matic/MaticX

)

and event_name = 'Transfer'

and event_inputs:from = '0x0000000000000000000000000000000000000000'

-- and block_timestamp > '2022-09-20'

group by 1

)

, burns as (

select

date_trunc('day', block_timestamp) as block_day

-- , contract_address

-- , tx_id

-- , event_inputs

, sum(event_inputs:value::int) / 1e18 as burn_amount

from polygon.core.fact_event_logs