ROUNDED_MONTH | UNIQUE_USERS | TX_VOL_USD | TX_COUNT | TRANSACTION_SIZE | |
|---|---|---|---|---|---|
1 | 2022-01-01 00:00:00.000 | 6607 | 2.47043592002359e+35 | 221265 | Large |
2 | 2022-01-01 00:00:00.000 | 704433 | 34087737327.3149 | 38835780 | Small |
3 | 2022-02-01 00:00:00.000 | 6171 | 1457196378285.78 | 203834 | Large |
4 | 2022-02-01 00:00:00.000 | 581182 | 30670313670.6079 | 37939981 | Small |
5 | 2022-03-01 00:00:00.000 | 7098 | 2520163973979520000 | 158346 | Large |
6 | 2022-03-01 00:00:00.000 | 589558 | 26064503677.6858 | 43225797 | Small |
7 | 2022-04-01 00:00:00.000 | 6233 | 440945815984.113 | 119042 | Large |
8 | 2022-04-01 00:00:00.000 | 527449 | 21221583749.6578 | 38211727 | Small |
9 | 2022-05-01 00:00:00.000 | 5679 | 98152975823.6649 | 81780 | Large |
10 | 2022-05-01 00:00:00.000 | 513907 | 24558250835.8011 | 26228819 | Small |
11 | 2022-06-01 00:00:00.000 | 3373 | 41310160653.1093 | 41640 | Large |
12 | 2022-06-01 00:00:00.000 | 308832 | 11309180982.8878 | 13936664 | Small |
13 | 2022-07-01 00:00:00.000 | 2329 | 20885509355.9368 | 23453 | Large |
14 | 2022-07-01 00:00:00.000 | 301859 | 7041389281.51264 | 12134379 | Small |
15 | 2022-08-01 00:00:00.000 | 2372 | 15610257622.6888 | 22685 | Large |
16 | 2022-08-01 00:00:00.000 | 308138 | 6176232011.3871 | 11318399 | Small |
17 | 2022-09-01 00:00:00.000 | 2162 | 13851988521.1092 | 21683 | Large |
18 | 2022-09-01 00:00:00.000 | 241875 | 5131081409.92507 | 9706528 | Small |
19 | 2022-10-01 00:00:00.000 | 1752 | 8185693177.36718 | 13913 | Large |
20 | 2022-10-01 00:00:00.000 | 353157 | 4187919150.10177 | 10499791 | Small |
ben-wyattunit-query
Updated 2025-02-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
›
⌄
--this combines the ez_native_transfer and the ez_token_transfer tables together
--grabs the amount_usd values and does a little bit of by-row analysis
SELECT
DATE_TRUNC('month', block_timestamp) AS rounded_month,
COUNT(DISTINCT from_address) AS unique_users,
SUM(amount_usd) AS tx_vol_usd,
COUNT(*) AS tx_count,
CASE
WHEN amount_usd > 100000 THEN 'Large'
ELSE 'Small'
END AS transaction_size
FROM (
SELECT
block_timestamp,
from_address,
amount_usd
FROM {{chain}}.core.ez_token_transfers
WHERE block_timestamp BETWEEN '2022-01-01' AND '2024-12-31'
UNION ALL
SELECT
block_timestamp,
from_address,
amount_usd,
FROM {{chain}}.core.ez_native_transfers
WHERE block_timestamp BETWEEN '2022-01-01' AND '2024-12-31'
) AS combined_transfers
--where amount_usd < 1e9
GROUP BY
rounded_month,
transaction_size
ORDER BY
rounded_month,
Last run: 3 months ago
72
5KB
9s