Abbas_ra21Whales Purchase
    Updated 2023-09-17
    with
    balance AS (
    select
    user_address AS user,
    max(BLOCK_TIMESTAMP) AS Time
    from
    ethereum.core.fact_eth_balances
    group by
    1
    ),
    balance2 AS (
    select
    user_address,
    Balance
    from
    ethereum.core.fact_eth_balances
    inner join balance on time = BLOCK_TIMESTAMP
    and user = user_address
    )
    select
    BLOCK_TIMESTAMP AS Time,
    ORIGIN_FROM_ADDRESS AS Address,
    AMOUNT_OUT_USD AS "Buy size (USD)",
    BALANCE / 1e18 AS "ETH BALANCE"
    from
    ethereum.core.ez_dex_swaps
    inner join balance2 on user_address = ORIGIN_FROM_ADDRESS
    where
    TOKEN_IN = lower('0x48c87cDacb6Bb6BF6E5Cd85D8ee5C847084c7410')
    and AMOUNT_OUT_USD >= 10000
    order by
    1 desc
    Run a query to Download Data