tbtc_suuply

tbtc_suuply

WITH tBTC AS
(
    SELECT
    date_trunc('day', block_time) as day,
    COALESCE(sum(e.value/1e18), 0) as supply
    FROM erc20."ERC20_evt_Transfer" e
    LEFT JOIN ethereum."transactions" tx ON evt_tx_hash = tx.hash
    WHERE "contract_address" = '\x8dAEBADE922dF735c38C80C7eBD708Af50815fAa' -- tBTC contract address
    and e."from" = '\x0000000000000000000000000000000000000000'
    GROUP BY 1
UNION ALL
    SELECT
    date_trunc('day', block_time) as day,
    COALESCE(sum(-e.value/1e18), 0) as supply
    FROM erc20."ERC20_evt_Transfer" e
    LEFT JOIN ethereum."transactions" tx ON evt_tx_hash = tx.hash
    WHERE "contract_address" = '\x8dAEBADE922dF735c38C80C7eBD708Af50815fAa' -- tBTC contract address
    and e."to" = '\x0000000000000000000000000000000000000000'
    GROUP BY 1
)

SELECT
sum(supply)
FROM tBTC