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: