-- forked from Avalanche: transfer Total @ https://flipsidecrypto.xyz/edit/queries/b279f7ab-8745-41ee-a750-558300892cb2

-- forked from Avalanche: transfer @ https://flipsidecrypto.xyz/edit/queries/6bc74cea-f3cf-488d-8c9a-0ee8899701ec

with

mint as (

SELECT sum(raw_amount)/pow(10,6) as amnt

FROM avalanche.core.fact_token_transfers

WHERE contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

AND from_address = '0x0000000000000000000000000000000000000000'

AND block_timestamp >= dateadd('month', -1*{{last_n_month}}, current_date) and block_timestamp <= CURRENT_DATE-1

),

burn as (

SELECT sum(raw_amount)/pow(10,6) as amnt

FROM avalanche.core.fact_token_transfers

WHERE contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

AND to_address = '0x0000000000000000000000000000000000000000'

AND block_timestamp >= dateadd('month', -1*{{last_n_month}}, current_date) and block_timestamp <= CURRENT_DATE-1

m.amnt as mint_vol,

b.amnt as burnt_vol,

zeroifnull(mint_vol)-zeroifnull(burnt_vol) as net_vol

FROM mint m

LEFT JOIN burn b

on 1=1