mohamadreza221166Total TOKE Holders
    Updated 2022-06-21
    WITH TOKE_transfers AS(
    SELECT *
    FROM ethereum.core.ez_token_transfers
    WHERE CONTRACT_ADDRESS = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
    AND DATE(BLOCK_TIMESTAMP) <= CURRENT_DATE
    ),
    transfers AS(
    SELECT FROM_ADDRESS AS ADDRESS, sum(AMOUNT) AS AMOUNT, COUNT(*) number_of_transactions, -1 AS flag
    FROM TOKE_transfers
    GROUP BY FROM_ADDRESS
    UNION
    SELECT TO_ADDRESS AS ADDRESS, sum(AMOUNT) AS AMOUNT, COUNT(*) number_of_transactions, 1 AS flag
    FROM TOKE_transfers
    GROUP BY TO_ADDRESS
    )

    SELECT COUNT(DISTINCT T1.ADDRESS) number_of_toke_HOlders, sum(T1.Amount * flag)::string total_holded_amount, sum(number_of_transactions) AS number_of_transactions
    FROM transfers T1

    --SELECT * FROM ethereum.core.fact_transactions WHERE tx_hash = '0x415a7d7d016be2bb0e1d0eaea2a87f3a7d395f199f019282b134191fd22e1673'

    --SELECT SYMBOL FROM ethereum.core.ez_token_transfersWHERE SYMBOL LIKE '%TOKE%' GROUP BY SYMBOL



    --select * from ethereum.core.dim_contracts where ADDRESS = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')

    Run a query to Download Data