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.
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:
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.
with transactions as (
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
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 (
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)
count(*) as frequency
group by 1,2,3
order by 4 desc
Osmosis Delegation Activity
Osmosis Validator Voting Tendencies
Trades by Pool ID on Osmosis DEX