helium_v1_solana

Tables

BurnDelegatedDataCreditsV0_instruction

Data credit burn transactions from Helium IoT subDAO on Solana, recording delegated credit consumption by devices for network usage. Useful for tracking IoT device activity and data credit economics across the Helium network.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`data_credits`	`STRING`	Solana account address holding the Data Credits token account for the Helium network. Base58-encoded 32-byte public key used to track data credit balances.
`delegated_data_credits`	`STRING`	Account address holding delegated data credits being burned in this transaction. Base58-encoded Solana public key representing the delegated data credits program-derived address.
`escrow_account`	`STRING`	Solana account address holding the escrowed data credits being burned in this transaction. Base58-encoded string representing the program-derived address (PDA) that manages the delegated credit balance.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`payer`	`STRING`	Account that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
`rewardable_entity_config`	`STRING`	Account address of the rewardable entity configuration associated with this data credit burn instruction. This field is typically null for most burn operations as seen in the sample data.
`sub_dao`	`STRING`	Program address of the Helium subDAO (IOT or MOBILE) under which the data credits are being burned. Base58-encoded Solana account identifier, consistently populated in all burn transactions.
`amount_raw`	`BIGNUMERIC`	Quantity of delegated data credits burned in this instruction, denominated in the smallest unit. Values typically range from 10,000 to 14,000 based on network data transfer costs.

Sample Data

sub_dao	amount_raw	block_slot	data_credits	surrogate_key	escrow_account	transaction_id	block_timestamp	instruction_type	executing_account	transaction_index	transaction_signer	delegated_data_credits
39Lw1RH6zt8AJvKn3BTxmUDofzduCM2J3kSaGDZ8L7Sk	10099	229557176	D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n	229557176-2ZEh5eTQhmD1jkmZEcgyq266yGFZmnTkBcyRNceG8EzYp5JavuTcRGiL9zqDvPwSz3cKECRU7RKLk2UrHHtMdBpv-0	D5HidvdTUtPh5xLjdZ5J5YUxXk1hNV3vgWYkdMFgsJJv	2ZEh5eTQhmD1jkmZEcgyq266yGFZmnTkBcyRNceG8EzYp5JavuTcRGiL9zqDvPwSz3cKECRU7RKLk2UrHHtMdBpv	2023-11-12T11:22:34.000Z	BurnDelegatedDataCreditsV0	credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT	166	iotdbYfWqPiDa5MruziFHxBsjHamKuEnMhkPFoW4mKE	4mfGBVjcgcNciGnDzdWKh53LET7HuHx5SBr3Chb55NKN
39Lw1RH6zt8AJvKn3BTxmUDofzduCM2J3kSaGDZ8L7Sk	10104	229555048	D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n	229555048-3efLHT7Yhjb8ptWLdVxjYjsVEJ9xuvpoaJVoeMJhRxMLwNzPKYWEsB3MdutTe2FsPEUg1bjyd4cuf5U3amVemHRg-0	D5HidvdTUtPh5xLjdZ5J5YUxXk1hNV3vgWYkdMFgsJJv	3efLHT7Yhjb8ptWLdVxjYjsVEJ9xuvpoaJVoeMJhRxMLwNzPKYWEsB3MdutTe2FsPEUg1bjyd4cuf5U3amVemHRg	2023-11-12T11:07:36.000Z	BurnDelegatedDataCreditsV0	credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT	118	iotdbYfWqPiDa5MruziFHxBsjHamKuEnMhkPFoW4mKE	4mfGBVjcgcNciGnDzdWKh53LET7HuHx5SBr3Chb55NKN
39Lw1RH6zt8AJvKn3BTxmUDofzduCM2J3kSaGDZ8L7Sk	13223	229504831	D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n	229504831-KNdnT6oZ5aeZTkojfDmowAaaHrjaJUvRGq28pJW2tofNnapcnJ5FQLDwVbmRaW49gP147ubZK6h1VcqUnRFHXCt-0	D5HidvdTUtPh5xLjdZ5J5YUxXk1hNV3vgWYkdMFgsJJv	KNdnT6oZ5aeZTkojfDmowAaaHrjaJUvRGq28pJW2tofNnapcnJ5FQLDwVbmRaW49gP147ubZK6h1VcqUnRFHXCt	2023-11-12T05:02:34.000Z	BurnDelegatedDataCreditsV0	credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT	92	iotdbYfWqPiDa5MruziFHxBsjHamKuEnMhkPFoW4mKE	4mfGBVjcgcNciGnDzdWKh53LET7HuHx5SBr3Chb55NKN

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.helium_v1_solana.BurnDelegatedDataCreditsV0_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BurnWithoutTrackingV0_instruction

Data credit burn instructions from Helium network on Solana that destroy credits without tracking usage, recording owner accounts and burn amounts. Used for analyzing Helium network payment flows and data credit consumption patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_slot`	`INT64`	Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
`transaction_id`	`STRING`	Unique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
`transaction_index`	`INT64`	Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
`transaction_signer`	`STRING`	Account that signed and authorized the transaction. Base58-encoded Solana public key.
`instruction_index`	`INT64`	Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
`outer_instruction_index`	`INT64`	Position of the parent instruction that invoked the current instruction through a Cross-Program Invocation. Zero-indexed integer representing the sequential order of the outer instruction within the transaction.
`executing_account`	`STRING`	Program address that executed the instruction. Base58-encoded Solana public key.
`outer_executing_account`	`STRING`	Program address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
`surrogate_key`	`STRING`	Composite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
`instruction_type`	`STRING`	Type of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
`data_credits`	`STRING`	Solana account address receiving the data credits (DC) from the burn operation. Base58-encoded, typically 32-44 character string identifying the DC balance account on Helium network.
`owner`	`STRING`	Account that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
`amount_raw`	`BIGNUMERIC`	Raw token amount being burned in this instruction, denominated in the smallest unit of the token. All sample values show ‘0’, indicating burns without tracked amounts in this instruction variant.

Sample Data

owner	block_slot	data_credits	surrogate_key	transaction_id	block_timestamp	instruction_type	executing_account	instruction_index	transaction_index	transaction_signer	outer_executing_account	outer_instruction_index
2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD	264706614	D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n	264706614-2CpiSfpBfrFGxRkAmzJbobjBxHVnqpYwRX6ZmLRzbgi86cYjQnpDZP8wgo5239UUzN67jDMMFcXk3bs6qQLYWzqF-2-1	2CpiSfpBfrFGxRkAmzJbobjBxHVnqpYwRX6ZmLRzbgi86cYjQnpDZP8wgo5239UUzN67jDMMFcXk3bs6qQLYWzqF	2024-05-09T05:22:05.000Z	BurnWithoutTrackingV0	credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT	1	41	2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD	hemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg8	2
2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD	264707261	D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n	264707261-7pghcSkLiDfq6hyA3z8rpaJHRNTxN5dAHyLoBj2LMegrdXg6nMLyFzZZ5tP5wocyfUe4UeBRCiM7jbHYuCNo3g6-2-1	7pghcSkLiDfq6hyA3z8rpaJHRNTxN5dAHyLoBj2LMegrdXg6nMLyFzZZ5tP5wocyfUe4UeBRCiM7jbHYuCNo3g6	2024-05-09T05:27:03.000Z	BurnWithoutTrackingV0	credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT	1	36	2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD	hemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg8	2
2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD	264751506	D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n	264751506-5vZFZriHv6ukTr4LBVuHSbPocJf1qKFKEoFCEFEWQ4koGu8GAt9zKBA2BVzJyWad8FnekZspyL7EFBZLuZhGa3MX-2-1	5vZFZriHv6ukTr4LBVuHSbPocJf1qKFKEoFCEFEWQ4koGu8GAt9zKBA2BVzJyWad8FnekZspyL7EFBZLuZhGa3MX	2024-05-09T11:01:27.000Z	BurnWithoutTrackingV0	credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT	1	17	2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD	hemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg8	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.helium_v1_solana.BurnWithoutTrackingV0_instruction`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

BurnDelegatedDataCreditsV0_instruction

BurnWithoutTrackingV0_instruction

​Tables

​BurnDelegatedDataCreditsV0_instruction

​BurnWithoutTrackingV0_instruction

Tables

BurnDelegatedDataCreditsV0_instruction

BurnWithoutTrackingV0_instruction