Stacks

The following section provides details on each of the Stacks cubes within the Ortege API. These cubes represent various aspects of the Stacks blockchain, including transaction details, contract calls, lending operations, Proof of Transfer (PoX) activities, token data, and more.

1. Cube: stacks

  • Title: Stacks

  • Description: This cube tracks the latest block information on the Stacks blockchain.

  • Measures:

    • Stacks Latest Block

      • Description: Provides the highest block number available in the Stacks blockchain.

      • Aggregation Type: max

      • Cumulative Total: No

  • Dimensions: None (this cube only includes aggregated block information).

2. Cube: stacks_contract_calls

  • Title: Stacks Contract Calls

  • Description: This cube contains data on function calls within smart contracts on the Stacks blockchain, capturing information about transactions, asset events, and involved participants.

  • Measures:

    • Stacks Contract Calls Asset Amount

      • Description: Sum of asset amounts involved in contract calls.

      • Aggregation Type: sum

      • Cumulative Total: No

    • Stacks Contract Calls Fee

      • Description: Total fees paid for contract calls.

      • Aggregation Type: sum

      • Cumulative Total: No

  • Dimensions:

    • stacks_contract_calls.asset_event_type: string — The type of asset event (e.g., transfer, burn).

    • stacks_contract_calls.asset_id: string — Unique identifier of the asset involved.

    • stacks_contract_calls.asset_recipient: string — Address of the asset recipient.

    • stacks_contract_calls.block_number: number — Block number where the contract call occurred.

    • stacks_contract_calls.contract_id: string — Identifier of the contract invoked.

    • stacks_contract_calls.contract_log: string — Log data from the contract call.

    • stacks_contract_calls.event_type: string — Event type within the contract (e.g., call, execution).

    • stacks_contract_calls.function_name: string — Name of the function called.

    • stacks_contract_calls.sender_address: string — Address of the caller.

    • stacks_contract_calls.tx_date: time — Date of the transaction.

3. Cube: stacks_lending_zest

  • Title: Stacks Lending Zest

  • Description: This cube contains metrics related to lending operations within the Stacks blockchain's Zest protocol, detailing borrowed, repaid, supplied, and withdrawn asset amounts.

  • Measures:

    • Stacks Lending Zest Total Borrowed

      • Description: Sum of total assets borrowed in the Zest protocol.

      • Aggregation Type: sum

      • Cumulative Total: No

    • Stacks Lending Zest Total Repaid

      • Description: Total assets repaid.

      • Aggregation Type: sum

      • Cumulative Total: No

    • Stacks Lending Zest Total Supplied

      • Description: Sum of assets supplied to the protocol.

      • Aggregation Type: sum

      • Cumulative Total: No

    • Stacks Lending Zest Total Withdrawn

      • Description: Total amount of assets withdrawn from the protocol.

      • Aggregation Type: sum

      • Cumulative Total: No

  • Dimensions:

    • stacks_lending_zest.asset_event_type: string — Type of asset event (e.g., borrow, repay).

    • stacks_lending_zest.asset_id: string — Identifier for the asset.

    • stacks_lending_zest.asset_recipient: string — Recipient of the asset.

    • stacks_lending_zest.block_number: number — Block number when the event occurred.

    • stacks_lending_zest.contract_id: string — Contract identifier for Zest.

    • stacks_lending_zest.event_type: string — Event type within the contract.

    • stacks_lending_zest.function_name: string — Function name invoked.

    • stacks_lending_zest.sender_address: string — Address of the event initiator.

    • stacks_lending_zest.tx_date: time — Date of the transaction.

4. Cube: stacks_pox_burnt

  • Title: Stacks PoX Burnt

  • Description: This cube provides data on Bitcoin burned as part of the Stacks Proof of Transfer (PoX) protocol.

  • Measures:

    • Stacks PoX Burnt Amount USD

      • Description: Total dollar value of Bitcoin burnt in PoX operations.

      • Aggregation Type: sum

      • Cumulative Total: No

    • Stacks PoX Burnt Sum of Satoshis burnt as part of Stacks PoX

      • Description: Total satoshis burned through PoX.

      • Aggregation Type: sum

      • Cumulative Total: No

  • Dimensions:

    • stacks_pox_burnt.address: string — Address that burned the Bitcoin.

    • stacks_pox_burnt.bitcoin_script: string — Bitcoin script used in the burn.

    • stacks_pox_burnt.block_date: time — Date of the block when burning occurred.

    • stacks_pox_burnt.block_number: number — Block number of the burn event.

    • stacks_pox_burnt.cycle: number — Cycle within PoX during which the burn happened.

5. Cube: stacks_pox_rewards

  • Title: Stacks Proof of Transfer Rewards

  • Description: This cube tracks PoX reward allocations, providing data on Bitcoin rewards distributed to Stacks participants.

  • Measures:

    • Stacks PoX Rewards Sum of Satoshis allocated to PoX rewards

      • Description: Sum of Bitcoin rewards (in satoshis) given out in PoX.

      • Aggregation Type: sum

      • Cumulative Total: No

    • Stacks PoX Rewards Value of BTC for PoX rewards in USD

      • Description: Total value of Bitcoin rewards in USD.

      • Aggregation Type: sum

      • Cumulative Total: No

  • Dimensions:

    • stacks_pox_rewards.address: string — Reward recipient address.

    • stacks_pox_rewards.bitcoin_script: string — Script associated with the reward.

    • stacks_pox_rewards.block_date: time — Date of the block when rewards were distributed.

    • stacks_pox_rewards.block_number: number — Block number of the reward event.

    • stacks_pox_rewards.cycle: number — PoX cycle during which rewards were distributed.

6. Cube: stacks_stacked_stx

  • Title: Stacked STX as per PoX Smart Contract

  • Description: This cube represents data on STX tokens stacked in accordance with the PoX smart contract.

  • Measures:

    • Stacked Amount

      • Description: Total amount of STX tokens stacked.

      • Aggregation Type: sum

      • Cumulative Total: No

  • Dimensions:

    • stacks_stacked_stx.cycle: number — PoX cycle during which the STX was stacked.

    • stacks_stacked_stx.sender_address: string — Address of the STX stacker.

7. Cube: stacks_stacked_stx_details

  • Title: Stacks Stacked STX Details

  • Description: This cube offers detailed information on STX tokens stacked in PoX, including specific contract information and transaction details.

  • Measures:

    • Total Stacked

      • Description: Sum of stacked STX tokens.

      • Aggregation Type: sum

      • Cumulative Total: No

    • Total Stacked in USD

      • Description: Value of stacked STX in USD.

      • Aggregation Type: sum

      • Cumulative Total: No

  • Dimensions:

    • stacks_stacked_stx_details.contract_id: string — Smart contract ID.

    • stacks_stacked_stx_details.contract_id_called: string — Called contract ID.

    • stacks_stacked_stx_details.cycle: number — PoX cycle of stacking.

    • stacks_stacked_stx_details.function_name: string — Invoked function name.

    • stacks_stacked_stx_details.hash: string — Transaction hash.

    • stacks_stacked_stx_details.pox_addr: string — PoX address.

    • stacks_stacked_stx_details.stacking_type: string — Type of stacking transaction.

8. Cube: stacks_oracle_prices

  • Title: Oracles Prices (3)

  • Description: Stacks Oracle Price feeds. Currently supporting Arkadiko, with plans to support Dia in the future.

  • Measures:

    • Oracles Prices Price

      • Description: Average price from oracle feeds.

      • Aggregation Type: avg

      • Cumulative Total: No

  • Dimensions:

    • stacks_oracle_prices.contract_id: string — Contract ID for the oracle.

    • stacks_oracle_prices.token: string — Token symbol.

    • stacks_oracle_prices.tx_date: time — Date of the transaction.

PreviousCubesNextQuery Syntax

Last updated