Use Cases

Export Data

If you are a developer that needs on-chain data to power your app you can use Numia´s datasets to do so. Just like any other database BigQuery offers you the ability to export data via ETL jobs to your own backend.

You can either use the BigQuery API or any of the client libraries to connect and start querying Numia data set.

Analytics

Data from Numia can be utilized in a nearly endless amount of ways. A few sample ones are:

• Validator Dashboards

• Project & User Activity Monitoring

• Chain Analytics

• Quarterly Reporting

However, only ones own creativity (& perhaps SQL knowledge) truly limits the amount of use cases for data from Numia.

A few examples are:

Build your own dashboards

Build a Sunburst Chart

Sometimes you want to understand the most common patterns for user behavior. What are users doing after Withdrawing rewards? What do users do after delegating?

Many UX and product experts use the Sunburst chart to analyze this behavior. Here is a quick guide on how to build yours.

Video

Query

with transactions as (
select
  tx_id,
  msg_index,
  block_timestamp,
  message_type as action,
  sender as sender,
  rank() over(partition by sender order by block_timestamp asc, tx_id asc, msg_index asc) as sequence
from `numia-data.evmos.evmos_message_types_transactions`
where block_timestamp >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 90 DAY)
and message_type not in ('exec','recvpacket','acknowledgement') -- exclude actions
order by sender asc, 6 asc, msg_index asc),

actions as (
select 
  t1.tx_id,
  t1.sender,
  t1.action as action_1,
  t2.action as action_2,
  t3.action as action_3
from transactions t1
inner join transactions t2 on t1.sender = t2.sender and t2.sequence = t1.sequence + 1 and t1.action <> t2.action
inner join transactions t3 on t1.sender = t3.sender and t3.sequence = t1.sequence + 2 and t1.action <> t2.action
order by sender, t1.sequence asc)

select 
  action_1,  
  action_2, 
  action_3,
  count(*) as frequency
from actions
group by 1,2,3
order by 4 desc

Osmosis Staking and Delegation Activity

Osmosis Delegation Activity

👉 Go to Osmosis Delegation Dashboard

Validator Voting Dashboard

Osmosis Validator Voting Tendencies

👉 Go to Osmosis Validator Voting Dashboard

Chain & DEX Activity

Trades by Pool ID on Osmosis DEX

👉 Go to Osmosis Activity Dashboard