gnosis_v1_ethereum

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.

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). This value represents the final quantity allocated to winning bidders at the clearing price.
`in_soldBiddingTokens`	`STRING`	Total 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_clearingPriceOrder`	`STRING`	Hex-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.

Sample Data

address	removed	log_index	block_number	in_auctionId	block_timestamp	transaction_hash	in_soldBiddingTokens	in_clearingPriceOrder	in_soldAuctioningTokens
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101	false	28	14003104	126	2022-01-14T10:30:00.000Z	0x2c53d424c1b490bf9bac4e7bda8bfca354785c7db87bb5487682c633d4b1385e	216442698	0x000000000000305f0000000000000004a817c800000000000000000003567e00	77300963762
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101	false	277	14003317	130	2022-01-14T11:15:51.000Z	0x3a9d9e6f3608d38af7de91494693961c5726b1225da248b8287886fe836cd422	316106562889	0x000000000000228b00000000000001544e261800000000000000003adf709300	1827205565833
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101	false	26	14003199	128	2022-01-14T10:50:07.000Z	0xe00dca873c77f4e97ca2d106fa585c1ff9f466f434802b06b5fc85c2c8830ed0	23868094943729868094	0x00000000000030c700000000000000598cdd0627000000008ac7230489e80000	918003651681

Example Query

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.

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. Hex-encoded, 0x-prefixed 40-character Ethereum address representing the ERC-20 token that bidders will receive.
`in__biddingToken`	`STRING`	Contract 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_orderCancellationEndDate`	`STRING`	Unix 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_auctionEndDate`	`STRING`	Unix 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_userId`	`STRING`	User identifier assigned to the auction initiator in the EasyAuction system. Sequential numeric identifier stored as string, unique per user across all auctions.
`in__auctionedSellAmount`	`STRING`	Amount 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__minBuyAmount`	`STRING`	Minimum 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_minimumBiddingAmountPerOrder`	`STRING`	Minimum 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_minFundingThreshold`	`STRING`	Minimum 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_allowListContract`	`STRING`	Contract 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_allowListData`	`STRING`	Optional merkle proof or allowlist data for restricting auction participation to whitelisted addresses. Empty (0x) when no allowlist is enforced.

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
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101	false	12756	286	15327199	321	2022-08-12T13:18:37.000Z	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1320459900	0x	0x2a4db19bde004af9f82e0387c81e8903d16832a9bab12218a80f149502e25c96	1660310917	0x120aed6fcb1f74e924c8d9561b72055d38eeb730	0x0000000000000000000000000000000000000000	10005000000000000	1660310917	1
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101	false	12756	517	15327842	322	2022-08-12T15:44:34.000Z	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	1320459900	0x	0xd1f30ef53d07f8107ebb5b53a777b743e414a36063b6248ccf9e1c333403d0e2	1660319674	0x120aed6fcb1f74e924c8d9561b72055d38eeb730	0x0000000000000000000000000000000000000000	10005000000000000	1660319674	1
0x0b7ffc1f4ad541a4ed16b40d8c37f0929158d101	false	7225	180	12362444	19	2021-05-03T16:58:50.000Z	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	110000000000000000000	0x	0xf1c6ad6335bc208982d43cb1ef217a5e31d5dd5bec02f7d530096e16bab9e468	1620763200	0xdd1ad9a21ce722c151a836373babe42c868ce9a4	0x0000000000000000000000000000000000000000	500000000000000000000000	0	10000000000000000

Example Query

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

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