SELECT distinct miner

FROM ethereum.core.fact_blocks

where BLOCK_TIMESTAMP <='2022-09-14')

SELECT Eth_to_address AS Miner_Wallets,

round(sum(amount)) as eth_volume

FROM ethereum.core.ez_eth_transfers

WHERE eth_from_address IN (SELECT * FROM miners)

and BLOCK_TIMESTAMP >= CURRENT_DATE - 30

GROUP BY 1

ORDER by 2 DESC

limit 10