solv_v2_ethereum

Tables

InitialBondOfferingMarket_Traded_event

Trade execution events from Solv Protocol’s Initial Bond Offering (IBO) marketplace contracts, recording buyer purchases of bond vouchers with payment currency, pricing details, and associated fees.

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

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
0x2e2e940c7041a2948934175a81908baa8adc6afe	false	0xd8183d599e89291e654dbeb30b3e5072198f5038	990099	301	25	0xcd7bff6051fffcfc68846b4ae2da496ec5ff1d8b	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	17135694	1682576363	9	12	10100000101000001010000010000000	2023-04-27T06:19:23.000Z	99999999999	0x1df7f58e558b024a05aa51bd019074e504309ea325c214724b62d81471a6a473
0x2e2e940c7041a2948934175a81908baa8adc6afe	false	0x42eeff1fba1c3df7f740d88dfc253a457934ac5c	997506	478	26	0xcd7bff6051fffcfc68846b4ae2da496ec5ff1d8b	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	17142915	1682664143	10	13	150375035338133304461326548000000	2023-04-28T06:42:23.000Z	1499999999999	0xbd306dc3cb6d4bbf3575488831c92a8952f7487ef9e7954dc34a902095db64fc
0x2e2e940c7041a2948934175a81908baa8adc6afe	false	0xaafcdd316559ed4a0204ebe4ea508e3cfdb398f8	990099	212	19	0xcd7bff6051fffcfc68846b4ae2da496ec5ff1d8b	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	15646187	1664541323	1	9	101000001010000010100000101000000	2022-09-30T12:35:23.000Z	999999999999	0xb6544db19819506ad86fc20422c0253ec23802ddc9e2d5e3b29b49f80fcf5103

Example Query

Query with partition filter

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

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
519999999	0x83208b368c34dac1a0f8b616f278ed42f1ffb8cd	false	0x31eb01ae40a4416490d24c7886626b7fa65dea42	980655	475	5	0xbf50337ed0ff20fa4d5702bf2da187e2c217d034	0xdac17f958d2ee523a2206206994597c13d831ec7	14165728	1644327401	5	2	10605156757473321402531981000000	2022-02-08T13:36:41.000Z	103999999999	0x8d911848f4784b4f1f6d3e3545bcc76951c907374291c04dcc1c09b46207cef2
480000000	0x83208b368c34dac1a0f8b616f278ed42f1ffb8cd	false	0x31eb01ae40a4416490d24c7886626b7fa65dea42	980655	210	4	0xbf50337ed0ff20fa4d5702bf2da187e2c217d034	0xdac17f958d2ee523a2206206994597c13d831ec7	14165676	1644326759	4	2	9789375468436912063875675000000	2022-02-08T13:25:59.000Z	96000000000	0x0973981e0760098a2aa899df0d4a5c36931c3892cf18230479aff258284ba997
969999999	0x83208b368c34dac1a0f8b616f278ed42f1ffb8cd	false	0x464a3946f609c74a2a77f89c5ab58b6c893e8a28	980655	331	7	0xbf50337ed0ff20fa4d5702bf2da187e2c217d034	0xdac17f958d2ee523a2206206994597c13d831ec7	14165885	1644329438	7	2	19782696259132926462415426000000	2022-02-08T14:10:38.000Z	193999999999	0x99f8372a3d81f3f3bf75f0c22a5e6bfbb640436f4b678970b00303c55d62cf66

Example Query

Query with partition filter

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

InitialVestingOfferingMarket_Traded_event

Traded events from Solv Protocol’s Initial Vesting Offering (IVO) marketplace capturing purchase transactions where buyers acquire vesting voucher tokens with payment currency. Records buyer address, offering identifier, trade units and amount, price and fee details, and voucher NFT issuance for tracking IVO marketplace activity.

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
95999999	0x66e6a6d0220ebd2c1600ddfd82d0daad438bb71b	false	0x77021bf8dc293628d341365b9018d18605b56dd5	2600000	532	2	0xee3a5800392614f18ce3ca82a3ace815c01f2ab4	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14456271	1648222262	2	1	3076923076923076923076	2022-03-25T15:31:02.000Z	7999999999	0x66d3dfbd484bbb6b1e6d08538478a6cb1e09146e99b333abf30659db377014a4
29314942	0x66e6a6d0220ebd2c1600ddfd82d0daad438bb71b	false	0x465b357bbac5f6f3bc78669db6980f9eaa21d0c2	2600000	39	1	0xee3a5800392614f18ce3ca82a3ace815c01f2ab4	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14455964	1648218295	1	1	939581495384615384615	2022-03-25T14:24:55.000Z	2442911887	0xba1c9087cc54873c06a6f36f11463b7d5e70007dc42a85850882ed05941a3798
30065028	0x66e6a6d0220ebd2c1600ddfd82d0daad438bb71b	false	0xde4f44441fd1a41eee326c17ae56e94d6da11da3	2600000	98	3	0xee3a5800392614f18ce3ca82a3ace815c01f2ab4	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14458476	1648252361	3	1	963622724230769230769	2022-03-25T23:52:41.000Z	2505419082	0x72c4697ed5733fc826af5a028cab8f9222f6e43ef56a9b4718fcdf039fa4fee4

Example Query

Query with partition filter

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

SolvICMarket_Traded_event

Trade execution events from Solv Protocol’s Initial Convertible (IC) marketplace contract containing buyer address, token identifiers, traded units and amounts, price, fees, and execution timestamp. Primary source for tracking IC token secondary market activity and price discovery.

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_saleId`	`STRING`	Unique identifier for the sale listing or offering within the marketplace contract. Numeric string representation.
`in_icToken`	`STRING`	Contract address of the initial coin offering token being traded. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
`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_feePayType`	`INT64`	Enumerated identifier indicating the payment method for the transaction fee. Integer value representing whether the fee is paid in the trade currency, the traded asset, or another specified 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	in_saleId	log_index	in_icToken	in_tokenId	in_tradeId	in_currency	block_number	in_tradeTime	in_tradedUnits	block_timestamp	in_tradedAmount	transaction_hash
24105769	0xd91a208995bfbde9d133c39417fbd352e595650b	false	0x16f7a4bb3327b561c64d9694a183cf66cf47c765	1450000	66	331	0xf97c35c542e0ad32e9b03967b41999a43acbdbe3	58	137	0xdac17f958d2ee523a2206206994597c13d831ec7	13201985	1631329698	1108311224827586206898	2021-09-11T03:08:18.000Z	1607051276	0x9f4027481384be1f8fc51ba9a9c7ad65a5cc085d46f01d574f43a78463f9b2c4
164999999	0xd91a208995bfbde9d133c39417fbd352e595650b	false	0x6261aa23e013b9a6825eb913398d0415517c32ff	1750000	65	109	0xf97c35c542e0ad32e9b03967b41999a43acbdbe3	35	136	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13201220	1631319467	6285714285714285714285	2021-09-11T00:17:47.000Z	10999999999	0x2b7d881041cf687e4b42fe5436f49a88d4dbeb8fc1d6cd49aae3ffdda6c928dd
899063852	0xd91a208995bfbde9d133c39417fbd352e595650b	false	0x123432244443b54409430979df8333f9308a6040	1750000	65	56	0xf97c35c542e0ad32e9b03967b41999a43acbdbe3	35	169	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	13362341	1633482027	34250051530857142857142	2021-10-06T01:00:27.000Z	59937590178	0x9f7095c26f81a989d645b8330239040de8fa61f682e6e2550c886eb79eb9454a

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

InitialBondOfferingMarket_Traded_event

InitialConvertibleOfferingMarket_Traded_event

InitialVestingOfferingMarket_Traded_event

SolvICMarket_Traded_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​InitialBondOfferingMarket_Traded_event

​InitialConvertibleOfferingMarket_Traded_event

​InitialVestingOfferingMarket_Traded_event

​SolvICMarket_Traded_event

Tables

InitialBondOfferingMarket_Traded_event

InitialConvertibleOfferingMarket_Traded_event

InitialVestingOfferingMarket_Traded_event

SolvICMarket_Traded_event