MoDeFi#NEAR Q5- Performance 3
Updated 2022-07-20
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
›
⌄
SELECT
(select avg(txs_minute) as near_avg_txs
from
(SELECT date_trunc('minute',BLOCK_TIMESTAMP) as date_minute, count(distinct TXN_HASH) as txs_minute
FROM flipside_prod_db.mdao_near.transactions
where BLOCK_TIMESTAMP>='2022-01-01'
group by date_minute)) as near_avg_txs,
(select avg(txs_minute) as sol_avg_txs
from
(SELECT date_trunc('minute',BLOCK_TIMESTAMP) as date_minute, sum(1) as txs_minute
FROM solana.core.fact_transactions
where BLOCK_TIMESTAMP>='2022-01-01'
group by date_minute)) as sol_avg_txs,
(select avg(txs_minute) as eth_avg_txs
from
(SELECT date_trunc('minute',BLOCK_TIMESTAMP) as date_minute, count(distinct TX_HASH) as txs_minute
FROM ethereum.core.fact_transactions
where BLOCK_TIMESTAMP>='2022-01-01'
group by date_minute)) as eth_avg_txs,
(select avg(txs_minute) as flow_avg_txs
from
(SELECT date_trunc('minute',BLOCK_TIMESTAMP) as date_minute, count(distinct TX_ID) as txs_minute
FROM flow.core.fact_transactions
where BLOCK_TIMESTAMP>='2022-01-01'
group by date_minute)
)as flow_avg_txs,
(select avg(txs_minute) as algo_avg_txs
from
(SELECT date_trunc('minute',BLOCK_TIMESTAMP) as date_minute, count(distinct TX_ID) as txs_minute
FROM flipside_prod_db.algorand.transactions
where BLOCK_TIMESTAMP>='2022-01-01'
group by date_minute)) as algo_avg_txs
Run a query to Download Data