crypto_edgarbGMT Minted
Updated 2025-01-21Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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