On-chain Analytics

stacks on chain model

The first batch of on-chain analytics is here! We are diving into the Stacksonchain data model and finding key nuggets of information about the Bitfari blockchain growth + Stacks. we will consolidate key queries here to share with the community and set up a dashboard once Stacksonchains opens up their platform. Here are the first Bitfari on-chain queries:

— Native Fari Transfers (Not StackSwap)
select block_height, count(*) from transactions
where contract_call_contract_id like ‘%.fari-token-mn’ and contract_call_function_name=’transfer’
and status = 1
group by 1

— Native Bitfari Screens
select sender_address, tx_index, block_height from transactions
where contract_call_contract_id like ‘%.screen-reg’ and contract_call_function_name=’claim’
and status = 1

— Get Fari Token Holders
select SUM(count) as token_holders
from
(
select block_height, count(*) as count from transactions
where contract_call_contract_id like ‘%.fari-token-mn’ and contract_call_function_name=’transfer’
and status = 1
group by 1
) as total

Plus Some Key STX Reports:

To run your own queries or to discover more on-chain analytics visit:

https://stacksonchain.com/query

Privacy Preferences
When you visit our website, it may store information through your browser from specific services, usually in form of cookies. Here you can change your privacy preferences. Please note that blocking some types of cookies may impact your experience on our website and the services we offer.
Share via
Copy link
Powered by Social Snap