zakkisyedWithdraw Amounts by Wallets over time
Updated 2023-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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