BLOCKCHAIN | DATE | ETH Volume | |
|---|---|---|---|
1 | Arbitrum | 2021-11-01 00:00:00.000 | 465663.24785376 |
2 | Optimism | 2021-11-01 00:00:00.000 | 37306.237373547 |
3 | Blast | 2024-09-01 00:00:00.000 | 205902.308801313 |
4 | Arbitrum | 2024-09-01 00:00:00.000 | 5061054.0847091 |
5 | Arbitrum | 2021-12-01 00:00:00.000 | 344796.454476036 |
6 | Optimism | 2021-12-01 00:00:00.000 | 53608.832178475 |
7 | Optimism | 2024-09-01 00:00:00.000 | 785549.912055573 |
8 | Base | 2024-09-01 00:00:00.000 | 5560582.3194022 |
9 | Blast | 2024-11-01 00:00:00.000 | 169306.78559574 |
10 | Arbitrum | 2024-11-01 00:00:00.000 | 5811119.46300135 |
11 | Optimism | 2024-11-01 00:00:00.000 | 943211.090057742 |
12 | Base | 2024-11-01 00:00:00.000 | 7812476.08410478 |
13 | Arbitrum | 2022-06-01 00:00:00.000 | 920585.811837321 |
14 | Optimism | 2022-06-01 00:00:00.000 | 350286.286614465 |
15 | Blast | 2024-05-01 00:00:00.000 | 1492861.78749272 |
16 | Arbitrum | 2024-05-01 00:00:00.000 | 7571235.88135493 |
17 | Optimism | 2024-05-01 00:00:00.000 | 850253.207139474 |
18 | Base | 2024-05-01 00:00:00.000 | 3165443.85190035 |
19 | Blast | 2024-02-01 00:00:00.000 | 177200.61980596 |
20 | Arbitrum | 2024-02-01 00:00:00.000 | 3645969.555052 |
rezarwzDaily ETH Volume
Updated 2025-02-24
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
›
⌄
SELECT
'Blast' as blockchain,
date_trunc('{{time_frame}}', block_Timestamp) as date,
sum(Value) as "ETH Volume"
FROM
blast.core.fact_transactions
where
block_Timestamp :: date is not null
and STATUS = 'SUCCESS'
and block_Timestamp :: date >= '{{day_from}}'
and block_Timestamp :: date <= '{{day_to}}'
group by
1,
2
UNION
all
SELECT
'Arbitrum' as blockchain,
date_trunc('{{time_frame}}', block_Timestamp) as date,
sum(Value) as "ETH Volume"
FROM
Arbitrum.core.fact_transactions
where
block_Timestamp :: date is not null
and STATUS = 'SUCCESS'
and block_Timestamp :: date >= '{{day_from}}'
and block_Timestamp :: date <= '{{day_to}}'
group by
1,
2
UNION
all
SELECT
'Optimism' as blockchain,
date_trunc('{{time_frame}}', block_Timestamp) as date,
sum(Value) as "ETH Volume"
Last run: 2 months ago
...
116
6KB
217s