yasmin-n-d-r-hwhale transection
    Updated 2022-07-27
    with whale_details as
    (select
    user_address ,sum(balance)
    from flipside_prod_db.ethereum.erc20_balances
    where symbol = 'ETH' and balance >= pow(10,6)
    group by user_address
    order by sum(balance)
    )
    select
    block_timestamp::date as date,
    case
    when date < '2022-05-01' then 'Before'
    when date > '2022-05-01' and date < '2022-06-30' then 'during in'
    when date > '2022-06-30' then 'After '
    end as timeframe,
    count(tx_hash)
    from ethereum.core.fact_transactions
    where date >= '2022-01-01' and date <= '2022-07-25'
    and from_address in (select user_address from whale_details)
    GROUP by 1
    Run a query to Download Data