fantom_v1_fantom

Tables

ERC721_Transfer_event

Non-fungible token (NFT) transfer events emitted by ERC-721 compliant smart contracts, capturing the movement of unique tokens between addresses. Contains sender, recipient, token ID, and contract address for tracking NFT ownership changes and marketplace activity across chains.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_tokenId`	`STRING`	Unique identifier for a non-fungible token within its contract. Numeric string representation of the token’s ID.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash
0x078eef5a2fb533e1a4d487ef64b27df113d12c32	false	0	1740857	2021-01-12T02:57:11.000Z	0x7f80bc8233c4b0bb711e2fac09446329d8ba7eafc01b40d8bd70f4f7e47ce83a
0x1ffbd1e3584f139ca42d77ef99ef99550ecf46a8	false	2	1742593	2021-01-12T08:30:28.000Z	0x09351aad38f0c869b828e66d697b28796c90392aee44cb81474905f54f57688a
0x1ffbd1e3584f139ca42d77ef99ef99550ecf46a8	false	0	1742593	2021-01-12T08:30:28.000Z	0x09351aad38f0c869b828e66d697b28796c90392aee44cb81474905f54f57688a

Example Query

Query with partition filter

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

SFC_ClaimedRewards_event

Staking reward claim events from Fantom’s SFC (Staking Fluid Contract) showing delegator withdrawals with unlocked and lockup-based rewards to specific validators. Used for analyzing validator delegation patterns and staking yield distribution across the Fantom network.

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_delegator`	`STRING`	Address of the delegator participating in the staking or delegation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_toValidatorID`	`STRING`	Identifier of the validator receiving the delegation or associated with the staking operation. Numeric string value.
`in_lockupExtraReward`	`STRING`	Amount of extra staking rewards earned during the lockup period, denominated in wei (smallest unit of FTM). This extra reward component incentivizes longer token lockup periods in the Fantom SFC (Staker Function Contract).
`in_lockupBaseReward`	`STRING`	Base staking reward amount earned in the lockup period, denominated in wei (smallest FTM unit). This value represents the standard reward component before any lockup multipliers or bonuses are applied.
`in_unlockedReward`	`STRING`	Amount of unlocked staking rewards claimed by the delegator, denominated in wei (smallest FTM unit). This value can be zero if the delegator only claimed locked rewards during the event.

Sample Data

address	removed	log_index	block_number	in_delegator	block_timestamp	in_toValidatorID	transaction_hash	in_unlockedReward	in_lockupBaseReward	in_lockupExtraReward
0xfc00face00000000000000000000000000000000	false	4	28597190	0xd82439b8c2ffa064f8710a6d21c55644e13cc990	2022-01-21T01:21:36.000Z	6	0xded9f056696a4737bd12869febba86f106a4eec7372c8a3051c50488e1e7f5c9	117883227246191	7642271403062235732	13936177235889740879
0xfc00face00000000000000000000000000000000	false	16	28614278	0x9ca8b0a4fc6cacbeadc4b2013579094ea76f574e	2022-01-21T05:45:23.000Z	16	0x18a37d25a79c5333b05ecc53c363421154b21cfa974b9b7150ef2ae55879729f	14936684075309242044	4278150678490745692	6530739226848837786
0xfc00face00000000000000000000000000000000	false	36	28641984	0x2421505a47fd5bdcf10406449bc99af08f3606e3	2022-01-21T12:33:07.000Z	63	0x546436c59d97ea8f1e52ef57a69f3c42e5b94c6d3c99babd7db58fb724fb7e84	217237605699271	473353648574520760661	1104491846673881776769

Example Query

Query with partition filter

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

SFC_RestakedRewards_event

Reward restaking events from Fantom’s SFC (Staking Fluid Contract) where delegators compound their staking rewards back to validators. Tracks unlocked rewards, base lockup rewards, and extra lockup bonuses for analyzing delegator compounding behavior and validator reward distribution.

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_delegator`	`STRING`	Address of the delegator participating in the staking or delegation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_toValidatorID`	`STRING`	Identifier of the validator receiving the delegation or associated with the staking operation. Numeric string value.
`in_lockupExtraReward`	`STRING`	Amount of extra staking rewards (in wei) earned during the lockup period that are being restaked. This represents the bonus portion of rewards on top of the base lockup reward.
`in_lockupBaseReward`	`STRING`	Base staking reward amount in wei (smallest FTM unit) that the delegator restaked with lockup commitment to the validator. This value represents the standard reward component before any additional bonuses from the lockup period.
`in_unlockedReward`	`STRING`	Amount of unlocked staking rewards being restaked to the validator, denominated in wei (1e-18 FTM). Represents the portion of rewards not subject to lockup periods, commonly zero when all rewards are locked.

Sample Data

address	removed	log_index	block_number	in_delegator	block_timestamp	in_toValidatorID	transaction_hash	in_unlockedReward	in_lockupBaseReward	in_lockupExtraReward
0xfc00face00000000000000000000000000000000	false	7	18964660	0x1ab83b2b586ab88e0f232430e355feee88aa96f6	2021-10-13T03:00:09.000Z	1	0xbba7dc970c3880a726a2fe6d7dd4a60bdf602c42da451690c2fb9c206d068247	0	1143038266556460919	2030547361325494802
0xfc00face00000000000000000000000000000000	false	43	18987445	0x26fcbd3afebbe28d0a8684f790c48368d21665b5	2021-10-13T10:02:14.000Z	1	0xd756e9d4fb79b510376c76be38a28ead90fbe1ed90000e9d5fa7924e80cc2e1b	31161602221131072000	89163396541290351000	61120239790117610774
0xfc00face00000000000000000000000000000000	false	14	18980803	0x42594969648d28c92fb85da50f356fd9f6c8a2a6	2021-10-13T07:54:52.000Z	1	0xdc1ac343b1c2ed3f6eab7db48b10c8e8351b132fc26a56983943f7daa5073875	0	9689927296265311238	5079468737950948516

Example Query

Query with partition filter

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

SFCV1_ClaimedDelegationReward_event

Delegation reward claim events from Fantom’s SFC (Staker Fluid Consensus) V1 contract, recording when delegators withdraw staking rewards across epoch ranges. Useful for analyzing reward distribution patterns, delegator behavior, and validator economics on Fantom Opera mainnet.

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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_stakerID`	`STRING`	Numeric identifier of the validator node to which the delegator has staked tokens on Fantom’s SFC (Staking for Consensus) contract. This ID references the specific validator receiving the delegated stake, visible in sample values ranging from 1 to 29.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromEpoch`	`STRING`	Starting epoch from which delegation rewards are being claimed in this transaction. Epoch numbers on Fantom increment sequentially and represent periods of validator activity.
`in_untilEpoch`	`STRING`	Ending epoch (inclusive) for the delegation reward claim period. Represents the last epoch included in the reward calculation for this claim event.

Sample Data

address	in_from	removed	in_reward	in_stakerID	block_number	in_fromEpoch	in_untilEpoch	block_timestamp	transaction_hash
0xfc00face00000000000000000000000000000000	0x5767eae9d324997eb36739b32fc0039ed3ecfe43	false	0	20	243647	898	1097	2020-07-09T03:20:34.000Z	0x0c2fcf7878c7af073969481d2beda40361847240bbff62292944cccf83a67aee
0xfc00face00000000000000000000000000000000	0x5767eae9d324997eb36739b32fc0039ed3ecfe43	false	0	20	243649	1098	1187	2020-07-09T03:21:34.000Z	0xf143bc66f595ec24183243d4d26996f938dcba7713be8824b783161ad6410401
0xfc00face00000000000000000000000000000000	0xa0ee21b247eddf340f1d89d47b5d68c587037286	false	11063210109903575570	9	246456	1183	1191	2020-07-09T17:00:15.000Z	0x321907509ae709189a4121ba0651f2a4a72ff7a394adabc700868c7b51c78ee0

Example Query

Query with partition filter

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

SFCV1_ClaimedValidatorReward_event

Validator reward claim events from Fantom’s SFC (Staking Fluid Contract) V1, tracking when validators withdraw staking rewards for specific epoch ranges. Useful for analyzing validator economics, reward distribution patterns, and staking yield calculations on Fantom Opera.

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_stakerID`	`STRING`	Numeric identifier for the validator claiming rewards from Fantom’s staking contract. Each validator on the network is assigned a unique staker ID used to track their staking operations and reward claims.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
`in_fromEpoch`	`STRING`	Starting epoch number from which validator rewards were accumulated and claimed in this transaction. Epochs are sequential time periods in Fantom’s consensus mechanism, typically spanning multiple blocks.
`in_untilEpoch`	`STRING`	Ending epoch number for the reward claim period on Fantom’s Special Fee Contract (SFC). Validators claim accumulated rewards for epochs between fromEpoch and untilEpoch inclusive.

Sample Data

address	removed	in_reward	in_stakerID	block_number	in_fromEpoch	in_untilEpoch	block_timestamp	transaction_hash
0xfc00face00000000000000000000000000000000	false	10583543870680983800894	13	249229	1188	1194	2020-07-10T06:59:50.000Z	0x2c0f074ca952619819c8e421c87a873b385006015f022a0b18ef4298eb772dbf
0xfc00face00000000000000000000000000000000	false	589792614037372258870504	14	540807	1232	1431	2020-08-31T15:34:32.000Z	0xd2b557f6c9972b3ab992fe728971f4ba1e8ff2ac56f9e9d4201d520897f0a3f8
0xfc00face00000000000000000000000000000000	false	562507396529418950465	15	536017	1526	1526	2020-08-31T02:00:59.000Z	0x84be43a89b9319dced27970eb90d347d9a1ffe8649ebe13fec5cb169a8703929

Example Query

Query with partition filter

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

SFCV1_UnstashedRewards_event

Staking reward withdrawal events from Fantom’s SFC (Staking Fluid Contracts) V1 system, emitted when validators or delegators claim accumulated rewards. Used for tracking reward distribution patterns and validator earnings on Fantom network.

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_auth`	`STRING`	Address authorized to unstash rewards on behalf of the receiver in the Fantom SFC (Staking Rewards Contract) system. Typically matches `in_receiver` when stakers claim their own rewards.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewards`	`STRING`	Amount of rewards in the smallest token unit. Numeric string representation of wei or equivalent base unit value.

Sample Data

address	in_auth	removed	in_rewards	in_receiver	block_number	block_timestamp	transaction_hash
0xfc00face00000000000000000000000000000000	0xde3cfecd08c8a4338d1d12706a82db0ea639ee72	false	1958031213764251988335	0xde3cfecd08c8a4338d1d12706a82db0ea639ee72	216321	2020-07-04T07:45:40.000Z	0xbd4d8e2d08b67a23633159a589229bec5a4cf38c59f83a28637314335b734a9e
0xfc00face00000000000000000000000000000000	0x55b68dcbdd8da887b53e9a53d416822578dce931	false	6804339664017320003330	0x55b68dcbdd8da887b53e9a53d416822578dce931	216492	2020-07-04T08:15:58.000Z	0xcd74e8cc1ccef169c12d18b8916ac36bb4f876369365bd16b04c4989acc266f1
0xfc00face00000000000000000000000000000000	0x39ea2261cb7e54ab8a610835abcdbf1281c115ff	false	2336816217452078263855	0x39ea2261cb7e54ab8a610835abcdbf1281c115ff	220694	2020-07-04T21:13:26.000Z	0x6951d1c2916f3068cda902769a6eb2db4cc17561760db6781dc22585b8f92be1

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ERC721_Transfer_event

SFC_ClaimedRewards_event

SFC_RestakedRewards_event

SFCV1_ClaimedDelegationReward_event

SFCV1_ClaimedValidatorReward_event

SFCV1_UnstashedRewards_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​ERC721_Transfer_event

​SFC_ClaimedRewards_event

​SFC_RestakedRewards_event

​SFCV1_ClaimedDelegationReward_event

​SFCV1_ClaimedValidatorReward_event

​SFCV1_UnstashedRewards_event

Tables

ERC721_Transfer_event

SFC_ClaimedRewards_event

SFC_RestakedRewards_event

SFCV1_ClaimedDelegationReward_event

SFCV1_ClaimedValidatorReward_event

SFCV1_UnstashedRewards_event