azuro_v1_gnosis

Tables

Core_ConditionResolved_event

Condition settlement events from Azuro prediction market protocol on Gnosis Chain, recording winning outcomes and liquidity provider profits for resolved betting conditions. Used for analyzing market resolution patterns and LP performance across prediction markets.

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_conditionId`	`STRING`	Unique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
`in_state`	`INT64`	State identifier or account address representing the protocol’s global state or configuration. Base58-encoded Solana public key for Solana programs, numeric identifier for EVM event logs.
`in_outcomeWin`	`STRING`	Identifier representing the winning outcome for the resolved betting condition in Azuro’s prediction market. The numeric value corresponds to a specific outcome option (e.g., team, score, result) that was determined as the winner.
`in_lpProfit`	`STRING`	Profit or loss incurred by liquidity providers (LP) when this Azuro betting condition was resolved, expressed in wei. Typically zero when the house breaks even on the resolved bet.

Sample Data

address	removed	in_state	log_index	block_number	in_outcomeWin	in_conditionId	block_timestamp	transaction_hash
0xc95c831c7bdb0650b8cd5f2a542b263872d8ed0e	false	1	13	29359842	106	581884142000000000	2023-08-08T13:27:20.000Z	0xc97534da4ebd872a8399d47523cde1fdf6d72e5d5c0614124badea66ee0a8171
0xc95c831c7bdb0650b8cd5f2a542b263872d8ed0e	false	1	18	29359842	101	581884105581884106	2023-08-08T13:27:20.000Z	0xc97534da4ebd872a8399d47523cde1fdf6d72e5d5c0614124badea66ee0a8171
0xc95c831c7bdb0650b8cd5f2a542b263872d8ed0e	false	1	9	29359842	107	581884084584040287	2023-08-08T13:27:20.000Z	0xc97534da4ebd872a8399d47523cde1fdf6d72e5d5c0614124badea66ee0a8171

Example Query

Query with partition filter

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

Core_NewBet_event

Bet placement events from Azuro prediction market protocol on Gnosis Chain, capturing bettor addresses, wager amounts, odds, outcome selections, and liquidity pool states at time of bet. Used for analyzing betting patterns, market liquidity dynamics, and affiliate referral 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.
`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_bettor`	`STRING`	Wallet address of the user placing the bet on the Azuro prediction market. Hex-encoded, 0x-prefixed 40-character Ethereum address identifying the bettor on Gnosis Chain.
`in_affiliate`	`STRING`	Address of the affiliate who referred the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_conditionId`	`STRING`	Unique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`in_outcomeId`	`STRING`	Identifier for the specific outcome being wagered on within a betting condition. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_odds`	`STRING`	Betting odds offered for the wager at the time of bet placement. Numeric string representation scaled by 10^12 (fixed-point decimal with 12 decimal places of precision).
`in_funds`	`ARRAY<STRING>`	Fund transfer routing parameters for a swap operation. Struct containing sender address, recipient address, and boolean flags indicating whether to use internal balance for source (fromInternalBalance) and destination (toInternalBalance) of funds.

Sample Data

address	in_odds	removed	in_funds	in_amount	in_bettor	log_index	in_tokenId	block_number	in_affiliate	in_outcomeId	in_conditionId	block_timestamp	transaction_hash
0xc95c831c7bdb0650b8cd5f2a542b263872d8ed0e	2228052187129	false	[“956603051786983606903”,“1442256687277371393097”]	5000000000000000000	0x2b96d9d537c3551ebfdd0e213bcd375588ab6f95	5	29340	27462042	0x82875517c2b4bd534de4b2c0d21bff5f40b25da6	165	514320495514320496	2023-04-15T14:57:25.000Z	0xcca5694db5cf2c78c146a625fa0337b438f1bf7730c8140a80bcfc033459da34
0xc95c831c7bdb0650b8cd5f2a542b263872d8ed0e	2151702924682	false	[“995541938549151941779”,“1403623695365097058221”]	5500000000000000000	0x2b96d9d537c3551ebfdd0e213bcd375588ab6f95	2	29368	27463775	0x82875517c2b4bd534de4b2c0d21bff5f40b25da6	106	514323228000000000	2023-04-15T17:27:45.000Z	0x032a6c59ae437ca3d8e3dc0d80f02b779ae738b47707e50110d34f340ccef768
0xc95c831c7bdb0650b8cd5f2a542b263872d8ed0e	1719532243646	false	[“1123081176433845341346”,“1277390009396829378654”]	1680000000000000000	0x35f5b90b8e9283a83d3617625fe0297460191a8f	8	29285	27460761	0x82875517c2b4bd534de4b2c0d21bff5f40b25da6	84	521209246521209247	2023-04-15T13:07:05.000Z	0x815012a36ba9de34d1295c827d1a1fd907298d2dc9c621c1f1d002009d52a2b7

Example Query

Query with partition filter

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

Core1_ConditionCreated_event

Condition creation events from Azuro v1 prediction market protocol on Gnosis Chain, linking internal condition IDs to oracle-provided outcomes with timestamps. Used for tracking new betting markets initialization and mapping protocol conditions to external oracle data feeds.

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_oracleConditionId`	`STRING`	External oracle’s unique identifier for this betting condition, used to link Azuro’s internal condition tracking with the upstream data source. Stored as a numeric string that references the oracle provider’s condition registry.
`in_conditionId`	`STRING`	Unique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
`in_timestamp`	`STRING`	Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.

Sample Data

address	removed	block_number	in_timestamp	in_conditionId	block_timestamp	transaction_hash	in_oracleConditionId
0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	false	22940335	1656720000	1806	2022-07-01T11:06:05.000Z	0x047ce57ac885b73508c14c7a37b29f4aeb2f639a87df27907c32dc9ac65a3c3f	42663
0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	false	22940353	1656720000	1812	2022-07-01T11:07:35.000Z	0x12b7bae0bf53121e71f7d9367ea9dc70b7a64da7d89191e3ecbe8e718e9c35c9	42705
0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	false	22940329	1656720000	1804	2022-07-01T11:05:35.000Z	0xb512a46af85ea31e4ccce16bd3f99bd32d0955e52f7a8872d9e5c8db71e2f57b	42708

Example Query

Query with partition filter

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

Core1_ConditionResolved_event

Bet settlement events from Azuro prediction market protocol on Gnosis Chain, recording winning outcomes and liquidity provider (LP) payouts for resolved betting conditions. Links oracle-determined results to condition IDs for analyzing market resolution patterns and LP profitability.

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_oracleConditionId`	`STRING`	Identifier for the oracle-level condition in Azuro’s prediction market protocol that maps to the platform’s internal condition ID. Links the on-chain betting condition to the external oracle system that provides settlement data.
`in_conditionId`	`STRING`	Unique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
`in_outcomeWin`	`STRING`	Winning outcome identifier for the resolved betting condition, typically ranging from 1-3 representing different possible results. Stored as a string numeric value indicating which prediction market outcome was determined correct by the oracle.
`in_state`	`INT64`	State identifier or account address representing the protocol’s global state or configuration. Base58-encoded Solana public key for Solana programs, numeric identifier for EVM event logs.
`in_amountForLp`	`STRING`	Amount returned to the liquidity pool after the betting condition resolves, denominated in the pool’s base token with 18 decimal precision. Values typically range around 5000 tokens (5e21 in raw format).

Sample Data

address	removed	in_state	log_index	block_number	in_outcomeWin	in_amountForLp	in_conditionId	block_timestamp	transaction_hash	in_oracleConditionId
0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	false	1	1	23751106	1	4980681555843999999999	11071	2022-08-17T22:08:05.000Z	0x534a44a23af177073cf4d5615502d58f99824c2dee7d3be0b76a8c7fbf62b175	66140
0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	false	1	12	23745784	1	5132742896571999999999	11078	2022-08-17T14:29:00.000Z	0x317dac733cf097554ded9445e40b2e3a5e8a0a6e9b40ccb31290985573a08070	67749
0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	false	1	0	23738185	1	5001080625048999999999	11074	2022-08-17T03:33:50.000Z	0x05c5ca77714e2b599c7933b668ee1da534fe57f0618bd65fde22e07761833549	66143

Example Query

Query with partition filter

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

Core1_updateReinforcements_function

Function call records for updating reinforcement parameters in Azuro prediction market protocol on Gnosis Chain. Contains paired condition ID and amount values for adjusting liquidity pool backing across multiple betting markets.

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_data`	`ARRAY<STRING>`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

gas	status	in_data	gas_used	signature	to_address	block_number	from_address	block_timestamp	transaction_hash
343925	true	[“1”,“5000000000000000000000”,“2”,“5000000000000000000000”,“3”,“5000000000000000000000”,“4”,“5000000000000000000000”,“5”,“5000000000000000000000”,“6”,“5000000000000000000000”,“7”,“5000000000000000000000”,“8”,“5000000000000000000000”,“9”,“5000000000000000000000”,“10”,“5000000000000000000000”,“11”,“5000000000000000000000”,“12”,“5000000000000000000000”,“13”,“5000000000000000000000”,“14”,“5000000000000000000000”,“15”,“5000000000000000000000”,“16”,“5000000000000000000000”,“17”,“5000000000000000000000”,“18”,“5000000000000000000000”,“19”,“5000000000000000000000”,“20”,“5000000000000000000000”,“21”,“5000000000000000000000”,“22”,“5000000000000000000000”,“23”,“8000000000000000000000”,“24”,“8000000000000000000000”,“25”,“5000000000000000000000”,“26”,“5000000000000000000000”,“27”,“5000000000000000000000”,“28”,“5000000000000000000000”,“29”,“8000000000000000000000”,“30”,“8000000000000000000000”,“31”,“8000000000000000000000”,“32”,“1000000000000000000000”,“33”,“1000000000000000000000”,“34”,“1000000000000000000000”,“35”,“1000000000000000000000”,“36”,“1000000000000000000000”,“37”,“1000000000000000000000”,“38”,“8000000000000000000000”,“39”,“8000000000000000000000”,“40”,“8000000000000000000000”,“41”,“1000000000000000000000”,“42”,“1000000000000000000000”,“43”,“1000000000000000000000”,“44”,“1000000000000000000000”,“45”,“1000000000000000000000”,“46”,“1000000000000000000000”,“47”,“1000000000000000000000”,“48”,“1000000000000000000000”]	337076	0xaf795470	0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	23554894	0x92fb32a7baec4237b250fb96403a12c7c89fdc2f	2022-08-06T09:44:50.000Z	0x5f982621595a1864d7f9b724917231b3b7f9de01457ca273eecaff88c10057ac
168740	true	[“1”,“5000000000000000000000”,“2”,“5000000000000000000000”,“9”,“5000000000000000000000”,“10”,“5000000000000000000000”,“13”,“5000000000000000000000”,“14”,“5000000000000000000000”,“23”,“5000000000000000000000”,“24”,“5000000000000000000000”,“29”,“20000000000000000000000”,“30”,“20000000000000000000000”,“31”,“20000000000000000000000”,“38”,“20000000000000000000000”,“39”,“20000000000000000000000”,“40”,“20000000000000000000000”,“6995”,“2000000000000000000000”,“6996”,“2000000000000000000000”,“7009”,“2000000000000000000000”,“7010”,“2000000000000000000000”,“7011”,“2000000000000000000000”,“7012”,“2000000000000000000000”,“7013”,“2000000000000000000000”,“7014”,“2000000000000000000000”,“34”,“2000000000000000000000”,“35”,“2000000000000000000000”,“36”,“2000000000000000000000”,“37”,“2000000000000000000000”,“41”,“2000000000000000000000”,“42”,“2000000000000000000000”,“6989”,“2000000000000000000000”,“6990”,“2000000000000000000000”,“6991”,“2000000000000000000000”,“6992”,“2000000000000000000000”,“6993”,“2000000000000000000000”,“6994”,“2000000000000000000000”]	164549	0xaf795470	0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	25137011	0x92fb32a7baec4237b250fb96403a12c7c89fdc2f	2022-11-24T15:04:25.000Z	0xfa3dfc08214f6a277263c1e7b8ded13d22675176279d6c8afe2edcca0a2d81b5
185807	true	[“1”,“5000000000000000000000”,“2”,“5000000000000000000000”,“9”,“5000000000000000000000”,“10”,“5000000000000000000000”,“13”,“5000000000000000000000”,“14”,“5000000000000000000000”,“23”,“5000000000000000000000”,“24”,“5000000000000000000000”,“29”,“10000000000000000000000”,“30”,“10000000000000000000000”,“31”,“10000000000000000000000”,“38”,“10000000000000000000000”,“39”,“10000000000000000000000”,“40”,“10000000000000000000000”,“6995”,“2000000000000000000000”,“6996”,“2000000000000000000000”,“7009”,“2000000000000000000000”,“7010”,“2000000000000000000000”,“7011”,“2000000000000000000000”,“7012”,“2000000000000000000000”,“7013”,“2000000000000000000000”,“7014”,“2000000000000000000000”,“34”,“2000000000000000000000”,“35”,“2000000000000000000000”,“36”,“2000000000000000000000”,“37”,“2000000000000000000000”,“41”,“2000000000000000000000”,“42”,“2000000000000000000000”,“6989”,“2000000000000000000000”,“6990”,“2000000000000000000000”,“6991”,“2000000000000000000000”,“6992”,“2000000000000000000000”,“6993”,“2000000000000000000000”,“6994”,“2000000000000000000000”]	181349	0xaf795470	0x4fe6a9e47db94a9b2a4ffede8db1602fd1fdd37d	25133907	0x92fb32a7baec4237b250fb96403a12c7c89fdc2f	2022-11-24T10:26:55.000Z	0x5d66697de98920ffe583b83c944907135144f056b49f9eb119232855fac5cde9

Example Query

Query with partition filter

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

Factory_NewPool_event

Pool creation events from Azuro prediction market protocol on Gnosis Chain. Tracks deployment of new liquidity pools (LP) with their associated core contracts, access controls, and pool type identifiers for monitoring protocol expansion.

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_lp`	`STRING`	Liquidity pool contract address. Hex-encoded, 0x-prefixed, 42-character string.
`in_core`	`STRING`	Contract address of the core Azuro protocol component deployed for this new pool. References the primary liquidity pool contract that manages betting markets and odds calculations.
`in_coreType`	`STRING`	Smart contract identifier or hash representing the type of Azuro core protocol implementation being used for this pool. This appears as a 32-byte keccak256 hash and categorizes the pool’s operational logic or version.
`in_access`	`STRING`	Contract address of the access control component for this Azuro liquidity pool. Hex-encoded, 0x-prefixed 40-character string managing permissions and governance for pool operations.

Sample Data

in_lp	address	in_core	removed	in_access	log_index	in_coreType	block_number	block_timestamp	transaction_hash
0x204e7371ade792c5c006fb52711c50a7efc843ed	0x8ea1a7241537f10fa73363fdc6380f3fc8619c03	0xc95c831c7bdb0650b8cd5f2a542b263872d8ed0e	false	0xc6c6b2f43180bfe7d6193d4cd41c34ce952def08	18	0x56ff202de9ba417fbc2912bebe53dea80efb0df607262a180f0517649590c806	26026907	2023-01-18T13:09:20.000Z	0x4d99426eafbc6fd5234a7921a8b3a97277d4c53d6a4a216404fe59a81c7fdff5

Example Query

Query with partition filter

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

LP_FeeChanged_event

Fee configuration change events from Azuro v1 liquidity pool (LP) contract on Gnosis Chain. Tracks adjustments to different fee types with values stored in basis points, useful for analyzing protocol fee evolution and governance decisions.

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_feeType`	`INT64`	Enumerated identifier for the category or classification of fee being charged or updated. Integer or string-encoded numeric value representing distinct fee type codes.
`in_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	log_index	in_feeType	block_number	block_timestamp	transaction_hash
50000000000	0x204e7371ade792c5c006fb52711c50a7efc843ed	false	0	2	28017702	2023-05-19T06:33:50.000Z	0x906078ba0a8aaa966bd2530679ac9d1120ad928ce468886881442c66e585c1b9
100000000000	0x204e7371ade792c5c006fb52711c50a7efc843ed	false	1	1	26422135	2023-02-11T09:39:55.000Z	0xb6b18fa782792f4d24eed22c628aa55b1dcc202aba9eaa06d668c941a881d17e
10000000000	0x204e7371ade792c5c006fb52711c50a7efc843ed	false	0	0	26422135	2023-02-11T09:39:55.000Z	0xb6b18fa782792f4d24eed22c628aa55b1dcc202aba9eaa06d668c941a881d17e

Example Query

Query with partition filter

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

LP_GameShifted_event

Game start time update events from Azuro prediction market Liquidity Pool (LP) contract on Gnosis Chain. Tracks when betting games have their start times rescheduled, useful for monitoring event postponements and analyzing oracle timing adjustments.

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_gameId`	`STRING`	Unique identifier for a game event in the Azuro prediction market protocol. Numeric string identifier that corresponds to a specific betting game that had its start time rescheduled.
`in_newStart`	`STRING`	Unix timestamp representing the rescheduled start time for the betting game identified in the event. Emitted when Azuro protocol shifts a game’s start time, typically due to real-world event postponements.

Sample Data

address	removed	in_gameId	in_newStart	block_number	block_timestamp	transaction_hash
0x204e7371ade792c5c006fb52711c50a7efc843ed	false	1566004922	1676169720	26366921	2023-02-08T02:22:05.000Z	0x8d419471649dcc6a534150ed073394b7d54bcbd44a09c8cd646af6e549ca8ef6
0x204e7371ade792c5c006fb52711c50a7efc843ed	false	1565674343	1676162520	26366929	2023-02-08T02:22:45.000Z	0x44294ee9a6eedd77237190d59bb9958f912b2fcffee4f5eb5bf3453a5f2801d4
0x204e7371ade792c5c006fb52711c50a7efc843ed	false	1565674341	1676166120	26366918	2023-02-08T02:21:50.000Z	0xfe2015095f9a88b89d05644a47b342b120617688f291404ae77520bdb8cb4a69

Example Query

Query with partition filter

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

LP_LiquidityAdded_event

Liquidity provider deposit events from Azuro v1 prediction market protocol on Gnosis Chain, tracking account addresses, token amounts (in wei), and leaf identifiers for each LP addition. Used for analyzing liquidity provider behavior and capital flows into Azuro’s betting pools.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_leaf`	`STRING`	Unique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_leaf	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x204e7371ade792c5c006fb52711c50a7efc843ed	1099511628237	false	200000000000000000000	4	0xaaac47bb9b16bcf89fdb54b1326327a223458d6d	30357042	2023-10-08T13:06:20.000Z	0x7dbf9503d9b91129acbb74628e862291643e7f7d72f8dc90983020a88308efbc
0x204e7371ade792c5c006fb52711c50a7efc843ed	1099511628236	false	1500000000000000000000	2533	0xaaac47bb9b16bcf89fdb54b1326327a223458d6d	30354851	2023-10-08T09:48:15.000Z	0x9d8b85fa65592ea0c699e25790495dffc295e958bd4dea85549711fe089922e5
0x204e7371ade792c5c006fb52711c50a7efc843ed	1099511628051	false	29980000000000000000000	2	0x74b3bb13ee674428795877742148c97124ee7358	27994789	2023-05-17T21:19:40.000Z	0x5b5ee2999c00179b0bf9727d3875a9cc5f3a9b55d3ce337d4bbfe350050e9104

Example Query

Query with partition filter

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

LP_LiquidityRemoved_event

Liquidity withdrawal events from Azuro v1 decentralized prediction market protocol on Gnosis chain, tracking LP (Liquidity Provider) token removals with account addresses, amounts, and leaf identifiers. Used for analyzing liquidity provider behavior and pool position changes over time.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_leaf`	`STRING`	Unique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_leaf	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x204e7371ade792c5c006fb52711c50a7efc843ed	1099511628000	false	103604626219245513032	0	0xee74ab7b50efd8284013a8554b207e110607ffe5	27959431	2023-05-15T17:57:05.000Z	0x1fb589f17f059e90cb0ec6390e84408f07f39f6a07227a84e039053e47e6c8cb
0x204e7371ade792c5c006fb52711c50a7efc843ed	1099511628006	false	62599578709139463595	0	0xd231d9feb1b5c12d2434e5e2aaca538049858f62	27962607	2023-05-15T22:32:00.000Z	0xe97dc077315eee64652aec5d511d4f066bf883b0782bfc3c757335b4ee6e3775
0x204e7371ade792c5c006fb52711c50a7efc843ed	1099511627776	false	5000000000	48	0x92fb32a7baec4237b250fb96403a12c7c89fdc2f	26221651	2023-01-30T09:07:55.000Z	0x6c5dd6eaae1e5ca50eab89a531b962f39d662001fab9d1b12c40da73405c7609

Example Query

Query with partition filter

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

LP1_LiquidityAdded_event

Liquidity provision events from Azuro v1 prediction market protocol on Gnosis Chain (formerly xDai). Records deposits into liquidity pool LP1 with account addresses, token amounts, and leaf identifiers for tracking liquidity provider positions.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_leaf`	`STRING`	Unique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier.

Sample Data

address	in_leaf	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1099511627810	false	900000000000000000	3	0xbf2052378c32c2e006e688a44c7f0a3d2de28a7b	24580872	2022-10-13T16:49:35.000Z	0xc9b3555b061722762267fdc7c46d2ec970ed2758b67ea01fe938328bd25a5fc1
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1099511627807	false	1000000000000000000	7	0x0d62b886234ea4dc9bd86fab239578dcd0075fb0	24579834	2022-10-13T14:56:30.000Z	0xb2cc72a9dbab3576a920b27293d0e54c9cf47a47685a000dad393f2e475b88f4
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1099511627808	false	1111111111110000000	9	0xa416b49c0e513ffdd25198f709ccb553256642dc	24579986	2022-10-13T15:12:45.000Z	0xad701e2a732f43f0269e5cd214b6a05bb6596f754d15246a5de2183aab7171cf

Example Query

Query with partition filter

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

LP1_LiquidityRemoved_event

Liquidity withdrawal events from Azuro v1 betting protocol liquidity pool on Gnosis Chain. Tracks LP token removals with amounts, account addresses, and leaf identifiers for analyzing liquidity provider behavior and pool depth changes.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_leaf`	`STRING`	Unique identifier for a liquidity position in the pool. Numeric string representation of a position index or leaf node identifier.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_leaf	removed	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1099511627779	false	100360301608021733679	2	0xbbb0f0b7f4a5851da0651a89f49e29ce70c6c5cb	24081974	2022-09-07T16:36:15.000Z	0x8cae96f65554cbbfe8aa69e72a66f86ed2cba3827a58ad953a639467b46cff7b
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1099511627809	false	10028837093647137877	32	0x458cd345b4c05e8df39d0a07220feb4ec19f5e6f	26241554	2023-01-31T14:07:15.000Z	0x2663d9c882701ba8cf133fba3468357ead80ac4f9d5be29144ba69109ebc06e3
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1099511627813	false	500160054248056648257121	1	0x458cd345b4c05e8df39d0a07220feb4ec19f5e6f	26241631	2023-01-31T14:14:05.000Z	0x5f754932ba29fdd859aeaa3abe1742272bf66fa8d01dc67fee318b5833f7fe47

Example Query

Query with partition filter

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

LP1_NewBet_event

Bet placement events from Azuro decentralized prediction markets protocol on Gnosis Chain, capturing bet owner, amount, odds, condition ID, and liquidity pool balances at time of placement. Used for analyzing betting patterns, odds movements, and market liquidity dynamics across prediction market conditions.

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_owner`	`STRING`	Address that owns or controls the shares or position being deposited or withdrawn. Hex-encoded, 0x-prefixed, 42-character string.
`in_betId`	`STRING`	Sequential identifier assigned to each bet placed on the Azuro platform. Unique integer values starting from 37071 in these samples.
`in_conditionId`	`STRING`	Unique identifier for a betting condition or market outcome. Numeric string representation of the condition’s ID in the protocol.
`in_outcomeId`	`STRING`	Identifier for the specific outcome being wagered on within a betting condition. Numeric string representation.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_odds`	`STRING`	Betting odds offered for the wager at the time of bet placement. Numeric string representation scaled by 10^12 (fixed-point decimal with 12 decimal places of precision).
`in_fund1`	`STRING`	Pool balance for outcome 1 after the bet is placed, denominated in the protocol’s base token with 18 decimal precision. Represents total liquidity allocated to one side of the betting condition.
`in_fund2`	`STRING`	Liquidity pool balance allocated to outcome 2 for this betting condition after the bet is placed. Denominated in wei (10^18 units per token), representing the pool’s exposure to the opposite side of the wager.

Sample Data

address	in_odds	removed	in_betId	in_fund1	in_fund2	in_owner	in_amount	log_index	block_number	in_outcomeId	in_conditionId	block_timestamp	transaction_hash
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1711166315	false	37202	2798857775516966501020	2203142224483033498979	0x72430cfc6cbead96b2ef218ce6791a394fb50bbe	2000000000000000000	31	24209536	1	17428	2022-09-16T13:30:30.000Z	0xfc51d03728768f9d5fc72e4b80063b9f7d51117ea252f65dd18145e6c8fe22f8
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1793286147	false	37070	2664120897035558719879	2336879102964441280120	0x0ec926b9c3d1fbc0c8643238e57f10a1ce2a8f52	1000000000000000000	2	24205376	1	17443	2022-09-16T06:23:50.000Z	0x5a675145833a2a5a6ac832a974fe77574b9907dd56e434b8bfc0f7332179729c
0xac004b512c33d029cf23abf04513f1f380b3fd0a	1813878144	false	37157	2632381678034483025115	2368618321965516974884	0x0ec926b9c3d1fbc0c8643238e57f10a1ce2a8f52	1000000000000000000	4	24208793	1	17576	2022-09-16T12:14:15.000Z	0x86f9bb15127bf15a5db5e3e75c1610d75a126dc95c620e09e269939de34219e3

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Core_ConditionResolved_event

Core_NewBet_event

Core1_ConditionCreated_event

Core1_ConditionResolved_event

Core1_updateReinforcements_function

Factory_NewPool_event

LP_FeeChanged_event

LP_GameShifted_event

LP_LiquidityAdded_event

LP_LiquidityRemoved_event

LP1_LiquidityAdded_event

LP1_LiquidityRemoved_event

LP1_NewBet_event

​Tables

​Core_ConditionResolved_event

​Core_NewBet_event

​Core1_ConditionCreated_event

​Core1_ConditionResolved_event

​Core1_updateReinforcements_function

​Factory_NewPool_event

​LP_FeeChanged_event

​LP_GameShifted_event

​LP_LiquidityAdded_event

​LP_LiquidityRemoved_event

​LP1_LiquidityAdded_event

​LP1_LiquidityRemoved_event

​LP1_NewBet_event

Tables

Core_ConditionResolved_event

Core_NewBet_event

Core1_ConditionCreated_event

Core1_ConditionResolved_event

Core1_updateReinforcements_function

Factory_NewPool_event

LP_FeeChanged_event

LP_GameShifted_event

LP_LiquidityAdded_event

LP_LiquidityRemoved_event

LP1_LiquidityAdded_event

LP1_LiquidityRemoved_event

LP1_NewBet_event