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
0x788dc3af7b62708b752d483a6e30d1cf23c3eaae0x56a4d805d7a292f03ead5be31e0ffb8f7d0e3b48false0x2bfddb460b2050c9e7567eec1f3ac39c1766a404299038080a4ad7ec294b64251600xcc0966d8418d412c599a6421b760a847eb169a8c4374332{“vault”:“0x94dc1436b459ff19be4e113a914f3a82a4317e8a”,“currency”:“0xcc0966d8418d412c599a6421b760a847eb169a8c”,“navOracle”:“0x45fb21ac62503c0bb6fff3513a3d0ffaaa11acdb”,“valueDate”:“1746057600”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”,“subscribeNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x9678e371922e934b5d1ede666566c879da457f23”,“latestProtocolFeeSettleTime”:“1746057600”},“poolSFTInfo”:{“openFundShare”:“0x788dc3af7b62708b752d483a6e30d1cf23c3eaae”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“20070464631911807053851373235364630027197982269692303312604928304223800691939”,“openFundRedemption”:“0x1fad7d0f2c3e9aeb19fc0a612f5c2b99b81f26c3”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1872201600”,“fundraisingStartTime”:“1745981086”}}2025-04-30T03:02:05.000Z0x1a4bc580c884808efacf4fe87c8a272e87fa0082cf21c96b02423db0f89e9b27
0x788dc3af7b62708b752d483a6e30d1cf23c3eaae0x56a4d805d7a292f03ead5be31e0ffb8f7d0e3b48false0x2716ab5b436a50e2a32950745dd1984909642afd749bb216709dfc2a993d11ca360x541fd749419ca806a8bc7da8ac23d346f2df8b774346984{“vault”:“0x3ca2c0fbcf99967e4cf23456a0b5647fc3f810c0”,“currency”:“0x541fd749419ca806a8bc7da8ac23d346f2df8b77”,“navOracle”:“0x45fb21ac62503c0bb6fff3513a3d0ffaaa11acdb”,“valueDate”:“1746144000”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”,“subscribeNavManager”:“0x150479dbd49d6b607970fadc0b6a8c94da4c7fcc”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x9678e371922e934b5d1ede666566c879da457f23”,“latestProtocolFeeSettleTime”:“1746144000”},“poolSFTInfo”:{“openFundShare”:“0x788dc3af7b62708b752d483a6e30d1cf23c3eaae”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“106364849777571868594476339325600973338617958733204578422008243301772891782637”,“openFundRedemption”:“0x1fad7d0f2c3e9aeb19fc0a612f5c2b99b81f26c3”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1872201600”,“fundraisingStartTime”:“1745927213”}}2025-04-29T11:52:42.000Z0x27c853c796c8b32e65cb41132e14aed463cde41b0cf72959fad642863198f8c0
0x1f4d23513c3ef0d63b97bbd2ce7c845ebb1cf1ce0x56a4d805d7a292f03ead5be31e0ffb8f7d0e3b48false0x8d0d551de285206573e1ff69a95bc8a9624c77d47f41a37a1f245c3cf4bc0d6b920x0555e30da8f98308edb960aa94c0db47230d2b9c4346987{“vault”:“0x52be8fe8fed6c8d52a9fd94a10dad12f4ffa9526”,“currency”:“0x0555e30da8f98308edb960aa94c0db47230d2b9c”,“navOracle”:“0x5017cf7b221e376f4d5f97bc1097ad965ed688c2”,“valueDate”:“1746057600”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x538db8bdd683b941d6cee61d9a7a128d53c32522”,“subscribeNavManager”:“0x538db8bdd683b941d6cee61d9a7a128d53c32522”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x9678e371922e934b5d1ede666566c879da457f23”,“latestProtocolFeeSettleTime”:“1746057600”},“poolSFTInfo”:{“openFundShare”:“0x1f4d23513c3ef0d63b97bbd2ce7c845ebb1cf1ce”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“73054730711870722933844565498985369099913996007027537845134272683003526055870”,“openFundRedemption”:“0xef8de79b25c5c8ed2f609c0b22b3d18cedfbb834”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“10000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1903219200”,“fundraisingStartTime”:“1745921017”}}2025-04-29T11:52:48.000Z0x76d0db642227e8adf45086fdbaf4b73654bd00f14692ecf4587b61ca89815e69
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_berachain.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
10000000000000000000x56a4d805d7a292f03ead5be31e0ffb8f7d0e3b48false0xe6193d4bfaaf1aa6aa106c309d698d39c0ccf7b45395183669723672470x2716ab5b436a50e2a32950745dd1984909642afd749bb216709dfc2a993d11ca665395183669723672473970x541fd749419ca806a8bc7da8ac23d346f2df8b7763624672025-06-14T06:39:35.000Z0xd56ab15c230e5702ef8f4fe7d189340116f50ba143b1cba1f4fbc042ec32dad7
10000000000000000000x56a4d805d7a292f03ead5be31e0ffb8f7d0e3b48false0xe6193d4bfaaf1aa6aa106c309d698d39c0ccf7b43401026028771897620x2716ab5b436a50e2a32950745dd1984909642afd749bb216709dfc2a993d11ca1093401026028771897623960x541fd749419ca806a8bc7da8ac23d346f2df8b7763622842025-06-14T06:33:42.000Z0x129726a23249e5c3d06cd3ad787bcae21e539245a0febe170be40508c6ac0093
1002506000x56a4d805d7a292f03ead5be31e0ffb8f7d0e3b48false0x44ec315a0b226432185eb4fafcd331558178fc7e5395183669723672470x8d0d551de285206573e1ff69a95bc8a9624c77d47f41a37a1f245c3cf4bc0d6b1254087040930x0555e30da8f98308edb960aa94c0db47230d2b9c63620402025-06-14T06:25:48.000Z0xd6feee29ea251790fad53324eb014efdc90e7fe8995189ce78f7a5f5526ad2f7
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_berachain.OpenFundMarket_Subscribe_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100