fathom_v3_xdc

Tables

AToken_BalanceTransfer_event

Interest-bearing aToken balance transfer events from Aave V3 lending protocol. Records movements between accounts with normalized interest index for calculating accrued yields on deposited collateral.

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_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

in_to	address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0xcc5228e62ab844d05196e0b5f57bf3e688e32846	0xec2358f4406bcdb371a9baa6e0592755d297bcbe	0x430fbea7274af6ca43e35b56cb566b4d77742022	false	1013594400999999999999999997393673880	1	10	73374696	2024-04-05T13:54:46.000Z	0x516e1aa8cf6116b43fdd213fae2ab6e34bc2834a1307fadb235f07af0cf90072
0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	0xa408b7c5bc50fa392642c58b9758410ea3376a09	false	1000508136963700743026072686	500000000000000000	22	73381714	2024-04-05T19:26:30.000Z	0xa972debfc5b8cfe24b04dad91cfb6483d663dc0218da73dad34b638b98eae57d
0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	0x00d93262c00311349b21b8982e277f43338f7302	false	1000000000279260161518998240	499999890876674002219	4	73363162	2024-04-05T05:01:13.000Z	0x82f1335c97ecee25275426f3a3c01ad62355515bfa8709d363737eb9ce33bbd6

Example Query

Query with partition filter

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

AToken_Burn_event

Burn events for Aave interest-bearing tokens (aTokens) emitted when users withdraw or repay underlying assets. Records the amount burned, the user’s address, the interest accrual index at burn time, and optional balance increase from accrued interest in V3 implementations.

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_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	-
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash
0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	false	1017466499580617977013862610	11109559043623834820517	0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	10	87159763	2025-04-07T21:35:49.000Z	0x927e441a1df6f6a4ddea87e9215e81bf805b867a011c0f515866a4697357431e
0xec826980367dabbaa28f614b8d0e14548dcca37b	0xe0844091bde320784d6b6a37b3119e69b877287c	false	1107716412008252451521944332	49740432111991265366	0xe0844091bde320784d6b6a37b3119e69b877287c	2	87143888	2025-04-07T12:08:51.000Z	0x60fefcc213792e19f200c56fb9adc36d5b74acc758eef7a8055de3eaa374a43c
0xec826980367dabbaa28f614b8d0e14548dcca37b	0xe0844091bde320784d6b6a37b3119e69b877287c	false	1107726003393192702059257662	80369501159873082576	0xe0844091bde320784d6b6a37b3119e69b877287c	3	87144203	2025-04-07T12:19:48.000Z	0x24aec4161ac7bbbaac73ed82f735a145e21d950f0a7fb6881626b0dfb9f8531d

Example Query

Query with partition filter

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

AToken_Initialized_event

Aave V3 AToken initialization events emitted when new interest-bearing token markets are deployed. Contains AToken metadata (name, symbol, decimals), configuration references (pool, treasury, incentives controller), and the underlying asset address being wrapped.

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_underlyingAsset`	`STRING`	Contract address of the underlying asset represented by the AToken. Hex-encoded, 0x-prefixed, 42-character string.
`in_pool`	`STRING`	Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.
`in_treasury`	`STRING`	Contract address of the Aave protocol treasury. Hex-encoded, 0x-prefixed, 42-character string.
`in_incentivesController`	`STRING`	Contract address of the incentives controller managing reward distribution for the token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aTokenDecimals`	`INT64`	Number of decimal places for the AToken. Integer value representing the divisibility of the token amount.
`in_aTokenName`	`STRING`	Human-readable name of the AToken being initialized in the Aave protocol. String value identifying the token, typically following the pattern “Aave [Chain] [Asset]” or “[Protocol] [Asset]”.
`in_aTokenSymbol`	`STRING`	Trading symbol for the AToken being initialized in the Aave protocol. String value representing the ticker symbol, following patterns like “aArb[Asset]”, “aEth[Asset]”, “aBnb[Asset]”, or protocol-specific variants.
`in_params`	`STRING`	Additional initialization parameters encoded as bytes. Hex-encoded string used for protocol-specific configuration data during contract initialization or cross-chain operations.

Sample Data

address	in_pool	removed	in_params	log_index	in_treasury	block_number	in_aTokenName	block_timestamp	in_aTokenSymbol	transaction_hash	in_aTokenDecimals	in_underlyingAsset	in_incentivesController
0xec2358f4406bcdb371a9baa6e0592755d297bcbe	0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	0x10	24	0xaedb3806a395eddf45c2700ab0ab67f99c06faf4	73305368	Fathom xUSDT	2024-04-03T09:59:10.000Z	fmxUSDT	0x6138ac45ac5812d335520adffd276a38e0c61edd5fb4c2edf8b30f39969a4dc7	6	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	0xf5e0c80114c0b0e3c4b55c217643e9a02699bb9b
0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	0x10	20	0xaedb3806a395eddf45c2700ab0ab67f99c06faf4	73305368	Fathom WXDC	2024-04-03T09:59:10.000Z	fmWXDC	0x6138ac45ac5812d335520adffd276a38e0c61edd5fb4c2edf8b30f39969a4dc7	18	0x951857744785e80e2de051c32ee7b25f9c458c42	0xf5e0c80114c0b0e3c4b55c217643e9a02699bb9b
0xec826980367dabbaa28f614b8d0e14548dcca37b	0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	0x10	16	0xaedb3806a395eddf45c2700ab0ab67f99c06faf4	73305368	Fathom FXD	2024-04-03T09:59:10.000Z	fmFXD	0x6138ac45ac5812d335520adffd276a38e0c61edd5fb4c2edf8b30f39969a4dc7	18	0x49d3f7543335cf38fa10889ccff10207e22110b5	0xf5e0c80114c0b0e3c4b55c217643e9a02699bb9b

Example Query

Query with partition filter

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

AToken_Mint_event

Aave Protocol interest-bearing token (aToken) mint events emitted when users deposit underlying assets into lending pools. Records deposit transactions including depositor address, recipient address, minted token amount, liquidity index, and accrued interest balance increases for lending position tracking.

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_caller`	`STRING`	-
`in_onBehalfOf`	`STRING`	-
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_balanceIncrease`	`STRING`	-
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	false	1041013353834661833646600618	50003086951347171440518	4	90666971	2025-07-04T07:19:31.000Z	0xb8d7f3b6b6a65cfc1931bc365634602730c5d401aa70c6a2551fff3bbbd36b87
0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	false	1041582621016611743221570948	416224952988098548293	4	90678504	2025-07-04T14:16:27.000Z	0xef92fef645d537e6cd98e74f08884fbb23b8e29144ec5c2ce2834d42be4c7efe
0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	false	1040989583359069098040028105	13003090134101127747419	4	90666540	2025-07-04T07:04:00.000Z	0x6f71bfbbad77d0465de05c2cd47bda49edf9a2b31fc45539f82038a1a2898029

Example Query

Query with partition filter

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

LendingPool_Borrow_event

Borrow events emitted by Aave lending pool contracts capturing loan originations with borrower address, reserve asset, loan amount, interest rate, and rate mode (stable or variable). Used for tracking DeFi lending activity and calculating protocol borrowing metrics.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_borrowRate`	`STRING`	Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_interestRateMode
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x1fd3595c20c68eacfba4c3623621eda0603f85b8	false	50000000000000000000	5	0x49d3f7543335cf38fa10889ccff10207e22110b5	73411613	37229531666888929341188075	0x1fd3595c20c68eacfba4c3623621eda0603f85b8	2024-04-06T18:26:09.000Z	0x92e428b471d163c8f4f8728b471105a01e1fed37c95d92fe280110c32dd06005	2
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x1fd3595c20c68eacfba4c3623621eda0603f85b8	false	25000000000000000000	5	0x49d3f7543335cf38fa10889ccff10207e22110b5	73411576	21923565232250098059860291	0x1fd3595c20c68eacfba4c3623621eda0603f85b8	2024-04-06T18:24:21.000Z	0xfbbe6d96728b49718ded68e8acc58e226c5d06f2f1bfa66ca4e8c853f59f19db	2
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0xd80d3be702e334744420956fb998958997fa987f	false	500000000000000000000	5	0x49d3f7543335cf38fa10889ccff10207e22110b5	73408195	35804569312500107787857923	0xd80d3be702e334744420956fb998958997fa987f	2024-04-06T15:55:44.000Z	0x3417c186dabdcb7cf54356259595b3ea3b9f8bc53e8b88623a7a0cf87d48ef1a	2

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

Flash loan events from Aave and Aave-forked lending protocols containing borrowed asset, amount, initiator, recipient, and premium fee charged. Used for tracking uncollateralized borrowing activity and arbitrage transactions.

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_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_interestRateMode`	`INT64`	Interest rate mode for the lending operation. Integer value where 0 indicates no interest rate mode, 1 indicates stable rate, and 2 indicates variable rate.
`in_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	transaction_hash
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	16900000000	0x430fbea7274af6ca43e35b56cb566b4d77742022	214	8450000	73374629	0x430fbea7274af6ca43e35b56cb566b4d77742022	2024-04-05T13:51:18.000Z	0xf70ab54cdc6acedf87a6964e6ab8d6cecff1366d06b604d595e1416ae42e2dea
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	16900000000	0x430fbea7274af6ca43e35b56cb566b4d77742022	219	8450000	73374629	0x430fbea7274af6ca43e35b56cb566b4d77742022	2024-04-05T13:51:18.000Z	0xf70ab54cdc6acedf87a6964e6ab8d6cecff1366d06b604d595e1416ae42e2dea
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	16900000000	0x430fbea7274af6ca43e35b56cb566b4d77742022	364	8450000	73374629	0x430fbea7274af6ca43e35b56cb566b4d77742022	2024-04-05T13:51:18.000Z	0xf70ab54cdc6acedf87a6964e6ab8d6cecff1366d06b604d595e1416ae42e2dea

Example Query

Query with partition filter

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

LendingPool_LiquidationCall_event

Liquidation events from Aave-compatible lending protocols when undercollateralized positions are closed. Records liquidator, borrower, debt repaid, collateral seized, and asset addresses for tracking protocol risk and liquidation bot activity.

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_collateralAsset`	`STRING`	Contract address of the asset being seized as collateral during a liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtAsset`	`STRING`	Contract address of the debt asset being repaid during liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_debtToCover`	`STRING`	Amount of debt being repaid during the liquidation operation. String-encoded integer representing the quantity in the debt asset’s smallest unit.
`in_liquidatedCollateralAmount`	`STRING`	Amount of collateral seized from the liquidated position. String-encoded integer representing the quantity in the collateral asset’s smallest unit.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receiveAToken`	`BOOL`	Boolean flag indicating whether the liquidator receives aTokens instead of the underlying collateral asset during liquidation.

Sample Data

address	in_user	removed	log_index	block_number	in_debtAsset	in_liquidator	in_debtToCover	block_timestamp	in_receiveAToken	transaction_hash	in_collateralAsset	in_liquidatedCollateralAmount
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x8e3f672ed8adbb6fb32896c150006e125ecf3094	false	86	76777108	0x49d3f7543335cf38fa10889ccff10207e22110b5	0xe537bde69737c6d8f1364bba34c40443e45685d8	2500243240214670	2024-07-04T14:48:57.000Z	false	0xa4e7cbce153df84ba0a3c510c6dd539d07c2792f868094c955900093a1782045	0x951857744785e80e2de051c32ee7b25f9c458c42	97092682044731994
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x4dd8a0521d56f7158f5286acaa98afdcb1a26bc8	false	54	97041572	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	0xa6dbef2053379d7f05ffbdfc278076f5a5064955	1178080	2025-12-09T15:20:30.000Z	false	0xba0ff6633ba38c22862eb4f4e1c6019b9cfaa5f9cd0d74d55df17f2609bc78e8	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	1231094
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0xbad9dff1026e59ea4c39cc3398aa5eb6f6f229ac	false	12	84173379	0x3279dbefabf3c6ac29d7ff24a6c46645f3f4403c	0xbad9dff1026e59ea4c39cc3398aa5eb6f6f229ac	3000000000000000000	2025-01-23T13:08:16.000Z	false	0x60840d16941368d5346f5ebf130d1f4d75119825d3cda884b4746dd45906ffd7	0x951857744785e80e2de051c32ee7b25f9c458c42	2346472303206997150

Example Query

Query with partition filter

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

LendingPool_MintedToTreasury_event

Aave V3 protocol event recording interest-bearing token mints to the treasury reserve. Contains reserve address, amount minted, and transaction identifiers for tracking protocol fee accumulation.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amountMinted`	`STRING`	Amount of interest-bearing tokens minted to the protocol treasury. String representation of an unsigned integer value.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_amountMinted	transaction_hash
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	5	0x951857744785e80e2de051c32ee7b25f9c458c42	81252604	2024-11-01T04:30:30.000Z	59599833929812538794	0x65c6ab4362b8c60d1b4b7860c7d848e355c48fca4c45a53b644a88dcb33adf68
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	8	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	81252604	2024-11-01T04:30:30.000Z	1010274	0x65c6ab4362b8c60d1b4b7860c7d848e355c48fca4c45a53b644a88dcb33adf68
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	2	0x49d3f7543335cf38fa10889ccff10207e22110b5	81252604	2024-11-01T04:30:30.000Z	28869376000473135380	0x65c6ab4362b8c60d1b4b7860c7d848e355c48fca4c45a53b644a88dcb33adf68

Example Query

Query with partition filter

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

LendingPool_Repay_event

Loan repayment events from Aave-based lending protocols containing borrower address, repayer address, reserve asset, and repayment amount. Used for tracking debt reduction and loan lifecycle analysis across DeFi lending markets.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayer`	`STRING`	Address of the account that executed the repayment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_useATokens`	`BOOL`	Boolean flag indicating whether aTokens (interest-bearing deposit tokens) were used to repay the debt instead of the underlying reserve asset.

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	in_useATokens	block_timestamp	transaction_hash
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x0c834261cb0b1f62bdf12753e90965b370a20144	false	208781655752934085185	4	0x0c834261cb0b1f62bdf12753e90965b370a20144	0x3279dbefabf3c6ac29d7ff24a6c46645f3f4403c	95760673	false	2025-11-07T22:48:17.000Z	0xdf990ecd58b686fc766ce23d73dadf47226f046d41b9360796a035a839d16159
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0xb694ff496cdf365c5742eae70cc0ce4d2f75cd85	false	1097740000000000000000	4	0xb694ff496cdf365c5742eae70cc0ce4d2f75cd85	0x49d3f7543335cf38fa10889ccff10207e22110b5	97749677	false	2025-12-28T15:14:30.000Z	0x4830c6b074d85c2a406b1c27b9956a7d7f7f8492a480f72d5371fbf2824cece5
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x57ffb07825f23829c9c7a5be1e294fd199151eff	false	35000000	20	0x57ffb07825f23829c9c7a5be1e294fd199151eff	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	76717545	false	2024-07-03T04:45:27.000Z	0xef585b174ad9d445545e68e663b23cefb690046e4e8681ab3c29ae2f94faf0fe

Example Query

Query with partition filter

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

LendingPool_ReserveDataUpdated_event

Aave V2/V3 protocol events emitted when lending pool reserve parameters are updated, including liquidity and borrow indices, interest rates for stable and variable borrowing. Used for tracking interest accrual and reserve state changes across lending markets.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityRate`	`STRING`	Current liquidity interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage yield earned by liquidity providers.
`in_stableBorrowRate`	`STRING`	Current stable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a stable rate loan.
`in_variableBorrowRate`	`STRING`	Current variable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a variable rate loan.
`in_liquidityIndex`	`STRING`	Cumulative liquidity index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor since the reserve’s inception, stored as a numeric string.
`in_variableBorrowIndex`	`STRING`	Cumulative variable borrow index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor for variable rate borrowers since the reserve’s inception, stored as a numeric string.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_stableBorrowRate	in_variableBorrowRate	in_variableBorrowIndex
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	0	0x951857744785e80e2de051c32ee7b25f9c458c42	95773219	2025-11-08T05:58:59.000Z	17837153618913753205937585	0x726cfb251e2c8508a85e10c088880f4bfa47c3538747e57fcbb7c507edf5e0da	1104683126049655903593244075	145524452478364252518061236	55524452478364252518061236	1228271820899914125137682882
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	2	0x49d3f7543335cf38fa10889ccff10207e22110b5	95797429	2025-11-08T20:13:42.000Z	327016421730060030202157315	0xb71b0883286262f203cef7043e3e0a6ef6e67d71677adb48d30f8d7946d92502	1193458924403903527141587951	419931941443841660340702648	404931941443841660340702648	1249361729055963002955171518
0x70d8005e3c8c7e383fe35fa40156042f3393449f	false	2	0x49d3f7543335cf38fa10889ccff10207e22110b5	95797227	2025-11-08T20:06:58.000Z	346921660321884417746124183	0xb7370c10aa922a51b15e5d1056e91b000455a9bc9401e06059a691f9d365cf0f	1193453620303693130765900208	441805422167624249754402280	426805422167624249754402280	1249354897939425591300339602

Example Query

Query with partition filter

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

LendingPool_Supply_event

Aave V3 Supply events emitted when users deposit assets into lending pools. Records depositor address, reserve token, deposit amount, beneficiary, and optional referral code for tracking liquidity provision across DeFi lending protocols.

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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	false	1000000000000000000000	6	0x951857744785e80e2de051c32ee7b25f9c458c42	94570083	0x54298f90a031ed5ce6ace652fbb8205c74fde831	2025-10-08T19:07:28.000Z	0x4964ccb735a44b981b6f05b5523f1e45c0c59fa973eb2e5fecdb58c0257836f3
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	false	50000000000000000000	35	0x951857744785e80e2de051c32ee7b25f9c458c42	96638531	0xed06ba8d7d1711f5e44ba591ee31057015d0646a	2025-11-29T12:48:18.000Z	0x954387805c1865a9e5426aead3162de7aafb792a3163ad85a6c9ccdccc96be3b
0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	false	22820000000000000000000	5	0x951857744785e80e2de051c32ee7b25f9c458c42	96636774	0xabd99d9af2795adebfd69968fec4f81b3d1bb273	2025-11-29T11:46:24.000Z	0x867c800756d6c6e531c0edaa56cd906c149f682d8c721264486e664a3bbb7f77

Example Query

Query with partition filter

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

LendingPool_Withdraw_event

Aave LendingPool withdrawal events recording asset removals from lending positions. Contains user address, reserve token address, withdrawal amount, and recipient address for tracking collateral and liquidity movements across Aave V2 and V3 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol 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_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x57ba8baa7c3ff6606751859f1ced9f68819c2f41	false	105000000000000000000	11	0x951857744785e80e2de051c32ee7b25f9c458c42	91311656	2025-07-20T07:20:28.000Z	0x7f80e2a718ebc9fbc3ca1276d547c7304ea9172480fc56fa2d801cb36497f594
0x8e2a75fc256fe2aff9dd89f97222d6df28e425b4	0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x8e2a75fc256fe2aff9dd89f97222d6df28e425b4	false	1565345596743656656616	5	0x49d3f7543335cf38fa10889ccff10207e22110b5	91306092	2025-07-20T04:07:44.000Z	0x2ff86f6f523b7c848d43773d3638fb9849b5441aed0c8f5566f311b967b22817
0x8e2a75fc256fe2aff9dd89f97222d6df28e425b4	0x70d8005e3c8c7e383fe35fa40156042f3393449f	0x8e2a75fc256fe2aff9dd89f97222d6df28e425b4	false	1000000000000000000000	5	0x49d3f7543335cf38fa10889ccff10207e22110b5	91306023	2025-07-20T04:05:26.000Z	0xa34fa3aaa8134d9d4038c4b8af8ff39bb7d60fa08f67da2d711ce7a9cf660ccf

Example Query

Query with partition filter

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

LendingPoolConfigurator_CollateralConfigurationChanged_event

Collateral parameter update events from lending protocol configurator contracts, recording changes to loan-to-value (LTV), liquidation threshold, and liquidation bonus for specific assets. Used for tracking risk parameter adjustments in lending markets.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_ltv`	`STRING`	Loan-to-value ratio for the collateral asset. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationThreshold`	`STRING`	Liquidation threshold at which a position becomes eligible for liquidation. Numeric string representing basis points where 10000 equals 100%.
`in_liquidationBonus`	`STRING`	Liquidation bonus awarded to liquidators for purchasing collateral during liquidation. Numeric string representing basis points where 10000 equals 100%.

Sample Data

in_ltv	address	removed	in_asset	log_index	block_number	block_timestamp	transaction_hash	in_liquidationBonus	in_liquidationThreshold
8000	0x56f3a75c71c207a77c3b8c77a34fc89cf1a6db66	false	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	5	73848147	2024-04-20T13:37:41.000Z	0xee2d371241df2534f839d2b0cfd47f1711657db505f24dfc4a39d50a85ee65a2	10500	8250
8000	0x56f3a75c71c207a77c3b8c77a34fc89cf1a6db66	false	0xfa2958cb79b0491cc627c1557f441ef849ca8eb1	0	95843966	2025-11-09T22:40:53.000Z	0x5865fc898dc608a67212e03e583f73e2a2d484a86c7b9c308a063bd497c3fe43	10500	8250
7500	0x56f3a75c71c207a77c3b8c77a34fc89cf1a6db66	false	0x8f9920283470f52128bf11b0c14e798be704fd15	1	75801167	2024-06-10T13:26:51.000Z	0xc086fa6d18a2e7c86d8447fd53004afd67ec16cca88d6524dc845fe7349a7b05	10500	8000

Example Query

Query with partition filter

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

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	-
`block_number`	`INT64`	-
`transaction_hash`	`STRING`	-
`log_index`	`INT64`	-
`address`	`STRING`	-
`removed`	`BOOL`	-
`in_asset`	`STRING`	-
`in_oldFee`	`STRING`	-
`in_newFee`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-based lending protocols.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_oldReserveFactor`	`STRING`	-
`in_newReserveFactor`	`STRING`	-

Sample Data

No sample data available.

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.

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_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x56f3a75c71c207a77c3b8c77a34fc89cf1a6db66	false	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	0x1c3bbc4fa17128711c238bc50bd0ae85d35c2515	4	73848139	2024-04-20T13:37:20.000Z	0x51dc07748a953fc7ca99aa9c4ee2750531593bd2259d98e52f4834687b68b651	0x2f6c3d501cfd528d78c7c1da3b8ea37ba85bdb93	0x98dc1115addcdd2ef67c87d35faf0b835b3f746d	0xb34a51d8443219bda8bfba5826b7907bc4032e11
0x56f3a75c71c207a77c3b8c77a34fc89cf1a6db66	false	0x951857744785e80e2de051c32ee7b25f9c458c42	0xdaef7d4000fb0e511c9f2deeae602d9c8fcb28f7	23	73305368	2024-04-03T09:59:10.000Z	0x6138ac45ac5812d335520adffd276a38e0c61edd5fb4c2edf8b30f39969a4dc7	0xcbf718e6802e646d6d016912453e1ecb1bdb0dca	0x10eb945e14131fb55b2f432d826f4e09d718276d	0x99e7d2d9b8349b70aae31e5213c54fd022fd5dcf
0x56f3a75c71c207a77c3b8c77a34fc89cf1a6db66	false	0xd4b5f10d61916bd6e0860144a91ac658de8a1437	0xec2358f4406bcdb371a9baa6e0592755d297bcbe	27	73305368	2024-04-03T09:59:10.000Z	0x6138ac45ac5812d335520adffd276a38e0c61edd5fb4c2edf8b30f39969a4dc7	0x0743086a55a3096c645f4dcf1888fcfab0dd181e	0xbfcf3204774c97944767074b2b873d33a4e5b598	0xb34a51d8443219bda8bfba5826b7907bc4032e11

Example Query

Query with partition filter

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

SToken_Burn_event

Stable rate debt token burn events from Aave-based lending protocols, emitted when borrowers repay stable-rate debt positions. Records the burn amount, user balance changes, average stable rate, and updated total supply for tracking debt repayments and interest accrual.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

SToken_Mint_event

Stable debt token minting events from Aave protocol lending pools. Captures stable-rate borrowing activity including borrowed amount, interest rate calculations, borrower address, and updated pool totals.

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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_currentBalance`	`STRING`	User’s current stable debt balance after accrued interest. Numeric string representation of token quantity in smallest denomination.
`in_balanceIncrease`	`STRING`	Accrued interest amount since the last update for the user’s balance. Numeric string representation of token quantity in smallest denomination.
`in_newRate`	`STRING`	Updated stable borrow rate for the user after the mint operation. Numeric string representation in ray units (27 decimals).
`in_avgStableRate`	`STRING`	Average stable borrow rate across all borrowers for the reserve. Numeric string representation in ray units (27 decimals).
`in_newTotalSupply`	`STRING`	Updated total supply of stable debt tokens after the operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

VToken_Burn_event

Variable debt token burn events emitted when borrowers repay debt in Aave-based lending protocols. Contains user address, repayment amount, updated interest index, and accrued interest since last interaction for tracking debt position changes.

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`	-
`in_value`	`STRING`	-
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	log_index	block_number	block_timestamp	transaction_hash
0x31d83e0cae604f6ce0a06800dafe0959449b1947	false	1000536893791834619355731744	2	83758683	2025-01-13T09:44:59.000Z	0x68ba96c596450bc2467da58900ece8ec8c074f51dd6becdf2f3e0889dacd4dc2
0xcf5b5c4dfea09a0ad129717bfbbca750c362e795	false	1099915197210277245574859412	23	85668308	2025-03-01T12:47:05.000Z	0x1229b57fe3f307d00615cb37088587393f08bed1544fadcbec7d0307df180f5f
0x98dc1115addcdd2ef67c87d35faf0b835b3f746d	false	1088140373883348762297330540	2	76406382	2024-06-25T19:34:48.000Z	0xc1e71a8515095d6784d69950ed1e4fa594815a22229f5733cfddeadfad2fcbfb

Example Query

Query with partition filter

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

VToken_Mint_event

Variable rate debt token mint events from lending protocols. Records debt token issuance with borrower address, borrowed amount, interest rate index, and accrued interest at the time of minting.

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_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	removed	in_index	in_value	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x10eb945e14131fb55b2f432d826f4e09d718276d	false	1167116322584217687411681531	160000000000000000000000	6	93160766	0x89530f21d6115c1c1d566f5f1eac510e4356e4ae	2025-09-03T15:25:26.000Z	0xa44dca7a2b174d442f1ca9a3eee9bea525fea327f2dddb5320f586237fb5389e
0xcf5b5c4dfea09a0ad129717bfbbca750c362e795	false	1040642272164254901210891658	150000000000000000000	1	81865542	0x4dd8a0521d56f7158f5286acaa98afdcb1a26bc8	2024-11-19T12:09:19.000Z	0xe66ddf01a914f98425b1e1c7ff74fb4ccdd7bb5be1e3ab5c1d2af513a55a26c9
0x10eb945e14131fb55b2f432d826f4e09d718276d	false	1051675888179163763013012277	250646438795653177704733	2	89671594	0x87dad63d3cb69438a507fdc2b54d155e08839e17	2025-06-08T21:27:40.000Z	0x0193253ac3b190b21c29291b0e4965a746626fcb1a3841d3957079a8c04e6aa3

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​AToken_BalanceTransfer_event

​AToken_Burn_event

​AToken_Initialized_event

​AToken_Mint_event

​LendingPool_Borrow_event

​LendingPool_FlashLoan_event

​LendingPool_LiquidationCall_event

​LendingPool_MintedToTreasury_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Supply_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_CollateralConfigurationChanged_event

​LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​SToken_Burn_event

​SToken_Mint_event

​VToken_Burn_event

​VToken_Mint_event

Tables

AToken_BalanceTransfer_event

AToken_Burn_event

AToken_Initialized_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_FlashLoan_event

LendingPool_LiquidationCall_event

LendingPool_MintedToTreasury_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Supply_event

LendingPool_Withdraw_event

LendingPoolConfigurator_CollateralConfigurationChanged_event

LendingPoolConfigurator_LiquidationProtocolFeeChanged_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

SToken_Burn_event

SToken_Mint_event

VToken_Burn_event

VToken_Mint_event