crypto_edgarbGMT Minted
    Updated 2025-01-21
    with
    bGMT_mints as (
    select
    TX_HASH,
    BLOCK_TIMESTAMP,
    RAW_AMOUNT / POW(10, 8) as GMT_MINTED
    from
    bsc.core.fact_token_transfers
    where
    BLOCK_TIMESTAMP >= TIMESTAMP '2022-03-01'
    AND CONTRACT_ADDRESS = '0x3019bf2a2ef8040c242c9a4c5c4bd4c81678b2a1'
    AND FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    order by
    BLOCK_TIMESTAMP ASC
    )

    SELECT SUM(GMT_MINTED) as TOTAL_GMT_MINTED_BSC
    FROM bGMT_mints
    QueryRunArchived: QueryRun has been archived