Skip to main content

Tables

Factory_DexT1Deployed_event

DEX deployment events emitted when a new decentralized exchange instance is created through a factory contract. Contains the deployed DEX address, sequential identifier, and the supply/borrow token pair configuration.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_dexSTRINGContract address of the decentralized exchange (DEX) deployment. Hex-encoded, 0x-prefixed, 42-character string.
in_dexIdSTRINGUnique identifier for the deployed decentralized exchange instance. String representation of a sequential integer.
in_supplyTokenSTRINGContract address of the token being supplied. Hex-encoded, 0x-prefixed, 42-character string.
in_borrowTokenSTRINGContract address of the token being borrowed. Hex-encoded, 0x-prefixed, 42-character string.
in_dexaddressremovedin_dexIdlog_indexblock_numberin_borrowTokenin_supplyTokenblock_timestamptransaction_hash
0x1dd125c32e4b5086c63cc13b3ca02c4a2a61fa9b0x91716c4eda1fb55e84bf8b4c7085f84285c19085false15147357999430x6bb7a212910682dcfdbd5bcbb3e28fb4e8da10ee0x211cc4dd073734da055fbf44a2b4667d5e5fe5d22025-09-20T17:27:13.000Z0x4e84341fc1bc1a2a9a63a8edb6f0bfe497594a9d9f7a5690af93574d0149066c
0x276084527b801e00db8e4410504f9baf93f72c670x91716c4eda1fb55e84bf8b4c7085f84285c19085false13621357999120x833589fcd6edb6e08f4c7c32d4f71b54bda029130x211cc4dd073734da055fbf44a2b4667d5e5fe5d22025-09-20T17:26:11.000Z0x1e1f01be7379d4e12f2830cb78c13e24241ca6a4534e738d118208d12fd36b42
0x080574d224e960c272e005aa03efbe793f3176400x91716c4eda1fb55e84bf8b4c7085f84285c19085false14259357999320x6bb7a212910682dcfdbd5bcbb3e28fb4e8da10ee0x5d3a1ff2b6bab83b63cd9ad0787074081a52ef342025-09-20T17:26:51.000Z0x2e5e07519cf789a7a9d2ab91bc4f0a454e72bb2999ed9190a4b9e76f922d68e1
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.Factory_DexT1Deployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Factory_LogDexDeployed_event

DEX deployment events emitted by Instadapp factory contracts containing the deployed exchange contract address and sequential identifier. Used for tracking new exchange instance creation and registry management.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_dexSTRINGContract address of the decentralized exchange (DEX) deployment. Hex-encoded, 0x-prefixed, 42-character string.
in_dexIdSTRINGUnique identifier for the deployed decentralized exchange instance. String representation of a sequential integer.
in_dexaddressremovedin_dexIdlog_indexblock_numberblock_timestamptransaction_hash
0x0b1a513ee24972daef112bc777a5610d4325c9e70x91716c4eda1fb55e84bf8b4c7085f84285c19085false1123257690082025-01-31T12:42:43.000Z0xb2c85dfcc1b63cc179643a0c9fccd20701791f0d6849d7994a59c7ad34022866
0x667701e51b4d1ca244f17c78f7ab8744b4c99f9b0x91716c4eda1fb55e84bf8b4c7085f84285c19085false2490300161602025-05-09T20:14:27.000Z0x06b44eaa642eda0c8269a1589145de1056f965099d914a2437ea7c8c26e2a6ee
0x3c0441b42195f4ad6aa9a0978e06096ea616cda70x91716c4eda1fb55e84bf8b4c7085f84285c19085false3328300161762025-05-09T20:14:59.000Z0x034f366216a1b109a73f22f953bc8401ae3293c295d75df7078587e1f50d79f8
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.Factory_LogDexDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Factory_VaultDeployed_event

Vault deployment events emitted by factory contracts when new vault instances are created. Records vault contract address and sequential vault identifier for tracking protocol-wide vault creation 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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_vaultSTRINGContract address of the vault. Hex-encoded, 0x-prefixed, 42-character string.
in_vaultIdSTRINGUnique identifier for a vault within the protocol. Numeric string representation.
addressremovedin_vaultlog_indexin_vaultIdblock_numberblock_timestamptransaction_hash
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2dfalse0xbec491fef7b4f666b270f9d5e5c3f443cbf20991602176159012024-07-26T19:12:29.000Z0x6644f73aca2ef6cc61811cb12caf20c660a8bad2a20650cbb52ad5c9b4160504
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2dfalse0xeabbfca72f8a8bf14c4ac59e69ecb2eb69f0811c501176159012024-07-26T19:12:29.000Z0x6644f73aca2ef6cc61811cb12caf20c660a8bad2a20650cbb52ad5c9b4160504
0x324c5dc1fc42c7a4d43d92df1eba58a54d13bf2dfalse0xa0f83fc5885cebc0420ce7c7b139adc80c4f4d91703176159012024-07-26T19:12:29.000Z0x6644f73aca2ef6cc61811cb12caf20c660a8bad2a20650cbb52ad5c9b4160504
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.Factory_VaultDeployed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FluidDex_Swap_event

Token swap events from FluidDex (Instadapp) decentralized exchange contracts recording input and output token amounts with directional swap indicators. Used for tracking DEX trading volume and price impact 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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_swap0to1BOOLBoolean flag indicating the swap direction, where true represents swapping from token0 to token1 and false represents swapping from token1 to token0.
in_amountInSTRINGAmount of input tokens being swapped or deposited in the transaction. Numeric string representing the token quantity in its smallest denomination.
in_amountOutSTRINGAmount of output tokens received from the swap. Numeric string representing the token quantity in its smallest denomination.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressremovedlog_indexin_amountInin_swap0to1block_numberin_amountOutblock_timestamptransaction_hash
0xc7d3ab410d49b664d03fe5b1038852ac852b1b290x0b1a513ee24972daef112bc777a5610d4325c9e7false1799637175448807931735true2639048431505657080000002025-02-14T21:58:35.000Z0x6adca9a9345ca1016aca05e98e8eba41fc9c7f27ee90ce2a2c1d3af34746b71a
0xbd59a718e60bd868123c6e949c9fd97185efbdb70x0b1a513ee24972daef112bc777a5610d4325c9e7false1404775423000000000000true2639048615254623760000002025-02-14T21:58:39.000Z0xef535895106c987d253c0c34678897a2813607637ee48e3dff5163b8f2d8634f
0xd28fb411e9b004feef57312c12f892504dcd54630x0b1a513ee24972daef112bc777a5610d4325c9e7false4181313539953522611false2639219741147036749430000002025-02-14T22:55:41.000Z0x5c61ad301d38896a0cdd65c26f53f67101cc8700da08de6db09a16f3d1b6e2b1
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.FluidDex_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FluidLendingFactory_LogTokenCreated_event

Event logs emitted when the Fluid Lending Factory contract creates a new lending token (fToken). Records the underlying asset address, created token address, token type (fToken or NativeUnderlying), and sequential count for tracking factory deployments.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_countSTRINGNumber of items or tokens involved in the transaction. Numeric string representation.
in_fTokenTypeSTRINGToken type classification for the created Fluid lending token. String value indicating the token wrapper variant such as “fToken” or “NativeUnderlying”.
addressremovedin_assetin_countin_tokenlog_indexblock_numberin_fTokenTypeblock_timestamptransaction_hash
0x54b91a0d94cb471f37f949c60f7fa7935b551d03false0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb4240x1943fa26360f038230442525cf1b9125b5dcb4013819720553fToken2024-09-13T12:27:33.000Z0x303907609fbe7787977e0ef33b6c63a37bff37f1ff5abd5e5187e929c158dfe3
0x54b91a0d94cb471f37f949c60f7fa7935b551d03false0x5875eee11cf8398102fdad704c9e96607675467a50xf62e339f21d8018940f188f6987bcdf02a84961921425139508fToken2025-01-16T22:59:23.000Z0xf4b1e08426de89b3a09f6749f2405ddb1a375dd841b202055711404fb04e7ddf
0x54b91a0d94cb471f37f949c60f7fa7935b551d03false0x420000000000000000000000000000000000000610x9272d6153133175175bc276512b2336be3931ce95717551731NativeUnderlying2024-07-25T07:33:29.000Z0x3ec32d03401438f5eefadb8efe95e0138af9d23b91fcc6fdefd70ffe08fa526a
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.FluidLendingFactory_LogTokenCreated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FluidLiquidity_LogCollectRevenue_event

Revenue collection events from Fluid Liquidity protocol recording token amounts collected as protocol fees. Contains token address and collected amount in smallest denomination for tracking protocol revenue across supported assets.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_tokenin_amountlog_indexblock_numberblock_timestamptransaction_hash
0x52aa899454998be5b000ad077a46bbe360f4e497false0x833589fcd6edb6e08f4c7c32d4f71b54bda02913296568680151775246946962025-01-06T15:52:19.000Z0x0b26aec1ca860b86e24f6f5ade5af7352d189d816fa259d3f77a877eee5666e3
0x52aa899454998be5b000ad077a46bbe360f4e497false0xc1cba3fcea344f92d9239c08c0568f6f2f0ee4521078885838263000751778246946962025-01-06T15:52:19.000Z0x0b26aec1ca860b86e24f6f5ade5af7352d189d816fa259d3f77a877eee5666e3
0x52aa899454998be5b000ad077a46bbe360f4e497false0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb4214891671481780246946962025-01-06T15:52:19.000Z0x0b26aec1ca860b86e24f6f5ade5af7352d189d816fa259d3f77a877eee5666e3
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.FluidLiquidity_LogCollectRevenue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FluidLiquidity_LogOperate_event

Liquidity operation events from the Fluid protocol recording supply, borrow, and withdrawal actions. Contains user addresses, token addresses, operation amounts, exchange prices, and total liquidity amounts for tracking DeFi lending pool 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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_supplyAmountSTRINGAmount supplied in the liquidity operation. Denominated in the smallest unit of the underlying token.
in_borrowAmountSTRINGAmount borrowed in the transaction. Denominated in the smallest unit of the underlying token.
in_withdrawToSTRINGAddress receiving withdrawn funds from the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; Base58-encoded Solana public key for Solana.
in_borrowToSTRINGAddress receiving the borrowed funds from the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_totalAmountsSTRINGCumulative total amounts in the liquidity pool after the operation. Decimal string representation of packed data encoding supply and borrow totals.
in_exchangePricesAndConfigSTRINGEncoded exchange prices and configuration parameters for the liquidity operation. Decimal string representation of packed data containing pricing and settings information.
addressin_userremovedin_tokenlog_indexin_borrowToblock_numberin_withdrawToblock_timestampin_borrowAmountin_supplyAmountin_totalAmountstransaction_hashin_exchangePricesAndConfig
0x52aa899454998be5b000ad077a46bbe360f4e4970x9272d6153133175175bc276512b2336be3931ce9false0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee2270x0000000000000000000000000000000000000000184980540x00000000000000000000000000000000000000002024-08-16T05:17:35.000Z010000000000000036862019981256120915357127843584399388094416882556539084970x9eacc701050625a4d5702e4d4cca1881592cd6bc9675457794f412ea85dceb6b45679895522644624935307222103818478551639470506587441332342
0x52aa899454998be5b000ad077a46bbe360f4e4970x9272d6153133175175bc276512b2336be3931ce9false0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee3070x0000000000000000000000000000000000000000185127640x00000000000000000000000000000000000000002024-08-16T13:27:55.000Z010000000000000037210215481505315312432845270284466525578283307000977141930x4ca11ea1d2028a41c2321d75bf96a010f01abfc2af97aeec06385c220d147cea45680400778010291192422354867948196356337156936398530936951
0x52aa899454998be5b000ad077a46bbe360f4e4970x9272d6153133175175bc276512b2336be3931ce9false0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee1610x0000000000000000000000000000000000000000185009840x00000000000000000000000000000000000000002024-08-16T06:55:15.000Z050000000000000036862019981256120915357127843584399388094257300601889231530x88014cff1d91951f68f3e8e0e6839a9d6063500a2b1304b62058acb9a3271ace45679995682777225684578511560368437466650945146185302147190
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.FluidLiquidity_LogOperate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FluidVaultT1_LogOperate_event

Vault operation events from Instadapp Fluid Protocol tracking collateral and debt position changes. Contains NFT-based position identifiers, collateral amounts, debt amounts, user addresses, and recipient addresses for analyzing leverage activities and vault state transitions across DeFi lending positions.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_user_STRINGAddress of the user initiating the vault operation. Hex-encoded, 0x-prefixed, 42-character string.
in_nftId_STRINGUnique identifier for the vault position. String-encoded integer representing the NFT token ID associated with the user’s vault.
in_colAmt_STRINGCollateral amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.
in_debtAmt_STRINGDebt amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.
in_to_STRINGRecipient address of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_to_addressremovedin_user_in_nftId_log_indexin_colAmt_in_debtAmt_block_numberblock_timestamptransaction_hash
0x41117551e82bc1eeb196150c4f476158f7757aee0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3false0x41117551e82bc1eeb196150c4f476158f7757aee36164230100000000236883662024-12-14T08:47:59.000Z0x225cf6765d373aa43c6d8b41100adf0ed8e545e84deaaa6e3c0ccffd2820f115
0x41117551e82bc1eeb196150c4f476158f7757aee0x0c8c77b7ff4c2af7f6cebbe67350a490e3dd6cb3false0x41117551e82bc1eeb196150c4f476158f7757aee3616400253821041328360850236884842024-12-14T08:51:55.000Z0x2dc895a21ad5537f3f555fbd8bd1f3c0ac8f010ff3cb960b14a06359a997f85b
0xab515542d621574f9b5212d50593cd0c07e641bd0x1982cc7b1570c2503282d0a0b41f69b3b28fdcc3false0xc71d7c5776a49f79bfa75c16109e944e830095ce29187800803417236915692024-12-14T10:34:45.000Z0x8d6834337efae05c4fbef776bcad3af15348fc99bd85dc9ad0dbb2c19264c403
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.FluidVaultT1_LogOperate_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

FluidVaultT1_LogRebalance_event

Rebalancing events emitted by Fluid Protocol VaultT1 contracts recording collateral and debt amount adjustments. Used for tracking vault position management and liquidation prevention activities across lending vaults.
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.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_colAmt_STRINGCollateral amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.
in_debtAmt_STRINGDebt amount for the vault operation. String-encoded signed integer representing token quantity in smallest denomination.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.instadapp_v1_base.FluidVaultT1_LogRebalance_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100