DATE | TRANSFER_VOLUME | TRANSACTIONS | ACTIVE_ADDRESSES | |
|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | 583880576800.165 | 41517892 | 998736 |
2 | 2025-02-01 00:00:00.000 | 1885187668334.5 | 37321898 | 1164888 |
3 | 2025-01-01 00:00:00.000 | 1344361183447.89 | 36684381 | 1420147 |
4 | 2024-12-01 00:00:00.000 | 906510299676.307 | 34334858 | 1048093 |
5 | 2024-11-01 00:00:00.000 | 560017765676.667 | 31923350 | 727391 |
6 | 2024-10-01 00:00:00.000 | 462965913358.145 | 23995952 | 611946 |
7 | 2024-09-01 00:00:00.000 | 252441134730.757 | 19483586 | 606104 |
8 | 2024-08-01 00:00:00.000 | 92052357295.9567 | 21195819 | 626054 |
9 | 2024-07-01 00:00:00.000 | 81607245530.3081 | 18321112 | 689762 |
10 | 2024-06-01 00:00:00.000 | 55593379672.4935 | 18107948 | 804848 |
11 | 2024-05-01 00:00:00.000 | 22321722200.951 | 14004673 | 669532 |
12 | 2024-04-01 00:00:00.000 | 23259344041.2752 | 17915212 | 689359 |
13 | 2024-03-01 00:00:00.000 | 13459248697.4003 | 8492541 | 475442 |
14 | 2024-02-01 00:00:00.000 | 3758460318.11466 | 4816150 | 284641 |
15 | 2024-01-01 00:00:00.000 | 3730851229.32075 | 4009054 | 243005 |
16 | 2023-12-01 00:00:00.000 | 3324245062.62245 | 3419876 | 234173 |
17 | 2023-11-01 00:00:00.000 | 2322080796.59716 | 2810767 | 209778 |
18 | 2023-10-01 00:00:00.000 | 2928284657.22824 | 3166397 | 244531 |
19 | 2023-09-01 00:00:00.000 | 3155789281.12921 | 1865445 | 171912 |
20 | 2023-08-01 00:00:00.000 | 2019323011.94681 | 1091878 | 144498 |
zyroqperiod 2
Updated 2025-03-31
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
›
⌄
with tf AS (
SELECT
ORIGIN_FROM_ADDRESS,
TX_HASH,
AMOUNT,
DATE_TRUNC('{{granularity }}', BLOCK_TIMESTAMP) AS date
FROM base.core.ez_token_transfers
WHERE CONTRACT_ADDRESS IN (
LOWER('0x833589fcd6edb6e08f4c7c32d4f71b54bda02913'),
LOWER('0xb79dd08ea68a908a97220c76d19a6aa9cbde4376'),
LOWER('0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca'),
LOWER('0x4621b7a9c75199271f773ebd9a499dbd165c3191'),
LOWER('0x50c5725949a6f0c72e6c4a641f24049a917db0cb'),
LOWER('0x417ac0e078398c154edfadd9ef675d30be60af93'),
LOWER('0xfde4c96c8593536e31f229ea8f37b2ada2699bb2'),
LOWER('0xca72827a3d211cfd8f6b00ac98824872b72cab49'),
LOWER('0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'),
LOWER('0xcfa3ef56d303ae4faaba0592388f19d7c3399fb4'),
LOWER('0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42')
)
AND LOWER(FROM_ADDRESS) <> '0x0000000000000000000000000000000000000000'
AND LOWER(TO_ADDRESS) <> '0x0000000000000000000000000000000000000000'
)
SELECT
date,
SUM(f.AMOUNT) AS transfer_volume,
COUNT(f.TX_HASH) AS transactions,
COUNT(DISTINCT f.ORIGIN_FROM_ADDRESS) AS active_addresses,
FROM tf f
GROUP BY date
ORDER BY date DESC;
Last run: 25 days ago
21
1KB
102s