Bitcoin Ecosystem

Bitcoin Ecosystem Cubes

The Bitcoin ecosystem cubes provide data and insights related to various aspects of the Bitcoin blockchain and its ecosystem. The cubes are organized into the following categories:

Bitcoin

L2 Transactions

• Cube Name: bitcoin_l2_tx

• Description: Retrieves data about Layer 2 transactions on the Bitcoin blockchain, specifically focusing on Stacks transactions identified by the OP_RETURN code of X2.

• Dimensions:

  • bitcoin_l2_tx.address: The Bitcoin address that initiated the transaction.

  • bitcoin_l2_tx.bitcoin_script: The Bitcoin script in assembly language.

• Measures:

  • bitcoin_l2_tx.amount: The sum of satoshis involved in the transactions. This includes all amounts in the same transaction, considering all outputs.

Stacks

PoX (Proof of Transfer)

• Cube Names:

  • stacks_pox_rewards: Provides data about BTC rewards paid to PoX stackers per cycle.

  • stacks_stacked_stx: Displays the amount of STX stacked per cycle.

  • stacks_pox_burnt: Shows the amount of BTC burnt by Stacks miners per cycle.

  • stacks_stacked_stx_details: Provides granular data about stackers.

DeFi

• Cube Names:

  • stacks_tokens: Retrieves information about all SIP10 fungible tokens on the Stacks blockchain.

  • stacks_contract_calls: Provides data about all contract calls on the Stacks blockchain.

  • stacks_oracle_prices: Retrieves price data provided by the Arkadiko Oracle.

  • stacks_dapp_zest_positions: Provides granular data about Zest positions.

  • stacks_dapp_zest_positions_net: Provides aggregated data about Zest positions.

Addresses

• Cube Name:

  • stacks_wallet_tx: Provides data about wallet transactions on the Stacks blockchain.

Litecoin

Latest Block

• Cube Name: litecoin.latest_block

• Description: Retrieves the latest indexed block from the Litecoin blockchain.

Dogecoin

Latest Block

• Cube Name: dogecoin.latest_block

• Description: Retrieves the latest indexed block from the Dogecoin blockchain.

Bitcoin Cash

Latest Block

• Cube Name: bitcoin_cash.latest_block

• Description: Retrieves the latest indexed block from the Bitcoin Cash blockchain.

These cubes provide comprehensive data and analytics for the Bitcoin ecosystem, including Bitcoin itself, as well as related blockchains like Stacks, Litecoin, Dogecoin, and Bitcoin Cash. You can leverage these cubes to gain insights into transactions, stacking, token economics, DeFi activities, and more within the Bitcoin ecosystem.