ML6Number of transactions over time op7
Updated 2022-09-08Copy Reference Fork
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
›
⌄
select count(distinct TX_HASH),to_date(block_timestamp) ,'NEAR'
from near.core.fact_transactions
group by 2
having to_date(block_timestamp)>= '2022-06-15'
UNION
select count(distinct TX_HASH),to_date(block_timestamp) , 'Optimism'
from optimism.core.fact_transactions
group by 2
having to_date(block_timestamp)>= '2022-06-15'
UNION
select count(distinct TX_HASH),to_date(block_timestamp) , 'Ethereum'
from ethereum.core.fact_transactions
group by 2
having to_date(block_timestamp)>= '2022-06-15'
--UNION
--select count(1),to_date(block_timestamp) , 'Solana'
--from solana.core.fact_transactions
--group by 2
-- having to_date(block_timestamp)>= '2022-06-15'
UNION
select count(1),to_date(block_timestamp) , 'Polygon'
from polygon.core.fact_transactions
group by 2
having to_date(block_timestamp)>= '2022-06-15'
Run a query to Download Data