reflexer_v1_ethereum

Tables

MerkleDistributor_Claimed_event

Token claim events from Reflexer’s Merkle distributor contracts on Ethereum. Records each claim with merkle proof index, claimed amount (in wei), and recipient account for tracking FLX token distribution campaigns.

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_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_index	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x230fde56e522433f1f5c1001e3c88a16a8b80f5b	false	88	1180335377000000000	355	0x8dd77eaba64018dab36dcff7bf464f2f5027f044	15138633	2022-07-14T04:42:57.000Z	0x23be900b1aa033e648624a59cf36bfda405e215eaf17e74929b564eb3c107ee7
0x4594b2fbdd493f0eabe1f2064dc6a750747007b9	false	167	721909723000000000	117	0x5273611f2caadcda536495909ea87bd2bb9cb9f9	15140581	2022-07-14T11:51:34.000Z	0x53885a775d7ba4a149218e7b116496c687d95b47f5d4a8b797d65b15b44aea63
0x4594b2fbdd493f0eabe1f2064dc6a750747007b9	false	294	1725869617000000000	369	0x8dd77eaba64018dab36dcff7bf464f2f5027f044	15138625	2022-07-14T04:41:17.000Z	0xdc0edd79b1da9242a64fe9f8581ac073e081b50ea358bb2ea65718b45d191eae

Example Query

Query with partition filter

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

MerkleDistributorFactory_DeployDistributor_event

DeployDistributor event logs from Reflexer’s MerkleDistributorFactory contract on Ethereum, recording the creation of new merkle-based token distribution contracts with their addresses and allocated token amounts. Used to track FLX token reward distribution campaigns and their associated distributor contract deployments.

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_id`	`STRING`	Unique identifier for the position, record, or entity within the protocol. Numeric string representation.
`in_distributor`	`STRING`	Address of the distributor contract responsible for managing the token distribution or reward allocation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenAmount`	`STRING`	Amount of tokens involved in the transaction or operation. String-encoded integer representing the token quantity in its smallest denomination.

Sample Data

in_id	address	removed	log_index	block_number	in_distributor	in_tokenAmount	block_timestamp	transaction_hash
5	0xb5ed650ef207e051453b68a2138d7cb67cc85e41	false	103	13037565	0xecd9c89e256cd1e4dab487c9319c5dec09fe96d4	17689778188958000000000	2021-08-16T17:26:39.000Z	0x86938ad037fafbd5b91e56daebc3b79f4a7475fd533178a31ed07d8cca02d924
20	0xb5ed650ef207e051453b68a2138d7cb67cc85e41	false	52	15825690	0xfaf43c4ec4e3ac0bd0e967caf93ec9946eb13bab	4799644444445000000000	2022-10-25T14:27:35.000Z	0x34d36876f9073f548da912bf8c7495f8bbc7ff18d1823053c7343dce1d43e91a
29	0xb5ed650ef207e051453b68a2138d7cb67cc85e41	false	326	17801374	0x0e53c0bf85a27ee73da1db2291d8d3a62e3604be	900000000006000000000	2023-07-29T21:27:35.000Z	0x373bf0eac61d40fb6aa6fe69ba9463b09ec49b56efb5403c3b6e21bd727e78cb

Example Query

Query with partition filter

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

RAI_Transfer_event

RAI token transfer events on Ethereum from the Reflexer protocol, tracking movements between addresses with amounts in wei. Used for analyzing RAI (a non-pegged stable asset) holder flows, liquidity migrations, and mint/burn activity indicated by zero addresses.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_dst	in_src	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xf9f934403ace836834a2b1c22c753690d61fb6a4	0x65274e52b12e0cfac2cc42bc4fb971447507c5e2	0x03ab458634910aad20ef5f1c8ee96f1d6ac54919	false	1291017623489383799743	4	13136586	2021-09-01T00:38:44.000Z	0xe591a0d688853be7291b7804caeba447f576404212ded059287180e095dbacda
0x8ae720a71622e824f576b4a8c03031066548a3b1	0xfa7d7a0858a45c1b3b7238522a0c0d123900c118	0x03ab458634910aad20ef5f1c8ee96f1d6ac54919	false	14081845653958235466384	3	13138012	2021-09-01T05:49:48.000Z	0x45f60a131d6d677379f319739da7507c3533a51257cd8fad2abd73eb642ccb8a
0x8ae720a71622e824f576b4a8c03031066548a3b1	0xae7861c80d03826837a50b45aecf11ec677f6586	0x03ab458634910aad20ef5f1c8ee96f1d6ac54919	false	26406536952307649793385	0	13138427	2021-09-01T07:28:36.000Z	0x9995ba9a58a0c4eea38c9b8f2edb688f78b3ef2e93753b0c6d837bec4d9d6591

Example Query

Query with partition filter

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

SAFEEngine_ModifySAFECollateralization_event

Collateral vault modification events from Reflexer’s SAFEEngine contract on Ethereum, tracking deposits, withdrawals, and debt changes for individual SAFEs (collateralized debt positions). Used for analyzing RAI stablecoin minting/burning activity, liquidation risk, and vault management patterns across different collateral types like ETH-A.

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_collateralType`	`STRING`	Identifier for the type of collateral used in the SAFE (e.g., ETH-A). Bytes32-encoded hex string representing the collateral category within Reflexer’s multi-collateral system.
`in_safe`	`STRING`	Safe contract address associated with the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_collateralSource`	`STRING`	Address from which collateral is being withdrawn or transferred in this SAFE (collateralized debt position) modification. Matches the SAFE owner address when collateral is added or removed directly.
`in_debtDestination`	`STRING`	Address where debt tokens are sent when generated debt is minted from the SAFE (collateralized debt position). Typically matches the SAFE owner address who receives the borrowed stablecoin.
`in_deltaCollateral`	`STRING`	Change in collateral amount for this SAFE (collateralized debt position), denominated in the smallest unit of the collateral token. Can be positive (collateral added), negative (collateral withdrawn), or zero (debt-only modification).
`in_deltaDebt`	`STRING`	Change in debt position for this SAFE (collateralized debt position), denominated in RAI’s internal accounting units. Positive values indicate debt issuance, negative values indicate debt repayment.
`in_lockedCollateral`	`STRING`	Amount of collateral locked in the SAFE (collateralized debt position) after this modification, denominated in the smallest unit of the collateral token (wei for ETH). Values represent the total locked balance, not the change amount.
`in_generatedDebt`	`STRING`	Total debt generated by this SAFE position after the modification, denominated in the protocol’s internal debt units. Represents the cumulative debt owed by the position across all modifications.
`in_globalDebt`	`STRING`	Total debt outstanding across all SAFEs in the Reflexer protocol at the time of this collateral modification. Denominated in RAI system units (scaled by 10^27 for precision).

Sample Data

address	in_safe	removed	log_index	block_number	in_deltaDebt	in_globalDebt	block_timestamp	in_generatedDebt	transaction_hash	in_collateralType	in_debtDestination	in_deltaCollateral	in_collateralSource	in_lockedCollateral
0xcc88a9d330da1133df3a7bd823b95e52511a6962	0x07058791ed5954680ed0fc54c3b8437a5ff047ff	false	314	18457367	484989772037315712365	2588472782866198152368763128898873234061919747148503	2023-10-29T17:35:59.000Z	164597138900514696944420	0xcc245558c931adb8643ef29cb237199ee2fb98017557688648b44cd6700987f9	0x4554482d41000000000000000000000000000000000000000000000000000000	0x07058791ed5954680ed0fc54c3b8437a5ff047ff	0	0x07058791ed5954680ed0fc54c3b8437a5ff047ff	504600000000000000000
0xcc88a9d330da1133df3a7bd823b95e52511a6962	0xe4f70ec016a04905cca66538cc12bbcbdcea343c	false	208	18456261	3879926371872078202341	2587967316287902332021517537130269019747072461867608	2023-10-29T13:53:23.000Z	14562761299876125515097	0x383870662429c895df72848ce4587e0266b16ee6c267943cb61dd66ace8052d2	0x4554482d41000000000000000000000000000000000000000000000000000000	0xe4f70ec016a04905cca66538cc12bbcbdcea343c	0	0xe4f70ec016a04905cca66538cc12bbcbdcea343c	49400000000000000000
0xcc88a9d330da1133df3a7bd823b95e52511a6962	0xe4f70ec016a04905cca66538cc12bbcbdcea343c	false	290	18456275	0	2587967316287902332021517537130269019747072461867608	2023-10-29T13:56:11.000Z	14562761299876125515097	0x34ff9fa3aeee9407796b49280c79c60bf6dbfa5cb809f2bf873c0e3aecf2a09f	0x4554482d41000000000000000000000000000000000000000000000000000000	0x0f4670dcc92de4482fdda82400edb4e41d4f80e2	6100000000000000000	0x0f4670dcc92de4482fdda82400edb4e41d4f80e2	55500000000000000000

Example Query

Query with partition filter

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

StakingRewardsEscrow_ClaimRewards_event

Staking reward claim events from Reflexer protocol’s escrow contract on Ethereum, capturing user addresses and reward amounts withdrawn from the staking program. Used to track reward distribution patterns and participant behavior in Reflexer’s FLX token staking system.

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_who`	`STRING`	Ethereum address of the user claiming staking rewards from the Reflexer escrow contract. Hex-encoded, 0x-prefixed 40-character string representing the reward recipient.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_who	address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xecbbc62189b18902e9abe7236edfa7964f7e3381	0x8017f897aaaabd5701b63d819590062a87732ba0	false	5176410266608089600	87	16261289	2022-12-25T10:53:35.000Z	0xaad0a47857ae064740f8ce5dc16bb7909081f5ad86d8bca38724e5856d68f0d3
0x91d6e260a5965a3c33d5bc4bf4adcf96c449ed2e	0x8017f897aaaabd5701b63d819590062a87732ba0	false	1016522925961580334	65	13871858	2021-12-25T03:13:57.000Z	0x184bc44d46a8a6f57e293a1b31895e278c02c63d288edbcfcd94dfe34ff30e88
0xf72aa846ecf3e9e8f6fb208a5bc9675759099a9a	0x8017f897aaaabd5701b63d819590062a87732ba0	false	919558859188437512	435	13877165	2021-12-25T22:58:52.000Z	0x0351d56abe1f08d37b6fc501532f9327f0aec2797466d3383428f1437f8a9da1

Example Query

Query with partition filter

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

TaxCollector_ModifyParameters_event

Parameter modification events from Reflexer’s TaxCollector contract on Ethereum, recording changes to stability fee rates for collateral types like ETH-A. Used to track interest rate adjustments in the RAI stablecoin system.

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_collateralType`	`STRING`	Hex-encoded identifier for the collateral type being modified in the Reflexer protocol’s TaxCollector contract. Based on samples, ‘ETH-A’ (0x4554482d41…) represents the standard ETH collateral vault type.
`in_parameter`	`STRING`	Hex-encoded parameter name being modified in the TaxCollector contract configuration. Common values include “stabilityFee” which controls the interest rate charged on collateralized debt positions.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

address	in_data	removed	log_index	block_number	in_parameter	block_timestamp	transaction_hash	in_collateralType
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	1000000000627937192491029810	false	336	14481269	0x73746162696c6974794665650000000000000000000000000000000000000000	2022-03-29T13:07:10.000Z	0x1c143a83b53874bd17fb6809bdc3d0d5a0dfeb730fd8bad6396f735ef5e880a9	0x4554482d41000000000000000000000000000000000000000000000000000000
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	999999999904727643957521610	false	199	12774066	0x73746162696c6974794665650000000000000000000000000000000000000000	2021-07-06T13:07:59.000Z	0x5df75d479ad0b9313d1abd91860e1da384d00879192f0bf15dc55c4ba64a0352	0x4554482d41000000000000000000000000000000000000000000000000000000
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	999999999952399602795807377	false	99	12729134	0x73746162696c6974794665650000000000000000000000000000000000000000	2021-06-29T13:07:53.000Z	0xa05621b59819df2e5d41b443eb03580c7e0541aaaece70649152c65409e16737	0x4554482d41000000000000000000000000000000000000000000000000000000

Example Query

Query with partition filter

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

TaxCollector_ModifyParameters2_event

Parameter modification events from Reflexer’s TaxCollector contract on Ethereum, tracking governance changes to stability fee settings including global rates and maximum secondary receiver limits. Used for monitoring protocol configuration updates and fee structure evolution in the RAI stablecoin system.

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_parameter`	`STRING`	Parameter name being modified in the TaxCollector contract, encoded as a bytes32 hex string. Common values include “maxSecondaryReceivers” and “globalStabilityFee” which control fee collection settings in the Reflexer protocol.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

address	in_data	removed	log_index	block_number	in_parameter	block_timestamp	transaction_hash
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	4	false	65	11848791	0x6d61785365636f6e646172795265636569766572730000000000000000000000	2021-02-13T14:22:18.000Z	0xbc25703902b744436d72ad62a2a65ebb5f796e8483a60aba3c00985bd2b95602
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	0	false	67	11848916	0x676c6f62616c53746162696c6974794665650000000000000000000000000000	2021-02-13T14:48:27.000Z	0xd7196abd3aeee65c4bf3777a4f8e685c65e3be41c4eb444118bb4fbd0c22f32a

Example Query

Query with partition filter

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

TaxCollector_ModifyParameters3_event

Parameter modification events from Reflexer’s TaxCollector contract on Ethereum, capturing administrative changes to tax collection settings including the primary tax receiver address. Used for tracking governance updates and fee distribution configuration in the RAI stablecoin protocol.

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_parameter`	`STRING`	Parameter name being modified in the tax collector contract, encoded as a hex string (bytes32). Common values include system configuration keys like ‘primaryTaxReceiver’ which appear as 0x-prefixed 64-character strings.
`in_data`	`STRING`	Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.

Sample Data

address	in_data	removed	log_index	block_number	in_parameter	block_timestamp	transaction_hash
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	0xcee6aa1ab47d0fb0f24f51a3072ec16e20f90fce	false	130	11848437	0x7072696d61727954617852656365697665720000000000000000000000000000	2021-02-13T13:05:31.000Z	0x94c0d3d6131fab1e3ea0365db1f637a955d6c930c053160654096796b134d721

Example Query

Query with partition filter

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

TaxCollector_ModifyParameters5_event

Parameter modification events from Reflexer’s TaxCollector contract on Ethereum, recording changes to stability fee configurations including tax percentages, receiver accounts, and collateral type positions. Used for tracking governance adjustments to the RAI stablecoin’s fee collection mechanism.

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_collateralType`	`STRING`	Collateral type identifier for the Reflexer protocol, represented as a bytes32-encoded string. Typically represents “ETH-A” or similar collateral vault types used in the stability fee calculation.
`in_position`	`STRING`	Address of the position or market contract being traded or operated on. Hex-encoded, 0x-prefixed, 42-character string.
`in_taxPercentage`	`STRING`	Tax rate applied to the specified collateral type, represented as a high-precision integer with 27 decimal places (RAY format in Reflexer). Sample values range from 0 (no tax) to 50000000000000000000000000000 (50% annualized stability fee).
`in_receiverAccount`	`STRING`	Ethereum address designated to receive tax revenue collected from the specified collateral type. Hex-encoded, 0x-prefixed 40-character string identifying the beneficiary account for tax distribution.

Sample Data

address	removed	log_index	in_position	block_number	block_timestamp	in_taxPercentage	transaction_hash	in_collateralType	in_receiverAccount
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	false	58	100000000000000	11848836	2021-02-13T14:32:50.000Z	50000000000000000000000000000	0xa103b453a2f50f3211d79671ec173d3f8aff9bf705c79ef3ab67a3be0f7bf370	0x4554482d41000000000000000000000000000000000000000000000000000000	0x83533fdd3285f48204215e9cf38c785371258e76
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	false	191	2	13588636	2021-11-10T13:08:01.000Z	0	0x20f9ff25746a8f19000e3dd2bce6b5339d318a01be400d12931e1271fa704927	0x4554482d41000000000000000000000000000000000000000000000000000000	0xae09afe44fcea8e93338bdc492a6b038f4092818
0xcdb05aeda142a1b0d6044c09c64e4226c1a281eb	false	429	2	13101162	2021-08-26T13:08:26.000Z	30000000000000000000000000000	0x94cc1650adbac6599417dcef395a0d10619e9636e9e47ca12d0f198bd2c12755	0x4554482d41000000000000000000000000000000000000000000000000000000	0xae09afe44fcea8e93338bdc492a6b038f4092818

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

MerkleDistributor_Claimed_event

MerkleDistributorFactory_DeployDistributor_event

RAI_Transfer_event

SAFEEngine_ModifySAFECollateralization_event

StakingRewardsEscrow_ClaimRewards_event

TaxCollector_ModifyParameters_event

TaxCollector_ModifyParameters2_event

TaxCollector_ModifyParameters3_event

TaxCollector_ModifyParameters5_event

​Tables

​MerkleDistributor_Claimed_event

​MerkleDistributorFactory_DeployDistributor_event

​RAI_Transfer_event

​SAFEEngine_ModifySAFECollateralization_event

​StakingRewardsEscrow_ClaimRewards_event

​TaxCollector_ModifyParameters_event

​TaxCollector_ModifyParameters2_event

​TaxCollector_ModifyParameters3_event

​TaxCollector_ModifyParameters5_event

Tables

MerkleDistributor_Claimed_event

MerkleDistributorFactory_DeployDistributor_event

RAI_Transfer_event

SAFEEngine_ModifySAFECollateralization_event

StakingRewardsEscrow_ClaimRewards_event

TaxCollector_ModifyParameters_event

TaxCollector_ModifyParameters2_event

TaxCollector_ModifyParameters3_event

TaxCollector_ModifyParameters5_event