Skip to main content

​
Tables

​
EasyAuction_AuctionCleared_event

Auction settlement events from Gnosis EasyAuction protocol on Ethereum, recording final clearing prices and token amounts exchanged when batch auctions complete. Used for analyzing price discovery mechanisms and auction participation patterns.
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). This value represents the final quantity allocated to winning bidders at the clearing price.
in_soldBiddingTokensSTRINGTotal amount of bidding tokens sold in this auction at the clearing price. Denominated in the smallest unit of the bidding token (wei for ETH, similar for other tokens).
in_clearingPriceOrderSTRINGHex-encoded order data representing the final clearing price at which the auction settled. This 66-character value encodes the price ratio between auctioning and bidding tokens that determined successful bids.
addressremovedlog_indexblock_numberin_auctionIdblock_timestamptransaction_hashin_soldBiddingTokensin_clearingPriceOrderin_soldAuctioningTokens
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101false28140031041262022-01-14T10:30:00.000Z0x2c53d424c1b490bf9bac4e7bda8bfca354785c7db87bb5487682c633d4b1385e2164426980x000000000000305f0000000000000004a817c800000000000000000003567e0077300963762
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101false277140033171302022-01-14T11:15:51.000Z0x3a9d9e6f3608d38af7de91494693961c5726b1225da248b8287886fe836cd4223161065628890x000000000000228b00000000000001544e261800000000000000003adf7093001827205565833
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101false26140031991282022-01-14T10:50:07.000Z0xe00dca873c77f4e97ca2d106fa585c1ff9f466f434802b06b5fc85c2c8830ed0238680949437298680940x00000000000030c700000000000000598cdd0627000000008ac7230489e80000918003651681
Query with partition filter
SELECT *
FROM `tt-contracts.gnosis_v1_ethereum.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 Ethereum, capturing batch auction parameters including auctioned and bidding token addresses, sell amounts, minimum buy amounts, and auction end dates. Used for tracking auction launches and analyzing tokenized asset price discovery mechanisms.
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. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the ERC-20 token that bidders will receive.
in__biddingTokenSTRINGContract address of the token accepted for bidding in the auction. Hex-encoded, 0x-prefixed 40-character Ethereum address commonly representing stablecoins (USDC, USDT) or WETH.
in_orderCancellationEndDateSTRINGUnix timestamp indicating the deadline for participants to cancel their bids in the auction. Often matches the auction end date but can be set earlier to create a commitment period.
in_auctionEndDateSTRINGUnix timestamp (in seconds) when the auction closes and stops accepting new bids. Typically set hours to days after auction creation based on sample values ranging from same-day to multi-day auctions.
in_userIdSTRINGUser identifier assigned to the auction initiator in the EasyAuction system. Sequential numeric identifier stored as string, unique per user across all auctions.
in__auctionedSellAmountSTRINGAmount of tokens being sold in the auction denominated in the smallest unit of the auctioning token. Typically ranges from millions to trillions depending on token decimals.
in__minBuyAmountSTRINGMinimum total quantity of bidding tokens required for the auction to be considered successful. Represents the minimum funding threshold denominated in the bidding token’s smallest unit.
in_minimumBiddingAmountPerOrderSTRINGMinimum token amount required per individual bid in the auction, denominated in the bidding token. Enforced as a spam-prevention mechanism; typical values range from 1 (no minimum) to larger amounts like 10^16 for WETH-denominated auctions.
in_minFundingThresholdSTRINGMinimum total bidding token amount required for the auction to be considered valid and executable. If total bids fall below this threshold (often ‘0’ for no minimum), the auction may be cancelled or considered unsuccessful.
in_allowListContractSTRINGContract address managing whitelist access controls for the auction, or zero address (0x00…00) if no restrictions apply. When non-zero, bidders must be approved by this contract to participate.
in_allowListDataSTRINGOptional merkle proof or allowlist data for restricting auction participation to whitelisted addresses. Empty (0x) when no allowlist is enforced.
addressremovedin_userIdlog_indexblock_numberin_auctionIdblock_timestampin__biddingTokenin__minBuyAmountin_allowListDatatransaction_hashin_auctionEndDatein__auctioningTokenin_allowListContractin_minFundingThresholdin__auctionedSellAmountin_orderCancellationEndDatein_minimumBiddingAmountPerOrder
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101false12756286153271993212022-08-12T13:18:37.000Z0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb4813204599000x0x2a4db19bde004af9f82e0387c81e8903d16832a9bab12218a80f149502e25c9616603109170x120aed6fcb1f74e924c8d9561b72055d38eeb7300x000000000000000000000000000000000000000001000500000000000016603109171
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101false12756517153278423222022-08-12T15:44:34.000Z0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb4813204599000x0xd1f30ef53d07f8107ebb5b53a777b743e414a36063b6248ccf9e1c333403d0e216603196740x120aed6fcb1f74e924c8d9561b72055d38eeb7300x000000000000000000000000000000000000000001000500000000000016603196741
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101false722518012362444192021-05-03T16:58:50.000Z0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc21100000000000000000000x0xf1c6ad6335bc208982d43cb1ef217a5e31d5dd5bec02f7d530096e16bab9e46816207632000xdd1ad9a21ce722c151a836373babe42c868ce9a40x00000000000000000000000000000000000000000500000000000000000000000010000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.gnosis_v1_ethereum.EasyAuction_NewAuction_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100