Pmisha-bmlMdxcomparison
Updated 2022-06-06
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
›
⌄
with t1 as (SELECT
date_trunc('day',BLOCK_TIMESTAMP) as dt1,
TX_SUCCEEDED,
count(TX_ID)/1440 as tpm_flow
from flow.core.fact_transactions
where BLOCK_TIMESTAMP>='2022-05-09'
group by 1,2),
t2 as (SELECT
date_trunc('day',BLOCK_TIMESTAMP) as dt2,
SUCCEEDED,
count(TX_ID)/1440 as tpm_solana
from flipside_prod_db.solana.fact_transactions
where BLOCK_TIMESTAMP>='2022-05-09'
group by 1,2),
t3 as (SELECT
date_trunc('day',BLOCK_TIMESTAMP) as dt3,
STATUS,
count(TX_HASH)/1440 as tpm_ETH
from flipside_prod_db.ethereum_core.fact_transactions
where BLOCK_TIMESTAMP>='2022-05-09'
group by 1,2)
select t1.dt1 as dt,
tpm_flow,
tpm_solana,
tpm_ETH
from t1 join t2 on t1.dt1=t2.dt2
join t3 on t1.dt1=t3.dt3
Run a query to Download Data