with tb as(

select

block_timestamp,

case when event_name='Mint' then decoded_log:amount/power(10,6) else 0 end as mint_amount,

case when event_name='Burn' then decoded_log:amount/power(10,6) else 0 end as burn_amount,

mint_amount-burn_amount as amount,

mint_amount+burn_amount as vol,

case when event_name='DepositForBurn' then DECODED_LOG:amount/power(10,6) else 0 end as cctp_burn_amount,

case when event_name='MintAndWithdraw' then DECODED_LOG:amount/power(10,6) else 0 end as cctp_mint_amount,

cctp_mint_amount-cctp_burn_amount as cctp_amount,

cctp_mint_amount+cctp_burn_amount as cctp_vol

from arbitrum.core.ez_decoded_event_logs

where

lower(contract_address) in (lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831'),lower('0x19330d10D9Cc8751218eaf51E8885D058642E08A'))

AND

event_name in ('Mint','Burn','DepositForBurn','MintAndWithdraw')

and TX_STATUS = 'SUCCESS'

),

daily_data as (

SELECT

date_trunc('day',block_timestamp) as day,

sum(mint_amount) as daily_mint,

sum(burn_amount) as daily_burn,

sum(vol) as daily_volume,

sum(amount) as daily_supply_change,

SUM(daily_supply_change) OVER (ORDER BY day) as total_supply,

sum(cctp_mint_amount) as daily_cctp_mint_amount,

sum(cctp_burn_amount) as daily_cctp_burn_amount,

sum(cctp_vol) as daily_cctp_vol,