Stacks

Stacks Data: Unveiling the Bitcoin-Powered Smart Contract Platform

Explore the innovative world of Stacks, a smart contract platform built on the security and decentralization of Bitcoin. The Ortege Data Catalog provides comprehensive datasets to analyze the Stacks ecosystem and its unique Proof of Transfer (PoX) mechanism.

Key Stacks Datasets:

1. Bitcoin-Stacks Interactions:

• bitcoin.l2_stacks_transactions: Captures all Stacks transactions that occur on the Bitcoin blockchain, providing a record of the interplay between the two networks.

2. Stacks Staking Data:

• stacks.pox<version>_stackers_<stacking type>: Offers detailed information about Stacks stakers, including their stacking type (aggregated, delegate, solo) and activity.

  • Available for both PoX3 and PoX4, reflecting the evolution of the Proof of Transfer protocol.

3. PoX4 Signers:

• stacks.pox4_signers: Provides data on the signers participating in the PoX4 consensus mechanism, the latest iteration of PoX.

4. Standardized Stacks Datasets:

• network_stats, market_stats, on_chain_tx, smart_contract_tx, account_tx: We provide semi-standardized datasets for Stacks, allowing you to analyze key metrics using a consistent structure comparable to other supported blockchains.

Calculating Stacks Staking APY:

To understand the profitability of Stacks staking, you can use SQL queries within Ortege Studio to calculate the APY for both PoX3 and PoX4. We provide sample queries and documentation to help you get started.

Unlocking Insights:

The Stacks datasets within the Ortege Data Catalog provide valuable insights into:

• The mechanics of the Proof of Transfer mechanism.

• The relationship between Bitcoin and Stacks.

• The growth and development of the Stacks ecosystem.

• The economics of Stacks staking.

Start Exploring Stacks:

Visit the Ortege Data Catalog to access these comprehensive Stacks datasets and uncover the potential of Bitcoin-powered smart contracts: