ML6Number of transactions over time
Updated 2022-08-09
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
›
⌄
select count(distinct TXN_HASH),to_date(block_timestamp) ,'NEAR'
from mdao_near.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