flipside

    avalanche total supply
    0-MIDavalanche total supply
    Updated 2023-08-15
    select date_trunc('month',BLOCK_TIMESTAMP) as month
    ,sum(case when FROM_ADDRESS='0x0000000000000000000000000000000000000000' then AMOUNT end) as mint_volume
    ,-sum(case when TO_ADDRESS='0x0000000000000000000000000000000000000000' then AMOUNT end) as burn_volume
    ,mint_volume+burn_volume as monthly_net_mint
    ,sum(monthly_net_mint)over(order by month)as total_net_mint
    from avalanche.core.ez_token_transfers
    where CONTRACT_ADDRESS in( lower('0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'))
    group by 1

    Run a query to Download Data