ROUNDED_MONTH | UNIQUE_USERS | TX_VOL_USD | TX_COUNT | TRANSACTION_SIZE | |
|---|---|---|---|---|---|
1 | 2022-01-01 00:00:00.000 | 6604 | 1943522652464.38 | 221250 | Large |
2 | 2022-01-01 00:00:00.000 | 653333 | 34087737327.3149 | 27493873 | Small |
3 | 2022-02-01 00:00:00.000 | 6171 | 1457196378285.78 | 203834 | Large |
4 | 2022-02-01 00:00:00.000 | 519491 | 30670313670.6079 | 29619176 | Small |
5 | 2022-03-01 00:00:00.000 | 7095 | 906223359356.604 | 158341 | Large |
6 | 2022-03-01 00:00:00.000 | 547814 | 26064503677.6858 | 36474721 | Small |
7 | 2022-04-01 00:00:00.000 | 6231 | 332445781393.329 | 119039 | Large |
8 | 2022-04-01 00:00:00.000 | 504082 | 21221583749.6578 | 34563554 | Small |
9 | 2022-05-01 00:00:00.000 | 5679 | 72482278741.6147 | 81776 | Large |
10 | 2022-05-01 00:00:00.000 | 492736 | 24558250835.8011 | 22964986 | Small |
11 | 2022-06-01 00:00:00.000 | 3373 | 41310160653.1093 | 41640 | Large |
12 | 2022-06-01 00:00:00.000 | 297198 | 11309180982.8878 | 11359331 | Small |
13 | 2022-07-01 00:00:00.000 | 2329 | 20885509355.9368 | 23453 | Large |
14 | 2022-07-01 00:00:00.000 | 291415 | 7041389281.51264 | 10015406 | Small |
15 | 2022-08-01 00:00:00.000 | 2372 | 15610257622.6888 | 22685 | Large |
16 | 2022-08-01 00:00:00.000 | 298090 | 6176232011.3871 | 9377422 | Small |
17 | 2022-09-01 00:00:00.000 | 2162 | 13851988521.1092 | 21683 | Large |
18 | 2022-09-01 00:00:00.000 | 232163 | 5131081409.92508 | 8185921 | Small |
19 | 2022-10-01 00:00:00.000 | 1752 | 8185693177.36718 | 13913 | Large |
20 | 2022-10-01 00:00:00.000 | 344343 | 4187919150.10177 | 8073349 | Small |
ben-wyatterc20-and-native-token-transfers
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
›
⌄
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 avalanche.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 avalanche.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,
transaction_size;
Last run: 3 months ago
72
5KB
14s