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