Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_currencySTRINGContract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_sftSTRINGContract 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.
in_sftaddressremovedin_poolIdlog_indexin_currencyblock_numberin_poolInfo_block_timestamptransaction_hash
0x788dc3af7b62708b752d483a6e30d1cf23c3eaae0xba891ce042bdb092c450d242c05db44d7e5bb728false0xeb419d20c80a32da9ba3b4dd8aa799fd3bc605d0739aa545775d89d9f776764250xae4efbc7736f963982aacb17efa37fcbab924cb311875537{“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.000Z0x787ade210ebba26999a02587336382ff6d98be78c6f698264b471c26e9dfbfdb
0x1f4d23513c3ef0d63b97bbd2ce7c845ebb1cf1ce0xba891ce042bdb092c450d242c05db44d7e5bb728false0x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a130x73e0c0d45e048d25fc26fa3159b0aa04bfa4db9811982401{“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.000Z0x58128ed5d6e6cfa9cdfb41a22ba7c192de2eae9d1abfccaba90763b39e68c8f7
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_poolIdSTRINGUnique identifier for the liquidity pool or staking pool. 66-character hex string including 0x prefix.
in_buyerSTRINGAddress of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_currencySTRINGContract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_navSTRINGNet Asset Value (NAV) per share at the time of the subscription transaction. Numeric string representation preserving precision for financial calculations.
in_paymentSTRINGAmount paid by the buyer in the transaction. Numeric string representation in smallest token denomination.
in_navaddressremovedin_buyerin_valuein_poolIdlog_indexin_paymentin_tokenIdin_currencyblock_numberblock_timestamptransaction_hash
1001001000xba891ce042bdb092c450d242c05db44d7e5bb728false0x9c5ace3a5915e330a48d36478c01d03ccb4fd099299700000290x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a113190x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98189211862025-07-13T15:13:17.000Z0x4e02f7dc400b9b178a3c823b69dd7fa87f209a013e57ff5e1271f550adfceaa6
1001001000xba891ce042bdb092c450d242c05db44d7e5bb728false0x9c5ace3a5915e330a48d36478c01d03ccb4fd099399600000390x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a84160x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98187007482025-07-11T01:59:19.000Z0xc89fb40d0337688b101a971a29a37987833c099990f6a2af2f4515573d830abf
1001001000xba891ce042bdb092c450d242c05db44d7e5bb728false0x9c5ace3a5915e330a48d36478c01d03ccb4fd0993196800003190x49c5914da51b1db7b098590c27d19e6ef45e7edcbe37f6854a03bc73afee6b7a932100x73e0c0d45e048d25fc26fa3159b0aa04bfa4db98172996792025-06-24T20:48:10.000Z0xd8453c4cea4453a095fb0bbbaec564ce42723150598bbeee5f5e06ea80ca9650
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