MoDeFi#NEAR Q5- Performance 2
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
›
⌄
with near_txs_pm as
(select date_minute::date as date, 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)
group by date),
sol_txs_pm as
(select date_minute::date as date, 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)
group by date),
eth_txs_pm as
(select date_minute::date as date, 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)
group by date),
flow_txs_pm as
(select date_minute::date as date, 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)
group by date),
Run a query to Download Data