PlaywoCrossChain: L2 Block TX Count
Updated 2022-07-27Copy Reference Fork
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
›
⌄
WITH polygon AS (
SELECT 'Polygon' AS chain, DATE_TRUNC({{timeframe}}, block_timestamp) AS time,
avg(tx_count) AS average_tx_count
FROM polygon.core.fact_blocks
GROUP BY time
),
optimism AS (
SELECT 'Optimism' AS chain, DATE_TRUNC({{timeframe}}, block_timestamp) AS time,
avg(tx_count) AS average_tx_count
FROM optimism.core.fact_blocks
GROUP BY time
),
arbitrum AS (
SELECT 'Arbitrum' AS chain, DATE_TRUNC({{timeframe}}, block_timestamp) AS time,
avg(tx_count) AS average_tx_count
FROM arbitrum.core.fact_blocks
GROUP BY time
),
collected AS (
SELECT * FROM polygon UNION
SELECT * FROM arbitrum UNION
SELECT * FROM optimism
),
mins AS (
SELECT min(time) AS first_entry_time
FROM collected
GROUP BY chain
)
SELECT * FROM collected
WHERE time >= (SELECT max(first_entry_time) FROM mins)
Run a query to Download Data