superflyTotal supply token
    Updated 2022-12-20
    SELECT sum(amount2/pow(10,18)) AS "Total supply"

    FROM

    (
    SELECT from_address,
    to_address, --minter
    raw_amount as amount2,
    BLOCK_TIMESTAMP AS block_time
    FROM ethereum.core.fact_token_transfers
    WHERE from_address = lower('0x0000000000000000000000000000000000000000')
    AND contract_address = lower('{{Address}}')
    UNION ALL

    SELECT from_address, --burner
    to_address,
    -(raw_amount) as amount2,
    BLOCK_TIMESTAMP AS block_time
    FROM ethereum.core.fact_token_transfers
    WHERE to_address = lower('{{Address}}')
    AND contract_address = lower('0xc944E90C64B2c07662A292be6244BDf05Cda44a7'))
    Run a query to Download Data