DAY | DAILY_TXS_ECLIPSE | DAILY_TXS_BASE | DAILY_TXS_ARBITRUM | DAILY_TXS_OPTIMISM | |
|---|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 112156984 | 13394092 | 1619143 | 667417 |
2 | 2025-01-02 00:00:00.000 | 115913054 | 12492205 | 1951410 | 877279 |
3 | 2025-01-03 00:00:00.000 | 152213775 | 12401169 | 1903385 | 825000 |
4 | 2025-01-04 00:00:00.000 | 154922040 | 11736861 | 1815314 | 901190 |
5 | 2025-01-05 00:00:00.000 | 153282245 | 10479200 | 1722501 | 784736 |
6 | 2025-01-06 00:00:00.000 | 159993084 | 11937115 | 2046325 | 726032 |
7 | 2025-01-07 00:00:00.000 | 165577553 | 11194067 | 2101476 | 856002 |
8 | 2025-01-08 00:00:00.000 | 157584536 | 11087719 | 2488510 | 840937 |
9 | 2025-01-09 00:00:00.000 | 152505571 | 11405571 | 2324032 | 798814 |
odesenfansdaily-volume-eclipse-vs-base
Updated 2025-01-15
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
›
⌄
WITH daily_eclipse_volume as (
SELECT
DATE(block_timestamp) as day,
COUNT(*) as daily_txs_eclipse
FROM
eclipse.core.fact_transactions
WHERE
block_timestamp >= '2025-01-01T00:00:00Z'
AND block_timestamp < '2025-01-10T00:00:00Z'
GROUP BY
1
),
daily_base_volume AS (
SELECT
DATE(block_timestamp) as day,
COUNT(*) as daily_txs_base
FROM
base.core.fact_transactions
WHERE
block_timestamp >= '2025-01-01T00:00:00Z'
AND block_timestamp < '2025-01-10T00:00:00Z'
GROUP BY
1
),
daily_arbitrum_volume AS (
SELECT
DATE(block_timestamp) as day,
COUNT(*) as daily_txs_arbitrum
FROM
arbitrum.core.fact_transactions
WHERE
block_timestamp >= '2025-01-01T00:00:00Z'
AND block_timestamp < '2025-01-10T00:00:00Z'
GROUP BY
1
),
Last run: 3 months ago
9
559B
20s