solv_v1_bsc

Tables

InitialBondOfferingMarket_Traded_event

Trade execution events from Solv Protocol’s Initial Bond Offering (IBO) marketplace contracts, recording buyer purchases of bond vouchers with payment currency, pricing details, and associated fees.

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
3999999999999999999	0xd22a4d7a691e56c8a4ebb2844fa0b80c54a5eb1a	false	0xbb3480f389ba128eb8fd356f306d87f77a4464d5	985221674876847290	265	18	0x2f030b1cea9746fbba4fa43fcdcdbdde1077ccbc	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	20540656	1660800574	11	8	1015000000000000000659750000000	2022-08-18T05:29:34.000Z	9999999999999999999999	0x260ba7c852842d1bde1112640d6d08bcf9f1ce6aef78da42aa6211ddf0539e94
524742111817088644	0xd22a4d7a691e56c8a4ebb2844fa0b80c54a5eb1a	false	0xafb3116ce35db24b4163e0bb3da0252240434f56	985221674876847290	101	16	0x2f030b1cea9746fbba4fa43fcdcdbdde1077ccbc	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	20539133	1660796005	9	8	133153310873586243676333000000	2022-08-18T04:13:25.000Z	1311855279542721611722	0x7596a489e62c27d8db9baeceb909e80634d08bbd0b385622cdf6dd9bd8b625c9
3199999999999999999	0xd22a4d7a691e56c8a4ebb2844fa0b80c54a5eb1a	false	0x48b742b9d935fdaeade1a48cd7c5e4aec4360b0c	985221674876847290	184	17	0x2f030b1cea9746fbba4fa43fcdcdbdde1077ccbc	0x0e09fabb73bd3ade0a17ecc321fd13a19e81ce82	20540105	1660798921	10	8	812000000000000000527800000000	2022-08-18T05:02:01.000Z	7999999999999999999999	0x7616fbfebdad294ea94544e696b0dce800d990abdd0e2466ef624b6267b39f32

Example Query

Query with partition filter

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

InitialVestingOfferingMarket_Traded_event

Traded events from Solv Protocol’s Initial Vesting Offering (IVO) marketplace capturing purchase transactions where buyers acquire vesting voucher tokens with payment currency. Records buyer address, offering identifier, trade units and amount, price and fee details, and voucher NFT issuance for tracking IVO marketplace activity.

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
1235999999999999999	0xba21023cd7d193f2b980fac8018f228c1f340b21	false	0x6b26e36191a5c008a61ed4aaabd6c24ff73405db	266000000000000000	109	1544	0xf6ee76141e5964f5ff2831c3cb39a90f1541794a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17077739	1650360421	430	14	387218045112781954887	2022-04-19T09:27:01.000Z	102999999999999999999	0x227c40c3651bdefd38536da025e7b9bc6c2b0026e470d35dd8fc22f968385bba
35112000000000000	0xba21023cd7d193f2b980fac8018f228c1f340b21	false	0x1de8355da82cfb8d2453a5ec3fc4c871281ab4bc	266000000000000000	755	1545	0xf6ee76141e5964f5ff2831c3cb39a90f1541794a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17081299	1650371149	431	14	11000000000000000000	2022-04-19T12:25:49.000Z	2926000000000000000	0xd19e109a5402c70722c9c4685bf2d24c49dd2363e487fefcf33f62c4bb74dae0
319200000000000000	0xba21023cd7d193f2b980fac8018f228c1f340b21	false	0x48fad5dc84caf07989ce5bb5827c139eb84194e0	266000000000000000	163	1543	0xf6ee76141e5964f5ff2831c3cb39a90f1541794a	0xe9e7cea3dedca5984780bafc599bd69add087d56	17067117	1650328424	429	14	100000000000000000000	2022-04-19T00:33:44.000Z	26600000000000000000	0x19c0c54c25e33cf64a82f5289169fd84fd24f4883fcb3313e3ec4433c7e507d1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_bsc.InitialVestingOfferingMarket_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
0xb816018e5d421e8b809a4dc01af179d86056ebdf	0xae050694c137ad777611286c316e5fdda58242f3	false	0xfb479486b8b4aefd5166608f8c17dc7d8cf3a44dd37c25879645dfc130e13f44	246	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	39195736	{“vault”:“0x37059ebb0b92fcd04caee6eb84542148109b8a30”,“currency”:“0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7”,“navOracle”:“0x9c491539aec346aafeb0bee9a1e9d9c02ab50889”,“valueDate”:“1718323200”,“managerInfo”:{“poolManager”:“0xf8616d9e202f662b5c0c4cf40ec9ae39170948cd”,“redeemNavManager”:“0x411573f437255851d3cb2a68664a4aa0d4066843”,“subscribeNavManager”:“0x411573f437255851d3cb2a68664a4aa0d4066843”},“poolFeeInfo”:{“carryRate”:“0”,“carryCollector”:“0x58b48d7dfb3c53a36bcf201e81fb835b6599953c”,“latestProtocolFeeSettleTime”:“1718323200”},“poolSFTInfo”:{“openFundShare”:“0xb816018e5d421e8b809a4dc01af179d86056ebdf”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“4633189612622459891976663503173569429834624325334409729937663418632334315353”,“openFundRedemption”:“0xe16cec2f385ea7a382772334a44506a865f98562”},“permissionless”:false,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1876089600”,“fundraisingStartTime”:“1717135574”}}	2024-05-31T06:09:24.000Z	0xbccd5ec1e94ec183955049e4e2266a08e94da6b0ee766e1dc4febcc9b9cd03e2
0xb816018e5d421e8b809a4dc01af179d86056ebdf	0xae050694c137ad777611286c316e5fdda58242f3	false	0x581324ed7cba2eab01ee5c5e3b3e357289c53e1c22c06ceb10e300293e5cdb60	101	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	38829786	{“vault”:“0xb657629afcdf64b87fc0355ae4c93f490f238e14”,“currency”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“navOracle”:“0x9c491539aec346aafeb0bee9a1e9d9c02ab50889”,“valueDate”:“1716595200”,“managerInfo”:{“poolManager”:“0xca4bfa078340f0ef3c6b11c2c7e3b6cb3c534639”,“redeemNavManager”:“0x411573f437255851d3cb2a68664a4aa0d4066843”,“subscribeNavManager”:“0x411573f437255851d3cb2a68664a4aa0d4066843”},“poolFeeInfo”:{“carryRate”:“3000”,“carryCollector”:“0x58b48d7dfb3c53a36bcf201e81fb835b6599953c”,“latestProtocolFeeSettleTime”:“1716595200”},“poolSFTInfo”:{“openFundShare”:“0xb816018e5d421e8b809a4dc01af179d86056ebdf”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“81333699482498011094463575553019077506742870073748713033543385814471338314821”,“openFundRedemption”:“0xe16cec2f385ea7a382772334a44506a865f98562”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1874361600”,“fundraisingStartTime”:“1716026400”}}	2024-05-18T12:24:30.000Z	0x8db2542a4dd14161ec13207066080b0496f2d16ce6a2270f03120b8ffdc28c97
0xb816018e5d421e8b809a4dc01af179d86056ebdf	0xae050694c137ad777611286c316e5fdda58242f3	false	0xef1a10327aa5ed6c70af4fe28178cd4cece1c08e1e5bc0314137feda1f5abf74	199	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	38829875	{“vault”:“0xb657629afcdf64b87fc0355ae4c93f490f238e14”,“currency”:“0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c”,“navOracle”:“0x9c491539aec346aafeb0bee9a1e9d9c02ab50889”,“valueDate”:“1716595200”,“managerInfo”:{“poolManager”:“0xca4bfa078340f0ef3c6b11c2c7e3b6cb3c534639”,“redeemNavManager”:“0xca4bfa078340f0ef3c6b11c2c7e3b6cb3c534639”,“subscribeNavManager”:“0xca4bfa078340f0ef3c6b11c2c7e3b6cb3c534639”},“poolFeeInfo”:{“carryRate”:“3000”,“carryCollector”:“0x58b48d7dfb3c53a36bcf201e81fb835b6599953c”,“latestProtocolFeeSettleTime”:“1716595200”},“poolSFTInfo”:{“openFundShare”:“0xb816018e5d421e8b809a4dc01af179d86056ebdf”,“latestRedeemSlot”:“0”,“openFundShareSlot”:“67766898239605156258501380852207923193619740467985810194663587771723472117631”,“openFundRedemption”:“0xe16cec2f385ea7a382772334a44506a865f98562”},“permissionless”:true,“fundraisingAmount”:“0”,“subscribeLimitInfo”:{“hardCap”:“100000000000000000000”,“subscribeMax”:“115792089237316195423570985008687907853269984665640564039457584007913129639935”,“subscribeMin”:“0”,“fundraisingEndTime”:“1874361600”,“fundraisingStartTime”:“1716112800”}}	2024-05-18T12:29:00.000Z	0x2bf1639471db8f5625394e1010cd98fac86f1de16dd4eb0287b6b5ddcf81a19c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_bsc.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
996883823863152654	0xae050694c137ad777611286c316e5fdda58242f3	false	0xa83376174f44b06536b0f0ddba6da6f7e8fd3167	718238156604183	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	19	716000000000000	974	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	38150065	2024-04-24T20:51:43.000Z	0x0818f3e437ccb4388562e4bf6da2178724e6730fa3543fa41c055a9c5ab933fa
996883823863152654	0xae050694c137ad777611286c316e5fdda58242f3	false	0xa83376174f44b06536b0f0ddba6da6f7e8fd3167	30082743126260962	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	24	29989000000000000	910	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	38131761	2024-04-24T05:35:23.000Z	0xa34a3a7416a4dac9ef8600f9a836e1f573a425f04f1c8664f13c9a715d1f93f3
996883823863152654	0xae050694c137ad777611286c316e5fdda58242f3	false	0xa83376174f44b06536b0f0ddba6da6f7e8fd3167	5015629585224742895	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	33	5000000000000000000	982	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	38153199	2024-04-24T23:28:44.000Z	0x9968bf8240e662b73925aadd7fce50687143e6b972866a6ed59a959e8b59b3eb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_bsc.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
0x8ec6ef69a423045cea97d2bd0d768d042a130aa7	false	0x4d4a6c1ec2386c5149c520a3c278dec0044bdac5798cfbb63ce224227b9899c5	103	0x53e63a31fd1077f949204b94f431bcab98f72bce	0x3542a87d17246a98d0bedc9aee2a92c81601bfb1	44142701	2024-11-19T09:34:07.000Z	1016868485904086227	669	0x5f55a56a23cb83e6b144bdd570e5ac81948f2b1cb0710cddcd57a96c8e752ed4
0x8ec6ef69a423045cea97d2bd0d768d042a130aa7	false	0x6fe7f2753798616f555389f971dae58b32e181fab8b1d60d35e5ddafbb6bb5b7	119	0x1346b618dc92810ec74163e4c27004c921d446a5	0x86da280b48569c3d478f604f3cdad62c37aa8f85	45424795	2025-01-02T22:05:47.000Z	10000000000000	1770	0x3e1084d15bbd2255068a100ea6dc70b3eca4b8f97c11ed6e4969cb63a44ef791
0x8ec6ef69a423045cea97d2bd0d768d042a130aa7	false	0x6fe7f2753798616f555389f971dae58b32e181fab8b1d60d35e5ddafbb6bb5b7	369	0x1346b618dc92810ec74163e4c27004c921d446a5	0x0b35c187e7d300f1148817a841f761e16e77b582	45404006	2025-01-02T04:46:19.000Z	100000000000000	1726	0x8c4b5388616b709c7e2945d7d4c2716724ba27bad0272e5c110a7dc291e915cd

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_bsc.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
0x8ec6ef69a423045cea97d2bd0d768d042a130aa7	false	0x6fe7f2753798616f555389f971dae58b32e181fab8b1d60d35e5ddafbb6bb5b7	139	0x1346b618dc92810ec74163e4c27004c921d446a5	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	41490703	0x6bb47e808940410cc4f456963bfcf519aa62ddd2	2024-08-19T04:53:13.000Z	0x63e9c555efc94fe422bec4b433e15f89ee91e82390348239694ae1855fddd692	100000000000000	100000000000000
0x8ec6ef69a423045cea97d2bd0d768d042a130aa7	false	0x6fe7f2753798616f555389f971dae58b32e181fab8b1d60d35e5ddafbb6bb5b7	132	0x1346b618dc92810ec74163e4c27004c921d446a5	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	41504142	0x076d4cdd0ae21f77018a844780d7f743c6dcceba	2024-08-19T16:07:02.000Z	0x8624587e20df9f900c0f94486543748b7b69b12a1b069041a2aa068943070c2e	10000000000000000	10000000000000000
0x8ec6ef69a423045cea97d2bd0d768d042a130aa7	false	0x6fe7f2753798616f555389f971dae58b32e181fab8b1d60d35e5ddafbb6bb5b7	195	0x1346b618dc92810ec74163e4c27004c921d446a5	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	41504140	0xe37e1d0e5d4be66ab1d56ceefbfaff8b6063e9ca	2024-08-19T16:06:56.000Z	0xa20a09b4b3e3eadca03dd47723def830a8e2c40fd60fed68ad42b01f4acfd241	10000000000000000	10000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_bsc.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
0x5c1215712f174df2cbc653edce8b53fa4caf2201	false	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	167	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	0xac2781bcee4573d5b605a7ee7afc34cd5e8aa0ac	43223416	2024-10-18T11:15:44.000Z	100000000000000	13163	0xc5a96970f5a4f78627ac870c885961c420986721c5b8cd658f85409411f43570
0x5c1215712f174df2cbc653edce8b53fa4caf2201	false	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	73	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	0xcde03566d2d324bc2fe22581e4d9506779e1e451	43234041	2024-10-18T20:07:08.000Z	100000000000000	13172	0xef19cf7b86a8ff4681b9a5bc34d42cba50e5edad262c3a4d0764085e2fcb84f7
0x5c1215712f174df2cbc653edce8b53fa4caf2201	false	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	415	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	0x1454baa9f390eebe99e30d4f62453c2e1f27591a	43218593	2024-10-18T07:14:35.000Z	100000000000000	13152	0xa53a2a1a4ce25c6c2ee60e6a20bdd293f50690ed56ca7986ed5d8eb30b7437f9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.solv_v1_bsc.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
0x5c1215712f174df2cbc653edce8b53fa4caf2201	false	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	258	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	43659648	0x20479d2ed614c49375cce290015d7b3102e38cdb	2024-11-02T14:48:39.000Z	0x64f506be06b8c67e20e99a600091cd8abe58a0c98952375df3181d0fa74f5782	10000000000000000	10000000000000000
0x5c1215712f174df2cbc653edce8b53fa4caf2201	false	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	72	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	43658309	0x20479d2ed614c49375cce290015d7b3102e38cdb	2024-11-02T13:41:42.000Z	0x838f4df2f940ef758ac16fcd633abfc333862e0e1c529274bba136fb809845f8	10000000000000000	10000000000000000
0x5c1215712f174df2cbc653edce8b53fa4caf2201	false	0xafb1107b43875eb79f72e3e896933d4f96707451c3d5c32741e8e05410b321d8	99	0x4aae823a6a0b376de6a78e74ecc5b079d38cbcf7	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	43646554	0xc729589ead6cca32ef4356bdf9d3c11c5f873050	2024-11-02T03:53:57.000Z	0x0b60067e5ce9ba1dff2bc2ec1f463fd85771aa3ce186fdca17c1de13580ba060	100000000000000000	100000000000000000

Example Query

Query with partition filter

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

SolvICMarket_Traded_event

Trade execution events from Solv Protocol’s Initial Convertible (IC) marketplace contract containing buyer address, token identifiers, traded units and amounts, price, fees, and execution timestamp. Primary source for tracking IC token secondary market activity and price discovery.

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_saleId`	`STRING`	Unique identifier for the sale listing or offering within the marketplace contract. Numeric string representation.
`in_icToken`	`STRING`	Contract address of the initial coin offering token being traded. 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_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_feePayType`	`INT64`	Enumerated identifier indicating the payment method for the transaction fee. Integer value representing whether the fee is paid in the trade currency, the traded asset, or another specified 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	in_saleId	log_index	in_icToken	in_tokenId	in_tradeId	in_currency	block_number	in_tradeTime	in_tradedUnits	block_timestamp	in_tradedAmount	transaction_hash
19350000000000000	0x758ae0c48ff013d18b3d63ca79408e70a977d496	false	0xf3239400cd2135cf5f99e191018eeb2a6d01eb76	2150000000000000000	5073	225	0xfed93e410a6a45bc045bc91deaae1fd642e4af7a	11863	16237	0xe9e7cea3dedca5984780bafc599bd69add087d56	20513539	1660719169	600000000000000000	2022-08-17T06:52:49.000Z	1290000000000000000	0x00d88c485cfd8db92e596396f685469e22cea98a8cb37b625140d5e93fdb55d2
342000000000000000	0x758ae0c48ff013d18b3d63ca79408e70a977d496	false	0xc41e5e7804cf89755ece46f60346280a9a932239	2280000000000000000	5676	93	0xfed93e410a6a45bc045bc91deaae1fd642e4af7a	5510	17832	0x55d398326f99059ff775485246999027b3197955	27280356	1681293684	10000000000000000000	2023-04-12T10:01:24.000Z	22800000000000000000	0x8d4882fa4b06989c8db85c584fb47fcaa2d0fcd4e213513831fe6305595eeddd
1094400000000000000	0x758ae0c48ff013d18b3d63ca79408e70a977d496	false	0xc41e5e7804cf89755ece46f60346280a9a932239	2280000000000000000	5676	236	0xfed93e410a6a45bc045bc91deaae1fd642e4af7a	5510	17833	0x55d398326f99059ff775485246999027b3197955	27286448	1681312008	32000000000000000000	2023-04-12T15:06:48.000Z	72960000000000000000	0xa0d3fe0339d4477399e990c4132b8de45f191a67cc4e7beaf7bf591220c8e34a

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

InitialBondOfferingMarket_Traded_event

InitialVestingOfferingMarket_Traded_event

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event

SolvICMarket_Traded_event

​Tables

​InitialBondOfferingMarket_Traded_event

​InitialVestingOfferingMarket_Traded_event

​OpenFundMarket_CreatePool_event

​OpenFundMarket_Subscribe_event

​SolvBTCLSTRouter_CreateRedemption_event

​SolvBTCLSTRouter_CreateSubscription_event

​SolvBTCRouter_CreateRedemption_event

​SolvBTCRouter_CreateSubscription_event

​SolvICMarket_Traded_event

Tables

InitialBondOfferingMarket_Traded_event

InitialVestingOfferingMarket_Traded_event

OpenFundMarket_CreatePool_event

OpenFundMarket_Subscribe_event

SolvBTCLSTRouter_CreateRedemption_event

SolvBTCLSTRouter_CreateSubscription_event

SolvBTCRouter_CreateRedemption_event

SolvBTCRouter_CreateSubscription_event

SolvICMarket_Traded_event