hopr_v1_gnosis

Tables

HoprChannels_ChannelBalanceDecreased_event

Payment channel balance reduction events from the HOPR privacy mixnet protocol on Gnosis Chain. Tracks state channel balance decreases with updated amounts for analyzing node payment flows and channel lifecycle management.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channelId`	`STRING`	Unique identifier for the HOPR payment channel where the balance decrease occurred. Hex-encoded, 0x-prefixed 64-character string that remains constant across multiple balance adjustment events.
`in_newBalance`	`STRING`	Updated balance of the HOPR payment channel after a decrease event, denominated in the smallest token unit (wei equivalent). Values represent token amounts with 18 decimal places of precision.

Sample Data

address	removed	log_index	block_number	in_channelId	in_newBalance	block_timestamp	transaction_hash
0x693bac5ce61c720ddc68533991ceb41199d8f8ae	false	708	30552733	0x01961e92a3c2c7658283e3cc37049197ebc0a579f5b1f7948292e91674081b1b	79700000000000000000	2023-10-20T15:21:05.000Z	0xb2bfc5b51a48ba511357001c1c5a096709aacb1db6fbb2408ce243f3e2b3f506
0x693bac5ce61c720ddc68533991ceb41199d8f8ae	false	743	30552733	0x01961e92a3c2c7658283e3cc37049197ebc0a579f5b1f7948292e91674081b1b	79000000000000000000	2023-10-20T15:21:05.000Z	0x5b201b757896a029bdf6b9c0b81403466decd1ecd8adb63ff56c1353483cbaa6
0x693bac5ce61c720ddc68533991ceb41199d8f8ae	false	713	30552733	0x01961e92a3c2c7658283e3cc37049197ebc0a579f5b1f7948292e91674081b1b	79600000000000000000	2023-10-20T15:21:05.000Z	0x77797320a443519dd500665ab15a419ddb6cd9b8dc619a269efa6971b9aa9e94

Example Query

Query with partition filter

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

HoprChannels_ChannelBalanceIncreased_event

Channel funding events from HOPR privacy mixnet protocol on Gnosis Chain recording when payment channel balances increase. Tracks channel identifiers, updated balance amounts, and funding transactions for analyzing node liquidity and network capacity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_channelId`	`STRING`	Unique identifier for the HOPR payment channel where the balance increase occurred. Hex-encoded 64-character hash that remains consistent across all balance updates for the same channel.
`in_newBalance`	`STRING`	Updated balance of the HOPR payment channel after the increase, denominated in the smallest token unit (wei). Values typically range from small amounts like 1000000 to larger deposits of 50-100 tokens (with 18 decimal places).

Sample Data

address	removed	log_index	block_number	in_channelId	in_newBalance	block_timestamp	transaction_hash
0x693bac5ce61c720ddc68533991ceb41199d8f8ae	false	2515	31132936	0x70c5503d77e34023f63912c4430b683afc8cb20298c910f71ed46de0f27613d3	1000000	2023-11-26T01:00:00.000Z	0x9e7428b09c0c94a7ba72a99f83d28258fb24f02e63e237ec1113e301a7707490
0x693bac5ce61c720ddc68533991ceb41199d8f8ae	false	2834	31136280	0x542e1b50e3e980c0b5e6e109cdd6d426cdedd6df902acfe3ac44128550083fae	50000000000000000000	2023-11-26T05:52:05.000Z	0xe8f6fd96e100d11490e69a310c95ff72e6e773ca5eefa0c456ca917baad7a251
0x693bac5ce61c720ddc68533991ceb41199d8f8ae	false	301	31136288	0x8315b7eaa42530c9acf99fad8115cb3b9d1469db187d15b78b9e920c95c61980	50000000000000000000	2023-11-26T05:52:45.000Z	0x76cb311c30de295bd575dfa633b2ee7847aafe81920511dee2ccfed03353bcad

Example Query

Query with partition filter

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

HoprChannels_redeemTicket_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_redeemable`	`STRUCT<data STRUCT<channelId STRING, amount STRING, ticketIndex STRING, indexOffset STRING, epoch STRING, winProb STRING>, signature STRUCT<r STRING, vs STRING>, porSecret STRING>`	-
`in_params`	`STRUCT<vx STRING, vy STRING, s STRING, h STRING, sBx STRING, sBy STRING, hVx STRING, hVy STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

HoprChannels_redeemTicketSafe_function

Ticket redemption function calls from HOPR payment channels on Gnosis Chain. Contains cryptographic proofs and signatures for validating probabilistic micropayments used in HOPR’s mixnet relay node incentivization.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_self`	`STRING`	Wallet address of the HOPR channel participant initiating the safe ticket redemption. Hex-encoded, 0x-prefixed 40-character Ethereum address on Gnosis Chain.
`in_redeemable`	`STRUCT<data STRUCT<channelId STRING, amount STRING, ticketIndex STRING, indexOffset STRING, epoch STRING, winProb STRING>, signature STRUCT<r STRING, vs STRING>, porSecret STRING>`	Structured ticket data being redeemed in a HOPR payment channel, including ticket parameters (epoch, amount, winning probability, channel ID, indexes) and cryptographic proof of redemption (PoR secret and signature). Null when redemption fails or parameters are malformed.
`in_params`	`STRUCT<vx STRING, vy STRING, s STRING, h STRING, sBx STRING, sBy STRING, hVx STRING, hVy STRING>`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

gas	status	in_self	gas_used	in_params	signature	to_address	block_number	from_address	in_redeemable	trace_address	block_timestamp	transaction_hash
315855	true	0x880f8befc1aeed187c1e5ead9cd4da27ebfa0da4	161591	{“h”:“64723716947591932904326132455051018096362327060861864340576853939306926637914”,“s”:“86978435110809644113609020324396176770260594239375740644824353935932147968728”,“vx”:“373879384000622919950075329250763736990944563682186422536415733030213468765”,“vy”:“44805412842324662664903688049831839166123084874422031801677475587676463774891”,“hVx”:“15072489575412258626775646891379894744352044732617765395127566650573620972529”,“hVy”:“59542660943996072213808064077323837590338768639490828182627925026922340094783”,“sBx”:“64688796512256670536794966506457016814626122823891880925680421766592899583873”,“sBy”:“9187139126182651707986184650291043713153429076756956827659310625219323107212”}	0x0cd88d72	0x693bac5ce61c720ddc68533991ceb41199d8f8ae	37597236	0x835c648516ead289631f7a4f888136065dc0e19e	{“data”:{“epoch”:“6”,“amount”:“10174500000000000000”,“winProb”:“72057594037927935”,“channelId”:“0x2363417a23180f61aab0d3f768e976bd43a3fc2f25d8f309593f20f4e5c1946f”,“indexOffset”:“30065”,“ticketIndex”:“210304”},“porSecret”:“78215537207976839001417947255163247412936531288115259524491001443780245624094”,“signature”:{“r”:“0x54d206816aec269bf552cad16404de16350cc2ac7657071483472fc42a6efbb2”,“vs”:“0xd8b152a39cac17b31fa7b115972c2a6995fda723116c238d01eea23344561d1e”}}	0,0,0,0	2024-12-19T00:26:30.000Z	0x5448e23a9d8ffa9ab717de04b37f08788ca8ca2aa4f170fcb4320ea190747b19
315855	true	0x0f375299ace67dd161a43c4d1202cf36e82c6ddf	161566	{“h”:“25988613264533459490461087569342132777659805647947884760055097992585894354596”,“s”:“31296462589115583460819239375991321121670347868923469647965329358616667234032”,“vx”:“21276038130625372968912438656524257322174026180469201797769456074640399793765”,“vy”:“87641979453036770175823639502453171703215118006869006898305570546030532526742”,“hVx”:“79090641246504100875520920783299994698717333288971410063321915659430599691322”,“hVy”:“83623356930298389015910239933509994646387831357600656489278297383686993789905”,“sBx”:“107432483995864260041373521778024134961188791978947333290172841097094356779381”,“sBy”:“89671109066983688559004568541943908619228212699470149599735125519526976288322”}	0x0cd88d72	0x693bac5ce61c720ddc68533991ceb41199d8f8ae	37601987	0xa91220f99e56ca2120e9bfe2f1eeecc4152deddb	{“data”:{“epoch”:“6”,“amount”:“15021000000000000000”,“winProb”:“72057594037927935”,“channelId”:“0x5ffead17198fb77f070d2e37bf8e8495066a243ed21299a4cf90177d5a52bdad”,“indexOffset”:“201946”,“ticketIndex”:“43058”},“porSecret”:“11260929780125287570417718332827701223469375842207327440617515208812420850647”,“signature”:{“r”:“0xa647a2b031188f7656cf6487e9fa8020d0356866f0101136585e3d1060e18243”,“vs”:“0x9100e62707659ec32db88e1d93f25925ed5f12b24fc175a0d7fa532077ec558a”}}	0,0,0,0	2024-12-19T07:16:05.000Z	0x6f15c0b005cd5adfabf0043b2e2e0c9197ee8d9096bb29b971a9cc830e077b18
315867	true	0x796412ae48305136cfba97efea39c6233cdae0b1	161591	{“h”:“9369372568708410902686151970138539744240171117174884453992213893250059215868”,“s”:“58125409498103660645037852228793050087374334031861872118138375504078237900134”,“vx”:“31332241738961827530890326426236038142500536087660361061716348527873036338666”,“vy”:“6252393408242542501834452378733615259516263676356896066869335533130590260017”,“hVx”:“90404534306137197308543293354440812559609851207735750470139050252171599923226”,“hVy”:“76835476697769743560639092092585712202860536082925178494359639476695537936239”,“sBx”:“15004183147935181543910383032954070993607628417844990699319061665976123210081”,“sBy”:“77583049298328712531430738391893861323405883256643367109558538253213868612721”}	0x0cd88d72	0x693bac5ce61c720ddc68533991ceb41199d8f8ae	37608927	0xc2956824932eba56ba75150c2c14f04548dceaed	{“data”:{“epoch”:“7”,“amount”:“30066000000000000000”,“winProb”:“72057594037927935”,“channelId”:“0x785174c58837e50dfc7b49102b9e801c7b2d13f59b75e611806f9e5481eccc20”,“indexOffset”:“165827”,“ticketIndex”:“0”},“porSecret”:“8947540119690905513775751369889697862416005072522198439174342981213094416245”,“signature”:{“r”:“0x196113a348fb419718e87f533dfc54d3b9e450fa6d59e08522d8d420f8191278”,“vs”:“0x8fbf1f06a38b67415ebb9c5fb9f001f8499928804792e7b00cc2fa22a5c19bba”}}	0,0,0,0	2024-12-19T17:16:10.000Z	0xc4573eb5eced532ef8033eda9bb4da92e35a061cf35a3d9a4a02484fb2a02ac4

Example Query

Query with partition filter

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

HoprNodeStakeFactory_NewHoprNodeStakeSafe_event

Factory contract events recording the deployment of new HOPR node staking Safe contracts on Gnosis Chain. Used for tracking node operator onboarding and identifying unique staking Safe addresses (in_instance) created through the factory.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_instance`	`STRING`	Contract address of the newly created HoprNodeStakeSafe instance deployed by the factory. Hex-encoded, 0x-prefixed 40-character string representing the Gnosis Safe used for HOPR node staking.

Sample Data

address	removed	log_index	in_instance	block_number	block_timestamp	transaction_hash
0x098b275485c406573d042848d66eb9d63fca311c	false	17	0x8d3d937193cbeff0088b8cd480e99d8c1090b659	29943182	2023-09-12T20:15:05.000Z	0x6bfa4ed4151bd8bd540f9d545a150290070cc348a7657c5ee11ab41938706ece
0x098b275485c406573d042848d66eb9d63fca311c	false	19	0x2187f1fea0f7a5b360dc7cd7119981a87a86bdec	29936814	2023-09-12T11:00:20.000Z	0x323cf134631d2e41b3252e178ee7e8bc76056409b0f57b72fa68b0464445f666
0x098b275485c406573d042848d66eb9d63fca311c	false	19	0xa3f25b8e661e11d3761d12ba09fa4ab59ecb1909	29929373	2023-09-12T00:00:50.000Z	0x0454a9b816355c8351d3e368751c6cabc254319882a23e4f3f0b855f995dc608

Example Query

Query with partition filter

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

HoprTicketPriceOracle_setTicketPrice_function

Transaction records of ticket price updates for the HOPR network’s TicketPriceOracle contract on Gnosis Chain. Captures administrative price adjustments with new ticket price values in wei, useful for analyzing HOPR protocol economic parameters and governance activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in__newTicketPrice`	`STRING`	The new ticket price value being set in the HOPR network’s price oracle contract, denominated in wei (smallest unit). Values typically range from 15-30 trillion wei (0.000015-0.03 tokens), representing the cost for HOPR payment channel tickets.

Sample Data

gas	status	gas_used	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in__newTicketPrice
163471	true	8891	0x15981650	0xca5656fe6f2d847aca32cf5f38e51d2054ca1273	36631838	0xd9a00176cf49dfb9ca3ef61805a2850f45cb1d05	0,0,2	2024-10-22T08:43:40.000Z	0x940c1f6e4221e7772bccdb7b727e9d00621265b80c9a5d3eebfc70fff30ae748	1500000000000000
163448	true	8891	0x15981650	0xca5656fe6f2d847aca32cf5f38e51d2054ca1273	36450167	0xd9a00176cf49dfb9ca3ef61805a2850f45cb1d05	0,0,2	2024-10-11T12:07:00.000Z	0xa05c7893e399190b27f08a53d65e69a580c7d8a3244036234c8a8eb2df6fb09f	750000000000000
32245	true	8891	0x15981650	0xca5656fe6f2d847aca32cf5f38e51d2054ca1273	38274858	0xd9a00176cf49dfb9ca3ef61805a2850f45cb1d05	0,1	2025-01-28T17:17:35.000Z	0x2a89ba751d3f7eb8f36e85a72e57ac8a922eece95cf5986759e925e479190b2b	15000000000000

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

HoprChannels_ChannelBalanceDecreased_event

HoprChannels_ChannelBalanceIncreased_event

HoprChannels_redeemTicket_function

HoprChannels_redeemTicketSafe_function

HoprNodeStakeFactory_NewHoprNodeStakeSafe_event

HoprTicketPriceOracle_setTicketPrice_function

​Tables

​HoprChannels_ChannelBalanceDecreased_event

​HoprChannels_ChannelBalanceIncreased_event

​HoprChannels_redeemTicket_function

​HoprChannels_redeemTicketSafe_function

​HoprNodeStakeFactory_NewHoprNodeStakeSafe_event

​HoprTicketPriceOracle_setTicketPrice_function

Tables

HoprChannels_ChannelBalanceDecreased_event

HoprChannels_ChannelBalanceIncreased_event

HoprChannels_redeemTicket_function

HoprChannels_redeemTicketSafe_function

HoprNodeStakeFactory_NewHoprNodeStakeSafe_event

HoprTicketPriceOracle_setTicketPrice_function