Skip to main content

​
Tables

​
IssueMarket_Subscribe_event

Subscribe events from Solv Protocol v3 on Ethereum capturing purchases of Semi-Fungible Tokens (SFTs) with buyer address, payment amount, currency, price, and underwriter fee details. Used for analyzing tokenized product subscriptions and primary market activity.
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_slotSTRINGIdentifier for the subscription slot in the Solv Protocol semi-fungible token (SFT) system. Large integer value uniquely representing the product offering or voucher type being purchased.
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 collected at token issuance, denominated in the same currency as the payment. Typically zero in Solv Protocol v3 subscriptions based on sample data.
in_underwriterFeeSTRINGFee paid to the underwriter for facilitating the token subscription, denominated in the payment currency’s base units. Typically zero in Solv Protocol subscriptions as shown in sample data.
in_sftaddressin_slotremovedin_buyerin_pricein_valuelog_indexin_paymentin_tokenIdin_currencyin_issueFeeblock_numberin_underwriterblock_timestamptransaction_hashin_underwriterFee
0xc4341c6e7df9db26a58e6ec3c53b937bdff06d650xdde4b08e7f9bb7792f73438a8e1a29271e06ebf639808713482099886438435603507726299213020305295353661129457152178384235468544false0x1d62daf9487c90c5bdea722a577d8c9a46f9e9ce1000000125000000000000000000001931250000000020xdac17f958d2ee523a2206206994597c13d831ec7017109445Solv Protocol2023-04-23T13:55:47.000Z0xea780dcffc14c28f363ddefb1564f713c4f95e6bd4696c32a2060d149355624d0
0xc4341c6e7df9db26a58e6ec3c53b937bdff06d650xdde4b08e7f9bb7792f73438a8e1a29271e06ebf639808713482099886438435603507726299213020305295353661129457152178384235468544false0xd7f4a04c736cc1c5857231417e6cb8da9cadbec710000002500000000000000000000166250000000030xdac17f958d2ee523a2206206994597c13d831ec7017109489Solv Protocol2023-04-23T14:04:35.000Z0x420da8bd40c7ad08128e702bee56f6da62053af43444223c3afab67418bc82680
0xc9a8d31465a1d4bd9b95e0e80016f7b23f992ebf0xdde4b08e7f9bb7792f73438a8e1a29271e06ebf665794622574488968363390264008371408447638611371533497606729373766222589545859false0xaf40e5625ec2dbbb3d2650affae4571498297ed2100000014990000000000000000000014514990000000020xdac17f958d2ee523a2206206994597c13d831ec7017143285Solv Protocol2023-04-28T07:57:23.000Z0x1a24be3fe5d055c4560df68291bb718ebb67eb527d18bb4d7a80957c2ce47aa00
Query with partition filter
SELECT *
FROM `tt-contracts.solv_v3_ethereum.IssueMarket_Subscribe_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100