PS0G1ETH transaction history of whales in May and June
    Updated 2022-07-28
    WITH major_holders AS (
    SELECT DISTINCT(user_address) AS Whales , balance as eth_amount
    FROM flipside_prod_db.ethereum.erc20_balances
    WHERE CONTRACT_ADDRESS = 'ETH' AND BALANCE_DATE::DATE = CURRENT_DATE
    GROUP BY Whales , eth_amount
    ORDER BY eth_amount DESC
    LIMIT 5
    )
    SELECT BLOCK_TIMESTAMP::DATE AS transaction_date , sum(ETH_VALUE) AS TRANSACTION_VOLUME, TO_ADDRESS
    FROM ethereum.core.fact_transactions
    WHERE TO_ADDRESS IN (SELECT Whales FROM major_holders) AND transaction_date BETWEEN '2022-05-01' AND '2022-06-30'
    GROUP BY 1 , 3
    ORDER BY transaction_date DESC
    Run a query to Download Data