sixahi60662024-03-05 04:36 PM
    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