rezaramshiniNEAR Performance - 3
Updated 2022-07-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT count(DISTINCT TXN_HASH)/count(DISTINCT date_trunc('minute', BLOCK_TIMESTAMP)) as tx_per_minute_near, 'near' as chain
from flipside_prod_db.mdao_near.transactions
where BLOCK_TIMESTAMP::date >= '2022-04-01'
-------------------------------------------------------------------------------
UNION
SELECT count(DISTINCT TX_HASH)/count(DISTINCT date_trunc('minute', BLOCK_TIMESTAMP)) as tx_per_minute_ETH, 'ETH' as chain
from ethereum.core.fact_transactions
where BLOCK_TIMESTAMP::date >= '2022-04-01'
------------------------------------------------------------------------------------
UNION
SELECT count(DISTINCT TX_ID)/count(DISTINCT date_trunc('minute', BLOCK_TIMESTAMP)) as tx_per_minute_flow, 'flow' as chain
from flow.core.fact_transactions
where BLOCK_TIMESTAMP::date >= '2022-04-01'
Run a query to Download Data