solv_v2_bsc

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

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
50000000000000000	0xd22a4d7a691e56c8a4ebb2844fa0b80c54a5eb1a	false	0x774fcdb73828176b120fe01bf9cd3f00b1b6bbe4	983606557377049180	335	2	0x08a3947cbd0abf0433bc71fb339b3a7b5116747a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17597396	1651928498	1	4	1016666666666666667006000000	2022-05-07T13:01:38.000Z	10000000000000000000	0xb2d350625ad0a82cef738192ca5605223d6ae32998e454917114b07b0df3ce6b
14999950000000000000000	0xd22a4d7a691e56c8a4ebb2844fa0b80c54a5eb1a	false	0x406db721bab68f39848de5ace22f0348ae13d7cf	983606557377049180	237	3	0x08a3947cbd0abf0433bc71fb339b3a7b5116747a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17597703	1651929425	2	4	304998983333333333434999661514931	2022-05-07T13:17:05.000Z	2999990000000000000000000	0x50f898ced9ee3424f15f2a6c413235fbf5324f604f8edb81534694ce737a02dd
4999999999999999999	0xd22a4d7a691e56c8a4ebb2844fa0b80c54a5eb1a	false	0xaacc290a1a4c89f5d7bc29913122f5982916de48	980392156862745098	429	4	0x91178a150e8395b46d2d37719d191e21271fcb79	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	17598480	1651931759	2	3	102000000000000000003978000000	2022-05-07T13:55:59.000Z	999999999999999999998	0x3017815823ce088f1bb19f8a764539bfe2873760a8f00e40a4067467fd7c79ee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v2_bsc.InitialBondOfferingMarket_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
31920000000000000	0xba21023cd7d193f2b980fac8018f228c1f340b21	false	0x7b5ecf8b105d0a4739b117c3f46439c1f19bd5d7	266000000000000000	204	1553	0xf6ee76141e5964f5ff2831c3cb39a90f1541794a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17130829	1650520250	440	14	10000000000000000000	2022-04-21T05:50:50.000Z	2660000000000000000	0x64d05a8564d6710313e84d84279d74a61f918255eb29bcfaf0d4b0f21c139b6d
35112000000000000	0xba21023cd7d193f2b980fac8018f228c1f340b21	false	0x6b73809a18879d6d0ef400d6d7cfe98ab0fcabbc	266000000000000000	167	1554	0xf6ee76141e5964f5ff2831c3cb39a90f1541794a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17135176	1650533292	441	14	11000000000000000000	2022-04-21T09:28:12.000Z	2926000000000000000	0x7046d39e8559f5ada5730a0fd7e3e3979f75921747527013bc11906025c813ec
35999999999999999	0xba21023cd7d193f2b980fac8018f228c1f340b21	false	0xde4ac27626604adf2f1171d64aee22fa9a3567c5	266000000000000000	283	1552	0xf6ee76141e5964f5ff2831c3cb39a90f1541794a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17128444	1650513093	439	14	11278195488721804511	2022-04-21T03:51:33.000Z	2999999999999999999	0xd52dcc538251b8fbb316e2bbd52c1aca8eb01c7acdf0e50d5b262db4c659d883

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v2_bsc.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
675000000000000	0x758ae0c48ff013d18b3d63ca79408e70a977d496	false	0x7ad4409d5823fc108114e4d4f96b95bf6bebd7f6	9000000000000000	5350	282	0xfed93e410a6a45bc045bc91deaae1fd642e4af7a	3	17027	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	22273010	1666066959	5000000000000000000	2022-10-18T04:22:39.000Z	45000000000000000	0x35b79a677eb7fe3c1add7abd449f738fda486e092035eae0c1cd46c07b8c9f33
675000000000000	0x758ae0c48ff013d18b3d63ca79408e70a977d496	false	0xa7a0e454aff5a6bc0cad938b21c05a7b0484744c	9000000000000000	5350	270	0xfed93e410a6a45bc045bc91deaae1fd642e4af7a	3	17026	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	22272756	1666066197	5000000000000000000	2022-10-18T04:09:57.000Z	45000000000000000	0xc96e226dd634e2a83b2e3f16d31f6b1c8dd38765c1f16a73b413f8267e13cf06
14250000000000000000	0x758ae0c48ff013d18b3d63ca79408e70a977d496	false	0xa89daef91270fa555c931d6d064aa6ab794c573f	950000000000000000	4529	164	0xe5ffde144592121195d43fdfb3621fc7530c0040	2261	17029	0xa2df7a11baf8bb555e93b99684a2de0f105eb592	22287275	1666110296	1000000000000000000000	2022-10-18T16:24:56.000Z	950000000000000000000	0x236776e3bd3070814b5613d96cda0c6071354cb10f907bb8b2533a937fb419ec

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

InitialBondOfferingMarket_Traded_event

InitialVestingOfferingMarket_Traded_event

SolvICMarket_Traded_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​InitialBondOfferingMarket_Traded_event

​InitialVestingOfferingMarket_Traded_event

​SolvICMarket_Traded_event

Tables

InitialBondOfferingMarket_Traded_event

InitialVestingOfferingMarket_Traded_event

SolvICMarket_Traded_event