Skip to main content

Tables

FlowFees_FeeParametersChanged_event

Flow blockchain transaction fee parameter update events from the FlowFees contract. Tracks changes to inclusion effort cost, execution effort cost, and surge factor multipliers for analyzing network fee economics and governance decisions.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_executionEffortCostSTRINGCost parameter for transaction execution effort in the FlowFees contract fee model, denominated in Flow tokens. Values range from 0 to 4000, reflecting computational resource pricing that can be adjusted through network governance.
in_inclusionEffortCostSTRINGCost parameter for including a transaction in a Flow block, denominated in FLOW tokens. Values are typically very small (1e-06 to 0.0001) and represent the base fee charged per transaction for network inclusion.
in_surgeFactorSTRINGMultiplier applied to base transaction fees during periods of network congestion on Flow. Typically 1.0 during normal conditions, increasing above 1.0 when demand is high.
addressblock_idevent_nameevent_indexblock_numbercontract_namein_surgeFactortransaction_idblock_timestampin_executionEffortCostin_inclusionEffortCost
f919ee77447b7497b2a01e2c58bbf6ff1e975001976ba132a27dd12fa746720799ec1cac8cb3afddFeeParametersChanged027341023FlowFees18f1c6437b785813ddecaa019b303b23793c797ade4336fbf614ee178376bdd632022-04-06T15:04:15.571207000Z01e-05
f919ee77447b7497c64b88e6ac133db1f81e1ebd7b719c6716347a04507f23c3e3c1670d27188896FeeParametersChanged030872622FlowFees1cc6fdc3847de02414ce6f4ac944e3fb6c99b2dec2073f5d3f23da42a4ef36dd22022-06-01T14:59:23.506515000Z4.990499051e-06
f919ee77447b7497c92f0dbaa30b1cf2bff3ef25f1a4f7b38174a3ad36cb7f34468b446642ee343dFeeParametersChanged0125605123FlowFees1.0177891fb148ed2c61f1418b3f91a419d1a4c7e65ab797fcc9011254b874ce907f2025-09-08T14:59:21.923505000Z24.992499241e-06
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowFees_FeeParametersChanged_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowFees_TokensDeposited_event

Token deposit events from the FlowFees contract on Flow blockchain, capturing fee-related token movements into the protocol’s fee collection account. Used for tracking protocol revenue and fee accumulation patterns.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressblock_idin_amountevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestamp
f919ee77447b74970000c65d2b30ef6a1434f9e77b88924c292c745172677cbd1b41805113accf130TokensDeposited6116465054FlowFees809b20b4988255583f09539e869e17878e26f37bde000b090fada1756eca3d202025-06-15T06:28:11.532812000Z
f919ee77447b7497001232d949ea193dfe91bc32127e6411390bc7e383cec7a5310e488f633b4cbd0TokensDeposited6116485040FlowFees71ac73690a78c0f01a8f5c2f7dd6a00bcb206e089c8ae7c32bbff53c6fd22a8e2025-06-15T10:55:12.403755000Z
f919ee77447b7497002fcb9de1c3c0f3c4d382e5f85b3911baa1fde1167b543722d41b57102ae1800TokensDeposited6116446126FlowFees24bc5d974b943cccdee258c579a6a23a21c2e02b32e12fcec4f0e0ba5a9995292025-06-15T02:15:26.449301000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowFees_TokensDeposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowFees_TokensWithdrawn_event

Token withdrawal events from the FlowFees contract on Flow blockchain, capturing FLOW token amounts withdrawn from the fee collection address. Used for tracking protocol fee distribution and treasury management 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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressblock_idin_amountevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestamp
f919ee77447b7497b1c37c373cc1d7610395ec9f27a748f192a350928eb79282512d1cbc7262f9d970.40485509TokensWithdrawn141881384FlowFeesaa890ff09415b12005a0c233d09282abec26aaa8c42990259f3b4fc30d50f0d22022-11-30T16:00:29.526879000Z
f919ee77447b74972382a96b6491d7de71690c1df749b11ad1275801ab20d1acfff452d01509a69122.50866TokensWithdrawn125568454FlowFees64a8781b0c6873d98ec30d5ef6ee296dcdddf93a8c2ec2e4378a6cfaea6b26312022-03-09T15:58:42.401769000Z
f919ee77447b7497426b605e653b8932bfcb94a9692036c85028b722a8cc4fb6521828834b2768f720.4645TokensWithdrawn122692277FlowFeesc1541b18ddd377983be4eda812100fb4b4baf5face603e6616e0f7d0391f8ddb2022-01-12T16:01:41.428027000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowFees_TokensWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_DelegatorRewardsPaid_event

Staking reward distribution events for delegators on Flow blockchain’s ID Table Staking contract. Tracks FLOW token rewards paid to individual delegators per validator node for analyzing delegation yield and validator performance.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_delegatorIDSTRINGUnique identifier for the delegator in the Flow staking system. Numeric string representing the delegator’s ID assigned when they register to delegate tokens to a validator node.
in_epochCounterSTRINGEpoch number during which the delegation reward was earned and distributed. Appears to be null in recent reward distributions, suggesting this field may be deprecated or conditionally populated.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
addressblock_idin_amountin_nodeIDevent_nameevent_indexblock_numbercontract_namein_delegatorIDtransaction_idblock_timestampin_epochCounter
8624b52f9ddcd04ac21595f8a22a9fcc35e6c3eb22b01dec229bbdcfa34af65991b9b696d6705c808.67778962022699aba098bce3eb3a8709f29feafa9793f65de7d24d37a46310d788cbcc74DelegatorRewardsPaid3905446272125FlowIDTableStaking139d04af347f25985fcc94f96c07a67c487ba25724911a054d3a69ca2a0f96b14632023-02-08T15:07:10.072717000Z
8624b52f9ddcd04ac21595f8a22a9fcc35e6c3eb22b01dec229bbdcfa34af65991b9b696d6705c800.26987948022699aba098bce3eb3a8709f29feafa9793f65de7d24d37a46310d788cbcc74DelegatorRewardsPaid3867946272125FlowIDTableStaking180d04af347f25985fcc94f96c07a67c487ba25724911a054d3a69ca2a0f96b14632023-02-08T15:07:10.072717000Z
8624b52f9ddcd04ac21595f8a22a9fcc35e6c3eb22b01dec229bbdcfa34af65991b9b696d6705c800.09906983022699aba098bce3eb3a8709f29feafa9793f65de7d24d37a46310d788cbcc74DelegatorRewardsPaid3888646272125FlowIDTableStaking193d04af347f25985fcc94f96c07a67c487ba25724911a054d3a69ca2a0f96b14632023-02-08T15:07:10.072717000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_DelegatorRewardsPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_DelegatorTokensStaked_event

Delegation staking events from Flow blockchain’s ID Table Staking contract, recording when delegators stake FLOW tokens to validator nodes. Used for analyzing delegation patterns, staking amounts, and delegator-to-node relationships in Flow’s Proof of Stake consensus.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_delegatorIDSTRINGUnique identifier for the delegator in the Flow staking system. Numeric string representing the delegator’s ID assigned when they register to delegate tokens to a validator node.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
addressblock_idin_amountin_nodeIDevent_nameevent_indexblock_numbercontract_namein_delegatorIDtransaction_idblock_timestamp
8624b52f9ddcd04a4d8adbd42affeedf6a3f62f2fed3ed1fe5566d2c3a3c10511c4108a9ce144a8538.314263093132ae6b090b3cf3b14d5da282e8a9cc6e5158342a83354c4fd27d5263416eDelegatorTokensStaked363813392497FlowIDTableStaking63359c9660c0410fc8f7d8dc180c958a4eabb2f04af24f442c7c0592dd64627f32021-04-07T05:04:04.213042000Z
8624b52f9ddcd04a4d8adbd42affeedf6a3f62f2fed3ed1fe5566d2c3a3c10511c4108a9ce144a85310.49114303093132ae6b090b3cf3b14d5da282e8a9cc6e5158342a83354c4fd27d5263416eDelegatorTokensStaked363513392497FlowIDTableStaking33359c9660c0410fc8f7d8dc180c958a4eabb2f04af24f442c7c0592dd64627f32021-04-07T05:04:04.213042000Z
8624b52f9ddcd04a4d8adbd42affeedf6a3f62f2fed3ed1fe5566d2c3a3c10511c4108a9ce144a852697.27559974129aab6407f6f66774ce77a03b8abd1ba67317eab1c70c5c6cdd7a433a7d64e8DelegatorTokensStaked364713392497FlowIDTableStaking63359c9660c0410fc8f7d8dc180c958a4eabb2f04af24f442c7c0592dd64627f32021-04-07T05:04:04.213042000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_DelegatorTokensStaked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_DelegatorTokensUnstaked_event

Delegator unstaking events from Flow blockchain’s ID Table Staking contract, capturing when delegators withdraw staked FLOW tokens from validator nodes. Useful for tracking delegation withdrawals and validator node liquidity changes.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_delegatorIDSTRINGUnique identifier for the delegator in the Flow staking system. Numeric string representing the delegator’s ID assigned when they register to delegate tokens to a validator node.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
addressblock_idin_amountin_nodeIDevent_nameevent_indexblock_numbercontract_namein_delegatorIDtransaction_idblock_timestamp
8624b52f9ddcd04ac8dc26e845f7ae5cb968ef6893df755acb9b8a40e3a506262295e6e13086e54a5.152763492cfab7e9163475282f67186b06ce6eea7fa0687d25dd9c7a84532f2016bc2e5eDelegatorTokensUnstaked2111089080FlowIDTableStaking1127679a211ff5b5847a2af42cc846788fdbfa11142fa9f151a76b465b28df5e8ffc42025-04-26T10:12:48.920888000Z
8624b52f9ddcd04a49619324b0d666553819b3a0ee81037f4c6e47705784584b0b0eba4798fdaaa701408c08272beb24ad4fe4e531a9b937a26ee72c5f56b50ac8f2b889c3c42d316DelegatorTokensUnstaked0133964054FlowIDTableStaking201c2737ceae9d3bef0ebece99c2ec085a2ed20b2d9030a643230fb1542a0f008172025-11-25T19:46:37.786Z
8624b52f9ddcd04a556bb786b56ec3662cf0af8458e1a32268aef9a20de39c00f2c1f5d3a36e01340f441ce06e155367c05c941b68fdb1bb3f0cb9efe0d8cc9a9932d7d1dbfd13f2cDelegatorTokensUnstaked0133929970FlowIDTableStaking244b75417274a2c683e1be02ca0e551d95d6b9c85bdc27708a2e8ff925f24b9c42025-11-25T12:12:04.984Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_DelegatorTokensUnstaked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_NewDelegatorCreated_event

NewDelegatorCreated events from Flow blockchain’s ID Table Staking contract, recording when accounts create new delegator positions to stake tokens with validator nodes. Contains delegator IDs, associated node IDs, and creation timestamps for analyzing staking participation and validator delegation patterns.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_delegatorIDSTRINGUnique identifier for the delegator in the Flow staking system. Numeric string representing the delegator’s ID assigned when they register to delegate tokens to a validator node.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
addressblock_idin_nodeIDevent_nameevent_indexblock_numbercontract_namein_delegatorIDtransaction_idblock_timestamp
8624b52f9ddcd04a45b124c5152b4438c2337e5886a3b2c7725bbf2114ef118519941f3576c5a21e2cfab7e9163475282f67186b06ce6eea7fa0687d25dd9c7a84532f2016bc2e5eNewDelegatorCreated013530336FlowIDTableStaking3522733426e431757511160cdb2569ea381ca5333cc330f20e1504454c1892c5e1a62021-04-12T08:19:56.669004000Z
8624b52f9ddcd04a4d3ae5dc13da3b2a54e5f01771a739de1e2dda321fbebc4aa431ead9adfb50c82cfab7e9163475282f67186b06ce6eea7fa0687d25dd9c7a84532f2016bc2e5eNewDelegatorCreated013530323FlowIDTableStaking35219fd611d8bc6731516616ee1dc03192a589ca584ec684e9be4d69b552dea85bff2021-04-12T08:19:23.604545000Z
8624b52f9ddcd04aa6992224fbb0244a89b3971cadbc08eb8404146cda5abbe2304dfa3b3a0457012cfab7e9163475282f67186b06ce6eea7fa0687d25dd9c7a84532f2016bc2e5eNewDelegatorCreated013538307FlowIDTableStaking3534e7cc90695d62a6c43da491e261ae7c20db266ccbe0630f44c06beca763f37c3d2021-04-12T15:06:12.694945000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_NewDelegatorCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_NewEpoch_event

Epoch transition events from Flow blockchain’s staking contract, recording when new staking periods begin with total staked amounts and reward payouts. Used for analyzing Flow validator economics, staking participation trends, and network reward distribution over time.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_newEpochCounterSTRINGSequential counter tracking the epoch number in Flow’s staking system, incrementing with each new epoch period. Values are null in earlier epochs before this field was implemented, then appear as incrementing integers (e.g., ‘145’) in later blocks.
in_totalRewardPayoutSTRINGTotal FLOW tokens paid as staking rewards at the start of this epoch. Denominated in FLOW with variable decimal precision as seen in sample values.
in_totalStakedSTRINGTotal amount of FLOW tokens staked across all validators at the start of the new epoch. Values are decimal strings representing FLOW token amounts, typically ranging from millions to over a billion tokens.
addressblock_idevent_nameevent_indexblock_numbercontract_namein_totalStakedtransaction_idblock_timestampin_newEpochCounterin_totalRewardPayout
8624b52f9ddcd04aaa11b50dd854e4b870c71aa0357096332ad8d719e5bc4b4a06dd9068dd7e7cd8NewEpoch699724825FlowIDTableStaking230625413bb00d7fa34156a2267a87ca7b33e608fad763dc08ec5dc436011b25bad708d22020-12-09T08:13:35.501916000Z1173391
8624b52f9ddcd04a9b7ccf72576e61e905132855ceee32cb5d21ad570d56e72c99470f6274ac832fNewEpoch3648320731158FlowIDTableStaking724038718.9085742be839d4aab6a6443e1c6f16c77f7ee9134b3d923893c6ba8aa90b08647762bfe2021-11-23T15:53:48.703447000Z1244474
8624b52f9ddcd04a1b5097d3bc9c37b4bde1473b83a507c3046d137beff1f706c2866c66f4600ea9NewEpoch489132001991FlowIDTableStaking723680582.2250525b4fc3d14db4df4040e530f63d9debbecab0a587e20a039320e286d42261522e52022-06-22T17:39:10.938990000Z1280001
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_NewEpoch_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_NewNodeCreated_event

Node registration events from Flow blockchain’s ID Table Staking contract, capturing when new validator or node operator accounts join the staking system. Records node identifiers, assigned roles (validator types), and initial stake commitments for analyzing network participation and validator onboarding patterns.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountCommittedSTRINGInitial amount of FLOW tokens committed by the node operator at registration time. Numeric value stored as string, typically ‘0’ for new nodes or a positive integer representing committed stake amount.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
in_roleSTRINGRole identifier for access control. 66-character keccak256 hash including 0x prefix.
addressin_roleblock_idin_nodeIDevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestampin_amountCommitted
8624b52f9ddcd04a51c92aa31b963d43e0ef2e0e8142d2120928bf29aa5a67cf2829b8e569dd7191f5952ff4b235c05973dee13f815ef572cd8011a89a77dc55689c77af369eb4597NewNodeCreated447968978FlowIDTableStaking453d3b609827bee26d1561bfd2e4d0f89efa72e559d624140121412588724fb52023-03-07T14:08:11.738713000Z0
8624b52f9ddcd04a41896942dde9296f4628829548474416533af7101a0812c4240f95286a7a432e855069e7e8926867bee8094bd31786f8f6b65c8c3bde468ae2275f33dc1245dc1NewNodeCreated113582011FlowIDTableStakingdc00b61b89dcaf3d6bb9a861d9abb4b1e6c011565f681ea8912b3ceb40068d002021-04-14T05:38:06.200720000Z135000
8624b52f9ddcd04a560232b71e6da0c6ab97b46054f855aed5e6641dbe7ff00053bf92312aee1bd1c55501da7d7db34bd63d27f97a6c8f73c6372958f77f3292cb00eb12555737061NewNodeCreated119036878FlowIDTableStaking4c4dd7f2a8b1fc4655cabf3fd450d57d4c9b63252903c7d0029ab2cc1d58cd352021-10-06T05:00:40.947544000Z0
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_NewNodeCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_NewWeeklyPayout_event

Weekly staking reward announcements from Flow blockchain’s IDTableStaking contract, emitted when new FLOW token payout amounts are set for validator and delegator rewards. Used for tracking staking yield changes and reward distribution patterns over time.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_newPayoutSTRINGWeekly staking reward payout amount denominated in FLOW tokens (smallest unit). Values typically range from 1.19M to 1.33M FLOW per week based on network emission schedule.
addressblock_idevent_nameevent_indexblock_numberin_newPayoutcontract_nametransaction_idblock_timestamp
8624b52f9ddcd04a78d79d190d199bb8b38dc674b04aec9353fb3d81f4da1c8aa8fe7f6985bd814eNewWeeklyPayout0120055361198633FlowIDTableStaking0c769bbdcc15c1ee08223cd74556c0e513a614ce38c34936118392f7fbbc8d222021-02-17T06:33:20.314038000Z
8624b52f9ddcd04a956430329182777d4f574458bccac940dd0845b76c53bd7f6ace05675e453c3aNewWeeklyPayout49874498228461330201FlowIDTableStakingb8b3d3a1dd4f8e36eb61c82d2acf5a807860460eb111a12f5d9a1c3025d661b32023-04-05T14:52:27.440819000Z
8624b52f9ddcd04a305d92eb446977d0e933cebfe0d93b842bacd8d7cb29c9aa9ae5ce6af74e1c7fNewWeeklyPayout0115311371196386FlowIDTableStaking085523d833938f1120a392cb788b95dd36d624bb0407c791931098c85d77d54b2021-02-03T06:13:14.950019000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_NewWeeklyPayout_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_RewardsPaid_event

Staking reward distribution events from Flow blockchain’s ID table staking contract, recording reward amounts paid to validator nodes. Used for analyzing validator earnings, reward distribution patterns, and staking economics across epochs.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_epochCounterSTRINGEpoch counter identifying which staking epoch the rewards were distributed for. Value is null in some historical events.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
addressblock_idin_amountin_nodeIDevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestampin_epochCounter
8624b52f9ddcd04ae2e792b8a36ea694fda869b29ffe36131d26e50e5a219cd6dc865e5164fef0df1555.46100b7793649e34f52e38c6848e036c2e408f9594bdce4eb6e414b763727d07c9aRewardsPaid402928649943FlowIDTableStaking1e75bcd5b38b498b3eb622d11e6e65d2f315f1584ed8e6eb3164f85784f979d72022-04-27T14:51:28.454880000Z
8624b52f9ddcd04ae2e792b8a36ea694fda869b29ffe36131d26e50e5a219cd6dc865e5164fef0df1555.461097e5e879e9c93f7e45f696b64f701f70215608b337ccfbc13ca3370f7a9e617RewardsPaid3219328649943FlowIDTableStaking1e75bcd5b38b498b3eb622d11e6e65d2f315f1584ed8e6eb3164f85784f979d72022-04-27T14:51:28.454880000Z
8624b52f9ddcd04ae2e792b8a36ea694fda869b29ffe36131d26e50e5a219cd6dc865e5164fef0df1555.4610a29d8eb288d9bb0a0a4f2f9ff180ec83617659998ce363814048ec1683083e0RewardsPaid106528649943FlowIDTableStaking1e75bcd5b38b498b3eb622d11e6e65d2f315f1584ed8e6eb3164f85784f979d72022-04-27T14:51:28.454880000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_RewardsPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_TokensStaked_event

Token staking events from Flow blockchain’s ID Table Staking contract, recording when FLOW tokens are delegated to validator nodes. Useful for analyzing staking behavior, validator node activity, and network security participation patterns.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
addressblock_idin_amountin_nodeIDevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestamp
8624b52f9ddcd04ac5097d17dbc2bc07b0fecad7b96fdf24898a980c7f6ae9a5c3e568fbc3f999071965.14082387b5e3cdbeb4986460b57a5a363789bb587eae7bff05589dcd122bcedc62be6664TokensStaked2098840229372FlowIDTableStakinge28f75b428dcf37d68b7a5a4f45bd61264685f1be5b7bbaea39500c4da257cce2022-11-03T15:01:13.957832000Z
8624b52f9ddcd04ac5097d17dbc2bc07b0fecad7b96fdf24898a980c7f6ae9a5c3e568fbc3f999071996.96714474166d1b52831da570fb37f0d85ded5d164937bc7ae976a6037bc33a77c3113735TokensStaked126640229372FlowIDTableStakinge28f75b428dcf37d68b7a5a4f45bd61264685f1be5b7bbaea39500c4da257cce2022-11-03T15:01:13.957832000Z
8624b52f9ddcd04ac5097d17dbc2bc07b0fecad7b96fdf24898a980c7f6ae9a5c3e568fbc3f9990730005dc67a4f47ea9ce55d1b63ebe04cc68d8b29c41e40ab5cdc63b108ce292139a0TokensStaked90340229372FlowIDTableStakinge28f75b428dcf37d68b7a5a4f45bd61264685f1be5b7bbaea39500c4da257cce2022-11-03T15:01:13.957832000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_TokensStaked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowIDTableStaking_TokensUnstaked_event

Token unstaking events from Flow blockchain’s ID Table Staking contract, recording when validators withdraw their staked FLOW tokens with amounts and node identifiers. Used for tracking validator participation changes and staking liquidity movements.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_nodeIDSTRINGIdentifier for the staking node in the Flow blockchain network. Hex-encoded, 64-character string without 0x prefix.
addressblock_idin_amountin_nodeIDevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestamp
8624b52f9ddcd04a8f57a284273d3d6e1d7f9a8498d2ca937aeec11f99bda43de7a69877860cd9a494121.96fabe5c7917f1368d0a01dde06da7e7b6da8ea8e872e62f4853afbc536ea8d59dTokensUnstaked1930614147586FlowIDTableStaking7c79febe209178851e4c6b0c1d9bf89955f89783ea8f9ace65e4c442ddd16e7d2021-05-04T15:16:48.852593000Z
8624b52f9ddcd04a968cbbc7a458584dd6e25ec6f9d0921fe2208992cfa3779ff57cc33d172be7182466.57452259a494a83f3eee8d95c49931a26483907aabe7bf8d6325a777b9033734756614f1TokensUnstaked081105570FlowIDTableStaking28f0e5621537c1d59aa038c08fdd35c20be494e86cf8aa018830cef3be3b00b12024-06-25T17:48:51.537126000Z
8624b52f9ddcd04a7ce8eeeb00ed4c4468dfc73f84efd8ecf5b4d3122d9a162b6dcd4f1d577733510c623076c01936f0eaadf1f8a6c618b087e8c88f00ad297db30a3172d8cd4d252TokensUnstaked2128904832FlowIDTableStaking3d4c8a6a5ba663bb3534a8a315e67968ace60daa10a3c2344011137a17edf33d2025-10-09T16:17:07.250140000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowIDTableStaking_TokensUnstaked_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowSystemContract_AccountContractAdded_event

Flow blockchain system events recording when smart contracts are deployed to accounts. Captures contract deployments with account addresses, contract names, and transaction details for tracking protocol and application deployment activity on Flow.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_addressSTRINGFlow account address where the contract was deployed. Hex-encoded, 0x-prefixed 16-character string identifying the account that added the smart contract.
in_codeHashSTRINGHash of the deployed contract code, used to verify contract integrity. Typically null in Flow events as code verification happens through other mechanisms.
in_contractSTRINGName of the smart contract being added to the Flow account. Corresponds to the contract identifier deployed at the specified address.
addressblock_idevent_namein_addressevent_indexin_codeHashin_contractblock_numbercontract_nametransaction_idblock_timestamp
FlowSystem4846ce277bdca9709e85ef5b19422509cbcd8376a6676a83789d571bc028c7a6AccountContractAdded0xebaf60543429f9a51Pess82738281FlowSystemContractdd23615dfb06e49c1acabe9f5eb4b2f296857dd0fef70aed703cddca764f1f282024-07-19T11:25:58.018463000Z
FlowSystemb150e9cbf9bea82521555028474a04316decd672da3199f96cb4abac28a3867dAccountContractAdded0xb2dac440af51dcd21NurseSarahBarker82744602FlowSystemContract5314e1cad4af377ef86f745508350d8b58c9ed5be25cb080d4c74646ba0aca502024-07-19T13:38:01.614149000Z
FlowSystemad3b7c2a1703e1d5b4d6f7653064bbc8ea290bc2355c72733852550e42ac3b38AccountContractAdded0x8bcaf9dacd3bb1251TokndNFT35961250FlowSystemContract0bba6e12450052385b2027987e7f68a24fb3f66c24b1f86a787a806bcf3733a72022-08-26T09:01:12.039796000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowSystemContract_AccountContractAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowSystemContract_AccountCreated_event

Account creation events from Flow blockchain’s system contract, recording new wallet addresses and their creation timestamps. Used for tracking network growth and user onboarding patterns.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_addressSTRINGFlow account address that was created in this event. Hex-encoded, 0x-prefixed 16-character identifier uniquely identifying the newly created Flow blockchain account.
addressblock_idevent_namein_addressevent_indexblock_numbercontract_nametransaction_idblock_timestamp
FlowSystem000cac72f5ec68c01e39c521dc7ab32a84178fbebc26fb6ae7e02fdf7a9748daAccountCreated0x00a4348b4875a9cc555439754FlowSystemContract4af383092c016b1e36dbfa160d9c3e10fa75226d043bee9d79d8dfb5b20d75422023-06-26T12:27:49.581869000Z
FlowSystem000cac72f5ec68c01e39c521dc7ab32a84178fbebc26fb6ae7e02fdf7a9748daAccountCreated0xe4c38d56598fa913555439754FlowSystemContract75a4aba7f0ab5d82533704042a80dbe3b019eddeb5e9978dc5d9ab0ef6f465822023-06-26T12:27:49.581869000Z
FlowSystem002f15261f72a0862b017bd9c50f227c8ebadbe92a3dd4dcc98d769d2659febcAccountCreated0xe9d36c7639f97baa555440224FlowSystemContractbf152f9de1c8ed6cd258035839a53064de4eb981eb7ba9ab6ce32c2a08eb749c2023-06-26T12:37:39.752485000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowSystemContract_AccountCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowSystemContract_AccountKeyAdded_event

Flow blockchain account key addition events capturing cryptographic key registration details including key index, hash algorithm, and signing weight. Tracks account key management for analyzing wallet security configurations and multi-signature setups.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_addressSTRINGFlow account address that received the new key, in 0x-prefixed hexadecimal format. Represents the account being modified by the key addition event.
in_hashAlgorithmSTRINGHash algorithm used for the cryptographic key being added to the Flow account. Typically represented as an enum value, with rawValue 1 commonly appearing in samples.
in_keyIndexSTRINGIndex position of the cryptographic key added to the Flow account. Typically starts at ‘0’ for the first key, incrementing for each additional key on the same account.
in_publicKeySTRINGPublic key that was added to the Flow account, encoded as a string. Typically null in event logs as the key material is not emitted for security reasons.
in_weightSTRINGVoting power or gauge weight allocated to a pool or account. Numeric string representation of wei-denominated value.
addressblock_idin_weightevent_namein_addressevent_indexin_keyIndexblock_numberin_publicKeycontract_nametransaction_idblock_timestampin_hashAlgorithm
FlowSystem3effc5573aaf5a53ce1da07b71232b89a8b97a9d48e240202d09281b5c5832b71000AccountKeyAdded0xceebe895f5be71d014090945076FlowSystemContract758c86e7aa25694e548c3402891ae15bd1e059b37717b48f39eb5f25637521812024-10-21T00:00:14.832984000ZHashAlgorithm(rawValue: 1)
FlowSystem290c6c0af651dfd2b5eab2c00257301c55656571eed7ef9a769ebcb0b032e5f61000AccountKeyAdded0xdd2a94ea8afb292b14090945100FlowSystemContract8183aff170054794079506d8ab33dd4a06a17ac96d783f98edfb61b779ac10dc2024-10-21T00:00:33.961819000ZHashAlgorithm(rawValue: 1)
FlowSystem0137cd432b984ee1aa5613410317d6c1060b215cf73b2c3e58a65a5ef6cfe0751000AccountKeyAdded0x394d2d379b0129f414090945121FlowSystemContract0b8e7db28b96db57f7dcbf68c5e17746ffc25ed1524845fc41cd58545f23b6052024-10-21T00:00:50.498235000ZHashAlgorithm(rawValue: 1)
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowSystemContract_AccountKeyAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowToken_TokensDeposited_event

FLOW token deposit events on the Flow blockchain recording incoming transfers to recipient addresses. Captures deposit amounts, recipient accounts, and transaction metadata for tracking token movement and wallet funding 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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressblock_idin_amountevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestamp
0x3653748f4f464a701654653399040a61ca149a2303993de2249d6cdaf27a18a775979137bfa9aa2450034564232cb9640.0001TokensDeposited176647445FlowToken7f10c6b18e28d5e6dc2c4d565ac805b7ccd4e6005815d1e4319ab0c457b496ff2024-04-22T00:00:00.091448000Z
0x38ec5f5a658266c31654653399040a61ca149a2303993de2249d6cdaf27a18a775979137bfa9aa2450034564232cb9640.0001TokensDeposited176647445FlowToken27d2b97d7c161c5c558741142bc597a4ec2a9c683764cd2ba0937707828406892024-04-22T00:00:00.091448000Z
0xcadf83b4ed7c6c7d1654653399040a61ca149a2303993de2249d6cdaf27a18a775979137bfa9aa2450034564232cb9640.0001TokensDeposited176647445FlowTokenfec840d4f065d3474a4966c88409ff435abbbd2becc51bd9b1c863126f2838b92024-04-22T00:00:00.091448000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowToken_TokensDeposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FlowToken_TokensWithdrawn_event

FLOW token withdrawal events from the FlowToken contract on Flow blockchain, capturing when tokens are moved from accounts. Used for tracking token outflows, account activity patterns, and transaction-level FLOW movements.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
addressin_fromblock_idin_amountevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestamp
1654653399040a610x8624b52f9ddcd04adea85f025065aa1905a5eba9cac4eb2be40bd3a68aed03eeed1b38d2fd9497be0TokensWithdrawn7321367173FlowTokenf7b8abc188bbcab32987ba0370f6b9ee5ab902a3ad7f2de66ba0824a715bf7f32021-12-10T16:05:01.305484000Z
1654653399040a610x8624b52f9ddcd04adea85f025065aa1905a5eba9cac4eb2be40bd3a68aed03eeed1b38d2fd9497be0TokensWithdrawn27121367173FlowTokenf7b8abc188bbcab32987ba0370f6b9ee5ab902a3ad7f2de66ba0824a715bf7f32021-12-10T16:05:01.305484000Z
1654653399040a610x8624b52f9ddcd04adea85f025065aa1905a5eba9cac4eb2be40bd3a68aed03eeed1b38d2fd9497be0TokensWithdrawn5821367173FlowTokenf7b8abc188bbcab32987ba0370f6b9ee5ab902a3ad7f2de66ba0824a715bf7f32021-12-10T16:05:01.305484000Z
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FlowToken_TokensWithdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FungibleToken_Deposited_event

Fungible token deposit events from Flow blockchain’s FungibleToken standard, capturing transfers into vaults with amounts, balance updates, and vault identifiers (UUIDs). Used to track token inflows across FlowToken, FUSD, and other fungible assets for wallet activity and token movement analysis.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_balanceAfterSTRINGAccount balance after the deposit transaction completes, denominated in the fungible token specified by in_type. Value stored as string to preserve decimal precision.
in_depositedUUIDSTRINGUnique identifier for the deposited vault resource in the Flow blockchain. Each deposit event generates a distinct UUID tracking the specific fungible token vault instance.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toUUIDSTRINGUnique identifier (UUID) of the receiving vault or account where the fungible tokens were deposited on Flow. Represented as a numeric string that corresponds to Flow’s resource identification system.
in_typeSTRINGType identifier for the Flow blockchain resource being transferred or operated on. Format follows Flow’s resource type notation: A.{contract_address}.{contract_name}.{resource_name}.
in_toaddressin_typeblock_idin_amountin_toUUIDevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestampin_balanceAfterin_depositedUUID
f233dcee88fe0abeA.1654653399040a61.FlowToken.Vault21c4a105d5f43228448ee16981e1fc84338684e42585f75e3dead3bd04ec2abe1.978124244815362541Deposited115107500694FungibleToken7f3d0fe7cf79145f990c919f3c4c5bebc00210ff624de19e9659e33b7b9142c02025-03-24T03:38:47.585893000Z1.978124244815362545
f233dcee88fe0abeA.1654653399040a61.FlowToken.Vault21c4a105d5f43228448ee16981e1fc84338684e42585f75e3dead3bd04ec2abe0.03956124244815362517Deposited49107500694FungibleToken7f3d0fe7cf79145f990c919f3c4c5bebc00210ff624de19e9659e33b7b9142c02025-03-24T03:38:47.585893000Z0.03956124244815362521
f233dcee88fe0abeA.1654653399040a61.FlowToken.Vault21c4a105d5f43228448ee16981e1fc84338684e42585f75e3dead3bd04ec2abe0.07912124244815362565Deposited181107500694FungibleToken7f3d0fe7cf79145f990c919f3c4c5bebc00210ff624de19e9659e33b7b9142c02025-03-24T03:38:47.585893000Z0.07912124244815362569
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FungibleToken_Deposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FungibleToken_Withdrawn_event

Fungible token withdrawal events from Flow blockchain’s FungibleToken standard, capturing when tokens (like FlowToken and USDCFlow) are removed from vaults with withdrawal amounts, vault UUIDs, account addresses, and post-withdrawal balances. Used for tracking token movements, analyzing wallet activity, and reconstructing account balance history on Flow.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_balanceAfterSTRINGAccount balance of the fungible token vault after the withdrawal transaction completes. Decimal string representing the remaining token amount in the source vault.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_fromUUIDSTRINGFlow account resource unique identifier (UUID) of the vault from which tokens were withdrawn. Numeric string representing the on-chain resource instance identifier on Flow blockchain.
in_typeSTRINGType identifier for the Flow blockchain resource being transferred or operated on. Format follows Flow’s resource type notation: A.{contract_address}.{contract_name}.{resource_name}.
in_withdrawnUUIDSTRINGUnique identifier for the specific withdrawal event instance on the Flow blockchain. This UUID distinguishes individual withdrawal occurrences even when the same vault is involved in multiple transactions.
addressin_fromin_typeblock_idin_amountevent_nameevent_indexin_fromUUIDblock_numbercontract_nametransaction_idblock_timestampin_balanceAfterin_withdrawnUUID
f233dcee88fe0abe0x7bb1e28c69407925A.1654653399040a61.FlowToken.Vault6f172360743247d0db0d879bb0166550a6b139af9d3ccc4f6a655ca36033c5fe1e-06Withdrawn1206845984130941690FungibleToken3ef830ea8e686d6b82d25618527dd3d7a02d63ad73853d9116937e7df1d675ef2025-10-28T19:53:22.448Z0.00416134195713071971234
f233dcee88fe0abe0xedf9df96c92f4595A.1654653399040a61.FlowToken.Vault33b1d1cd4e370568fec4761e7551f08bffe456e0465c0f810431a987f57bbabd2.874e-05Withdrawn51332776299130944003FungibleTokend0b443c86f3daa278305f158c75029b2029267b0ce6a5adf9fbd6775824760ca2025-10-28T20:24:13.812Z91.06084887257285723122665
f233dcee88fe0abe0x1b65c33d7a352c61A.1654653399040a61.FlowToken.Vault86868b573df0c3400c217be23b459d62aab699bbee6352f3982913e44119ae301.624e-05Withdrawn9114569256130924439FungibleToken934af67d42652c4937ce41118916041d5207bbf9c5a97d41c48e7808da760b872025-10-28T16:03:23.139Z946.32993427252887676628656
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.FungibleToken_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

NonFungibleToken_Deposited_event

NFT (Non-Fungible Token) deposit events on Flow blockchain, capturing when NFTs are transferred into user accounts with unique identifiers and collection metadata. Primarily used for tracking NBA Top Shot moments and other Flow NFT collection movements across wallets.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_collectionUUIDSTRINGUniversal unique identifier of the collection receiving the NFT on Flow. Appears as ‘0’ in standard deposit events based on the NonFungibleToken contract implementation.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_typeSTRINGType identifier for the Flow blockchain resource being transferred or operated on. Format follows Flow’s resource type notation: A.{contract_address}.{contract_name}.{resource_name}.
in_uuidSTRINGUnique identifier for the swap operation. 32-character hex string without 0x prefix.
in_idin_toaddressin_typein_uuidblock_idevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestampin_collectionUUID
455984600x648c4b604351c5c81d7e57aa55817448A.0b2a3299cc857e29.TopShot.NFT145453413555abfd7a7f95fb6c77321e7b681d1d2524f976ce23fc2c584638af24f032f5d9Deposited15130541463NonFungibleToken6a499a1a48de7a11fda075285f313029332f3bf5edf20eb1245272f53fc730c12025-10-25T02:54:51.560Z0
499719390x648c4b604351c5c81d7e57aa55817448A.0b2a3299cc857e29.TopShot.NFT271579373984969dfe47316da43f7daa4bb3bf5714c27fd81f7d7784170230a16aa0cdcf046e41bDeposited3130544414NonFungibleTokena1d2a116c3cfdb30b6f874d17f65e6f5a08d434bca50dedde34d7d66576105592025-10-25T03:34:12.030Z0
498950650xb0675bab0027d6601d7e57aa55817448A.0b2a3299cc857e29.TopShot.NFT118747257642836eb4023b68947755b079d6c76613eaa0a0512eb1b8fe0d845176b543d3e6f623fDeposited13130578424NonFungibleTokenbb12de9b098fb011bcdcc670e7a8cc8b37fe26d047b199edf8d768604559894f2025-10-25T11:07:39.560Z0
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.NonFungibleToken_Deposited_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

NonFungibleToken_Withdrawn_event

NFT withdrawal events from Flow blockchain’s NonFungibleToken standard, capturing when NFTs are removed from accounts with unique identifiers, token types, and source addresses. Useful for tracking NFT transfers, collection activity, and wallet inventory changes on Flow.
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.
block_idSTRINGUnique identifier for the block containing the event or transaction. Hex-encoded, 64-character string without 0x prefix.
transaction_idSTRINGUnique identifier for the transaction. Base58-encoded string for Solana transactions, hex-encoded string for Flow transactions.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
contract_nameSTRINGName of the smart contract that emitted the event. Human-readable string identifier for the contract within the Flow blockchain namespace.
event_nameSTRINGName of the blockchain event emitted by the contract. Human-readable string identifier indicating the specific action or state change that occurred.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_idSTRINGUnique identifier for the position, record, or entity within the protocol. Numeric string representation.
in_providerUUIDSTRINGUniversal unique identifier of the NFT provider or collection owner from which the token is being withdrawn. Appears as a numeric string identifier in Flow blockchain events.
in_typeSTRINGType identifier for the Flow blockchain resource being transferred or operated on. Format follows Flow’s resource type notation: A.{contract_address}.{contract_name}.{resource_name}.
in_uuidSTRINGUnique identifier for the swap operation. 32-character hex string without 0x prefix.
in_idaddressin_fromin_typein_uuidblock_idevent_nameevent_indexblock_numbercontract_nametransaction_idblock_timestampin_providerUUID
14797343081d7e57aa558174480x011dbf8099c6dabfA.0b2a3299cc857e29.PackNFT.NFT1479734308cfad06327d049795979433de251d20d67974842fbd8f74580217aff2e2bfcd77Withdrawn3125120054NonFungibleToken6735666619c89fbb1f4e8c4452bcb0052af9f0249f013cb8e99ee16a5bcbff3c2025-09-04T01:09:39.526740000Z1342768732
1627277229399321d7e57aa558174480x011dbf8099c6dabfA.0b2a3299cc857e29.PackNFT.NFT1627277229399323d3c7f1efb3723a1f70a957c9f3416681ca39c92a89a8980ccbde70f91202aedWithdrawn3125128603NonFungibleTokenc1dc9c3a4cdca02b25131387358233539a3535a85bed32e090d021bca68c80092025-09-04T03:03:49.857748000Z1342768732
1088516531802611d7e57aa558174480x011dbf8099c6dabfA.0b2a3299cc857e29.PackNFT.NFT1088516531802616c43b68ddc3ccb1dfc3f74bc995902690e7a7ef35c2b0f92b4a6e9479207ad82Withdrawn3125190720NonFungibleTokena66ff429a8aa9a67da8f3757bb09fa0826cecd0cab6d0b1a7c57bb116b9b19b62025-09-04T16:53:04.317733000Z1342768732
Query with partition filter
SELECT *
FROM `tt-contracts.flow_v1_flow.NonFungibleToken_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100