ML65opintropt
Updated 2023-03-06
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with axelar_table as (select count(*) / (24*60*60) as tps , trunc(block_timestamp, 'DAY') as d from axelar.core.fact_transactions where year(block_timestamp)=2023 group by d)
, osmosis_table as (select count(*) / (24*60*60) as tps , trunc(block_timestamp, 'DAY') as d from osmosis.core.fact_transactions where year(block_timestamp)=2023 group by d)
, cosmos_table as (select count(*) / (24*60*60) tps , trunc(block_timestamp, 'DAY') as d from cosmos.core.fact_transactions where year(block_timestamp)=2023 group by d)
select 'AXELAR CHAIN' , tps , d from axelar_table
UNION
select 'OSMOSIS CHAIN' , tps , d from osmosis_table
UNION
select 'COSMOS CHAIN' , tps , d from cosmos_table
Run a query to Download Data