kaibladeTotal frETH Held
    Updated 2022-09-08
    WITH send_receive AS
    (SELECT from_address as address, -1*amount AS amount
    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374'

    UNION ALL
    SELECT to_address as address, amount AS amount
    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = '0xb4bd4628e6efb0cb521d9ec35050c75840320374'
    )
    ,
    raw_output AS (
    SELECT address, SUM(amount) AS balance
    FROM send_receive
    GROUP BY address
    ORDER BY balance DESC)
    ,
    processed_output AS (
    SELECT *
    FROM raw_output
    WHERE balance > 0
    ),

    TFcreator_raw AS
    (SELECT * , LEN(output) as length
    FROM ethereum.core.fact_traces

    WHERE data:from = '0x0fbb8d17027b16810795b12cbeadc65b252530c4' AND identifier = 'CALL_ORIGIN' AND length = 66
    OR (data:from= '0x0fbb8d17027b16810795b12cbeadc65b252530c4' AND identifier = 'CREATE_ORIGIN')
    )
    ,
    TFcreator_addresses AS (SELECT (CASE
    WHEN identifier = 'CALL_ORIGIN' THEN RIGHT(OUTPUT,40)
    WHEN identifier = 'CREATE_ORIGIN' THEN RIGHT(TO_ADDRESS,40)
    END
    Run a query to Download Data