MLDZMNTPS
Updated 2022-06-01
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 tb1 as (
with seconds_tps as (
SELECT
date_trunc('second',block_timestamp) seconds,
count(tx_id) tps
from Solana.fact_transactions
where block_timestamp >= '2022-01-01'
group by 1)
select
'Solana' as Blockchain,
date_trunc('week', seconds) "week",
max(tps) max_tps
from seconds_tps
group by 1,2),
tb2 as (
with seconds_tps as (
SELECT
date_trunc('second',block_timestamp) seconds,
count(tx_hash) tps
from ethereum_core.fact_transactions
where block_timestamp >= '2022-01-01'
group by 1)
select
'Ethereum' as Blockchain,
date_trunc('week', seconds) "week",
max(tps) max_tps
from seconds_tps
group by 1,2)
select * from tb1
Run a query to Download Data