solv_v1_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	0x43242843fbcb7076e2ec62d4452297e18e28cc2f	981514	99	18	0x5af543536e0e68352764d7b8bded3c2ff1cdfc51	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14996002	1655720254	2	7	311245677653196999737140785000000	2022-06-20T10:17:34.000Z	3054919900561	0x609d5e2b5ffaf738b478ed02caef10451c08b1c666b01acb4267ae799170b7f1
0x2e2e940c7041a2948934175a81908baa8adc6afe	false	0xcec2336cb64c1990a7c3ce01a6fb328d642d5b9f	997229916897506982	296	11	0x5297e4fd4d103289bfd2ce1f835e63659d3c5ba9	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	14816323	1653123198	6	2	25069444444444443016739003331	2022-05-21T08:53:18.000Z	249999999999999999999	0x71f7d3464cfd32e6caa1543691a82ce8d3c1cc984335c328f901232854945e39
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_v1_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
2759789999	0x83208b368c34dac1a0f8b616f278ed42f1ffb8cd	false	0x70ab756806eb5358783fc6fc53ab4932db7642cb	983827	106	15	0x2d53f42b2edf8907bcaa4d3f28e6f76bd95334e3	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14224431	1645112042	5	3	46752630289674912357558798000000	2022-02-17T15:34:02.000Z	459964999999	0x8881169aefff2264629bd4e4a7edfca4b0c54e4eef3b4d687d34fd8abe5e779a
6327482517	0x83208b368c34dac1a0f8b616f278ed42f1ffb8cd	false	0x7603ca381c5c0a5731b9320c7d7a49357849c1fb	983827	89	12	0x2d53f42b2edf8907bcaa4d3f28e6f76bd95334e3	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14223848	1645103638	2	3	107191652550804155608658839000000	2022-02-17T13:13:58.000Z	1054580419540	0x7bbf976b54c94e5b30c742a11de0aac8ab154e2d47fc8425618d1b7af63f42ff
1799999999	0x83208b368c34dac1a0f8b616f278ed42f1ffb8cd	false	0xf2a66463bf485bc53d6a23717e20f59dceed5c77	983827	539	13	0x2d53f42b2edf8907bcaa4d3f28e6f76bd95334e3	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14223912	1645104561	3	3	30493165973285953729669952000000	2022-02-17T13:29:21.000Z	299999999999	0x3556f331deddb35ee56862c0660ccc396de9afe3b06a64b2d54e8a4df891a2a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_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
9360000	0x66e6a6d0220ebd2c1600ddfd82d0daad438bb71b	false	0x7813d37cb9d88a42c9a97b6deee1951eb5c08a21	2600000	212	6	0xee3a5800392614f18ce3ca82a3ace815c01f2ab4	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14462450	1648306032	6	1	300000000000000000000	2022-03-26T14:47:12.000Z	780000000	0xe4307c6c6932469f4387b80c8e336fdd2fab5eefd54f9ce3c535af31f86c790d
19379011	0x66e6a6d0220ebd2c1600ddfd82d0daad438bb71b	false	0xb3313b023e68cda95d7b625200e1b0fe6335a0c2	2600000	176	5	0xee3a5800392614f18ce3ca82a3ace815c01f2ab4	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14461625	1648294927	5	1	621122151153846153846	2022-03-26T11:42:07.000Z	1614917592	0x941e88dc21cc80750c73a64c8c5db467d58ce9d0b355cac43d1bf612993bc45a
1878402	0x66e6a6d0220ebd2c1600ddfd82d0daad438bb71b	false	0xce5a9c9775e47c6df3ef4eac865ae3741d11fa33	2600000	148	9	0xee3a5800392614f18ce3ca82a3ace815c01f2ab4	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14464761	1648337136	9	1	60205216923076923076	2022-03-26T23:25:36.000Z	156533563	0x08fcb3119302c2675774378c0a8862b676b528c8a3dd8c9a3b33837abc01187c

Example Query

Query with partition filter

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

OpenFundMarket_CreatePool_event

Event emitted when a new fund pool is created in the OpenFundMarket contract, recording pool configuration including SFT (Semi-Fungible Token) addresses, fee structures, manager roles, subscription limits, vault details, and fundraising parameters. Used for tracking fund pool initialization across DeFi protocols.

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_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_sft`	`STRING`	Contract address of the Semi-Fungible Token (SFT) in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_poolInfo_`	STRUCT<poolSFTInfo STRUCT<openFundShare STRING, openFundRedemption STRING, openFundShareSlot STRING, latestRedeemSlot STRING>, poolFeeInfo STRUCT<carryRate STRING, carryCollector STRING, latestProtocolFeeSettleTime STRING>, managerInfo STRUCT<poolManager STRING, subscribeNavManager STRING, redeemNavManager STRING>, subscribeLimitInfo STRUCT<hardCap STRING, subscribeMin STRING, subscribeMax STRING, fundraisingStartTime STRING, fundraisingEndTime STRING>, vault STRING, currency STRING, navOracle STRING, valueDate STRING, permissionless BOOL, fundraisingAmount STRING>	Structured data containing comprehensive pool configuration and state information for an open fund. Includes nested structs for SFT token details (openFundShare, openFundRedemption, slot identifiers), fee parameters (carryRate, carryCollector, settlement timestamps), manager addresses (poolManager, NAV managers), subscription limits (hardCap, min/max amounts, fundraising period), vault address, currency token, NAV oracle, value date, permissionless flag, and total fundraising amount.

Sample Data

in_sft	address	removed	in_poolId	log_index	in_currency	block_number	in_poolInfo_	block_timestamp	transaction_hash
0x982d50f8557d57b748733a3fc3d55aef40c46756	0x57bb6a8563a8e8478391c79f3f433c6ba077c567	false	0xa336828fb006403bd08709b3dd2fa7f1b142d9ec46c7a8b380bdf2f3deb4ee41	210	0x7a56e1c57c7475ccf742a1832b028f0456652f97	21542131	{“vault”:“0xc98c7bb5fd8baa1a64b1558f393a00e00109a599”,“currency”:“0x7a56e1c57c7475ccf742a1832b028f0456652f97”,“navOracle”:“0x8c29858319614380024093dbee553f9337665756”,“valueDate”:“1736121600”,“managerInfo”:{“poolManager”:“0x2c1fa5f5e49d781637a5be8e692031778ccaf264”,“redeemNavManager”:“0x41875981fb656e3787c463d15e01230340694958”,“subscribeNavManager”:“0x41875981fb656e3787c463d15e01230340694958”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x228466de8341977e2c47fcfc653a7176c6d7d298”,“latestProtocolFeeSettleTime”:“1736121600”},“poolSFTInfo”:{“openFundShare”:“0x982d50f8557d57b748733a3fc3d55aef40c46756”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“14373501204713645571429805632318849823719301554473645038877008124244216272236”,“openFundRedemption”:“0x1d0db695f3033875d1b6a0155c38b3ee2aed3082”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1862352000”,“fundraisingStartTime”:“1735884766”}}	2025-01-03T06:21:47.000Z	0xb2cc554bdd6c74852f4a1b6a2ca64622442996234ec32d00fcd5326c2976bf26
0x1d0db695f3033875d1b6a0155c38b3ee2aed3082	0x57bb6a8563a8e8478391c79f3f433c6ba077c567	false	0x8f9dc8b4106316f407d7f301a8087db11a01705f8a41c35c08f2f9b42bd49a5e	15	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	21694029	{“vault”:“0xc40210f5751e41b9da4cfae78d7f50efb72c4ec5”,“currency”:“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“navOracle”:“0x0812a85551a3ab1296c893291366207b3e4f7f26”,“valueDate”:“1727313313”,“managerInfo”:{“poolManager”:“0xc40210f5751e41b9da4cfae78d7f50efb72c4ec5”,“redeemNavManager”:“0x16f10b947008f8423fa7a09e09764797b79b40da”,“subscribeNavManager”:“0x16f10b947008f8423fa7a09e09764797b79b40da”},“poolFeeInfo”:{“carryRate”:“1000”,“carryCollector”:“0x16f10b947008f8423fa7a09e09764797b79b40da”,“latestProtocolFeeSettleTime”:“1727313313”},“poolSFTInfo”:{“openFundShare”:“0x1d0db695f3033875d1b6a0155c38b3ee2aed3082”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“2370665384744342933087807509644646037891567639574778387949462739027335439478”,“openFundRedemption”:“0x1d0db695f3033875d1b6a0155c38b3ee2aed3082”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“1766847064778384329583297500742918515827483896875618958121606201292619775”,“subscribeMin”:“1”,“fundraisingEndTime”:“1768785313”,“fundraisingStartTime”:“1696209313”}}	2025-01-24T11:21:23.000Z	0x6aed79b992ccb783ce2dc27a1e89d623f88a99cb7df67f24b1553b8f4e10c758
0x982d50f8557d57b748733a3fc3d55aef40c46756	0x57bb6a8563a8e8478391c79f3f433c6ba077c567	false	0x7213c9a8b57376668a0dd79c4abfd2d3df1266ae62ce0cd58b18d39d2be697c9	281	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	20541967	{“vault”:“0x6c0fe76da5b8c3b24125830f127037bf16bca46c”,“currency”:“0x2260fac5e5542a773aa44fbcfedf7c193bc2c599”,“navOracle”:“0x8c29858319614380024093dbee553f9337665756”,“valueDate”:“1724457600”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x41875981fb656e3787c463d15e01230340694958”,“subscribeNavManager”:“0x41875981fb656e3787c463d15e01230340694958”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x228466de8341977e2c47fcfc653a7176c6d7d298”,“latestProtocolFeeSettleTime”:“1724457600”},“poolSFTInfo”:{“openFundShare”:“0x982d50f8557d57b748733a3fc3d55aef40c46756”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“51514566892407555397009708021388281273766695948604159071726269952549078432959”,“openFundRedemption”:“0x1d0db695f3033875d1b6a0155c38b3ee2aed3082”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1977523200”,“fundraisingStartTime”:“1723819745”}}	2024-08-16T15:03:59.000Z	0x9dd96a0adc0c8e1be488b189adcf0ddd425c494b95048bed27e7a435dda4db97

Example Query

Query with partition filter

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

OpenFundMarket_Subscribe_event

Subscription events emitted when buyers purchase tokens from open-ended fund pools on Solv Protocol. Records buyer address, payment currency, payment amount, NAV (Net Asset Value), token amount received, pool identifier, and minted NFT token ID for tracking fund share issuance.

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_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_buyer`	`STRING`	Address of the account purchasing tokens or assets in the transaction. 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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nav`	`STRING`	Net Asset Value (NAV) per share at the time of the subscription transaction. Numeric string representation preserving precision for financial calculations.
`in_payment`	`STRING`	Amount paid by the buyer in the transaction. Numeric string representation in smallest token denomination.

Sample Data

in_nav	address	removed	in_buyer	in_value	in_poolId	log_index	in_payment	in_tokenId	in_currency	block_number	block_timestamp	transaction_hash
100000000	0x57bb6a8563a8e8478391c79f3f433c6ba077c567	false	0xa3c5e4d471df75447dcb1256ef1ada80eeb806b3	115000000000000	0x2dc130e46b5958208155546bd4049d5b3319798063a8c4180b4b2b82f3ebdc3d	58	11500	50	0xc96de26018a54d51c097160568752c4e3bd6c364	20345554	2024-07-20T05:08:35.000Z	0xed835183e5611b04dda57898e34d1901f333f38e05dfc696172ca4252f0b16ef
100000000	0x57bb6a8563a8e8478391c79f3f433c6ba077c567	false	0xa3c5e4d471df75447dcb1256ef1ada80eeb806b3	110020000000000	0x2dc130e46b5958208155546bd4049d5b3319798063a8c4180b4b2b82f3ebdc3d	58	11002	57	0xc96de26018a54d51c097160568752c4e3bd6c364	20346071	2024-07-20T06:51:59.000Z	0x9f70fc3d09d99a510c5233ca7894ac471f674703d39e51d63ff2f018221f0357
100000000	0x57bb6a8563a8e8478391c79f3f433c6ba077c567	false	0xa3c5e4d471df75447dcb1256ef1ada80eeb806b3	109850000000000	0x2dc130e46b5958208155546bd4049d5b3319798063a8c4180b4b2b82f3ebdc3d	71	10985	58	0xc96de26018a54d51c097160568752c4e3bd6c364	20346190	2024-07-20T07:15:59.000Z	0x0ed7d74cc8b9edc8b887923a70c9481dd43b1a9daf0e6c3c3f6db4c0a2f702ba

Example Query

Query with partition filter

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

SolvBTCLSTRouter_CreateRedemption_event

Redemption initiation events emitted by the SolvBTC Liquid Staking Token Router contract when users create withdrawal requests. Records redeemer address, redemption amount, pool identifier, SolvBTC token contract, and assigned redemption ID for tracking withdrawal lifecycle.

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_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_solvBTC`	`STRING`	Contract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redemptionId`	`STRING`	Unique identifier assigned to the redemption transaction when it is created.

Sample Data

address	removed	in_poolId	log_index	in_solvBTC	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redemptionId	transaction_hash
0x01024aaed5561fa6237c0ad4073417576c591261	false	0xefcca1eb946cdc7b56509489a56b45b75aff74b8bb84dad5b893012157e0df93	189	0xd9d920aa40f578ab794426f5c90f6c731d159def	0xaed0a189fe381d5bb35da6fa925ac36e54d84607	21654261	2025-01-18T22:08:47.000Z	142702465655439134	376	0x71f7b39e84281f11d035b157367e0105531459e0eb72afc3babfa901afb70a50
0x01024aaed5561fa6237c0ad4073417576c591261	false	0xefcca1eb946cdc7b56509489a56b45b75aff74b8bb84dad5b893012157e0df93	284	0xd9d920aa40f578ab794426f5c90f6c731d159def	0x2bd6da5b31162e0fd53cdd3cf01b1057249d6811	21649394	2025-01-18T05:51:23.000Z	12052841152327802	373	0x24b9f05cc6bc5123ce697a84367c9b9abd223938e3ec6eed63b80b52a4d5fa3f
0x01024aaed5561fa6237c0ad4073417576c591261	false	0xefcca1eb946cdc7b56509489a56b45b75aff74b8bb84dad5b893012157e0df93	301	0xd9d920aa40f578ab794426f5c90f6c731d159def	0xa139ee8244e005fd21aedcab38bb4d51ee0bc01a	21647702	2025-01-18T00:09:59.000Z	209338880000000000	369	0xb400168533c3425ffc95ad9d4632aeae28ab8f78df922ee493925d6c8d1eb089

Example Query

Query with partition filter

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

SolvBTCLSTRouter_CreateSubscription_event

CreateSubscription events emitted by SolvBTC LST (Liquid Staking Token) Router contracts when users subscribe to SolvBTC pools by depositing currency tokens in exchange for SolvBTC tokens. Records subscriber address, pool identifier, deposited currency amount, and received SolvBTC amount.

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_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_subscriber`	`STRING`	Wallet address of the account receiving the subscription tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_solvBTC`	`STRING`	Contract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_subscribeAmount`	`STRING`	Amount of SolvBTC tokens to be received by the subscriber in the subscription. Numeric string representation of the token quantity in its smallest unit.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_currencyAmount`	`STRING`	Amount of currency tokens involved in the transaction. Numeric string representation of the token quantity in its smallest unit.

Sample Data

address	removed	in_poolId	log_index	in_solvBTC	in_currency	block_number	in_subscriber	block_timestamp	transaction_hash	in_currencyAmount	in_subscribeAmount
0x01024aaed5561fa6237c0ad4073417576c591261	false	0xefcca1eb946cdc7b56509489a56b45b75aff74b8bb84dad5b893012157e0df93	69	0xd9d920aa40f578ab794426f5c90f6c731d159def	0x7a56e1c57c7475ccf742a1832b028f0456652f97	20709483	0x5bd5c8207f1976a9f03b60971986706011b4625c	2024-09-09T00:31:11.000Z	0x06c76c08a8b3fb3b12203856a241ba73087fccee08a7a729f3281549f3cec2a6	1950070000000000	1950070000000000
0x01024aaed5561fa6237c0ad4073417576c591261	false	0xefcca1eb946cdc7b56509489a56b45b75aff74b8bb84dad5b893012157e0df93	242	0xd9d920aa40f578ab794426f5c90f6c731d159def	0x7a56e1c57c7475ccf742a1832b028f0456652f97	20710178	0x940235597bcfe0d1af848b34789d3d93c1e54316	2024-09-09T02:50:23.000Z	0x05678943be482aa9e0d63aa7fa5b02086c8388a564358c110a6c3665a1edf743	5000000000000000	5000000000000000
0x01024aaed5561fa6237c0ad4073417576c591261	false	0xefcca1eb946cdc7b56509489a56b45b75aff74b8bb84dad5b893012157e0df93	175	0xd9d920aa40f578ab794426f5c90f6c731d159def	0x7a56e1c57c7475ccf742a1832b028f0456652f97	20709725	0x7f1d18e37e8fbde9534d5856f90d21a05b094539	2024-09-09T01:19:47.000Z	0x4c1e6d2385cb276f5b35578ebc80764c8932313febeda9fe4bb4ee15604efb07	2699050000000000	2699050000000000

Example Query

Query with partition filter

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

SolvBTCRouter_CreateRedemption_event

Event emitted when a user initiates a SolvBTC token redemption request through the SolvBTCRouter contract. Records the redeemer address, redemption amount, pool identifier, SolvBTC token contract, and assigned redemption identifier for tracking withdrawal requests.

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_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_solvBTC`	`STRING`	Contract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redemptionId`	`STRING`	Unique identifier assigned to the redemption transaction when it is created.

Sample Data

address	removed	in_poolId	log_index	in_solvBTC	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redemptionId	transaction_hash
0x1ff7d7c0a7d8e94046708c611dec5056a9d2b823	false	0x2dc130e46b5958208155546bd4049d5b3319798063a8c4180b4b2b82f3ebdc3d	157	0x7a56e1c57c7475ccf742a1832b028f0456652f97	0xdd5ae96db35709ae9762becb357150c3a5e4a57f	20517382	2024-08-13T04:41:35.000Z	104184370000000	56	0x520f6ebbd0200e621e75dc35504054f34d84205fa4329a5985f6df146d69b94a
0x1ff7d7c0a7d8e94046708c611dec5056a9d2b823	false	0x2dc130e46b5958208155546bd4049d5b3319798063a8c4180b4b2b82f3ebdc3d	188	0x7a56e1c57c7475ccf742a1832b028f0456652f97	0x2daafbcb69c136c94a4702411333860b50c79022	20516731	2024-08-13T02:31:11.000Z	45580000000000	55	0x5e44e93050a193ee74b60394b24554bf1b22ede983f3469b5afa17ab6ecad305
0x1ff7d7c0a7d8e94046708c611dec5056a9d2b823	false	0x2dc130e46b5958208155546bd4049d5b3319798063a8c4180b4b2b82f3ebdc3d	421	0x7a56e1c57c7475ccf742a1832b028f0456652f97	0xcb46c929d37527f89cea7ad4cdedb79e9d400d28	20519629	2024-08-13T12:13:47.000Z	302094119962000000	58	0x66a49c08507f0ee9639ca8ea8be2a75d6358c2b0d6d4e5781317fbd4ad0d32ae

Example Query

Query with partition filter

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

SolvBTCRouter_CreateSubscription_event

Emitted when a user subscribes to a SolvBTC pool by depositing a currency token in exchange for SolvBTC tokens. Records the pool identifier, input currency and amount, output SolvBTC token and amount, and subscriber address for tracking Bitcoin-backed token subscription transactions.

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_poolId`	`STRING`	Unique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
`in_subscriber`	`STRING`	Wallet address of the account receiving the subscription tokens. Hex-encoded, 0x-prefixed, 42-character string.
`in_solvBTC`	`STRING`	Contract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_subscribeAmount`	`STRING`	Amount of SolvBTC tokens to be received by the subscriber in the subscription. Numeric string representation of the token quantity in its smallest unit.
`in_currency`	`STRING`	Contract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_currencyAmount`	`STRING`	Amount of currency tokens involved in the transaction. Numeric string representation of the token quantity in its smallest unit.

Sample Data

address	removed	in_poolId	log_index	in_solvBTC	in_currency	block_number	in_subscriber	block_timestamp	transaction_hash	in_currencyAmount	in_subscribeAmount
0x1ff7d7c0a7d8e94046708c611dec5056a9d2b823	false	0x716db7dc196abe78d5349c7166896f674ab978af26ada3e5b3ea74c5a1b48307	205	0x7a56e1c57c7475ccf742a1832b028f0456652f97	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	21077875	0x18f92f0673e46cf247a13703f5e403493b7c17ce	2024-10-30T10:30:59.000Z	0x55ad8676db15abba1cf635d4c6de633d921848ee1a24e3ad71642c185002a97f	730163	7301630000000000
0x1ff7d7c0a7d8e94046708c611dec5056a9d2b823	false	0x716db7dc196abe78d5349c7166896f674ab978af26ada3e5b3ea74c5a1b48307	513	0x7a56e1c57c7475ccf742a1832b028f0456652f97	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	21076985	0x4c02a171fbef3485368037dff53ce1a8a930cdf8	2024-10-30T07:31:35.000Z	0x3079927b4f3a3d251b4b3e19f5b2f9ee7cad636ae56e09d8d1da9883b47b01be	906807	9068070000000000
0x1ff7d7c0a7d8e94046708c611dec5056a9d2b823	false	0x716db7dc196abe78d5349c7166896f674ab978af26ada3e5b3ea74c5a1b48307	249	0x7a56e1c57c7475ccf742a1832b028f0456652f97	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	21080469	0x20479d2ed614c49375cce290015d7b3102e38cdb	2024-10-30T19:13:59.000Z	0xaaffabd3782c5594b7071a36b79237db8e737875ae44f99eec5059c678456cba	1230000	12300000000000000

Example Query

Query with partition filter

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

SolvConvertibleMarket_Traded_event

Trade execution events from Solv Protocol’s convertible token marketplace on Ethereum, recording buyer addresses, traded amounts, prices, fees, and token IDs. Used for analyzing secondary market activity and pricing dynamics of tokenized convertible instruments.

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
4500000300	0x962e18f89d27cfc84c8ffa2ec7c90b3d933ad685	false	0xf7701575f489376b2c646d66e7205fd57bd0be61	967742	2	432	0x2d53f42b2edf8907bcaa4d3f28e6f76bd95334e3	10	2	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	14542698	1649387616	31000000000000000000000000000000	2022-04-08T03:13:36.000Z	300000020000	0xe2aaef3b28713226e849023c341d1f63a5d58c3e3d024a2803e0c7666dd1b3b6
74999	0x962e18f89d27cfc84c8ffa2ec7c90b3d933ad685	false	0xe72452a9935758c9d3651eee9f84a56634b6456c	950000	1	217	0xbf50337ed0ff20fa4d5702bf2da187e2c217d034	11	7	0xdac17f958d2ee523a2206206994597c13d831ec7	15796322	1666353359	526315789473684210526000000	2022-10-21T11:55:59.000Z	4999999	0x30b475d94a645a2465777c9f92ddb2349e70dc454741434a79f098a90eafbb36
30000	0x962e18f89d27cfc84c8ffa2ec7c90b3d933ad685	false	0x48b742b9d935fdaeade1a48cd7c5e4aec4360b0c	950000	1	446	0xbf50337ed0ff20fa4d5702bf2da187e2c217d034	11	1	0xdac17f958d2ee523a2206206994597c13d831ec7	14429012	1647856574	210526315789473684211000000	2022-03-21T09:56:14.000Z	2000000	0x8c67b61e017973d843b0f4b187ad951b516b5b730b4a898e6a4c5db2d430b997

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_ethereum.SolvConvertibleMarket_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
3000000	0xd91a208995bfbde9d133c39417fbd352e595650b	false	0xec6792bab73bec96a1d6fe5a27f78f311162be35	1000000	76	207	0x705d6b0c912a33a8643b5f7e42b5c7ca386a3b32	9	182	0xdac17f958d2ee523a2206206994597c13d831ec7	13732528	1638520043	200000000000000000000	2021-12-03T08:27:23.000Z	200000000	0x11298079bb8771e6a402299a45bcb4e09e85322255a47330c216a2dae4218d9e
29999	0xd91a208995bfbde9d133c39417fbd352e595650b	false	0x8a9c930896e453ca3d87f1918996423a589dd529	880000	68	92	0xadb9ab302ecd551264a718d43ae6b3c255a8afa5	52	406	0xdac17f958d2ee523a2206206994597c13d831ec7	15851105	1667014967	2272727272727272727	2022-10-29T03:42:47.000Z	1999999	0x8a0808b3623b64f18a4cbd6185b793975ec6f8b6df2459f089fb807f7659a681
3742500000	0xd91a208995bfbde9d133c39417fbd352e595650b	false	0xd186a553b40210cabf18c9f251504ddffbdc4ac8	25000000000	125	575	0x30fda944075c1b7e92498ce6358bcef1284febfa	4	291	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	15218934	1658849622	998000000	2022-07-26T15:33:42.000Z	249500000000	0xc5894c0a70c49c092726d6a19eaa0c6733c4d777d22458247f21ded239277801

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_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

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event

SolvConvertibleMarket_Traded_event

SolvICMarket_Traded_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​InitialBondOfferingMarket_Traded_event

​InitialConvertibleOfferingMarket_Traded_event

​InitialVestingOfferingMarket_Traded_event

​OpenFundMarket_CreatePool_event

​OpenFundMarket_Subscribe_event

​SolvBTCLSTRouter_CreateRedemption_event

​SolvBTCLSTRouter_CreateSubscription_event

​SolvBTCRouter_CreateRedemption_event

​SolvBTCRouter_CreateSubscription_event

​SolvConvertibleMarket_Traded_event

​SolvICMarket_Traded_event

Tables

InitialBondOfferingMarket_Traded_event

InitialConvertibleOfferingMarket_Traded_event

InitialVestingOfferingMarket_Traded_event

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event

SolvConvertibleMarket_Traded_event

SolvICMarket_Traded_event