Skip to main content

Tables

ActivePool_ActivePoolETHBalanceUpdated_event

ETH balance updates from Liquity v1’s Active Pool contract on Ethereum, tracking the total collateral held across all active Troves (collateralized debt positions). Used for monitoring protocol-wide collateral changes and system health 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__ETHSTRINGCurrent ETH balance in the Liquity Active Pool contract, denominated in wei (10^-18 ETH). This balance fluctuates as borrowers open, adjust, or close troves in the protocol.
addressin__ETHremovedlog_indexblock_numberblock_timestamptransaction_hash
0xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f364043492939298711187022false259151569132022-07-17T00:22:34.000Z0x0381f1e33e15fb52e6f6b5a673ba310254bb77b154bd15c166fd5c4812b802df
0xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f364053492939298711187022false474151577702022-07-17T03:28:20.000Z0x0959b4620f2ec9c9f92b465b5239576ad0a6f82a1b102831535b4120a1df4ea1
0xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f368154454556399450952052false480151597022022-07-17T10:47:15.000Z0x2e5b589f561a9dcd615e5dc5560e7175143cfac3400618ab82cacf79f6e461dc
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.ActivePool_ActivePoolETHBalanceUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BorrowerOperations_LUSDBorrowingFeePaid_event

Borrowing fee payment events from Liquity protocol on Ethereum, recording LUSD stablecoin fees paid by borrowers when opening or adjusting collateralized debt positions. Used for analyzing protocol fee revenue and borrower cost structure.
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__borrowerSTRINGAddress of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string.
in__LUSDFeeSTRINGAmount of LUSD borrowing fee paid by the borrower, denominated in wei (smallest unit of LUSD). Typically zero in these samples, but non-zero values represent fees charged when opening or adjusting Trove positions.
addressremovedlog_indexin__LUSDFeeblock_numberin__borrowerblock_timestamptransaction_hash
0x24179cd81c9e782a4096035f7ec97fb8b783e007false2300130706470x0561a78021d8966ddd20c28c6c4318d8675ee1f02021-08-21T19:56:49.000Z0x93568c4b48585798f0c1b6870500516438d95eb61bb17b66739b17a8d5249a20
0x24179cd81c9e782a4096035f7ec97fb8b783e007false760130690420x0561a78021d8966ddd20c28c6c4318d8675ee1f02021-08-21T13:56:56.000Z0x81f6a00109152e8989ed661b0d4cf12dbc3ff5c344d4ecaa7fa237f9d5c464fa
0x24179cd81c9e782a4096035f7ec97fb8b783e007false900130708640x251acec7536e28cc43268f92f1d554e64f4214202021-08-21T20:49:23.000Z0xae2d1a385e611a508618a2a71587fdcf5049ead351ab66730a9e8896c9798e2d
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.BorrowerOperations_LUSDBorrowingFeePaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DefaultPool_DefaultPoolETHBalanceUpdated_event

ETH balance change events from Liquity v1’s Default Pool contract on Ethereum, tracking collateral movements when troves are liquidated and their ETH is sent to the default pool. Used for monitoring liquidation mechanics and default pool collateral levels over time.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
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__ETHSTRINGETH balance in the Liquity Default Pool after the balance update event, denominated in wei. Stored as a string to preserve precision; sample values show zero balances during these particular events.
addressin__ETHremovedlog_indexblock_numberblock_timestamptransaction_hash
0x896a3f03176f05cfbb4f006bfcd8723f2b0d741c0false29149439842022-06-11T11:22:40.000Z0x8f9734fd1b557b394006da3025fdccf8e4c246772c7a15897d764032c9f661f5
0x896a3f03176f05cfbb4f006bfcd8723f2b0d741c0false11149439842022-06-11T11:22:40.000Z0x8f9734fd1b557b394006da3025fdccf8e4c246772c7a15897d764032c9f661f5
0x896a3f03176f05cfbb4f006bfcd8723f2b0d741c0false20149439842022-06-11T11:22:40.000Z0x8f9734fd1b557b394006da3025fdccf8e4c246772c7a15897d764032c9f661f5
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.DefaultPool_DefaultPoolETHBalanceUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StabilityPool_LQTYPaidToDepositor_event

LQTY token reward distribution events from Liquity Protocol’s Stability Pool on Ethereum. Tracks LQTY incentive payments to depositors who provide LUSD stablecoin liquidity to cover liquidations.
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__depositorSTRINGAddress of the user who made the deposit into the stability pool. Hex-encoded, 0x-prefixed, 42-character string.
in__LQTYSTRINGAmount of LQTY tokens paid to the depositor as stability pool rewards, denominated in wei (18 decimals). Can be zero if no rewards were accumulated at time of event.
addressremovedin__LQTYlog_indexblock_numberin__depositorblock_timestamptransaction_hash
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse894154073693521081490239146091820x00ff66ab8699aafa050ee5ef5041d1503aa0849a2022-04-18T12:28:32.000Z0x2f387de983e953e40dd702fb75d1bf628fef6257f8619ac97d6786c8f1923936
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse715670359712650311252126146081190x0d3abaa7e088c2c82f54b2f47613da438ea8c5982022-04-18T08:25:48.000Z0x390293906cc2e4a893af0e10745f980af926b974149f541db6655cd32522eda8
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse4697587454822296048841128146118040x0d3abaa7e088c2c82f54b2f47613da438ea8c5982022-04-18T22:26:36.000Z0xd27d6e82dada69882c207004042b9fa8944e2d6d9b586a3839c786cb44dd88b5
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.StabilityPool_LQTYPaidToDepositor_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StabilityPool_LQTYPaidToFrontEnd_event

LQTY token reward distributions to frontend operators in Liquity’s Stability Pool on Ethereum. Tracks frontend kickback payments where operators earn LQTY incentives for providing user interfaces to the protocol.
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__frontEndSTRINGEthereum address of the front-end operator receiving LQTY token rewards for facilitating Stability Pool deposits. This address earns a share of the depositor’s LQTY rewards as commission for providing the interface.
in__LQTYSTRINGAmount of LQTY tokens paid to the front-end operator as commission, denominated in wei (18 decimals). Values of ‘0’ indicate events where no LQTY commission was distributed.
addressremovedin__LQTYlog_indexblock_numberin__frontEndblock_timestamptransaction_hash
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse0122175758280x04e313306c008f704ad6e34a08d6523db3a271f92023-06-28T05:46:23.000Z0x6d650b49e73bffaccf1143cda543c62ed199f6b51b658b53f83d075e53a148d4
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse0187175794280x04e313306c008f704ad6e34a08d6523db3a271f92023-06-28T17:53:11.000Z0x4b809d527ab64f58b88f2a1526058710098f7e97d69c5388573de24fad74de94
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse0176175793880x04e313306c008f704ad6e34a08d6523db3a271f92023-06-28T17:45:11.000Z0x04e11d7581e25b5ba6c6044029426f474346117713869a4eebada815132fcfeb
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.StabilityPool_LQTYPaidToFrontEnd_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StabilityPool_StabilityPoolETHBalanceUpdated_event

ETH balance change events from Liquity V1’s Stability Pool contract on Ethereum, tracking the pool’s total ETH holdings in wei after each liquidation or deposit/withdrawal. Used for monitoring Stability Pool liquidity and analyzing liquidation gains distributed to LUSD depositors.
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__newBalanceSTRINGNew balance after the event or transaction. String-encoded integer representing the balance in smallest unit (wei for ETH, base units for tokens).
addressremovedlog_indexblock_numberin__newBalanceblock_timestamptransaction_hash
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse3721476331150065460306385294692012022-05-12T21:02:04.000Z0x10601f3205a1314b8fdf7cba1be0ee92f91e880d684dff5d601bca8b612da1b8
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse511475921259874634283975132157502022-05-12T05:15:52.000Z0xdb205f8d51fe279c71f0f8889e737f01ee02d300ed01538fc44ac2db5c06bfb1
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse1721475984065407544572631458069982022-05-12T07:36:16.000Z0x463fbe7b08b17d18232140f618cbdb340e9367662c02e8014debea5e56f46945
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.StabilityPool_StabilityPoolETHBalanceUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

StabilityPool_StabilityPoolLUSDBalanceUpdated_event

Liquity Stability Pool balance change events tracking LUSD deposits and withdrawals on Ethereum. Records the total pool balance after each update for monitoring stability pool reserves and user deposit activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__newBalanceSTRINGNew balance after the event or transaction. String-encoded integer representing the balance in smallest unit (wei for ETH, base units for tokens).
addressremovedlog_indexblock_numberin__newBalanceblock_timestamptransaction_hash
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse208134469354240022775418349999136784572021-10-19T07:44:53.000Z0xc17f32105bffee8b9d1f739a89fa15e72e7acdd910c9c6cc9adf60c3e55d994e
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse514134482774243721221411542668685081852021-10-19T12:49:35.000Z0x5407fe16d56676b47aa421aec0fd67da06fcc61e6ff311f78cc09ad97d45cdb9
0x66017d22b0f8556afdd19fc67041899eb65a21bbfalse114134480814243751778752845304910333392021-10-19T12:03:29.000Z0xb747eb2526908f7bd6cfb692c939b828d022e4f1f4eab21893e60ee26f443468
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.StabilityPool_StabilityPoolLUSDBalanceUpdated_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

TroveManager_Redemption_event

LUSD stablecoin redemption events from Liquity v1 protocol on Ethereum, capturing when users burn LUSD to reclaim ETH collateral from the system. Tracks attempted and actual LUSD amounts redeemed, ETH returned to redeemers, and redemption fees charged for analyzing collateral ratio dynamics and redemption arbitrage activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__attemptedLUSDAmountSTRINGLUSD stablecoin amount requested for redemption in the transaction, denominated in wei (18 decimals). This value matches the actual amount redeemed when sufficient collateral is available in the system.
in__actualLUSDAmountSTRINGActual amount of LUSD stablecoin redeemed in this transaction, denominated in wei (18 decimals). May differ from attempted amount if insufficient collateral was available across troves.
in__ETHSentSTRINGAmount of ETH collateral returned to the redeemer in exchange for LUSD tokens during this redemption event. Denominated in wei (10^-18 ETH), representing the collateral extracted from liquidated troves.
in__ETHFeeSTRINGETH fee charged for processing this redemption transaction in the Liquity protocol, denominated in wei (1e18 wei = 1 ETH). Values typically range from 0.15 to 2.45 ETH based on the redemption size.
addressremovedlog_indexin__ETHFeein__ETHSentblock_numberblock_timestamptransaction_hashin__actualLUSDAmountin__attemptedLUSDAmount
0xa39739ef8b0231dbfa0dcda07d7e29faabcf4bb2false8248275398400070406591149119224962803764177276192023-07-19T13:46:47.000Z0xb4c7112515317933cdebb1ade5f9b31441aa1098e13f3b79aec90d9bf6cc7f90173900478682579412000033173900478682579412000033
0xa39739ef8b0231dbfa0dcda07d7e29faabcf4bb2false15515212384417052262422674961987056379356183379402023-10-13T00:34:59.000Z0x6f348daf60f9104791bb0e3cbb3eddcd494a4552b86a86050b9ca043a643e2b83490300000000000000000034903000000000000000000
0xa39739ef8b0231dbfa0dcda07d7e29faabcf4bb2false23217814315170478680426225334942368619369183379422023-10-13T00:35:23.000Z0xc6908e62964925cc87a8b0153450c0e2481e180a72db4174cf46f01e97cd8d3d4036800000000000000000040368000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.TroveManager_Redemption_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Unipool_RewardPaid_event

Liquidity mining reward distribution events from Liquity v1’s LQTY-ETH Unipool staking contract on Ethereum, recording LQTY token payouts to liquidity providers. Used for analyzing reward claim patterns and liquidity mining participation.
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_rewardSTRINGContract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.
addressin_userremovedin_rewardlog_indexblock_numberblock_timestamptransaction_hash
0xd37a77e71ddf3373a79be2ebb76b6c4808bdf0d50x024bcbcaad82e67f721799e259ca60bc7d363419false1003014571024013930659164124048822021-05-10T05:57:07.000Z0x2fa294bc58421d85573a7729e952a7649ebf2f6341f1ce352d37bb906e79e501
0xd37a77e71ddf3373a79be2ebb76b6c4808bdf0d50x024bcbcaad82e67f721799e259ca60bc7d363419false1113654584277586352635256124083292021-05-10T18:44:11.000Z0x14c2d55944146f833a479d334021767435e9db9f9f68dbc327d9e326df5309ee
0xd37a77e71ddf3373a79be2ebb76b6c4808bdf0d50x024bcbcaad82e67f721799e259ca60bc7d363419false135670534576181891528167124033862021-05-10T00:28:21.000Z0xcae96db39673b4bab784e90b88a0fc2e6e017b4ced296abe06f7949ad599ba85
Query with partition filter
SELECT *
FROM `tt-contracts.liquity_v1_ethereum.Unipool_RewardPaid_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100