hessDaily Transactions
Updated 2023-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date(block_timestamp) as date, 'OSMOSIS' as chain, count(DISTINCT(tx_from)) as total_user,
count(DISTINCT(tx_id)) as total_tx
from osmosis.core.fact_transactions
where date >= '2023-01-01'
group by 1,2
UNION
select date(block_timestamp) as date, 'Terra' as chain, count(DISTINCT(tx_sender)) as total_user,
count(DISTINCT(tx_id)) as total_tx
from terra.core.fact_transactions
where date >= '2023-01-01'
group by 1,2
Run a query to Download Data