Eman-RazNumber of Transactions of different chains
Updated 2022-08-27
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 table5 as (with table1 as (with tab1 as (select block_timestamp::date as day, count(tx_id) as flow_tx_count
from flow.core.fact_transactions
where day>='2022-07-01' and day<=current_date-1
group by 1
order by 1),
tab2 as (select block_timestamp::date as day, count(tx_hash) as eth_tx_count
from ethereum.core.fact_transactions
where day>='2022-07-01' and day<=current_date-1
group by 1
order by 1)
select tab1.day as day_, flow_tx_count, eth_tx_count --**********************************
from tab1 full outer join tab2 on tab1.day=tab2.DAY
order by 1),
-------------------------------------------------------------------------------------------------------
table2 as (with tab3 as (select block_timestamp::date as day, count(tx_hash) as Avalanche_tx_count
from avalanche.core.fact_transactions
where day>='2022-07-01' and day<=current_date-1
group by 1
order by 1),
tab4 as (select block_timestamp::date as day, count(tx_hash) as BSC_tx_count
from bsc.core.fact_transactions
where day>='2022-07-01' and day<=current_date-1
group by 1
order by 1)
select tab3.day as day_, Avalanche_tx_count, BSC_tx_count --****************************************************
from tab3 full outer join tab4 on tab3.day=tab4.DAY
order by 1)
-------------------------------------------------------------------------------------------------------
select table1.day_ as date_, flow_tx_count, eth_tx_count, Avalanche_tx_count, BSC_tx_count --/////////////////////////////////////////
from table1 full outer join table2 on table1.day_=table2.DAY_
order by 1),
----------------------------------------------------------------------------------------------------------------------------------
table6 as (with table3 as (with tab5 as (select block_timestamp::date as day, count(tx_id) as Algorand_tx_count
Run a query to Download Data