sixahi60662024-03-05 04:36 PM
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
TxnType AS "Type",
block_number AS "Block Number",
block_time AS "Block Time",
CONCAT(
CAST('https://etherscan.io/tx/' AS VARCHAR),
CAST(txid AS VARCHAR)
) AS "TxID",
amount as "Amount (Raw)",
CAST(amount AS DECIMAL) / 1e6 as "Amount",
SUM(amount) OVER (
ORDER BY
block_time
) AS "Total Supply (Raw)",
SUM(amount) OVER (
ORDER BY
block_time
) / 1e6 AS "Total Supply"
FROM
(
SELECT
'Initial' AS TxnType,
block_number,
block_time,
hash AS txid,
100000000000 AS amount
FROM
ethereum.transactions
WHERE
-- https://explorer.phalcon.xyz/tx/eth/0x2f1c5c2b44f771e942a8506148e256f94f1a464babc938ae0690c6e34cd79190
-- function TetherToken(uint _initialSupply, string _name, string _symbol, uint _decimals)
-- _initialSupply is 100000000000 / 1e6 = 100000
hash = '0x2f1c5c2b44f771e942a8506148e256f94f1a464babc938ae0690c6e34cd79190'
UNION ALL
SELECT
Run a query to Download Data