datavortexlomba
Updated 2025-01-09
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 combined_data AS (
SELECT
from_address AS "from",
amount_usd,
block_timestamp,
DATE_TRUNC('day', block_timestamp) AS date,
CASE
WHEN to_address = LOWER('0x52c2bc859f5082c4f8c17266a3cd640b5047370e') THEN 'TOKEN_A'
WHEN to_address = LOWER('0x34bdba9b3d8e3073eb4470cd4c031c2e39c32da8') THEN 'TOKEN_B'
ELSE 'UNKNOWN'
END AS symbol
FROM
ethereum.core.ez_token_transfers
WHERE
to_address IN ('0x52c2bc859f5082c4f8c17266a3cd640b5047370e', '0x34bdba9b3d8e3073eb4470cd4c031c2e39c32da8')
),
daily_totals AS (
SELECT
date,
symbol,
COUNT(DISTINCT "from") AS daily_users,
SUM(amount_usd) AS daily_total_usd
FROM
combined_data
GROUP BY
date, symbol
)
SELECT
date,
symbol,
daily_users,
daily_total_usd,
SUM(daily_total_usd) OVER (PARTITION BY symbol ORDER BY date) AS cumulative_total_usd,
SUM(daily_users) OVER (PARTITION BY symbol ORDER BY date) AS cumulative_total_users
FROM
daily_totals
QueryRunArchived: QueryRun has been archived