solv_v1_ink

Tables

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
0x788dc3af7b62708b752d483a6e30d1cf23c3eaae	0xba891ce042bdb092c450d242c05db44d7e5bb728	false	0xeb419d20c80a32da9ba3b4dd8aa799fd3bc605d0739aa545775d89d9f7767642	5	0xae4efbc7736f963982aacb17efa37fcbab924cb3	11875537	{“vault”:“0x32611194b98b7ef451edf2a8bb0a11475ca8c287”,“currency”:“0xae4efbc7736f963982aacb17efa37fcbab924cb3”,“navOracle”:“0x600fb9600444fb8373bf9a112ae0977f6676c564”,“valueDate”:“1745452800”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”,“subscribeNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x9678e371922e934b5d1ede666566c879da457f23”,“latestProtocolFeeSettleTime”:“1745452800”},“poolSFTInfo”:{“openFundShare”:“0x788dc3af7b62708b752d483a6e30d1cf23c3eaae”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“21878350592799687335720143765034541687231338182764106208669036308924224432770”,“openFundRedemption”:“0x1fad7d0f2c3e9aeb19fc0a612f5c2b99b81f26c3”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“2124489600”,“fundraisingStartTime”:“1745372371”}}	2025-04-23T02:05:48.000Z	0x787ade210ebba26999a02587336382ff6d98be78c6f698264b471c26e9dfbfdb
0x1f4d23513c3ef0d63b97bbd2ce7c845ebb1cf1ce	0xba891ce042bdb092c450d242c05db44d7e5bb728	false	0x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a	13	0x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98	11982401	{“vault”:“0x33b7a7a164b77433a61d4b49bd780a2718812e6e”,“currency”:“0x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98”,“navOracle”:“0x2a83bf5866fbc782b71f859589a4d28b55190949”,“valueDate”:“1745625600”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”,“subscribeNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x9678e371922e934b5d1ede666566c879da457f23”,“latestProtocolFeeSettleTime”:“1745625600”},“poolSFTInfo”:{“openFundShare”:“0x1f4d23513c3ef0d63b97bbd2ce7c845ebb1cf1ce”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“78908435061005241208597124183970788172052752205035978365903093961294268813828”,“openFundRedemption”:“0xef8de79b25c5c8ed2f609c0b22b3d18cedfbb834”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“2000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1903219200”,“fundraisingStartTime”:“1745480448”}}	2025-04-24T07:46:52.000Z	0x58128ed5d6e6cfa9cdfb41a22ba7c192de2eae9d1abfccaba90763b39e68c8f7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_ink.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
100100100	0xba891ce042bdb092c450d242c05db44d7e5bb728	false	0x9c5ace3a5915e330a48d36478c01d03ccb4fd099	29970000029	0x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a	11	3	19	0x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98	18921186	2025-07-13T15:13:17.000Z	0x4e02f7dc400b9b178a3c823b69dd7fa87f209a013e57ff5e1271f550adfceaa6
100100100	0xba891ce042bdb092c450d242c05db44d7e5bb728	false	0x9c5ace3a5915e330a48d36478c01d03ccb4fd099	39960000039	0x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a	8	4	16	0x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98	18700748	2025-07-11T01:59:19.000Z	0xc89fb40d0337688b101a971a29a37987833c099990f6a2af2f4515573d830abf
100100100	0xba891ce042bdb092c450d242c05db44d7e5bb728	false	0x9c5ace3a5915e330a48d36478c01d03ccb4fd099	319680000319	0x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a	9	32	10	0x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98	17299679	2025-06-24T20:48:10.000Z	0xd8453c4cea4453a095fb0bbbaec564ce42723150598bbeee5f5e06ea80ca9650

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

​Tables

​OpenFundMarket_CreatePool_event

​OpenFundMarket_Subscribe_event

Tables

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event