superflyTotal supply token
Updated 2022-12-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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