avalanche_mints as (

select

symbol,

count(distinct tx_hash) as transactions,

count(distinct to_address) as addresses,

sum(amount) as volume

from

avalanche.core.ez_token_transfers

where

from_address = '0x0000000000000000000000000000000000000000'

and to_address != '0x0000000000000000000000000000000000000000'

and amount > 0

and contract_address in (

'0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be', -- benqi

'0xc3344870d52688874b06d844e0c36cc39fc727f6', -- ankr

'0xa25eaf2906fa1a3a13edac9b9657108af7b703e3', -- gogopool

'0xf7d9281e8e363584973f946201b82ba72c965d27', -- yield yak

'0x6026a85e11bd895c934af02647e8c7b4ea2d9808' -- geode

)

group by

symbol

),

avalanche_burns as (

select

symbol,

count(distinct tx_hash) as transactions,

count(distinct from_address) as addresses,

sum(amount) as volume

from

avalanche.core.ez_token_transfers

where

from_address != '0x0000000000000000000000000000000000000000'

and to_address = '0x0000000000000000000000000000000000000000'

and amount > 0

and contract_address in (