zakkisyed2023-09-16 01:20 PM
    Updated 2023-09-16
    --MArk Cuban 2 0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab


    -- SELECT

    -- SUM(usd_value_last_activity) AS total_usd_before_drain,
    -- SUM(usd_value_now) AS total_usd_now
    -- FROM
    -- ETHEREUM.core.ez_current_balances
    -- WHERE
    -- user_address = lower('0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab')
    -- AND
    -- last_activity_block_timestamp::date >= CURRENT_DATE - 1;


    -- select * from ethereum.core.ez_token_transfers
    -- where origin_from_address = lower('0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab')
    -- limit 10

    -- USDC balabces
    SELECT
    date_trunc(hour,b.block_timestamp),
    p.SYMBOL as token_symbol,
    b.balance/6
    FROM
    ethereum.core.fact_token_balances AS b
    JOIN
    ethereum.price.ez_hourly_token_prices AS p ON b.contract_address = p.TOKEN_ADDRESS
    WHERE
    b.user_address = lower('0x5b94E0Fc819B923e8fE1068bc82Aba6C870C10Ab')
    AND b.contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48')
    AND b.block_timestamp >= current_date -1

    ORDER BY
    b.block_timestamp;


    Run a query to Download Data