FULL_DATES | DAILY_CQT_BALANCE_USD | |
|---|---|---|
1 | 2022-07-07 00:00:00.000 | 125510.64 |
2 | 2022-07-08 00:00:00.000 | 124827.95 |
3 | 2022-07-09 00:00:00.000 | 121678.58 |
4 | 2022-07-10 00:00:00.000 | 121774.7 |
5 | 2022-07-11 00:00:00.000 | 115993.54 |
6 | 2022-07-12 00:00:00.000 | 109281.52 |
7 | 2022-07-13 00:00:00.000 | 103916.91 |
8 | 2022-07-14 00:00:00.000 | 107178.96 |
9 | 2022-07-15 00:00:00.000 | 106427.67 |
10 | 2022-07-16 00:00:00.000 | 104028.66 |
11 | 2022-07-17 00:00:00.000 | 105989.77 |
12 | 2022-07-18 00:00:00.000 | 109564.05 |
13 | 2022-07-19 00:00:00.000 | 111098.28 |
14 | 2022-07-20 00:00:00.000 | 114969.22 |
15 | 2022-07-21 00:00:00.000 | 80228.1 |
16 | 2022-07-22 00:00:00.000 | 80345.46 |
17 | 2022-07-23 00:00:00.000 | 75656.14 |
18 | 2022-07-24 00:00:00.000 | 74871.33 |
19 | 2022-07-25 00:00:00.000 | 73814.83 |
20 | 2022-07-26 00:00:00.000 | 68298.55 |
kamilclelderly-coral
Updated 2025-04-03
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
›
⌄
-- Fee wallet ETH balances
WITH min_timestamp AS (
-- Gets the earliest date where there is a nonzero balance
SELECT
MIN(block_timestamp)::DATE AS min_date -- 2019-04-03
FROM ethereum.core.ez_balance_deltas
WHERE user_address = LOWER('0xd1669ac6044269b59fa12c5822439f609ca54f41') -- fee wallet address
AND contract_address = LOWER('0xD417144312DbF50465b1C641d016962017Ef6240')
),
dates AS (
-- Gets a list of dates
SELECT
date_day
FROM ethereum.core.dim_dates
WHERE date_day BETWEEN '2022-07-07' AND '2022-07-31'
AND date_day >= (SELECT min_date FROM min_timestamp)
),
balance_changes AS (
-- Gets the latest (in case there are multiple changes in a single day) ETH USD balance for each day there is a change
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
current_bal_usd,
prev_bal_usd
FROM ethereum.core.ez_balance_deltas
WHERE user_address = LOWER('0xd1669ac6044269b59fa12c5822439f609ca54f41') -- CGS fee wallet address
AND block_timestamp::DATE BETWEEN '2022-07-07' AND '2022-07-31'
AND contract_address = LOWER('0xD417144312DbF50465b1C641d016962017Ef6240')
AND has_price = TRUE
QUALIFY ROW_NUMBER() OVER (PARTITION BY day ORDER BY block_timestamp DESC) = 1
),
daily_cqt_balances AS (
SELECT
Last run: 24 days ago
25
938B
14s