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
0x6b2e555b6c17bfbba251cc3cde084071f4a7ef380xf5a247157656678398b08d3efa1673358c611a3ffalse0x1706a4881586917b18c2274dfdbcdffe48ee22e18c99090dcee7dd38464526b47650x236aa50979d5f3de3bd1eeb40e81137f22ab794b21782475{“vault”:“0xf2416c264aa4068ff4d1949383366458f295f205”,“currency”:“0x236aa50979d5f3de3bd1eeb40e81137f22ab794b”,“navOracle”:“0x8b79e5bf5689c38a9fc386afdfb1a12b1abdeb0b”,“valueDate”:“1730851200”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x40751f26093fa4475a7b7ddbbbc7963fa544f56b”,“subscribeNavManager”:“0x40751f26093fa4475a7b7ddbbbc7963fa544f56b”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“latestProtocolFeeSettleTime”:“1730851200”},“poolSFTInfo”:{“openFundShare”:“0x6b2e555b6c17bfbba251cc3cde084071f4a7ef38”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“112080783148248594065790277258566860467412206538881753911731961993640874169445”,“openFundRedemption”:“0xd39015c678475a6423fac275b32cdf988175983b”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1888012800”,“fundraisingStartTime”:“1730353906”}}2024-10-31T05:58:17.000Z0xb0cfe22bb008a284c97853793622e242dce1738a2c6d80e42fca7125084d031e
0x6b2e555b6c17bfbba251cc3cde084071f4a7ef380xf5a247157656678398b08d3efa1673358c611a3ffalse0x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f53170xcbb7c0000ab88b473b1f5afd9ef808440eed33bf19111970{“vault”:“0xcdaaaa09e6e0de3e7171259cf6962e4d44f983f9”,“currency”:“0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf”,“navOracle”:“0x8b79e5bf5689c38a9fc386afdfb1a12b1abdeb0b”,“valueDate”:“1725494400”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x40751f26093fa4475a7b7ddbbbc7963fa544f56b”,“subscribeNavManager”:“0x40751f26093fa4475a7b7ddbbbc7963fa544f56b”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“latestProtocolFeeSettleTime”:“1725494400”},“poolSFTInfo”:{“openFundShare”:“0x6b2e555b6c17bfbba251cc3cde084071f4a7ef38”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“88468361214282768022888996948490661551803884394452793264507689010931000556751”,“openFundRedemption”:“0xd39015c678475a6423fac275b32cdf988175983b”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“10000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1882656000”,“fundraisingStartTime”:“1725012304”}}2024-08-30T10:21:27.000Z0xcf2044df3d5c704e4e638155491f9653e708241e8c0085222730f415e4cee674
0x29f870ed75b4632301946bb935433605f39d515e0xf5a247157656678398b08d3efa1673358c611a3ffalse0xb20032ac848893cf4820a7b3259020ffd5057d49f537c2adc5f74a337cc56ddc3370x3b86ad95859b6ab773f55f8d94b4b9d443ee931f19105243{“vault”:“0x66db87c3d4b95c0184ba8cb3d4dc44fd3f3fbfdb”,“currency”:“0x3b86ad95859b6ab773f55f8d94b4b9d443ee931f”,“navOracle”:“0x1210371f2e26a74827f250afdfdbe3091304a3b7”,“valueDate”:“1725494400”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x40751f26093fa4475a7b7ddbbbc7963fa544f56b”,“subscribeNavManager”:“0x40751f26093fa4475a7b7ddbbbc7963fa544f56b”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“latestProtocolFeeSettleTime”:“1725494400”},“poolSFTInfo”:{“openFundShare”:“0x29f870ed75b4632301946bb935433605f39d515e”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“21594604619467779384440136342992607739900587760885830736240056183867191526104”,“openFundRedemption”:“0x10e42a1fd1aec5d330f4f8eca94b06cff264d02a”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1882656000”,“fundraisingStartTime”:“1724999289”}}2024-08-30T06:37:13.000Z0x7bf4e7a7f5dbbdd25a6c345f5932d3263e074068cef65b6394feb63e985fef6d
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_base.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
1000000000xf5a247157656678398b08d3efa1673358c611a3ffalse0x65effda5e69df470d4dbd31a805e15855cae65c720687100000000000x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f532220687119040xcbb7c0000ab88b473b1f5afd9ef808440eed33bf231670592024-12-02T07:11:05.000Z0x939077884363223de434b01a6bed11e2669f86f6c4e690c6a2585dc40d538723
1000000000xf5a247157656678398b08d3efa1673358c611a3ffalse0x65effda5e69df470d4dbd31a805e15855cae65c774000000000000000x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f560174000019160xcbb7c0000ab88b473b1f5afd9ef808440eed33bf231799192024-12-02T14:19:45.000Z0x1d882e6d0e54fbb7254d10afcf2c52a48f889a993cb5185b826010d47b76317c
1000000000xf5a247157656678398b08d3efa1673358c611a3ffalse0x65effda5e69df470d4dbd31a805e15855cae65c72260300000000000x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f52172260319230xcbb7c0000ab88b473b1f5afd9ef808440eed33bf231906392024-12-02T20:17:05.000Z0xecc473307120340c33133ac5ff0917108b2389ce812d4c0adf4aece26f3f0729
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_base.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.
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_redeemerSTRINGAddress of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_solvBTCSTRINGContract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_redeemAmountSTRINGAmount of underlying asset tokens withdrawn from the lending pool during redemption.
in_redemptionIdSTRINGUnique identifier assigned to the redemption transaction when it is created.
addressremovedin_poolIdlog_indexin_solvBTCin_redeemerblock_numberblock_timestampin_redeemAmountin_redemptionIdtransaction_hash
0x814f3ae67df0da9fe2399a29516fd14b9085263afalse0xb20032ac848893cf4820a7b3259020ffd5057d49f537c2adc5f74a337cc56ddc3470xc26c9099bd3789107888c35bb41178079b2825610xbebe18d02b47eae7cd31c6d4f6d82353fa69f431256939272025-01-29T19:00:01.000Z39306188594345024960x83759f3681c6f2dbc40be0100aabd91725c47787d4212c979135eee129ae771c
0x814f3ae67df0da9fe2399a29516fd14b9085263afalse0xb20032ac848893cf4820a7b3259020ffd5057d49f537c2adc5f74a337cc56ddc1160xc26c9099bd3789107888c35bb41178079b2825610x21f3b824d69b9746d062dcb4af9d4f595360288e256983802025-01-29T21:28:27.000Z11749468462868564970x43cca05a19ed4287a1aa7faea89ce7e5660f9451ffde3be9789b01ef7492327a
0x814f3ae67df0da9fe2399a29516fd14b9085263afalse0xb20032ac848893cf4820a7b3259020ffd5057d49f537c2adc5f74a337cc56ddc2810xc26c9099bd3789107888c35bb41178079b2825610x0419959c9fff74feac47e51d5869fabca61fff15246293252025-01-05T03:33:17.000Z152003072685405051640x2769e9ebb44e583b458d29e070384fce3702d49f49dd3f7f255907a9fd30d744
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_base.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.
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_subscriberSTRINGWallet address of the account receiving the subscription tokens. Hex-encoded, 0x-prefixed, 42-character string.
in_solvBTCSTRINGContract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_subscribeAmountSTRINGAmount of SolvBTC tokens to be received by the subscriber in the subscription. Numeric string representation of the token quantity in its smallest unit.
in_currencySTRINGContract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_currencyAmountSTRINGAmount of currency tokens involved in the transaction. Numeric string representation of the token quantity in its smallest unit.
addressremovedin_poolIdlog_indexin_solvBTCin_currencyblock_numberin_subscriberblock_timestamptransaction_hashin_currencyAmountin_subscribeAmount
0x814f3ae67df0da9fe2399a29516fd14b9085263afalse0xb20032ac848893cf4820a7b3259020ffd5057d49f537c2adc5f74a337cc56ddc3960xc26c9099bd3789107888c35bb41178079b2825610x3b86ad95859b6ab773f55f8d94b4b9d443ee931f238548600x0419959c9fff74feac47e51d5869fabca61fff152024-12-18T05:17:47.000Z0x7651ad3a04e4116e92ee112516f6ca660a48383113cf49c62e2102bb4d444d7f1519578000000000015195780000000000
0x814f3ae67df0da9fe2399a29516fd14b9085263afalse0xb20032ac848893cf4820a7b3259020ffd5057d49f537c2adc5f74a337cc56ddc1720xc26c9099bd3789107888c35bb41178079b2825610x3b86ad95859b6ab773f55f8d94b4b9d443ee931f238649680x0b34f02845bded1ad1d64beb013e68b5b5cdccda2024-12-18T10:54:43.000Z0x7473f6447d079fc6574d071773172f888d9a763c29a34e846e7b198893a7612510000000000000001000000000000000
0x814f3ae67df0da9fe2399a29516fd14b9085263afalse0xb20032ac848893cf4820a7b3259020ffd5057d49f537c2adc5f74a337cc56ddc2300xc26c9099bd3789107888c35bb41178079b2825610x3b86ad95859b6ab773f55f8d94b4b9d443ee931f238549040x144e1547ad7be53ed5f751406a661540b860d5222024-12-18T05:19:15.000Z0x40faa331c60f752dc49dfd089d480bf8c3dfbe70f73b99c987471f82e8db0ba64129388000000000041293880000000000
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_base.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.
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_redeemerSTRINGAddress of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_solvBTCSTRINGContract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_redeemAmountSTRINGAmount of underlying asset tokens withdrawn from the lending pool during redemption.
in_redemptionIdSTRINGUnique identifier assigned to the redemption transaction when it is created.
addressremovedin_poolIdlog_indexin_solvBTCin_redeemerblock_numberblock_timestampin_redeemAmountin_redemptionIdtransaction_hash
0x65effda5e69df470d4dbd31a805e15855cae65c7false0x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f53250x3b86ad95859b6ab773f55f8d94b4b9d443ee931f0xf6f238e6a1751e4d6bdd1f46f929f432cca28a05224264662024-11-15T03:44:39.000Z32427100000000001090x74b20a427f96de9b178e831239c66ea51cea3d65557ecce54803782b652d892a
0x65effda5e69df470d4dbd31a805e15855cae65c7false0x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f53340x3b86ad95859b6ab773f55f8d94b4b9d443ee931f0x836b7e7c21b92df35d56373e758faa5946795729224423962024-11-15T12:35:39.000Z605921000000000001100xbc51e862dc26d14c07a2ca4c07d635284d920b1c67cf614f1bfe95795f5bb849
0x65effda5e69df470d4dbd31a805e15855cae65c7false0x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f52500x3b86ad95859b6ab773f55f8d94b4b9d443ee931f0xb250570d1595c1fe4759fa4a8b140a86858ae39f231795692024-12-02T14:08:05.000Z10000000000000000001860x37d322b6885548d0a33870c1379b6904b04aede5f0aedaa7b6618d61207e270b
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_base.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.
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_subscriberSTRINGWallet address of the account receiving the subscription tokens. Hex-encoded, 0x-prefixed, 42-character string.
in_solvBTCSTRINGContract address of the SolvBTC token involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_subscribeAmountSTRINGAmount of SolvBTC tokens to be received by the subscriber in the subscription. Numeric string representation of the token quantity in its smallest unit.
in_currencySTRINGContract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_currencyAmountSTRINGAmount of currency tokens involved in the transaction. Numeric string representation of the token quantity in its smallest unit.
addressremovedin_poolIdlog_indexin_solvBTCin_currencyblock_numberin_subscriberblock_timestamptransaction_hashin_currencyAmountin_subscribeAmount
0x65effda5e69df470d4dbd31a805e15855cae65c7false0x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f52300x3b86ad95859b6ab773f55f8d94b4b9d443ee931f0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf215327370xccd724b9af92a3a389150334556330efd3f594872024-10-25T11:13:41.000Z0xad0ffe66787edb445c61825d0b02b8e9ac37d9a10694f1f4ab5cfbc9ece668bf100000010000000000000000
0x65effda5e69df470d4dbd31a805e15855cae65c7false0x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f5830x3b86ad95859b6ab773f55f8d94b4b9d443ee931f0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf215354670x11c4bea6825f43af5c2eaca3d92fd65bb1a70df92024-10-25T12:44:41.000Z0x47ef4a2e303f7869cda7055628aa55855834e1431a12fd48ede879bda781f844100000010000000000000000
0x65effda5e69df470d4dbd31a805e15855cae65c7false0x0d85d41382f6f2effeaa41a46855870ec8b1577c6c59cf16d72856a22988e3f53090x3b86ad95859b6ab773f55f8d94b4b9d443ee931f0xcbb7c0000ab88b473b1f5afd9ef808440eed33bf215329280xccd724b9af92a3a389150334556330efd3f594872024-10-25T11:20:03.000Z0x146d30dc22343c26e5b9b6be6e6bee0dbac8e4804b21a0d6d9e7b4eb7ea4eceb100000010000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v1_base.SolvBTCRouter_CreateSubscription_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100