Skip to main content

Tables

AToken_TokenMinterBurned_event

No description available.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the 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.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.AToken_TokenMinterBurned_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AToken_TokenMinterMinted_event

No description available.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the 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.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.AToken_TokenMinterMinted_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

AToken_Transfer_event

Transfer events for AToken interest-bearing tokens on XDC Network from the PrimeNumbers lending protocol. Tracks minting (from zero address), burning (to zero address), and transfers of yield-accruing deposit tokens for analyzing lending market activity and liquidity flows.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_toaddressin_fromremovedin_valuelog_indexblock_numberblock_timestamptransaction_hash
0x9d96d06cb863b76b07670e98d86470407a965a9c0x1ff5e0037b478547715a4ce337d9fcff86a304010x0000000000000000000000000000000000000000false9439444232753334700158950834352025-10-22T02:13:57.000Z0xd362893296321bf816f5c24fbe5d43f8e4bef56626b5dbb6f69c21d63a9c831b
0x9d96d06cb863b76b07670e98d86470407a965a9c0x1ff5e0037b478547715a4ce337d9fcff86a304010x0000000000000000000000000000000000000000false49977737433407924273950834742025-10-22T02:15:41.000Z0xe42b0f6b162a7228674a93e1f970c8660666d5ac8624d6c56ebb48a6ddd99c15
0x9d96d06cb863b76b07670e98d86470407a965a9c0x1ff5e0037b478547715a4ce337d9fcff86a304010x0000000000000000000000000000000000000000false119180663775509965161950835892025-10-22T02:19:49.000Z0xfd0c73f9a8dcdfa08f889fa35c626bd19fa29acbf435133fb05b144c75e8bf95
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.AToken_Transfer_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.
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_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the 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.
in_borrowRateModeSTRINGInterest rate mode selected for the borrow operation. Numeric string value where ‘1’ represents stable rate and ‘2’ represents variable rate.
in_borrowRateSTRINGAnnual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
in_referralSTRINGReferral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
addressin_userremovedin_amountlog_indexin_reservein_referralblock_numberin_borrowRatein_onBehalfOfblock_timestamptransaction_hashin_borrowRateMode
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x065fd3ba477c85503bfac48be7d1a2fcada02847false2076362875537234094653110x951857744785e80e2de051c32ee7b25f9c458c4209529845710765222663728259171626376460xf62158223df23af019bbd012ee7faf3045657d232025-10-27T15:02:32.000Z0xfc3be69133e36b01d06ada43953f44895a05716aae3d8aa16fba178ffdbaeb992
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x065fd3ba477c85503bfac48be7d1a2fcada02847false201356178762300000000100x951857744785e80e2de051c32ee7b25f9c458c42094840611305901763650098109201654110x5aa7bf0e4b54c4760314d3bf846093c28a8f778d2025-10-15T20:59:03.000Z0x7979623472e0a22d02f015f8e0042b2a38904af46c544ac4c2bb51828d5bd0ef2
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x065fd3ba477c85503bfac48be7d1a2fcada02847false600000000000000000000100x951857744785e80e2de051c32ee7b25f9c458c42094830289476962801885243435015947430xcd2db3fde23958a066919d99796bb4ebead353de2025-10-15T14:21:11.000Z0xac81a63c43f115d75fe48957eddc6024473d3327641b77f33b0a5716b238aba22
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.LendingPool_Borrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendingPool_Deposit_event

Deposit events from lending pool contracts recording user supply transactions. Contains depositor address, reserve asset, deposit amount, beneficiary account, and optional referral code for tracking protocol liquidity provisioning.
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_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the 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.
in_referralSTRINGReferral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.
addressin_userremovedin_amountlog_indexin_reservein_referralblock_numberin_onBehalfOfblock_timestamptransaction_hash
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x5aa7bf0e4b54c4760314d3bf846093c28a8f778dfalse6213708833938301780x81b244d0be055ef3bef1b09b7826cc2b108b2cbd0948697480x5aa7bf0e4b54c4760314d3bf846093c28a8f778d2025-10-16T15:08:12.000Z0xd637fd05e95d3eaf7054437af26dd2e0090e665a9d1decd67ac3a3bb8bf2c016
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x065fd3ba477c85503bfac48be7d1a2fcada02847false60000000000000000000100x951857744785e80e2de051c32ee7b25f9c458c420948695620x5aa7bf0e4b54c4760314d3bf846093c28a8f778d2025-10-16T15:01:25.000Z0x32cea75fcbf9bce66bf7cd6091e36f4da5f1e38c818f21859aeff1af5469d24f
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x065fd3ba477c85503bfac48be7d1a2fcada02847false89041744535040000000100x951857744785e80e2de051c32ee7b25f9c458c420948505440x5aa7bf0e4b54c4760314d3bf846093c28a8f778d2025-10-16T03:09:06.000Z0xbcce52e7d65d50f4a3333b9f48e5d15ddcc3c2db58642c4318dc3c4e66b46c0e
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.LendingPool_Deposit_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.
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_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
in_initiatorSTRINGAddress of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
in_assetSTRINGContract address of the asset or token. 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.
in_premiumSTRINGFee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
in_referralCodeSTRINGReferral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
addressremovedin_assetin_amountin_targetlog_indexin_premiumblock_numberin_initiatorblock_timestampin_referralCodetransaction_hash
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c3false0x951857744785e80e2de051c32ee7b25f9c458c42261715959299039440000xcb6eb8df68153cebf60e1872273ef52075a5c2974323554436336913549954315000xcb6eb8df68153cebf60e1872273ef52075a5c2972025-10-30T23:33:12.000Z00x2c5f7a08328f8fca52f4d83f2c39d3f79a338c985fa607c489e55261c1150437
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c3false0x951857744785e80e2de051c32ee7b25f9c458c42115331261163095360000xcb6eb8df68153cebf60e1872273ef52075a5c2976610379813504678582955912230xcb6eb8df68153cebf60e1872273ef52075a5c2972025-11-03T20:23:43.000Z00xbeb70bc68824c839f842fcde6e0c57999781aabca8681a870194e028f611b673
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c3false0x951857744785e80e2de051c32ee7b25f9c458c429800000000000000000xcb6eb8df68153cebf60e1872273ef52075a5c29735882000000000000959533390xcb6eb8df68153cebf60e1872273ef52075a5c2972025-11-12T16:03:28.000Z00x450cff32a7bf2c53ffcbe1e72e560de010ed7900020dcdb6834c42681889b635
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.LendingPool_FlashLoan_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.
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_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_repayerSTRINGAddress of the account that executed the repayment transaction. 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.
addressin_userremovedin_amountlog_indexin_repayerin_reserveblock_numberblock_timestamptransaction_hash
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30xf62158223df23af019bbd012ee7faf3045657d23false10000000000000000000090xf62158223df23af019bbd012ee7faf3045657d230x9b8e12b0bac165b86967e771d98b520ec3f665a6952325802025-10-25T23:44:12.000Z0x5e1e7e00d4a215d0a829702f647452df14ead5c2c83ace642b4f458ba6d8441a
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30xeee6307021edf44fcf865fbd4dc53a212b71acaafalse2752000000000000000110x065fd3ba477c85503bfac48be7d1a2fcada028470x951857744785e80e2de051c32ee7b25f9c458c42955310202025-11-02T09:25:31.000Z0x78d71be5ba6a594a7bebc7cbf51a4b4c997f94bd61201cbab603e304c8c06c23
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x5aa7bf0e4b54c4760314d3bf846093c28a8f778dfalse1113074888639400000100x065fd3ba477c85503bfac48be7d1a2fcada028470x951857744785e80e2de051c32ee7b25f9c458c42955204242025-11-02T03:17:10.000Z0x8b59adf2eecbb5578ee3e6c7910b01b169ac7664bd0a60adbc7c7f2873fa15ee
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_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.
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_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_liquidityRateSTRINGCurrent 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_stableBorrowRateSTRINGCurrent 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_variableBorrowRateSTRINGCurrent 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_liquidityIndexSTRINGCumulative 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_variableBorrowIndexSTRINGCumulative 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.
addressremovedlog_indexin_reserveblock_numberblock_timestampin_liquidityRatetransaction_hashin_liquidityIndexin_stableBorrowRatein_variableBorrowRatein_variableBorrowIndex
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c3false20x9b8e12b0bac165b86967e771d98b520ec3f665a6957511182025-11-07T17:19:29.000Z41620392849019472003720570x5f43c296697529aae614ee8310a220e1beab1609cf6bdbfb44501dd6c69271c1100023239612976023839694579486582406105553743398664802452659248844429947189318421002378252280792611821294684
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c3false20x9b8e12b0bac165b86967e771d98b520ec3f665a6957261032025-11-07T02:42:49.000Z42418998674962323525907220xc14efab0722e6c208b0226b64e7107acec99b9f4585acec4d420416b19dc3f20100022531912147834713042281387122674115223500158026503456981392921788001264212021002301851379290335641816314
0x8a619d8e3bfab54f7c30ef39ce16c53429c739c3false20x9b8e12b0bac165b86967e771d98b520ec3f665a6957508722025-11-07T17:11:14.000Z41620355205050862082952450x31bbce50269018cf72ee11a2e4f754a223008495eec54cecef6e6f0b0713fc86100023232989007922319385501586582380517294537631023833452659044138356301048190661002377535268675594626952013
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.LendingPool_ReserveDataUpdated_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.
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_reserveSTRINGContract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the 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.
in_toaddressin_userremovedin_amountlog_indexin_reserveblock_numberblock_timestamptransaction_hash
0x065fd3ba477c85503bfac48be7d1a2fcada028470x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x065fd3ba477c85503bfac48be7d1a2fcada02847false10116721538902393506327120x951857744785e80e2de051c32ee7b25f9c458c42958141492025-11-09T05:47:12.000Z0x4fa08d15d189e1c0cc00f565984a60bbce61d318503d15ef3dbf7fb833aff016
0xaaa913590a373e5c2d802641b165627d1df589bd0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30xaaa913590a373e5c2d802641b165627d1df589bdfalse482724744388817066321280x9b8e12b0bac165b86967e771d98b520ec3f665a6958068362025-11-09T01:35:23.000Z0xbc7f3a90f9640d1c9ba58d2066f3a7b73f1b51a5bc2abe0cc7aaacdd8f22a253
0x07a43a9b6f1d2a0bd916e6b19efdceacac335d5e0x8a619d8e3bfab54f7c30ef39ce16c53429c739c30x07a43a9b6f1d2a0bd916e6b19efdceacac335d5efalse500000012876745884978960x9b8e12b0bac165b86967e771d98b520ec3f665a6958364302025-11-09T18:25:41.000Z0xd2aab7b000b053ad06a2a6c2ef04814796b4cdbc2d1a3a4afa7d0c3af7b8cc35
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.LendingPool_Withdraw_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.
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_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_factorSTRINGReserve factor for the asset in basis points. String-encoded integer where 10000 equals 100%.
addressremovedin_assetin_factorlog_indexblock_numberblock_timestamptransaction_hash
0x4664379831583139a415b03f2914026bf2c75646false0x9b8e12b0bac165b86967e771d98b520ec3f665a6750011947578922025-10-13T16:29:21.000Z0x26a5cf23677150931814d9b60fc7a8b97fbd06f7cb3ea414691e6997fb570c30
0x4664379831583139a415b03f2914026bf2c75646false0x951857744785e80e2de051c32ee7b25f9c458c4275008947578922025-10-13T16:29:21.000Z0x26a5cf23677150931814d9b60fc7a8b97fbd06f7cb3ea414691e6997fb570c30
0x4664379831583139a415b03f2914026bf2c75646false0xfa2958cb79b0491cc627c1557f441ef849ca8eb175002947578922025-10-13T16:29:21.000Z0x26a5cf23677150931814d9b60fc7a8b97fbd06f7cb3ea414691e6997fb570c30
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_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.
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_assetSTRINGContract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
in_aTokenSTRINGContract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_stableDebtTokenSTRINGContract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_variableDebtTokenSTRINGContract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
in_interestRateStrategyAddressSTRINGContract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_assetin_aTokenlog_indexblock_numberblock_timestamptransaction_hashin_stableDebtTokenin_variableDebtTokenin_interestRateStrategyAddress
0x4664379831583139a415b03f2914026bf2c75646false0x81b244d0be055ef3bef1b09b7826cc2b108b2cbd0x3a577f9789fc81c2ea0b81b9e02b6dbc67158a375947580462025-10-13T16:34:53.000Z0x55de9ffb5235e80345f3530dca5715514185a10a236a0df9de3ab2cc8733ed170xde4ac0d2caee918f215fa60122067833254bd0e20xd9ba32e8a4955e4fbbbdd61f121b2f81ca7bbfe80x515fbd7124a782818ba6719e48e94c489ba769f4
0x4664379831583139a415b03f2914026bf2c75646false0xfa2958cb79b0491cc627c1557f441ef849ca8eb10xb9a14b24c6e669d24e76dab65f7c4dc52f68741c5947578832025-10-13T16:29:03.000Z0x9ff7e8d0e0f4146bfad08ddf3e7f51dc34759f7a81ed35d9528fdb0a6891acb00xa679a608bddd118ff4da4a8bd1c67877dc0e97bc0xdbed51f298901987651faf1daed8bb575942d4060xcf5445fb854260b5a11e09be759511e1e70fa7ba
0x4664379831583139a415b03f2914026bf2c75646false0xcda5b77e2e2268d9e09c874c1b9a4c3f07b375550x2a50be4df06202a239384e828d6e67f9f2fa954e11947578832025-10-13T16:29:03.000Z0x9ff7e8d0e0f4146bfad08ddf3e7f51dc34759f7a81ed35d9528fdb0a6891acb00x1811d261c05de6c7470d9de6a56b8954271511270xaae0d3c0b4aa454ceb5b5346ba1e95a86395d6560xcf5445fb854260b5a11e09be759511e1e70fa7ba
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.LendingPoolConfigurator_ReserveInitialized_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MultiFeeDistribution_RewardAdded_event

RewardAdded event logs from the MultiFeeDistribution contract on XDC Network, capturing when new reward tokens are added to the distribution pool. Used for tracking reward token allocations and distribution events across multiple token types.
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__rewardTokenSTRINGContract address of the reward token being added to the MultiFeeDistribution contract on XDC Network. Hex-encoded, 0x-prefixed 40-character string representing the token distributed as a reward.
addressremovedlog_indexblock_numberblock_timestampin__rewardTokentransaction_hash
0x01e7cd81d3d7a4907815877e0c937a77de537e99false1947580462025-10-13T16:34:53.000Z0x3a577f9789fc81c2ea0b81b9e02b6dbc67158a370x55de9ffb5235e80345f3530dca5715514185a10a236a0df9de3ab2cc8733ed17
0x01e7cd81d3d7a4907815877e0c937a77de537e99false1947578832025-10-13T16:29:03.000Z0xb9a14b24c6e669d24e76dab65f7c4dc52f68741c0x9ff7e8d0e0f4146bfad08ddf3e7f51dc34759f7a81ed35d9528fdb0a6891acb0
0x01e7cd81d3d7a4907815877e0c937a77de537e99false19947578832025-10-13T16:29:03.000Z0x834695a5d33967f8cc27e6d15684c0aa36ca43750x9ff7e8d0e0f4146bfad08ddf3e7f51dc34759f7a81ed35d9528fdb0a6891acb0
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.MultiFeeDistribution_RewardAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MultiFeeDistribution_RewardPaid_event

Event log emitted when a user claims or receives rewards from a multi-token fee distribution contract. Records the user address, reward token contract address, and reward amount paid out.
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_rewardTokenSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
in_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.MultiFeeDistribution_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

MultiFeeDistribution_Withdrawn_event

Withdrawal events from MultiFeeDistribution contracts recording token unlock operations with user addresses, received amounts, penalty fees, and locked balance details. Used for tracking vesting schedule exits and early withdrawal penalties in DeFi protocols.
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_receivedAmountSTRINGActual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token’s smallest denomination.
in_lockedBalanceSTRINGRemaining locked balance of the user after the withdrawal operation. String-encoded integer representing token units in smallest denomination.
in_penaltySTRINGPenalty amount assessed in the operation. Numeric string representation of token quantity in smallest denomination.
in_burnSTRINGAmount of tokens burned in the withdrawal operation. String-encoded integer representing token units in smallest denomination.
in_isLPBOOLBoolean flag indicating whether the withdrawn tokens are liquidity provider (LP) tokens.
addressin_burnin_isLPin_userremovedlog_indexin_penaltyblock_numberblock_timestampin_lockedBalancetransaction_hashin_receivedAmount
0x01e7cd81d3d7a4907815877e0c937a77de537e990true0xdd8abf5905c72d0d7d74d36efefd3b1a46a0a975false90968728452025-12-05T09:16:31.000Z1114870097234880107770040x9fbca7e4f6ac0ab78ab0e0f5d915d71f1fe18bf738edcee923d64cb54ea786b39291530957421387965868
0x01e7cd81d3d7a4907815877e0c937a77de537e990true0x7783b4f4ed3a10c31bbb985b63c54348babd64a5false20960584292025-11-15T05:26:06.000Z00x2603823392236b9541284faccd324577c75835c9d27cf621cb4682af3039a87037104351396306182400
0x01e7cd81d3d7a4907815877e0c937a77de537e990true0x8533daef2612a2aa6435dcb9a77afc7fd2fed396false20974904532025-12-20T14:55:39.000Z00x4e6dfce4bc2125228e05eddd5544a03890a493958595b566057a939295d0185b654267732017394298471
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.MultiFeeDistribution_Withdrawn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

PrimeStakedXDC_RewardPaid_event

No description available.
ColumnTypeDescription
block_timestampTIMESTAMP-
block_numberINT64-
transaction_hashSTRING-
log_indexINT64-
addressSTRING-
removedBOOL-
in_userSTRING-
in_rewardSTRING-
No sample data available.
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.PrimeStakedXDC_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VariableDebtToken_Burn_event

Variable rate debt token burn events emitted when users repay borrowed assets in lending protocols. Records the debt amount repaid, accumulated interest, and liquidity index at the time of repayment for tracking variable-rate loan lifecycle and interest accrual.
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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_userremovedin_indexin_amountlog_indexblock_numberblock_timestamptransaction_hash
0x47c4d740016411bb8f5c9d9bdb3f866c9b46e0a40xeee6307021edf44fcf865fbd4dc53a212b71acaafalse10002467263504251534313512461000000000000000000000010951463472025-10-23T16:30:50.000Z0xb14d58ded27299f08256fc1e1fa6b24c1c6c40bfb3bcb4774cf0137001309b9c
0x47c4d740016411bb8f5c9d9bdb3f866c9b46e0a40xeee6307021edf44fcf865fbd4dc53a212b71acaafalse1000246444462828651635419429100000000000000000000006951462732025-10-23T16:28:04.000Z0xdbc5ba5b947510f1763d775f055ba6d9599762c48d6b71c656677428765fc9f7
0x47c4d740016411bb8f5c9d9bdb3f866c9b46e0a40x22bac4e9224899f625ccd473fe769261fb56f6f0false1000233406648003527321632431220036875866595660006951427082025-10-23T14:20:09.000Z0x6d035a4f49cb273dec5c71c06ada3ed760f9ad9ee6c1f395f7157a09f291165e
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.VariableDebtToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

VariableDebtToken_Mint_event

Variable debt token minting events from lending protocols recording debt issuance to borrowers. Contains borrower address, delegated beneficiary, debt amount, and liquidity index in ray units (1e27) for tracking compounding interest on variable-rate loans.
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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_valueSTRINGAmount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
in_indexSTRINGLiquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).
addressin_fromremovedin_indexin_valuelog_indexblock_numberin_onBehalfOfblock_timestamptransaction_hash
0x47c4d740016411bb8f5c9d9bdb3f866c9b46e0a40x5a11800f0673b47a60930d981d5f5e5f641da041false100010215301590498544439813350000000000000000000006949932240x5a11800f0673b47a60930d981d5f5e5f641da0412025-10-19T18:49:09.000Z0xd7f4f5264ad8f4d955991ae9a3d44c146fad0b899a2ff7ef33aa56accdeb3743
0x47c4d740016411bb8f5c9d9bdb3f866c9b46e0a40xdb1d858beed366f51c35efb19a25a7a19709976cfalse1000100694063134737174583985150000000000000000000010949899840xdb1d858beed366f51c35efb19a25a7a19709976c2025-10-19T16:50:51.000Z0xb83599b8a9c773816328618e96eba4078ab8e8a7c5d326d81b6c0cffb109bd0b
0xc12bdd620a54149df6b73fad9726d387402a90660x065fd3ba477c85503bfac48be7d1a2fcada02847false10030356102515900682958267285000000000000000000007949771970xeee6307021edf44fcf865fbd4dc53a212b71acaa2025-10-19T08:59:51.000Z0x7d10719160739aa76ba6797001ac5b137f341d919595aeed212471f85ff83273
Query with partition filter
SELECT *
FROM `tt-contracts.primenumbers_v1_xdc.VariableDebtToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100