Stacks

The Stacks cubes are organized into the following categories:

1. Base Cubes

2. Proof of Transfer (PoX)

3. DeFi

4. Addresses

You can find this structure within the provided Postman Collection.

Base Cubes

Latest Block

• Cube Name: stacks.latest_block

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

Proof of Transfer (PoX)

PoX Rewards

• Cube Name: stacks_pox_rewards

• Description: Provides the amount of BTC paid by Stacks miners per cycle for the opportunity to mine Stacks. The rewards are denominated in both satoshis and USD.

• Dimensions:

  • stacks_pox_rewards.cycle: The Stacks cycle number.

• Measures:

  • stacks_pox_rewards.amount: The sum of satoshis allocated to PoX rewards.

  • stacks_pox_rewards.amount_usd: The value of BTC for PoX rewards in USD.

Stacked STX (Simple)

• Cube Name: stacks_stacked_stx

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

• Dimensions:

  • stacks_stacked_stx.cycle: The Stacks cycle number.

  • stacks_stacked_stx.sender_address: The Stacks address that initiated the stacking.

• Measures:

  • stacks_stacked_stx.stacked_amount: The sum of STX that have been stacked.

PoX Burnt

• Cube Name: stacks_pox_burnt

• Description: Shows the amount of BTC burnt by Stacks miners per cycle. The burnt amount is provided in both satoshis and USD value.

• Dimensions:

  • stacks_pox_burnt.cycle: The Stacks cycle number.

• Measures:

  • stacks_pox_burnt.amount: The sum of satoshis burnt as part of Stacks PoX.

  • stacks_pox_burnt.amount_usd: The value of burnt BTC in USD.

Stacked STX Details

• Cube Name: stacks_stacked_stx_details

• Description: Provides granular data about stackers, including their Bitcoin address for receiving payments, the smart contract that initiated the stacking, and the stacking type.

• Dimensions:

  • stacks_stacked_stx_details.cycle: The Stacks cycle number.

  • stacks_stacked_stx_details.pox_addr: The Bitcoin address where the stacker receives rewards.

  • stacks_stacked_stx_details.contract_id: The smart contract that initiated the stacking transaction.

  • stacks_stacked_stx_details.stacking_type: The type of stacking transaction determined by the function called on the PoX smart contract.

• Measures:

  • stacks_stacked_stx_details.stacked_amount: The sum of STX that have been stacked.

DeFi

SIP10 Fungible Tokens

• Cube Name: stacks_tokens

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

• Dimensions:

  • stacks_tokens.name: The name of the token.

  • stacks_tokens.symbol: The symbol of the token.

  • stacks_tokens.decimals: The number of decimal places for the token.

Contract Calls

• Cube Name: stacks_contract_calls

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

• Dimensions:

  • stacks_contract_calls.contract_id: The ID of the called contract.

  • stacks_contract_calls.function_name: The name of the called function.

• Measures:

  • stacks_contract_calls.fee: The sum of fees paid for the contract calls.

  • stacks_contract_calls.asset_amount: The sum of asset amounts involved in the contract calls.

Oracle Prices

• Cube Name: stacks_oracle_prices

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

• Dimensions:

  • stacks_oracle_prices.token: The name of the token.

• Measures:

  • stacks_oracle_prices.price: The average price of the token.

Zest Positions

• Cube Name: stacks_dapp_zest_positions

• Description: Provides granular data about Zest positions.

• Dimensions:

  • stacks_dapp_zest_positions.sender_address: The Stacks address of the position holder.

  • stacks_dapp_zest_positions.asset_id: The ID of the asset in the position.

  • stacks_dapp_zest_positions.tx_type: The type of transaction (supply, borrow, repay, etc.).

  • stacks_dapp_zest_positions.asset_price: The current price of the asset.

• Measures:

  • stacks_dapp_zest_positions.adjusted_amount: The asset amount after applying decimals.

Zest Positions Net

• Cube Name: stacks_dapp_zest_positions_net

• Description: Provides aggregated data about Zest positions.

• Dimensions:

  • stacks_dapp_zest_positions_net.lender_address: The Stacks address of the lender.

  • stacks_dapp_zest_positions_net.asset_id: The ID of the asset in the position.

• Measures:

  • stacks_dapp_zest_positions_net.total_supply: The total supplied amount of the asset.

  • stacks_dapp_zest_positions_net.total_supply_usd: The total supplied amount of the asset in USD.

  • stacks_dapp_zest_positions_net.total_borrow: The total borrowed amount of the asset.

  • stacks_dapp_zest_positions_net.total_borrow_usd: The total borrowed amount of the asset in USD.

  • stacks_dapp_zest_positions_net.total_repaid: The total repaid amount of the asset.

  • stacks_dapp_zest_positions_net.total_repaid_usd: The total repaid amount of the asset in USD.

Addresses

Wallet Transactions

• Cube Name: stacks_wallet_tx

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

• Dimensions:

  • stacks_wallet_tx.sender_address: The Stacks address that initiated the transaction.

• Measures:

  • stacks_wallet_tx.gas_paid: The total gas paid for the transactions.

  • stacks_wallet_tx.transaction_count: The count of transactions.

  • stacks_wallet_tx.dapp_count: The count of dApps interacted with.

  • stacks_wallet_tx.active_days: The number of active days for the wallet.

This documentation provides an overview of the available Stacks cubes and their respective dimensions and measures. You can use the provided cube names and dimension/measure names to construct queries and retrieve data from the Stacks blockchain.