sunshine-juliaNum of tx per min
Updated 2022-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with near_per_min as (
select
count(distinct txn_hash)/datediff(minute, min(block_timestamp), max(block_timestamp)) as tx_per_minute,
'NEAR' as l1_blockchain
from flipside_prod_db.mdao_near.transactions
),terra_per_min as (
select
count(distinct tx_id)/datediff(minute, min(block_timestamp), max(block_timestamp)) as tx_per_minute,
'Terra' as l1_blockchain
from flipside_prod_db.terra.transactions
),ether_per_min as (
select
count(distinct tx_hash)/datediff(minute, min(block_timestamp), max(block_timestamp)) as tx_per_minute,
'Ethereum' as l1_blockchain
from ethereum.core.fact_transactions
)
SELECT * FROM near_per_min
UNION
SELECT * FROM terra_per_min
UNION
SELECT * FROM ether_per_min
Run a query to Download Data