zakkisyedWithdraw Amounts by Wallets over time
    Updated 2023-04-30
    WITH daily_withdrawal_eth AS (
    SELECT
    w.WITHDRAWAL_ADDRESS,
    DATE_TRUNC('DAY', w.SLOT_TIMESTAMP) AS day,
    SUM(w.WITHDRAWAL_AMOUNT) AS daily_withdrawal_amount_eth
    FROM
    ethereum.beacon_chain.fact_withdrawals w
    GROUP BY
    w.WITHDRAWAL_ADDRESS,
    DATE_TRUNC('DAY', w.SLOT_TIMESTAMP)
    ),
    daily_withdrawal_usd AS (
    SELECT
    w.WITHDRAWAL_ADDRESS,
    DATE_TRUNC('DAY', w.SLOT_TIMESTAMP) AS day,
    SUM(w.WITHDRAWAL_AMOUNT * p.PRICE) AS daily_withdrawal_amount_usd
    FROM
    ethereum.beacon_chain.fact_withdrawals w
    JOIN
    ethereum.core.fact_hourly_token_prices p
    ON
    DATE_TRUNC('HOUR', w.SLOT_TIMESTAMP) = p.HOUR AND p.SYMBOL = 'WETH'
    GROUP BY
    w.WITHDRAWAL_ADDRESS,
    DATE_TRUNC('DAY', w.SLOT_TIMESTAMP)
    )
    SELECT
    e.WITHDRAWAL_ADDRESS,
    e.day,
    e.daily_withdrawal_amount_eth,
    u.daily_withdrawal_amount_usd
    FROM
    daily_withdrawal_eth e
    JOIN
    daily_withdrawal_usd u
    ON
    Run a query to Download Data