banterlyticsbanana net change
    Updated 2022-11-30
    SELECT mint.date AS DAY,
    COALESCE(mint.claimed,0) as claimed,
    COALESCE(burn.burned,0) as burned,
    COALESCE(claimed,0)-COALESCE(burned,0) as netchange
    FROM
    (SELECT block_timestamp::date as date,
    COALESCE(sum(raw_amount/pow(10,18)),0) as claimed
    from ethereum.core.fact_token_transfers
    where block_timestamp > '2022-01-01'
    and contract_address = lower('0x94e496474F1725f1c1824cB5BDb92d7691A4F03a')
    and from_address = lower('0x0000000000000000000000000000000000000000')
    GROUP BY 1
    ORDER BY 1 DESC) mint

    LEFT JOIN
    (select p.date as date,(COALESCE(e.burned,0)+COALESCE(p.burned,0)) as burned from
    (SELECT block_timestamp::date as date,
    COALESCE(sum(raw_amount/pow(10,18)),0) as burned
    from polygon.core.fact_token_transfers
    where block_timestamp > '2022-01-01'
    and contract_address = lower('0xbC91347e80886453F3f8bBd6d7aC07C122D87735')
    and to_address = lower('0x000000000000000000000000000000000000dead')
    GROUP BY 1
    ORDER BY 1 DESC) p

    full join

    (SELECT block_timestamp::date as date,
    COALESCE(sum(raw_amount/pow(10,18)),0) as burned
    from ethereum.core.fact_token_transfers
    where block_timestamp > '2022-01-01'
    and contract_address = lower('0x94e496474F1725f1c1824cB5BDb92d7691A4F03a')
    and to_address = lower('0x0000000000000000000000000000000000000000')
    GROUP BY 1
    ORDER BY 1 DESC) e
    Run a query to Download Data