solv_v2_arbitrum

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.

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_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_offeringId`	`STRING`	Unique identifier for the token offering or sale event in the marketplace contract. Numeric string representation assigned to each distinct offering.
`in_voucher`	`STRING`	Contract address of the voucher token representing the purchased asset or position in the trade. Hex-encoded, 0x-prefixed, 42-character string.
`in_voucherId`	`STRING`	Token identifier for the voucher NFT issued to the buyer. Numeric string representation assigned to the specific voucher created in the trade.
`in_tradeId`	`STRING`	Sequential identifier for the trade within the marketplace contract. Numeric string representation incrementing with each executed trade.
`in_tradeTime`	`STRING`	Timestamp when the trade was executed. Unix epoch format, second precision.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_priceType`	`INT64`	Enumerated 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_price`	`STRING`	Price of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
`in_tradedUnits`	`STRING`	Quantity 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_tradedAmount`	`STRING`	Amount 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_fee`	`STRING`	Fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest unit of the relevant token or currency.

Sample Data

in_fee	address	removed	in_buyer	in_price	log_index	in_tradeId	in_voucher	in_currency	block_number	in_tradeTime	in_voucherId	in_offeringId	in_tradedUnits	block_timestamp	in_tradedAmount	transaction_hash
75682499	0x67d48ce0e776147b0d996e1facc0fbaa91b1cbc4	false	0x35307770412f60406d5e8c5b52e7af4e6ea29819	987654	11	3	0x32126ae067ec31974180f79b6313ae986a375faa	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9690831	1649768412	3	2	1021714082057076668549917000000	2022-04-12T13:00:12.000Z	10090999999	0x4f601af6fb05f579a982e3c7015623a2c904d1320fe4e94b049998e5343769df
2249999999	0x67d48ce0e776147b0d996e1facc0fbaa91b1cbc4	false	0xaafcdd316559ed4a0204ebe4ea508e3cfdb398f8	987654	12	2	0x32126ae067ec31974180f79b6313ae986a375faa	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9690805	1649768412	2	2	30375009871878208360417717000000	2022-04-12T13:00:12.000Z	299999999999	0xa689a1c3039f03a5bd680afcc4bc5f465f44e490e540dbc928c9109c27bcf874
74999999	0x67d48ce0e776147b0d996e1facc0fbaa91b1cbc4	false	0x543c0893b67ca3b72011fc3a1c794d6b912bfb03	987654	11	4	0x32126ae067ec31974180f79b6313ae986a375faa	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9691022	1649768682	4	2	1012500329062606945347257000000	2022-04-12T13:04:42.000Z	9999999999	0x422c1d9e36dbb3474725d53be480d53051e4144bb699fe3ccee4b78381b0f3b2

Example Query

Query with partition filter

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

⌘I

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

InitialConvertibleOfferingMarket_Traded_event

​Tables

​InitialConvertibleOfferingMarket_Traded_event

Tables

InitialConvertibleOfferingMarket_Traded_event