solv_v1_arbitrum

Tables

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
2249999999	0x67d48ce0e776147b0d996e1facc0fbaa91b1cbc4	false	0xaafcdd316559ed4a0204ebe4ea508e3cfdb398f8	987654	12	2	0x32126ae067ec31974180f79b6313ae986a375faa	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9690805	1649768412	2	2	30375009871878208360417717000000	2022-04-12T13:00:12.000Z	299999999999	0xa689a1c3039f03a5bd680afcc4bc5f465f44e490e540dbc928c9109c27bcf874
75682499	0x67d48ce0e776147b0d996e1facc0fbaa91b1cbc4	false	0x35307770412f60406d5e8c5b52e7af4e6ea29819	987654	11	3	0x32126ae067ec31974180f79b6313ae986a375faa	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9690831	1649768412	3	2	1021714082057076668549917000000	2022-04-12T13:00:12.000Z	10090999999	0x4f601af6fb05f579a982e3c7015623a2c904d1320fe4e94b049998e5343769df
74999999	0x67d48ce0e776147b0d996e1facc0fbaa91b1cbc4	false	0x543c0893b67ca3b72011fc3a1c794d6b912bfb03	987654	11	4	0x32126ae067ec31974180f79b6313ae986a375faa	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	9691022	1649768682	4	2	1012500329062606945347257000000	2022-04-12T13:04:42.000Z	9999999999	0x422c1d9e36dbb3474725d53be480d53051e4144bb699fe3ccee4b78381b0f3b2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_arbitrum.InitialConvertibleOfferingMarket_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
0x22799daa45209338b7f938edf251bdfd1e6dcb32	0x629ad7bc14726e9cea4fcb3a7b363d237bb5dbe8	false	0x0c50b6d37ebce13c1a14c442303b4b25c6a5f88e70bb72341caef12a57bde5bb	43	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	141369381	{“vault”:“0xb04c57a9727ced77b019e2e42e3b1e404b06d5d5”,“currency”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“navOracle”:“0x6ec1fec6c6af53624733f671b490b8250ff251ed”,“valueDate”:“1697760000”,“managerInfo”:{“poolManager”:“0xcb6d5749e1ef94e2826c71240c2aaaf60fa04adb”,“redeemNavManager”:“0xb04c57a9727ced77b019e2e42e3b1e404b06d5d5”,“subscribeNavManager”:“0x3eebfac5b51ff51c82f0856dad42750d581d7483”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x78cb3134758dbae79923c22b34c0343648492a23”,“latestProtocolFeeSettleTime”:“1697760000”},“poolSFTInfo”:{“openFundShare”:“0x22799daa45209338b7f938edf251bdfd1e6dcb32”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“88182935818832256312545045622787117515574786777129470905804035345049290006949”,“openFundRedemption”:“0xe9bd233b2b34934fb83955ec15c2ac48f31a0e8c”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“30000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“10000000000”,“fundraisingEndTime”:“1855612800”,“fundraisingStartTime”:“1697538236”}}	2023-10-17T10:31:24.000Z	0x84d70c93f6a612f00917665fa4a67fdf50d32493c60219f60a30528596afbb1a
0x22799daa45209338b7f938edf251bdfd1e6dcb32	0x629ad7bc14726e9cea4fcb3a7b363d237bb5dbe8	false	0x0ef01fb59f931e3a3629255b04ce29f6cd428f674944789288a1264a79c7c931	5	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	156746474	{“vault”:“0x0d37f425cd5df98c5cde47f13a18b6c7f23e2ea2”,“currency”:“0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9”,“navOracle”:“0x6ec1fec6c6af53624733f671b490b8250ff251ed”,“valueDate”:“1701993600”,“managerInfo”:{“poolManager”:“0xca4bfa078340f0ef3c6b11c2c7e3b6cb3c534639”,“redeemNavManager”:“0x0d37f425cd5df98c5cde47f13a18b6c7f23e2ea2”,“subscribeNavManager”:“0x3eebfac5b51ff51c82f0856dad42750d581d7483”},“poolFeeInfo”:{“carryRate”:“2500”,“carryCollector”:“0x78cb3134758dbae79923c22b34c0343648492a23”,“latestProtocolFeeSettleTime”:“1701993600”},“poolSFTInfo”:{“openFundShare”:“0x22799daa45209338b7f938edf251bdfd1e6dcb32”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“17873186957027148109033339637575361280044016486300679380351688892728620516739”,“openFundRedemption”:“0xe9bd233b2b34934fb83955ec15c2ac48f31a0e8c”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“30000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1861574400”,“fundraisingStartTime”:“1701679930”}}	2023-12-04T08:59:40.000Z	0x4e533d6094a68defa065d93eb7faf1ac49f7119b4cd69802784c2917a7ec0e12
0x22799daa45209338b7f938edf251bdfd1e6dcb32	0x629ad7bc14726e9cea4fcb3a7b363d237bb5dbe8	false	0xa4af80753e210288a4d6fd68d9642568db68b10d5002964d04f39c1adf787891	18	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	150894084	{“vault”:“0x1139ab5e48740ab6577da7766bcdbc1c7711d6b7”,“currency”:“0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f”,“navOracle”:“0x6ec1fec6c6af53624733f671b490b8250ff251ed”,“valueDate”:“1700179200”,“managerInfo”:{“poolManager”:“0xca4bfa078340f0ef3c6b11c2c7e3b6cb3c534639”,“redeemNavManager”:“0x1139ab5e48740ab6577da7766bcdbc1c7711d6b7”,“subscribeNavManager”:“0x3eebfac5b51ff51c82f0856dad42750d581d7483”},“poolFeeInfo”:{“carryRate”:“2500”,“carryCollector”:“0x78cb3134758dbae79923c22b34c0343648492a23”,“latestProtocolFeeSettleTime”:“1700179200”},“poolSFTInfo”:{“openFundShare”:“0x22799daa45209338b7f938edf251bdfd1e6dcb32”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“18690844592665392806120500966565403107294568728373608746602125247992241422247”,“openFundRedemption”:“0xe9bd233b2b34934fb83955ec15c2ac48f31a0e8c”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“500000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1857945600”,“fundraisingStartTime”:“1700114628”}}	2023-11-16T06:08:44.000Z	0xebbd5d7ee03bb8c6c25e8ec676d1e35062e9973b55f92aaa747212bccd0a8080

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_arbitrum.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
1008400	0x629ad7bc14726e9cea4fcb3a7b363d237bb5dbe8	false	0xae291032246bd821d226b5debf26c52a7658c0bc	109083696945656485521	0xc573ea3cb55168e5ebe04b118c4b8a33ba62e86bbe1d1e735a447467795c3bd4	6	110000000	280	0xaf88d065e77c8cc2239327c5edb3a432268e5831	134093273	2023-09-24T09:12:14.000Z	0xd8249e02690d58fc1aa184ca604482aebde684b4656d94ce788c46e80c21581b
1000649348905797500	0x629ad7bc14726e9cea4fcb3a7b363d237bb5dbe8	false	0x92e8a4407fd1ae7a53a32f1f832184edf071080a	138751435626330	0x88b47de44e1954c8d5849c964ac424f6e636ca5b89f0eae4e47902bf5678841f	9	138841533719232	20919	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	369462399	2025-08-17T18:41:50.000Z	0xfc39c16465813a811d975e4b99e6d5ec4bfde4d7fc8d05847ca34e8b44683120
1000000	0x629ad7bc14726e9cea4fcb3a7b363d237bb5dbe8	false	0xc94fb917910d110b370edb6b78a7a623bc869571	1000000000000000000	0xc573ea3cb55168e5ebe04b118c4b8a33ba62e86bbe1d1e735a447467795c3bd4	6	1000000	78	0xaf88d065e77c8cc2239327c5edb3a432268e5831	117585283	2023-08-03T01:34:09.000Z	0x9ecfb93754000e445169df498b8333e7a6b319952ae4f2a00fbeb36c3f79ccd6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_arbitrum.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
0x836be4332347440995bc06103aa740adafc0068a	false	0x0e11a7249a1ca69c4ed42b0bfcc0e3d8f45de5e510c0d866132fdf078f3849df	171	0xafafd68afe3fe65d376eec9eab1802616cfaccb8	0x0099e3ea4f7aa9505be2c1c94149116b9856208b	281527822	2024-12-05T07:48:47.000Z	266780000000000000	4103	0x066a9f027bfbfd889b5f2eb39311573a81c75c457a812aa02b4a7c9d6bb5b8a9
0x836be4332347440995bc06103aa740adafc0068a	false	0xa1a41164e490bee159f8629380d0f52d82d852ba58c35528a0cc8779049416e8	29	0x346c574c56e1a4aaa8dc88cda8f7eb12b39947ab	0x997b96bad648c39226281bc002f9857274e42a01	288412950	2024-12-25T09:27:49.000Z	11000000000000000	4318	0x601c04a3e5f898dcc00fc5fdb7dc85511e077e700a79386ac690430c17174a70
0x836be4332347440995bc06103aa740adafc0068a	false	0xa1a41164e490bee159f8629380d0f52d82d852ba58c35528a0cc8779049416e8	28	0x346c574c56e1a4aaa8dc88cda8f7eb12b39947ab	0x8ec6aa8fcc0692b0949ed0bd307767320cfa27f8	288526738	2024-12-25T17:23:57.000Z	750000000000000	4325	0xf3cf8535849a49e4b3bb377c67f56c1f21b82f31260d3142c45d2b5f87a2ac1d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_arbitrum.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
0x836be4332347440995bc06103aa740adafc0068a	false	0x0e11a7249a1ca69c4ed42b0bfcc0e3d8f45de5e510c0d866132fdf078f3849df	18	0xafafd68afe3fe65d376eec9eab1802616cfaccb8	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	256239741	0x4b03af034512f9535084e44f3cba700e8efe12a2	2024-09-22T17:15:07.000Z	0x5b39f2b52c23962746ff296ffe36c1660ae95d2770b2a464e126c576b02683f3	258130000000000	257478579194637
0x836be4332347440995bc06103aa740adafc0068a	false	0xa1a41164e490bee159f8629380d0f52d82d852ba58c35528a0cc8779049416e8	18	0x346c574c56e1a4aaa8dc88cda8f7eb12b39947ab	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	256295293	0x12df4a71ac51e026393179d70d5645f74b0ffc47	2024-09-22T21:07:42.000Z	0x329e67471aa9379cf33dbdb0d58e1e4c93a84d90039b279e5ddc6869a9aec738	1000000000000000	1000000000000000
0x836be4332347440995bc06103aa740adafc0068a	false	0xa1a41164e490bee159f8629380d0f52d82d852ba58c35528a0cc8779049416e8	18	0x346c574c56e1a4aaa8dc88cda8f7eb12b39947ab	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	256192815	0xc0cdbcd0b24361df8a888e18d2a3cedd4cec948e	2024-09-22T13:58:38.000Z	0x557afe8ffab4c3ae6a13a1bb985e8891f6830fc4b4d3eb31b2dea5fa9ebb1f82	33698610000000000	33698610000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_arbitrum.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
0xe9ed7530427cb41a56c9e004e00e074ccc168c44	false	0x488def4a346b409d5d57985a160cd216d29d4f555e1b716df4e04e2374d2d9f6	22	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	0x5ba1ffb6bb31d760d662585559f85990120bbb34	300636473	2025-01-29T22:19:30.000Z	26000000000000	10513	0x9ab62238622697dfea983411708d5db407bd618784f3fd9e97a4fffd7eaf0ce2
0xe9ed7530427cb41a56c9e004e00e074ccc168c44	false	0x488def4a346b409d5d57985a160cd216d29d4f555e1b716df4e04e2374d2d9f6	22	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	0xcc9724fbbee0d5d3e14d850ecf169f32422a476d	300371431	2025-01-29T03:44:27.000Z	1631210588000000	10496	0x1e873a5990bc3c665c2341067b074e7ab1218dc81ed85d0aa867fb8939e7691f
0xe9ed7530427cb41a56c9e004e00e074ccc168c44	false	0x488def4a346b409d5d57985a160cd216d29d4f555e1b716df4e04e2374d2d9f6	22	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	0x0ad2dd47bbdb6323c543144df42516b58c0a8c4d	300356585	2025-01-29T02:40:24.000Z	2788556682851779	10495	0x3686404de25e6b2e260336330f7af96573aadd33df39ae37acc45eaa812618e3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_arbitrum.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
0xe9ed7530427cb41a56c9e004e00e074ccc168c44	false	0x488def4a346b409d5d57985a160cd216d29d4f555e1b716df4e04e2374d2d9f6	37	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	250896496	0x001198a08def2498cebe678b88b0529e5f91dac1	2024-09-07T03:27:52.000Z	0xb2202f18ee26831cd9c7a770facc44f3243503b7cdf37888475e9f351fd751a7	415462	4154620000000000
0xe9ed7530427cb41a56c9e004e00e074ccc168c44	false	0x488def4a346b409d5d57985a160cd216d29d4f555e1b716df4e04e2374d2d9f6	27	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	250872576	0x02abf4c974b50d0b5006bd8a7122da2226307110	2024-09-07T01:47:53.000Z	0x816b628c2309221a48d796dd19c9d2c901e6197d988eea9c66cb553ed7e56c89	70000	700000000000000
0xe9ed7530427cb41a56c9e004e00e074ccc168c44	false	0x488def4a346b409d5d57985a160cd216d29d4f555e1b716df4e04e2374d2d9f6	20	0x3647c54c4c2c65bc7a2d63c0da2809b399dbbdc0	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	251107295	0x05d156101f5031275279ff892326288cb32058c8	2024-09-07T18:10:25.000Z	0x41606d0d4a69fea127c31edbb33d4835993b3bec5afd589d075b6906b98dff08	295000	2950000000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

InitialConvertibleOfferingMarket_Traded_event

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​InitialConvertibleOfferingMarket_Traded_event

​OpenFundMarket_CreatePool_event

​OpenFundMarket_Subscribe_event

​SolvBTCLSTRouter_CreateRedemption_event

​SolvBTCLSTRouter_CreateSubscription_event

​SolvBTCRouter_CreateRedemption_event

​SolvBTCRouter_CreateSubscription_event

Tables

InitialConvertibleOfferingMarket_Traded_event

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event