solv_v1_avalanche

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
0x6b2e555b6c17bfbba251cc3cde084071f4a7ef38	0x59cf3db95bdf5c545877871c3863c9dbe6b0b7cf	false	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	19	0x152b9d0fdc40c096757f570a51e494bd4b943e50	48694929	{“vault”:“0x33b7a7a164b77433a61d4b49bd780a2718812e6e”,“currency”:“0x152b9d0fdc40c096757f570a51e494bd4b943e50”,“navOracle”:“0x1b4a98cd14f6d42975f1f10ef15551a818a5f2bf”,“valueDate”:“1723075200”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x2247cf2dce1093d501f7364b6ff99246dfa1259e”,“subscribeNavManager”:“0x2247cf2dce1093d501f7364b6ff99246dfa1259e”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x6590ef9c7cbdf30a1a49f93939ee3824d1ec21a4”,“latestProtocolFeeSettleTime”:“1723075200”},“poolSFTInfo”:{“openFundShare”:“0x6b2e555b6c17bfbba251cc3cde084071f4a7ef38”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“11855698383361531140241834848840694583099560042595010827827423787557845170628”,“openFundRedemption”:“0xd39015c678475a6423fac275b32cdf988175983b”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“10000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1880841600”,“fundraisingStartTime”:“1722484464”}}	2024-08-01T03:58:27.000Z	0x6a403e2e0d38006ac3a69cd442946aff89db1f45a57a922b4ee91c759a0ab7c0
0x29f870ed75b4632301946bb935433605f39d515e	0x59cf3db95bdf5c545877871c3863c9dbe6b0b7cf	false	0xfe32d4edc14725d9178a3dd19d5f17c94e33945adc6e0091dc67c126bdf30182	16	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	48987169	{“vault”:“0x3d13c5ff0f5fa3cdddcf226e733d3b9f990cd935”,“currency”:“0xbc78d84ba0c46dfe32cf2895a19939c86b81a777”,“navOracle”:“0x540a9dbba1ae6250253ba8793714492ee357ac1d”,“valueDate”:“1723680000”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x2247cf2dce1093d501f7364b6ff99246dfa1259e”,“subscribeNavManager”:“0x2247cf2dce1093d501f7364b6ff99246dfa1259e”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x6590ef9c7cbdf30a1a49f93939ee3824d1ec21a4”,“latestProtocolFeeSettleTime”:“1723680000”},“poolSFTInfo”:{“openFundShare”:“0x29f870ed75b4632301946bb935433605f39d515e”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“91416864602533104392592890824497157334485490509693941626320001937970957602493”,“openFundRedemption”:“0x10e42a1fd1aec5d330f4f8eca94b06cff264d02a”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1881360000”,“fundraisingStartTime”:“1723087720”}}	2024-08-08T03:34:27.000Z	0x1c9c0bd11644942206294b350afedbbc9c5ba93d9734515d253d017d8dfe34eb
0x29f870ed75b4632301946bb935433605f39d515e	0x59cf3db95bdf5c545877871c3863c9dbe6b0b7cf	false	0x83933f7cabce9efa8ed17c7f601dba81cfa49f0dabaf2885bf1624719bf78443	5	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	59635012	{“vault”:“0x439fe7c5df1515508e717aed75b4371537c3ab7d”,“currency”:“0xbc78d84ba0c46dfe32cf2895a19939c86b81a777”,“navOracle”:“0x540a9dbba1ae6250253ba8793714492ee357ac1d”,“valueDate”:“1744416000”,“managerInfo”:{“poolManager”:“0x2e51f039fc2de139af3d5a4bd6898d67c3442bb0”,“redeemNavManager”:“0x2247cf2dce1093d501f7364b6ff99246dfa1259e”,“subscribeNavManager”:“0x2247cf2dce1093d501f7364b6ff99246dfa1259e”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x6590ef9c7cbdf30a1a49f93939ee3824d1ec21a4”,“latestProtocolFeeSettleTime”:“1744416000”},“poolSFTInfo”:{“openFundShare”:“0x29f870ed75b4632301946bb935433605f39d515e”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“86753098298693272234281896498673541742160926213380072723269693569823891599359”,“openFundRedemption”:“0x10e42a1fd1aec5d330f4f8eca94b06cff264d02a”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1998259200”,“fundraisingStartTime”:“1743608565”}}	2025-04-03T02:12:29.000Z	0xdb40da969b9fb5c19521fd0f935af9d857899d93c6e32f1597dc5b0d6878e96a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_avalanche.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
100000000	0x59cf3db95bdf5c545877871c3863c9dbe6b0b7cf	false	0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	2000000000000000000	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	13	200000000	124	0x152b9d0fdc40c096757f570a51e494bd4b943e50	51241175	2024-10-01T20:03:50.000Z	0x002787f237fea8b0bc689668f4f7c84dd3c0a105d320a54daeffde82339fcb08
100000000	0x59cf3db95bdf5c545877871c3863c9dbe6b0b7cf	false	0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	8812660000000000	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	31	881266	805	0x152b9d0fdc40c096757f570a51e494bd4b943e50	63689204	2025-06-11T15:04:03.000Z	0x0da15cd378054c913a840f179576d1d8e854810a2142463702b734629538d3c4
100000000	0x59cf3db95bdf5c545877871c3863c9dbe6b0b7cf	false	0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	728710000000000	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	103	72871	806	0x152b9d0fdc40c096757f570a51e494bd4b943e50	63690261	2025-06-11T15:32:56.000Z	0xabe30957fd63350c4155c02dfa169849e38a6ba876ec16d5be6041bbe507109a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_avalanche.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
0x2181e83ba95df14fa339f0f854a706e7d289f78a	false	0xfe32d4edc14725d9178a3dd19d5f17c94e33945adc6e0091dc67c126bdf30182	36	0xcc0966d8418d412c599a6421b760a847eb169a8c	0xb3fd923ac79aebf7fc11563fad9ddbdd8914783a	55045983	2024-12-29T13:30:22.000Z	45325310790616	9	0xc396945cabbbabd701f56cbf5cba409b1654d871bad7fdf63d96f12f1b9702c6
0x2181e83ba95df14fa339f0f854a706e7d289f78a	false	0xfe32d4edc14725d9178a3dd19d5f17c94e33945adc6e0091dc67c126bdf30182	22	0xcc0966d8418d412c599a6421b760a847eb169a8c	0xd8de34b4540b9c5e4ac1499aa47175c8a2062ab4	55166466	2025-01-01T03:48:11.000Z	220000389845050085	11	0x49de32b65a81f0de29554b467ca3d60543181252c0258d8ca2978ed90a6dffcd
0x2181e83ba95df14fa339f0f854a706e7d289f78a	false	0xfe32d4edc14725d9178a3dd19d5f17c94e33945adc6e0091dc67c126bdf30182	25	0xcc0966d8418d412c599a6421b760a847eb169a8c	0x42c4131b3c71ca4e5bded440af0ba86677e2f58d	55086448	2024-12-30T10:36:26.000Z	830904851922334538	10	0xaea524f25c24ca5ad967d1657a727c6a027648cb1530690e4b832d3a0b01ce75

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_avalanche.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
0x2181e83ba95df14fa339f0f854a706e7d289f78a	false	0xfe32d4edc14725d9178a3dd19d5f17c94e33945adc6e0091dc67c126bdf30182	18	0xcc0966d8418d412c599a6421b760a847eb169a8c	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	53216677	0xa4dd88a913df59b924c8cc137d37d63b9252078e	2024-11-18T02:42:57.000Z	0x28a13e97f872a8540c57ad3c355b17711929ddc8acc81da9c12c5df0f9d65328	313105080527253	313105080527253
0x2181e83ba95df14fa339f0f854a706e7d289f78a	false	0xfe32d4edc14725d9178a3dd19d5f17c94e33945adc6e0091dc67c126bdf30182	18	0xcc0966d8418d412c599a6421b760a847eb169a8c	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	55166867	0xa6861734e12e45e3b3a1dfc3d06d1bc5d3c34589	2025-01-01T04:01:15.000Z	0x93a92f0c63dfaa3782e1409902513f01e54e09c7defda68ad090c85e9ca21724	76060000000000	76060000000000
0x2181e83ba95df14fa339f0f854a706e7d289f78a	false	0xfe32d4edc14725d9178a3dd19d5f17c94e33945adc6e0091dc67c126bdf30182	20	0xcc0966d8418d412c599a6421b760a847eb169a8c	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	55179605	0xa34ff97e3a06c212556aea209ae0089370d615f2	2025-01-01T11:13:34.000Z	0x45dc49aaa65d2508a8573391de9dd71da975c83f265b380d1bebcc40c7cfce50	289677112678137	289677112678137

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_avalanche.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
0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	false	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	35	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	0x04000848c9a371c018be34f977a6150cedd156a9	50089962	2024-09-04T00:52:45.000Z	2550000000000000	2	0xdefaf55d4a3266b29570087198c10aca63aa0ed42329013338b3feffc1bbd7f7
0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	false	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	22	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	0xdb70eed3578f12929eae82e0f13e51ca01216789	56829101	2025-02-04T16:14:52.000Z	154091200000000	155	0x95a0c4b50c316e6cf168aefe29b3c8eba3a9839892507edbd477531d91b246bb
0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	false	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	26	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	0xe386ab1c896f09a70d000e27ec99315735d98627	52954319	2024-11-11T22:47:17.000Z	1132164688648774589	66	0x88a1c9df85997e9bb09eb490e9f13ab2bd707aa3c2800333b530f7dfe3fa87a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_avalanche.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
0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	false	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	20	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	0x152b9d0fdc40c096757f570a51e494bd4b943e50	51150505	0x6132221fd7067f70a48391db495ae1eead4f5514	2024-09-29T16:02:46.000Z	0xace64d444aed22da9920409d90455a0ae337d466d9f51c1773d704cf6a9b84fd	720000	7200000000000000
0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	false	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	20	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	0x152b9d0fdc40c096757f570a51e494bd4b943e50	51157832	0x279b7d51e0348ccf6580190ac64976096a44b274	2024-09-29T20:14:42.000Z	0xb0f117e9a3c6251af1221e72d95b3f0eecf550a51ec207db75fc1a41b7007ad6	442864	4428640000000000
0x5b60f7e24ac48c1146d1aedb6a72b62c83378730	false	0xf5ae38da3319d22b4628e635f6fa60bf966de13c5334b6845eba764d6321e16b	20	0xbc78d84ba0c46dfe32cf2895a19939c86b81a777	0x152b9d0fdc40c096757f570a51e494bd4b943e50	51140637	0xf2e9fec0f136c9e8992257855554c221856f769f	2024-09-29T10:23:35.000Z	0x708d8d626137657111babab6663ddef8cf7313b4779adb594915d59ce4614683	1000	10000000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​OpenFundMarket_CreatePool_event

​OpenFundMarket_Subscribe_event

​SolvBTCLSTRouter_CreateRedemption_event

​SolvBTCLSTRouter_CreateSubscription_event

​SolvBTCRouter_CreateRedemption_event

​SolvBTCRouter_CreateSubscription_event

Tables

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event