SELECT BLOCK_TIMESTAMP::date AS "time", COUNT (DISTINCT TX_HASH) AS withdraw_transactions, COUNT (DISTINCT WITHDRAWER) AS distinct_withdrawer, w.SYMBOL AS token_withdrawn, SUM (AMOUNT_WITHDRAWN * PRICE) as volume_withdrawn FROM ethereum.maker.ez_withdrawals w
LEFT JOIN ethereum.core.fact_hourly_token_prices d ON HOUR = BLOCK_TIMESTAMP::date AND w.symbol = d.symbol WHERE BLOCK_TIMESTAMP >= '2022-01-01' AND TX_STATUS = 'SUCCESS' GROUP BY "time", w.SYMBOL
--Daily Number of Distinct Withdrawers
--Withdarawal Transactions by Assets Withdrawn
--Daily USD Volume of Withdrawals
--Daily Number of Withdrawal Transactions