setprotocol_v2_ethereum

Tables

BasicIssuanceModule_SetTokenIssued_event

SetToken minting events from Set Protocol v2’s BasicIssuanceModule on Ethereum, recording when users issue (create) new Set tokens by depositing underlying components. Used for tracking Set token supply changes, minting activity, and composition rebalancing patterns.

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__setToken`	`STRING`	Contract address of the Set token being issued or redeemed. Hex-encoded, 0x-prefixed, 42-character string.
`in__issuer`	`STRING`	Address of the account that initiated the issuance of Set Protocol tokens through the BasicIssuanceModule. This is typically the same as the recipient (in__to) for self-issuances or a contract address for programmatic minting.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__hookContract`	`STRING`	Contract address of an optional hook executed during the issuance process. Commonly set to the zero address (0x00…00) when no pre-issuance hook is configured.
`in__quantity`	`STRING`	Amount of Set tokens being issued or redeemed in the transaction. Numeric string representation in smallest token unit (wei).

Sample Data

in__to	address	removed	log_index	in__issuer	block_number	in__quantity	in__setToken	block_timestamp	in__hookContract	transaction_hash
0x43dea97e75237ba81bc806c7047b48321f19ab9d	0xd8ef3cace8b4907117a45b0b125c68560532f94d	false	127	0x43dea97e75237ba81bc806c7047b48321f19ab9d	14547846	198486322001224333100	0x0acc0fee1d86d2cd5af372615bf59b298d50cd69	2022-04-08T22:41:28.000Z	0x0000000000000000000000000000000000000000	0x6652f4fd48522413612b0eaea94a8c1aef967f4f727369abfed7f74e55f8a6b1
0xcd979a9219db9a353e29981042a509f2e7074d8b	0xd8ef3cace8b4907117a45b0b125c68560532f94d	false	419	0xcd979a9219db9a353e29981042a509f2e7074d8b	14545287	11384699757631409222	0x109d2034e97ec88f50beebc778b5a5650f98c124	2022-04-08T13:06:09.000Z	0x0000000000000000000000000000000000000000	0xe178f7008609daca90f6f462eced7ec5e367ada5998e7c4aa93f7996af1041fe
0x208226200b45b82212b814f49efa643980a7bdd1	0xd8ef3cace8b4907117a45b0b125c68560532f94d	false	62	0xde2f79510e13ba79224bb86ed7bc1da90a9ecb75	14547859	175000000000000000000	0x33d63ba1e57e54779f7ddaeaa7109349344cf5f1	2022-04-08T22:43:43.000Z	0x0000000000000000000000000000000000000000	0xfa58f6e90cd544b0051b22839fb311b2af495b9bfa2c4f8cd68eb12d18a49200

Example Query

Query with partition filter

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

BasicIssuanceModule_SetTokenRedeemed_event

SetToken redemption events from Set Protocol v2 on Ethereum, capturing when users burn Set tokens to receive underlying component assets. Contains redeemer addresses, token quantities, and recipient data for analyzing protocol outflows and token composition unwinding.

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__setToken`	`STRING`	Contract address of the Set token being issued or redeemed. Hex-encoded, 0x-prefixed, 42-character string.
`in__redeemer`	`STRING`	Address of the account redeeming SetTokens back into their underlying component assets. Hex-encoded, 0x-prefixed 40-character Ethereum address that initiated the redemption transaction.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__quantity`	`STRING`	Amount of Set tokens being issued or redeemed in the transaction. Numeric string representation in smallest token unit (wei).

Sample Data

in__to	address	removed	log_index	block_number	in__quantity	in__redeemer	in__setToken	block_timestamp	transaction_hash
0x00000000000e1d0dabf7b7c7b68866fc940d0db8	0xd8ef3cace8b4907117a45b0b125c68560532f94d	false	42	14375632	100000000000000000000	0x00000000000e1d0dabf7b7c7b68866fc940d0db8	0x33d63ba1e57e54779f7ddaeaa7109349344cf5f1	2022-03-13T02:05:42.000Z	0x10ee2c4fa6b4f458e619013fa2d663d114f38ae85a3524b2af4013c2bdee7fef
0x00000000000e1d0dabf7b7c7b68866fc940d0db8	0xd8ef3cace8b4907117a45b0b125c68560532f94d	false	44	14376183	100000000000000000000	0x00000000000e1d0dabf7b7c7b68866fc940d0db8	0x33d63ba1e57e54779f7ddaeaa7109349344cf5f1	2022-03-13T04:15:41.000Z	0x671e919001933e19f4200fb033698ac627695209ea6b99fa1eb9513f189e916e
0x00000000000e1d0dabf7b7c7b68866fc940d0db8	0xd8ef3cace8b4907117a45b0b125c68560532f94d	false	26	14375620	400000000000000000000	0x00000000000e1d0dabf7b7c7b68866fc940d0db8	0x33d63ba1e57e54779f7ddaeaa7109349344cf5f1	2022-03-13T02:04:01.000Z	0xb18e0486053b49fe7b306029e374051b0d5f02ea18306be48f99409a1fb5977e

Example Query

Query with partition filter

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

DebtIssuanceModule_SetTokenIssued_event

SetToken minting events from Set Protocol v2’s DebtIssuanceModule on Ethereum, capturing issuance transactions with recipient addresses, quantities, and associated manager and protocol fees. Used for tracking token creation activity and fee analysis across Set Protocol’s composable token products.

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__setToken`	`STRING`	Contract address of the Set token being issued or redeemed. Hex-encoded, 0x-prefixed, 42-character string.
`in__issuer`	`STRING`	Address of the account that initiated the Set token issuance transaction. Always matches the transaction sender in the DebtIssuanceModule contract.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__hookContract`	`STRING`	Contract address of the hook invoked during Set token issuance for custom pre/post-issuance logic. Hex-encoded, 0x-prefixed 40-character Ethereum address that executed alongside the main issuance operation.
`in__quantity`	`STRING`	Amount of Set tokens being issued or redeemed in the transaction. Numeric string representation in smallest token unit (wei).
`in__managerFee`	`STRING`	Fee amount charged to the manager for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).
`in__protocolFee`	`STRING`	Fee amount charged by the protocol for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).

Sample Data

in__to	address	removed	log_index	in__issuer	block_number	in__quantity	in__setToken	in__managerFee	block_timestamp	in__hookContract	transaction_hash
0x3a518964ff40ee733d30749a213d2e5c9ffb2b8c	0x39f024d621367c044bace2bf0fb15fb3612ecb92	false	22	0x3a518964ff40ee733d30749a213d2e5c9ffb2b8c	12130108	367553589782271016808	0xaa6e8127831c9de45ae56bb1b0d4d4da6e5665bd	367553589782271016	2021-03-28T21:36:49.000Z	0x0f1171c24b06aded18d2d23178019a3b256401d3	0x9b545f97c67553acae9977a69ff0b21ea07fd9f5f8ae218719bf856e6662291c
0x3a518964ff40ee733d30749a213d2e5c9ffb2b8c	0x39f024d621367c044bace2bf0fb15fb3612ecb92	false	24	0x3a518964ff40ee733d30749a213d2e5c9ffb2b8c	12128342	625750000000000000000	0xaa6e8127831c9de45ae56bb1b0d4d4da6e5665bd	625750000000000000	2021-03-28T15:05:18.000Z	0x0f1171c24b06aded18d2d23178019a3b256401d3	0x7ebe422a6ff7de09e5cab3f5f4ba29e88484751fedcb3d09306bb4f6ef02649b
0xf91c12dae1313d0be5d7a27aa559b1171cc1eac5	0x39f024d621367c044bace2bf0fb15fb3612ecb92	false	106	0x885fa07b84cc5cbacd45d6b1df44a01f96bfbb4e	12130688	374257213691686422285	0xaa6e8127831c9de45ae56bb1b0d4d4da6e5665bd	374257213691686422	2021-03-28T23:44:57.000Z	0x0f1171c24b06aded18d2d23178019a3b256401d3	0x97b30679f2ab45e1dabddb307e22c9087b95ea49ef1cb8b4af6e44bd28675584

Example Query

Query with partition filter

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

DebtIssuanceModule_SetTokenRedeemed_event

Set Protocol v2 redemption events on Ethereum recording when users burn Set tokens to receive underlying basket components, including redeemed quantities, recipient addresses, and manager/protocol fees. Used for tracking Set token supply changes and fee analysis across TokenSets and structured products.

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__setToken`	`STRING`	Contract address of the Set token being issued or redeemed. Hex-encoded, 0x-prefixed, 42-character string.
`in__redeemer`	`STRING`	Address of the account redeeming Set Protocol tokens and receiving the underlying component assets. Always matches the transaction initiator in these redemption events.
`in__to`	`STRING`	Destination address for the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
`in__quantity`	`STRING`	Amount of Set tokens being issued or redeemed in the transaction. Numeric string representation in smallest token unit (wei).
`in__managerFee`	`STRING`	Fee amount charged to the manager for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).
`in__protocolFee`	`STRING`	Fee amount charged by the protocol for the issuance, redemption, or operation. Numeric string representation in smallest token unit (wei).

Sample Data

in__to	address	removed	log_index	block_number	in__quantity	in__redeemer	in__setToken	in__managerFee	block_timestamp	transaction_hash
0x75600ed0819b51e4da873e38bcdc8330c14444cf	0x39f024d621367c044bace2bf0fb15fb3612ecb92	false	24	14741338	588125240000000000000	0x75600ed0819b51e4da873e38bcdc8330c14444cf	0x0b498ff89709d3838a063f1dfa463091f9801c2b	588125240000000000	2022-05-09T08:13:39.000Z	0x103c5e1139747bb39516f56d86386b508afb737acc4af0bdcdbfa0a20a6ec3ae
0x07197a25bf7297c2c41dd09a79160d05b6232bcf	0x39f024d621367c044bace2bf0fb15fb3612ecb92	false	40	14741447	932503733983177423158	0x07197a25bf7297c2c41dd09a79160d05b6232bcf	0x0b498ff89709d3838a063f1dfa463091f9801c2b	932503733983177423	2022-05-09T08:40:12.000Z	0xdbba829c72277ace9c4f5357a5c43eed6f12e1adf6fec4b219c0563fc1f17acc
0x75600ed0819b51e4da873e38bcdc8330c14444cf	0x39f024d621367c044bace2bf0fb15fb3612ecb92	false	40	14741374	966987557468453487234	0x75600ed0819b51e4da873e38bcdc8330c14444cf	0x0b498ff89709d3838a063f1dfa463091f9801c2b	966987557468453487	2022-05-09T08:22:35.000Z	0x2e9aff6c0f6de090c5e3c3e372686ba7047b65bc9f663b28a0721dc673bfb2df

Example Query

Query with partition filter

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

StreamingFeeModule_StreamingFeeUpdated_event

Streaming fee configuration changes for Set Protocol V2 token sets on Ethereum, capturing when managers update the annual management fee percentage for tokenized portfolios. Used for tracking fee structure modifications and governance decisions across Set Protocol’s asset management products.

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__setToken`	`STRING`	Contract address of the Set token being issued or redeemed. Hex-encoded, 0x-prefixed, 42-character string.
`in__newStreamingFee`	`STRING`	Updated streaming fee rate for the Set Protocol token, expressed in wei as a percentage with 18 decimal precision. For example, ‘20000000000000000’ represents a 2% annual fee, while ‘0’ indicates fee removal.

Sample Data

address	removed	log_index	block_number	in__setToken	block_timestamp	transaction_hash	in__newStreamingFee
0x08f866c74205617b6f3903ef481798eced10cdec	false	648	15421426	0xe101f6cebb69985412e06a010a50a57cef7fa6c9	2022-08-27T11:53:25.000Z	0x6f92a6d6bbc1dc07e5079f212f1bd00a036b91c36c78e01843d3616acda04535	0
0x08f866c74205617b6f3903ef481798eced10cdec	false	133	15782917	0x7c07f7abe10ce8e33dc6c5ad68fe033085256a84	2022-10-19T15:01:59.000Z	0x157a828530e6c3b09b5dc47853779eeae37766ca5d966d1abe95da25a5145967	7500000000000000
0x08f866c74205617b6f3903ef481798eced10cdec	false	200	12459421	0x45548ea8523007e82177d0309a648124936881fd	2021-05-18T16:16:39.000Z	0xfd89c0d979277e69fe17580c7656c70caa3455bb2c950739c6c7b4377af41524	50000000000000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BasicIssuanceModule_SetTokenIssued_event

BasicIssuanceModule_SetTokenRedeemed_event

DebtIssuanceModule_SetTokenIssued_event

DebtIssuanceModule_SetTokenRedeemed_event

StreamingFeeModule_StreamingFeeUpdated_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BasicIssuanceModule_SetTokenIssued_event

​BasicIssuanceModule_SetTokenRedeemed_event

​DebtIssuanceModule_SetTokenIssued_event

​DebtIssuanceModule_SetTokenRedeemed_event

​StreamingFeeModule_StreamingFeeUpdated_event

Tables

BasicIssuanceModule_SetTokenIssued_event

BasicIssuanceModule_SetTokenRedeemed_event

DebtIssuanceModule_SetTokenIssued_event

DebtIssuanceModule_SetTokenRedeemed_event

StreamingFeeModule_StreamingFeeUpdated_event