Skip to main content

​
Tables

​
InitialConvertibleOfferingMarket_Traded_event

Trade execution events from Solv Protocol’s Initial Convertible Offering (ICO) marketplace contract. Records buyer address, voucher NFT issuance, traded units and currency amounts, price and price type, fees, and execution timestamps for each completed offering purchase.
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_buyerSTRINGAddress of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_offeringIdSTRINGUnique identifier for the token offering or sale event in the marketplace contract. Numeric string representation assigned to each distinct offering.
in_voucherSTRINGContract address of the voucher token representing the purchased asset or position in the trade. Hex-encoded, 0x-prefixed, 42-character string.
in_voucherIdSTRINGToken identifier for the voucher NFT issued to the buyer. Numeric string representation assigned to the specific voucher created in the trade.
in_tradeIdSTRINGSequential identifier for the trade within the marketplace contract. Numeric string representation incrementing with each executed trade.
in_tradeTimeSTRINGTimestamp when the trade was executed. Unix epoch format, second precision.
in_currencySTRINGContract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_priceTypeINT64Enumerated identifier indicating the pricing method or denomination type for the trade. Integer value representing the price calculation or display format used in the transaction.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_tradedUnitsSTRINGQuantity of units or tokens acquired by the buyer in the trade. String-encoded integer value representing the amount in the smallest unit or with extended precision for the asset being traded.
in_tradedAmountSTRINGAmount of currency paid for the asset or units in the trade. String-encoded integer value representing the payment in the smallest unit of the currency token.
in_feeSTRINGFee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v2_polygon.InitialConvertibleOfferingMarket_Traded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100