stfx_v1_arbitrum

Tables

StfxVault_Claimed_event

Reward claim events from STFX vault contracts on Arbitrum, recording when investors withdraw earnings from trading vaults. Tracks claim amounts, investor addresses, and associated vault addresses for analyzing vault performance and withdrawal 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_investor`	`STRING`	Address of the investor depositing funds into or claiming funds from the vault. Hex-encoded, 0x-prefixed, 42-character string.
`in_stfxAddress`	`STRING`	Contract address of the STFX fund or vault instance. 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_amount	log_index	in_investor	block_number	in_stfxAddress	block_timestamp	transaction_hash
0xd974db6393b83274c7da596b5e9541503500d773	false	470000000	1	0x8cb4c1c8abe7d1e7b4cc9b068206e74b235a83fb	58412177	0x114c8639977369e755dc8aa1d74bc52c8fd1d753	2023-02-06T05:27:12.000Z	0x75e869e3e30f7fda87b5fd8e57fd45859a02b096a0878f6c4c655277dad7de5c
0xd974db6393b83274c7da596b5e9541503500d773	false	498444632	4	0x8cb4c1c8abe7d1e7b4cc9b068206e74b235a83fb	58411687	0x29b2691d2896b7e27c393c0687dc0d88324145cc	2023-02-06T05:24:58.000Z	0x8716608c678110938c11b7e059ad830cb506b6d0b3f329da7e21cededbd0dd1b
0xd974db6393b83274c7da596b5e9541503500d773	false	300000000	12	0x8cb4c1c8abe7d1e7b4cc9b068206e74b235a83fb	58411255	0x36d2bbfe83ec2a41cdd24777f26d7942644f2cf7	2023-02-06T05:23:02.000Z	0x66ea5d6c1c7d516fe9464ad642229d64482657659eea0907cca24c221adef154

Example Query

Query with partition filter

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

StfxVault_DepositIntoFund_event

Investor deposit events into STFX (Sustainable Trading Foundation eXperience) vault funds on Arbitrum, capturing investor addresses, deposited amounts, and corresponding STFX fund addresses. Used for tracking capital flows and investment patterns across STFX managed trading vaults.

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__stfxAddress`	`STRING`	Address of the STFX token or fund contract associated with the vault operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_investor`	`STRING`	Address of the investor depositing funds into or claiming funds from the vault. 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_amount	log_index	in_investor	block_number	block_timestamp	in__stfxAddress	transaction_hash
0xd974db6393b83274c7da596b5e9541503500d773	false	20000000	4	0x44ffd81ff924e193e5735f338967e87164c224ff	68857155	2023-03-11T13:28:36.000Z	0xc7e11259a57c950e98d3381c17cb65e9612e33df	0x54a77027dc3fd3ea7ce5a2cf1bb6e0f3e4a1545d80e6d367c6d03c75edda2c83
0xd974db6393b83274c7da596b5e9541503500d773	false	20000000	2	0x27964f7ce0796b3b22178ad86f1ef054f9e4b19e	68849446	2023-03-11T12:52:29.000Z	0xf8cd4f28b7e16ffd4d5a2fec7497fedb443956c2	0xebe297f2ca5d8e1a0440f33fba37bb8da01dc1d887f013286bdc0df0ec4d7730
0xd974db6393b83274c7da596b5e9541503500d773	false	146500000	2	0x5f023a855586ebb99f6261697363375a7a5e13ab	68959823	2023-03-11T22:02:56.000Z	0x6fc705e16920f4fcef19999391778dbd2939d66b	0xff583130a831d978b22f1090eb10f44cbb9660171b33fc18b97c7e66d19003c4

Example Query

Query with partition filter

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

StfxVault_FeesTransferred_event

Fee transfer events from STFX protocol vaults on Arbitrum, capturing manager and protocol fee distributions with vault balance snapshots. Useful for analyzing vault fee structures and revenue sharing between vault managers and the 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__stfxAddress`	`STRING`	Address of the STFX token or fund contract associated with the vault operation. Hex-encoded, 0x-prefixed, 42-character string.
`in__remainingBalance`	`STRING`	Vault balance remaining after manager and protocol fees were transferred, denominated in the smallest unit of the vault’s base token. String-encoded integer value representing the post-fee vault balance.
`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

address	removed	log_index	block_number	block_timestamp	in__stfxAddress	transaction_hash	in__remainingBalance
0xd974db6393b83274c7da596b5e9541503500d773	false	46	72952564	2023-03-23T21:08:21.000Z	0x5c46ef42712a29a4ed40df76c99c706fad720555	0x08f18d42cd5d0a22fe744cb8061bb5a0ae3238a5ad7533f734ca3dc9ad9bb8b4	30119962
0xd974db6393b83274c7da596b5e9541503500d773	false	1	72819767	2023-03-23T12:24:54.000Z	0xbd088b110983c16cc0d6a6838820c63e02a917d4	0xd9303abff053c6ae5a17fd67626fbd2f2a5f3f8569589c3394ca6596fa2149ab	19769507
0xd974db6393b83274c7da596b5e9541503500d773	false	5	72824346	2023-03-23T12:41:26.000Z	0x67942025b536ace2c45b74f3450d8198334b6784	0xbced934e8e758f5801ab111862a965213311f0f556d4d5bdf6019bcefe846fc9	19596852

Example Query

Query with partition filter

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

StfxVault_NewFundCreated_event

Fund creation events from STFX protocol on Arbitrum capturing leveraged trading vault parameters including manager address, base token (WETH), trade direction, entry/target/liquidation prices, leverage multiples, and fundraising periods. Used for analyzing fund manager strategies and vault performance metrics.

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_baseToken`	`STRING`	Contract address of the base token in a trading pair. Hex-encoded, 0x-prefixed, 42-character string.
`in_fundraisingPeriod`	`STRING`	Duration in seconds that the fund accepts deposits before trading begins. Typically ranges from 10,800 (3 hours) to 604,800 (7 days) based on sample values.
`in_entryPrice`	`STRING`	Price at which the trading position was entered. String-encoded numeric value representing the entry price in the smallest denomination or with extended precision.
`in_targetPrice`	`STRING`	Target price for the leveraged position, denominated in the smallest unit of the base token (typically wei for ETH). Represents the profit-taking exit level set by the fund manager at creation.
`in_liquidationPrice`	`STRING`	Price level at which the leveraged position will be automatically closed to prevent further losses, denominated in the base token’s smallest unit. Typically zero when no liquidation threshold is set for the fund.
`in_leverage`	`STRING`	Leverage multiplier applied to the trading position. String-encoded numeric value representing the multiple of the margin amount used to determine position size.
`in_tradeDirection`	`BOOL`	Trade position direction where true indicates a long position and false indicates a short position. Based on sample data, this fund protocol appears to primarily support short positions.
`in_stfxAddress`	`STRING`	Contract address of the STFX fund or vault instance. Hex-encoded, 0x-prefixed, 42-character string.
`in_manager`	`STRING`	Address of the account authorized to manage the pool, vault, or fund. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_manager	in_leverage	block_number	in_baseToken	in_entryPrice	in_stfxAddress	in_targetPrice	block_timestamp	transaction_hash	in_tradeDirection	in_fundraisingPeriod
0xd974db6393b83274c7da596b5e9541503500d773	false	1	0x6b6e2f7f703b5d8715d8c1047222210b2f56b3b6	8000000	36078642	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1750000000	0x61951cc9d2d4e6c41d61b56a405838b93d4723f0	1000000000	2022-11-07T18:06:39.000Z	0x60494a2590b1b6c2d7bec71bd731662c1212af1b77e17053e23d33c460579107	false	360000
0xd974db6393b83274c7da596b5e9541503500d773	false	11	0x56e9fa99b38333cfd3a370f9eff662bc0283fdc1	10000000	35972993	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1570000000	0xdddf8680256a9f5c1f609a5550376b92db34090f	1300000000	2022-11-07T09:47:17.000Z	0x8d9d53c51153dd53eee85e208dc485b09ed3b6911651bb8c28225f3cd84a59c0	false	72000
0xd974db6393b83274c7da596b5e9541503500d773	false	1	0xfbd8d99e190491d9dc256faef0bf2b49e1b80629	10000000	35973458	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	1570000000	0x74307b2319903912ca7277fee0b7dbbe4c1bb3ca	1300000000	2022-11-07T09:49:26.000Z	0xace258350cbb725e68c957c9a7e31201511ca8dcf15e345a3d718b9ca532a28e	false	10800

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

StfxVault_Claimed_event

StfxVault_DepositIntoFund_event

StfxVault_FeesTransferred_event

StfxVault_NewFundCreated_event

​Tables

​StfxVault_Claimed_event

​StfxVault_DepositIntoFund_event

​StfxVault_FeesTransferred_event

​StfxVault_NewFundCreated_event

Tables

StfxVault_Claimed_event

StfxVault_DepositIntoFund_event

StfxVault_FeesTransferred_event

StfxVault_NewFundCreated_event