Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_auctionIdSTRINGUnique identifier for the auction. Numeric string representing the sequential auction number within the contract.
in_soldAuctioningTokensSTRINGTotal 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_soldBiddingTokensSTRINGTotal 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_clearingPriceOrderSTRINGEncoded order data representing the final clearing price at which the auction settled. Contains packed parameters including price ratio and order identifiers in hex format.
addressremovedlog_indexblock_numberin_auctionIdblock_timestamptransaction_hashin_soldBiddingTokensin_clearingPriceOrderin_soldAuctioningTokens
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61false1711673923242022-03-04T12:11:12.000Z0x01802ec3d4b8dcad0d15bcf6607e0f5abf7489faeb598984824808f81970b184249996987728750000000x000000000000000800000000000000e8d3ed3543000000015af0c59470fbb8c0999987950915
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61false911672383232022-03-04T11:20:23.000Z0xf868276f7d273a47faa5ca7e09807afae9e230b297e3ef7973e58edb69551c011712690000000000000000x0000000000000000000000000000047355ff80c60000000948d5b813f46080004893410558150
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61false819649536872022-09-07T19:03:33.000Z0x3f2493c0533775e928cc720e6044023bdaf01a5282d3de5b2c3e47b700ce5e8300x000000000000000000000a968163f0a57b400000000000000de0b6b3a76400000
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_auctionIdSTRINGUnique identifier for the auction. Numeric string representing the sequential auction number within the contract.
in__auctioningTokenSTRINGContract 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__biddingTokenSTRINGContract 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_orderCancellationEndDateSTRINGUnix 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_auctionEndDateSTRINGUnix timestamp indicating when the auction closes and stops accepting bids. Typically set hours to days after the auction creation timestamp.
in_userIdSTRINGPlatform-assigned identifier for the auction creator or initiating user. Numeric value assigned sequentially as users interact with the EasyAuction contract on Avalanche.
in__auctionedSellAmountSTRINGTotal 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__minBuyAmountSTRINGMinimum 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_minimumBiddingAmountPerOrderSTRINGMinimum 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_minFundingThresholdSTRINGMinimum 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_allowListContractSTRINGContract 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_allowListDataSTRINGEmpty 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.
addressremovedin_userIdlog_indexblock_numberin_auctionIdblock_timestampin__biddingTokenin__minBuyAmountin_allowListDatatransaction_hashin_auctionEndDatein__auctioningTokenin_allowListContractin_minFundingThresholdin__auctionedSellAmountin_orderCancellationEndDatein_minimumBiddingAmountPerOrder
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61false121514046638492022-04-29T10:00:08.000Z0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be1355421752787072448660x0x52c8f4297cffe801744ad2e0940da5864ba055e7ae13dece409b034e5071014716512270080xe2cb20f48d07df9272f45b736a0a523cfb98d2d40x00000000000000000000000000000000000000000963702482378616512270081
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61false41514046342482022-04-29T09:50:07.000Z0xb31f66aa3c1e785363f0875a1b74e27b85fd66c71691369918086317636100x0x2022e9fe197d3745d9c82b369244fb92fc6a6f2f7ccbb2bca68a3763ac1ac58f16512264070xe537fb4faba470ba0cbba72830941bc56c2c05a60x000000000000000000000000000000000000000001071693399454716512264071
0xb5d00f83680ea5e078e911995c64b43fbfd1ee61false112314046930502022-04-29T10:10:05.000Z0xa7d7079b0fead91f3e65f86e8915cb59c1a4c66420346381870x0x7de930cf7a5f37b084a0a9719f952777d6d5c39239c82e60e3c2a4dfa1960e4d16512276050xe3b389f96ce66819b2b018b1ddac516ef581f1b60x00000000000000000000000000000000000000000167323133316216512276051
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