gnosis_v1_avalanche

Tables

EasyAuction_AuctionCleared_event

Auction settlement events from Gnosis EasyAuction protocol on Avalanche, recording cleared auctions with final clearing prices, total tokens sold, and winning bid amounts. Used for analyzing token sale outcomes and price discovery mechanisms in batch auctions.

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_auctionId`	`STRING`	Unique identifier for the auction. Numeric string representing the sequential auction number within the contract.
`in_soldAuctioningTokens`	`STRING`	Total amount of auctioning tokens sold in this cleared auction, denominated in the token’s smallest unit (wei-equivalent). Represents the final allocation of tokens being sold by the auctioneer to winning bidders.
`in_soldBiddingTokens`	`STRING`	Total amount of bidding tokens sold in the auction, denominated in the token’s smallest unit (wei-equivalent). Typically zero for unsuccessful auctions and substantial values for completed auctions with bidder participation.
`in_clearingPriceOrder`	`STRING`	Encoded order data representing the final clearing price at which the auction settled. Contains packed parameters including price ratio and order identifiers in hex format.

Sample Data

address	removed	log_index	block_number	in_auctionId	block_timestamp	transaction_hash	in_soldBiddingTokens	in_clearingPriceOrder	in_soldAuctioningTokens
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61	false	17	11673923	24	2022-03-04T12:11:12.000Z	0x01802ec3d4b8dcad0d15bcf6607e0f5abf7489faeb598984824808f81970b184	24999698772875000000	0x000000000000000800000000000000e8d3ed3543000000015af0c59470fbb8c0	999987950915
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61	false	9	11672383	23	2022-03-04T11:20:23.000Z	0xf868276f7d273a47faa5ca7e09807afae9e230b297e3ef7973e58edb69551c01	171269000000000000000	0x0000000000000000000000000000047355ff80c60000000948d5b813f4608000	4893410558150
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61	false	8	19649536	87	2022-09-07T19:03:33.000Z	0x3f2493c0533775e928cc720e6044023bdaf01a5282d3de5b2c3e47b700ce5e83	0	0x000000000000000000000a968163f0a57b400000000000000de0b6b3a7640000	0

Example Query

Query with partition filter

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

EasyAuction_NewAuction_event

Auction creation events from Gnosis EasyAuction protocol on Avalanche, capturing token sale parameters including auction ID, token addresses, minimum bid amounts, and timing windows. Used for tracking Dutch auction launches and analyzing token sale mechanics.

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_auctionId`	`STRING`	Unique identifier for the auction. Numeric string representing the sequential auction number within the contract.
`in__auctioningToken`	`STRING`	Contract address of the token being sold in the auction on Avalanche. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token that bidders will receive.
`in__biddingToken`	`STRING`	Contract address of the token accepted for bids in the auction. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token bidders use to participate.
`in_orderCancellationEndDate`	`STRING`	Unix timestamp (in seconds) representing the deadline by which bidders can cancel their orders in the auction. Typically matches the auction end date, as seen in sample values like `1651227008`.
`in_auctionEndDate`	`STRING`	Unix timestamp indicating when the auction closes and stops accepting bids. Typically set hours to days after the auction creation timestamp.
`in_userId`	`STRING`	Platform-assigned identifier for the auction creator or initiating user. Numeric value assigned sequentially as users interact with the EasyAuction contract on Avalanche.
`in__auctionedSellAmount`	`STRING`	Total quantity of tokens being sold by the auctioneer in the auction, denominated in the smallest unit of the auctioning token. Stored as a string to preserve precision for large token amounts with varying decimal places.
`in__minBuyAmount`	`STRING`	Minimum amount of bidding tokens required to purchase the auctioned tokens, denominated in the smallest unit of the bidding token. Values are string-encoded integers representing token amounts with their native decimal precision.
`in_minimumBiddingAmountPerOrder`	`STRING`	Minimum token amount required per individual bid order in the auction. Specified in the smallest unit of the bidding token (e.g., wei), typically set to 1 to allow any bid size.
`in_minFundingThreshold`	`STRING`	Minimum amount of bidding tokens required to be raised for the auction to be considered successful. If the auction does not meet this threshold, it may be cancelled or deemed invalid.
`in_allowListContract`	`STRING`	Contract address of the optional allowlist that restricts which addresses can participate in the auction. Typically set to zero address (0x00…00) when no allowlist is enforced.
`in_allowListData`	`STRING`	Empty bytes field passed as additional data when validating auction participants against the allowlist contract. Typically 0x, indicating no extra validation data is required beyond the standard allowlist check.

Sample Data

address	removed	in_userId	log_index	block_number	in_auctionId	block_timestamp	in__biddingToken	in__minBuyAmount	in_allowListData	transaction_hash	in_auctionEndDate	in__auctioningToken	in_allowListContract	in__auctionedSellAmount	in_orderCancellationEndDate	in_minimumBiddingAmountPerOrder
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61	false	12	15	14046638	49	2022-04-29T10:00:08.000Z	0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	135542175278707244866	0x	0x52c8f4297cffe801744ad2e0940da5864ba055e7ae13dece409b034e50710147	1651227008	0xe2cb20f48d07df9272f45b736a0a523cfb98d2d4	0x0000000000000000000000000000000000000000	9637024823786	1651227008	1
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61	false	4	15	14046342	48	2022-04-29T09:50:07.000Z	0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7	169136991808631763610	0x	0x2022e9fe197d3745d9c82b369244fb92fc6a6f2f7ccbb2bca68a3763ac1ac58f	1651226407	0xe537fb4faba470ba0cbba72830941bc56c2c05a6	0x0000000000000000000000000000000000000000	10716933994547	1651226407	1
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61	false	11	23	14046930	50	2022-04-29T10:10:05.000Z	0xa7d7079b0fead91f3e65f86e8915cb59c1a4c664	2034638187	0x	0x7de930cf7a5f37b084a0a9719f952777d6d5c39239c82e60e3c2a4dfa1960e4d	1651227605	0xe3b389f96ce66819b2b018b1ddac516ef581f1b6	0x0000000000000000000000000000000000000000	1673231333162	1651227605	1

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

EasyAuction_AuctionCleared_event

EasyAuction_NewAuction_event

​Tables

​EasyAuction_AuctionCleared_event

​EasyAuction_NewAuction_event

Tables

EasyAuction_AuctionCleared_event

EasyAuction_NewAuction_event