select block_timestamp as creation_date,

decoded_log:creator as token_creator,

decoded_log:token as token_address,

from avalanche.core.ez_decoded_event_logs

where contract_address = lower ('0x4274f80635183e9bE3c16E1313a16f929B61E00e')

and event_name = 'TokenCreated'

and origin_from_address = decoded_log:creator

and topics [0] = '0xf9539e87adbf50c20723b1b894d0acfaec6754c75303fa1d4f914094b6d3bad7'),

datet1 as (

select date_day

from ethereum.core.dim_dates

where date_day >= '2024-10-10' and date_day < current_date

group by date_day),

mintst as (

select block_timestamp::date as date,

contract_address,

sum (amount) as Minted_Tokens

from avalanche.core.ez_token_transfers t1 join createtable t2 on t1.contract_address = t2.token_address

where from_address = '0x0000000000000000000000000000000000000000'

and origin_to_address is not null

group by 1,2),

burnst as (

select block_timestamp::date as date,

contract_address,

sum (amount) as Burned_Tokens

from avalanche.core.ez_token_transfers t1 join createtable t2 on t1.contract_address = t2.token_address

where to_address = '0x0000000000000000000000000000000000000000'

group by 1,2),

non_circulating as (

select block_timestamp::date as date,