WITH Last30DaysBalances AS (
SELECT
USER_ADDRESS AS Address,
current_bal_usd,
symbol
FROM
ethereum.core.ez_balance_deltas
WHERE
BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 days'
)
SELECT
symbol,
COUNT(DISTINCT Address) AS Total_Addresses_With_Non_Zero_Balance
FROM
Last30DaysBalances
WHERE
current_bal_usd > 0 and SYMBOL = 'ETH'
GROUP BY
symbol
ORDER BY
Total_Addresses_With_Non_Zero_Balance DESC