Skip to main content

​
Tables

​
IssueMarket_Subscribe_event

Subscription events from Solv Protocol V3 on BSC (BNB Chain) where buyers purchase semi-fungible token (SFT) vouchers, recording tokenId, slot identifiers, payment amounts in stablecoins (USDT/USDC), and associated fees. Used for tracking voucher issuance activity and primary market purchases in Solv’s structured product offerings.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_sftSTRINGContract address of the Semi-Fungible Token (SFT) in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_slotSTRINGUnique identifier for the specific slot being subscribed to within the Solv Protocol’s semi-fungible token (SFT) structure. Represented as a large integer that designates a distinct investment position or token variant.
in_buyerSTRINGAddress of the account purchasing tokens or assets in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenIdSTRINGUnique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.
in_underwriterSTRINGAddress of the underwriter who provided liquidity or backstopped the position. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_currencySTRINGContract address of the currency token used in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_priceSTRINGPrice of the asset or position in the transaction or event. Numeric string representation in smallest denomination or with extended precision.
in_paymentSTRINGAmount paid by the buyer in the transaction. Numeric string representation in smallest token denomination.
in_issueFeeSTRINGFee charged by the platform for issuing the SFT (Semi-Fungible Token), denominated in the smallest unit of the payment currency. Typically zero in sample transactions, indicating no platform issuance fee was applied.
in_underwriterFeeSTRINGFee paid to the underwriter for facilitating the subscription transaction, denominated in the payment currency’s smallest unit. Always zero in sample data, suggesting fee-free issuances or promotional periods.
in_sftaddressin_slotremovedin_buyerin_pricein_valuelog_indexin_paymentin_tokenIdin_currencyin_issueFeeblock_numberin_underwriterblock_timestamptransaction_hashin_underwriterFee
0x66e6b4c8aa1b8ca548cc4ebcd6f3a8c6f4f3d04d0x443e5e0434e51db27717db447af2631f0355e7f869241537919702150613154853432198648266613125456743547434186129513768164173327false0x42b643bd0998e74c0159ee1479b849665b36a17d10000000000000000003000000000000000000003083000000000000000000001020x55d398326f99059ff775485246999027b3197955028548130Solv Protocol2023-05-26T12:27:12.000Z0x7330c387f42a204a277f4a8bb44d62fd102ffe5db2a3041a5567e1649e58020b0
0x66e6b4c8aa1b8ca548cc4ebcd6f3a8c6f4f3d04d0x443e5e0434e51db27717db447af2631f0355e7f811712844170045366482607359415119875785648939583364185631214445672283769211136false0x6f137867480c2e434f8fa82a84ee448c2d4d73bc1000000000000000000100000000000000000000021810000000000000000000001320x55d398326f99059ff775485246999027b3197955028766047Solv Protocol2023-06-03T02:24:35.000Z0x3bd74047c74a55ad4ff33e6721cda644b3fc5e64f853cf00a839c05664b4abc20
0x66e6b4c8aa1b8ca548cc4ebcd6f3a8c6f4f3d04d0x443e5e0434e51db27717db447af2631f0355e7f821290088092669844216867669734865853998396149251393550032649472336683160587966false0xcca5800477b7b6019a91a5e367e92f0e0b3d5ca010000000000000000008909500000000000000001968909500000000000000002030x55d398326f99059ff775485246999027b3197955029352046Solv Protocol2023-06-23T12:02:35.000Z0xad2b35344dce5b5865faf206b0f1c64c8e62dee244df5dfb6968688b8d899fa70
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v3_bsc.IssueMarket_Subscribe_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100