messariOsmosis Daily
Updated 2023-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) as date,
SUM(GAS_USED) as gas_used,
COUNT(DISTINCT BLOCK_ID) as num_blocks,
COUNT(DISTINCT TX_FROM) as num_active_users,
COUNT(DISTINCT TX_ID) as num_transactions
FROM
osmosis.core.fact_transactions
WHERE
TX_SUCCEEDED = true
GROUP BY
date
order by
date desc
Run a query to Download Data