BLOCKCHAIN | DATE | Avg ETH Volume per TX | |
|---|---|---|---|
1 | Blast | 2024-05-01 00:00:00.000 | 0.07385008714 |
2 | Arbitrum | 2024-05-01 00:00:00.000 | 0.1085355136 |
3 | Optimism | 2024-05-01 00:00:00.000 | 0.0514980162 |
4 | Base | 2024-05-01 00:00:00.000 | 0.05550702947 |
5 | Blast | 2024-11-01 00:00:00.000 | 0.01037983178 |
6 | Arbitrum | 2024-11-01 00:00:00.000 | 0.08936619453 |
7 | Optimism | 2024-11-01 00:00:00.000 | 0.03587422543 |
8 | Base | 2024-11-01 00:00:00.000 | 0.04578167046 |
9 | Arbitrum | 2023-04-01 00:00:00.000 | 0.1044565492 |
10 | Optimism | 2023-04-01 00:00:00.000 | 0.06727504805 |
11 | Arbitrum | 2021-11-01 00:00:00.000 | 0.6122008733 |
12 | Optimism | 2021-11-01 00:00:00.000 | 0.06174679007 |
13 | Blast | 2024-08-01 00:00:00.000 | 0.01057801349 |
14 | Arbitrum | 2024-08-01 00:00:00.000 | 0.1024063101 |
15 | Optimism | 2024-08-01 00:00:00.000 | 0.0430753656 |
16 | Base | 2024-08-01 00:00:00.000 | 0.04277205312 |
17 | Blast | 2024-09-01 00:00:00.000 | 0.01167690821 |
18 | Arbitrum | 2024-09-01 00:00:00.000 | 0.09411239773 |
19 | Arbitrum | 2021-12-01 00:00:00.000 | 0.444322465 |
20 | Optimism | 2021-12-01 00:00:00.000 | 0.04806337598 |
rezarwzAvg ETH Volume per TX
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,
avg(Value) as "Avg ETH Volume per TX"
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,
avg(Value) as "Avg ETH Volume per TX"
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,
avg(Value) as "Avg ETH Volume per TX"
Last run: 2 months ago
...
116
6KB
152s