drethereumStarknet mainnet vs testnet
Updated 2022-11-05
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 main AS (
SELECT
date_trunc('day',timestamp) AS time,
COUNT(DISTINCT block_number) AS num_blocks_main,
SUM(tx_count) AS num_tx_main
FROM tokenflow_starknet.decoded.blocks
WHERE chain_id = 'mainnet'
GROUP BY time
ORDER BY time DESC
),
test AS (
SELECT
date_trunc('day',timestamp) AS time,
COUNT(DISTINCT block_number) AS num_blocks_test,
SUM(tx_count) AS num_tx_test
FROM tokenflow_starknet.decoded.blocks
WHERE chain_id = 'testnet'
GROUP BY time
ORDER BY time DESC
)
SELECT
time,
num_blocks_main,
num_blocks_test,
num_tx_main,
num_tx_test
FROM main m
FULL JOIN test t USING(time)
ORDER BY time DESC
Run a query to Download Data