Skip to main content

​
Tables

​
IssueMarket_Subscribe_event

Subscription events from Solv Protocol V3’s IssueMarket contract on Arbitrum, capturing semi-fungible token (SFT) purchases with buyer addresses, payment amounts, token IDs, and underwriter fees. Used for analyzing issuance activity and fee distribution in Solv’s tokenized asset marketplace.
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 subscription slot or tranche within the Solv Protocol SFT (Semi-Fungible Token) contract. Large integer value that categorizes different types or series of subscriptions available in the issue market.
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 for issuing the SFT (Semi-Fungible Token) in the subscription, 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, denominated in the payment currency’s smallest unit. Typically zero in most Solv Protocol subscriptions based on sample data.
in_sftaddressin_slotremovedin_buyerin_pricein_valuelog_indexin_paymentin_tokenIdin_currencyin_issueFeeblock_numberin_underwriterblock_timestamptransaction_hashin_underwriterFee
0x66e6b4c8aa1b8ca548cc4ebcd6f3a8c6f4f3d04d0xdde4b08e7f9bb7792f73438a8e1a29271e06ebf631347703608164904488310398163527252362875626235740646117139428796899810055835false0x560c244e82ca8f6d19d0889e2097acb220ce570510000009900000000000000000000279900000000290xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb90122591055Solv Protocol2023-08-18T12:09:24.000Z0x852eac8e96011da44b3d9d88de043bb9e92d4a0f07f9bbee717d1662fef94bbb0
0x66e6b4c8aa1b8ca548cc4ebcd6f3a8c6f4f3d04d0xdde4b08e7f9bb7792f73438a8e1a29271e06ebf631347703608164904488310398163527252362875626235740646117139428796899810055835false0x560c244e82ca8f6d19d0889e2097acb220ce5705100000010000000000000000000013100000000280xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb90122590740Solv Protocol2023-08-18T12:08:02.000Z0x62a89d73103d7c4561a92d9170b27afad0bee52a8c97d76d7ce63e15a385efb10
0x66e6b4c8aa1b8ca548cc4ebcd6f3a8c6f4f3d04d0xdde4b08e7f9bb7792f73438a8e1a29271e06ebf649470495201034116262485632843129956912775508672679478902443253586559117888383false0x560c244e82ca8f6d19d0889e2097acb220ce5705100000000100000000000000011100000260x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f0122589927Solv Protocol2023-08-18T12:04:38.000Z0xc6d3fae00bfd0ffefbd2110f6b6da5e2207a2f7f64ebc2f3f2a0ca758a7ad0580
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v3_arbitrum.IssueMarket_Subscribe_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100