Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position 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_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
data_creditsSTRINGSolana 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_creditsSTRINGAccount address holding delegated data credits being burned in this transaction. Base58-encoded Solana public key representing the delegated data credits program-derived address.
escrow_accountSTRINGSolana 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.
ownerSTRINGAccount that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
payerSTRINGAccount that funds transaction fees and rent-exempt balances for new accounts. Base58-encoded Solana public key.
rewardable_entity_configSTRINGAccount 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_daoSTRINGProgram 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_rawBIGNUMERICQuantity 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.
ownerpayersub_daoamount_rawblock_slotdata_creditssurrogate_keyescrow_accounttransaction_idblock_timestampinstruction_typeexecuting_accountinstruction_indextransaction_indextransaction_signerdelegated_data_creditsouter_executing_accountouter_instruction_indexrewardable_entity_config
39Lw1RH6zt8AJvKn3BTxmUDofzduCM2J3kSaGDZ8L7Sk10099229557176D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n229557176-2ZEh5eTQhmD1jkmZEcgyq266yGFZmnTkBcyRNceG8EzYp5JavuTcRGiL9zqDvPwSz3cKECRU7RKLk2UrHHtMdBpv-0D5HidvdTUtPh5xLjdZ5J5YUxXk1hNV3vgWYkdMFgsJJv2ZEh5eTQhmD1jkmZEcgyq266yGFZmnTkBcyRNceG8EzYp5JavuTcRGiL9zqDvPwSz3cKECRU7RKLk2UrHHtMdBpv2023-11-12T11:22:34.000ZBurnDelegatedDataCreditsV0credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT0166iotdbYfWqPiDa5MruziFHxBsjHamKuEnMhkPFoW4mKE4mfGBVjcgcNciGnDzdWKh53LET7HuHx5SBr3Chb55NKN
39Lw1RH6zt8AJvKn3BTxmUDofzduCM2J3kSaGDZ8L7Sk10104229555048D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n229555048-3efLHT7Yhjb8ptWLdVxjYjsVEJ9xuvpoaJVoeMJhRxMLwNzPKYWEsB3MdutTe2FsPEUg1bjyd4cuf5U3amVemHRg-0D5HidvdTUtPh5xLjdZ5J5YUxXk1hNV3vgWYkdMFgsJJv3efLHT7Yhjb8ptWLdVxjYjsVEJ9xuvpoaJVoeMJhRxMLwNzPKYWEsB3MdutTe2FsPEUg1bjyd4cuf5U3amVemHRg2023-11-12T11:07:36.000ZBurnDelegatedDataCreditsV0credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT0118iotdbYfWqPiDa5MruziFHxBsjHamKuEnMhkPFoW4mKE4mfGBVjcgcNciGnDzdWKh53LET7HuHx5SBr3Chb55NKN
39Lw1RH6zt8AJvKn3BTxmUDofzduCM2J3kSaGDZ8L7Sk13223229504831D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n229504831-KNdnT6oZ5aeZTkojfDmowAaaHrjaJUvRGq28pJW2tofNnapcnJ5FQLDwVbmRaW49gP147ubZK6h1VcqUnRFHXCt-0D5HidvdTUtPh5xLjdZ5J5YUxXk1hNV3vgWYkdMFgsJJvKNdnT6oZ5aeZTkojfDmowAaaHrjaJUvRGq28pJW2tofNnapcnJ5FQLDwVbmRaW49gP147ubZK6h1VcqUnRFHXCt2023-11-12T05:02:34.000ZBurnDelegatedDataCreditsV0credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT092iotdbYfWqPiDa5MruziFHxBsjHamKuEnMhkPFoW4mKE4mfGBVjcgcNciGnDzdWKh53LET7HuHx5SBr3Chb55NKN
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_slotINT64Slot number of the block containing the transaction. Sequential integer representing block position in the Solana blockchain.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
transaction_indexINT64Position of the transaction within its containing block. Zero-indexed integer representing the sequential order of transaction execution.
transaction_signerSTRINGAccount that signed and authorized the transaction. Base58-encoded Solana public key.
instruction_indexINT64Position of the instruction within the transaction. Zero-indexed integer representing the sequential order of instruction execution.
outer_instruction_indexINT64Position 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_accountSTRINGProgram address that executed the instruction. Base58-encoded Solana public key.
outer_executing_accountSTRINGProgram address that invoked the current instruction when execution occurs as a nested Cross-Program Invocation (CPI). Base58-encoded Solana public key.
surrogate_keySTRINGComposite identifier for the instruction or event. Concatenation of block_slot, transaction_id, and instruction_index, separated by hyphens.
instruction_typeSTRINGType of instruction or operation being executed. Categorizes the specific action performed within the program or protocol.
data_creditsSTRINGSolana 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.
ownerSTRINGAccount that owns the position, order, or withdrawal being acted upon. Base58-encoded Solana public key.
amount_rawBIGNUMERICRaw 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.
owneramount_rawblock_slotdata_creditssurrogate_keytransaction_idblock_timestampinstruction_typeexecuting_accountinstruction_indextransaction_indextransaction_signerouter_executing_accountouter_instruction_index
2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD0264706614D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n264706614-2CpiSfpBfrFGxRkAmzJbobjBxHVnqpYwRX6ZmLRzbgi86cYjQnpDZP8wgo5239UUzN67jDMMFcXk3bs6qQLYWzqF-2-12CpiSfpBfrFGxRkAmzJbobjBxHVnqpYwRX6ZmLRzbgi86cYjQnpDZP8wgo5239UUzN67jDMMFcXk3bs6qQLYWzqF2024-05-09T05:22:05.000ZBurnWithoutTrackingV0credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT1412Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJDhemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg82
2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD0264707261D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n264707261-7pghcSkLiDfq6hyA3z8rpaJHRNTxN5dAHyLoBj2LMegrdXg6nMLyFzZZ5tP5wocyfUe4UeBRCiM7jbHYuCNo3g6-2-17pghcSkLiDfq6hyA3z8rpaJHRNTxN5dAHyLoBj2LMegrdXg6nMLyFzZZ5tP5wocyfUe4UeBRCiM7jbHYuCNo3g62024-05-09T05:27:03.000ZBurnWithoutTrackingV0credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT1362Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJDhemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg82
2Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJD0264751506D1LbvrJQ9K2WbGPMbM3Fnrf5PSsDH1TDpjqJdHuvs81n264751506-5vZFZriHv6ukTr4LBVuHSbPocJf1qKFKEoFCEFEWQ4koGu8GAt9zKBA2BVzJyWad8FnekZspyL7EFBZLuZhGa3MX-2-15vZFZriHv6ukTr4LBVuHSbPocJf1qKFKEoFCEFEWQ4koGu8GAt9zKBA2BVzJyWad8FnekZspyL7EFBZLuZhGa3MX2024-05-09T11:01:27.000ZBurnWithoutTrackingV0credMBJhYFzfn7NxBMdU4aUqFggAjgztaCcv2Fo6fPT1172Bu28xLA3g4J3C3MTepCa8SnVWjCRPJugJvixyC81iJDhemjuPXBpNvggtaUnN1MwT3wrdhttKEfosTcc2P9Pg82
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