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.Columns
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__ETH | STRING | Current 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. |
Sample Data
Sample Data
| address | in__ETH | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f | 364043492939298711187022 | false | 259 | 15156913 | 2022-07-17T00:22:34.000Z | 0x0381f1e33e15fb52e6f6b5a673ba310254bb77b154bd15c166fd5c4812b802df |
| 0xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f | 364053492939298711187022 | false | 474 | 15157770 | 2022-07-17T03:28:20.000Z | 0x0959b4620f2ec9c9f92b465b5239576ad0a6f82a1b102831535b4120a1df4ea1 |
| 0xdf9eb223bafbe5c5271415c75aecd68c21fe3d7f | 368154454556399450952052 | false | 480 | 15159702 | 2022-07-17T10:47:15.000Z | 0x2e5b589f561a9dcd615e5dc5560e7175143cfac3400618ab82cacf79f6e461dc |
Example Query
Example Query
Query with partition filter
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.Columns
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__borrower | STRING | Address of the account that borrowed funds or holds the borrowing position. Hex-encoded, 0x-prefixed, 42-character string. |
in__LUSDFee | STRING | Amount 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. |
Sample Data
Sample Data
| address | removed | log_index | in__LUSDFee | block_number | in__borrower | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x24179cd81c9e782a4096035f7ec97fb8b783e007 | false | 230 | 0 | 13070647 | 0x0561a78021d8966ddd20c28c6c4318d8675ee1f0 | 2021-08-21T19:56:49.000Z | 0x93568c4b48585798f0c1b6870500516438d95eb61bb17b66739b17a8d5249a20 |
| 0x24179cd81c9e782a4096035f7ec97fb8b783e007 | false | 76 | 0 | 13069042 | 0x0561a78021d8966ddd20c28c6c4318d8675ee1f0 | 2021-08-21T13:56:56.000Z | 0x81f6a00109152e8989ed661b0d4cf12dbc3ff5c344d4ecaa7fa237f9d5c464fa |
| 0x24179cd81c9e782a4096035f7ec97fb8b783e007 | false | 90 | 0 | 13070864 | 0x251acec7536e28cc43268f92f1d554e64f421420 | 2021-08-21T20:49:23.000Z | 0xae2d1a385e611a508618a2a71587fdcf5049ead351ab66730a9e8896c9798e2d |
Example Query
Example Query
Query with partition filter
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.Columns
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__ETH | STRING | ETH 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. |
Sample Data
Sample Data
| address | in__ETH | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x896a3f03176f05cfbb4f006bfcd8723f2b0d741c | 0 | false | 29 | 14943984 | 2022-06-11T11:22:40.000Z | 0x8f9734fd1b557b394006da3025fdccf8e4c246772c7a15897d764032c9f661f5 |
| 0x896a3f03176f05cfbb4f006bfcd8723f2b0d741c | 0 | false | 11 | 14943984 | 2022-06-11T11:22:40.000Z | 0x8f9734fd1b557b394006da3025fdccf8e4c246772c7a15897d764032c9f661f5 |
| 0x896a3f03176f05cfbb4f006bfcd8723f2b0d741c | 0 | false | 20 | 14943984 | 2022-06-11T11:22:40.000Z | 0x8f9734fd1b557b394006da3025fdccf8e4c246772c7a15897d764032c9f661f5 |
Example Query
Example Query
Query with partition filter
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.Columns
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__depositor | STRING | Address of the user who made the deposit into the stability pool. Hex-encoded, 0x-prefixed, 42-character string. |
in__LQTY | STRING | Amount 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. |
Sample Data
Sample Data
| address | removed | in__LQTY | log_index | block_number | in__depositor | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 894154073693521081490 | 239 | 14609182 | 0x00ff66ab8699aafa050ee5ef5041d1503aa0849a | 2022-04-18T12:28:32.000Z | 0x2f387de983e953e40dd702fb75d1bf628fef6257f8619ac97d6786c8f1923936 |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 7156703597126503112521 | 26 | 14608119 | 0x0d3abaa7e088c2c82f54b2f47613da438ea8c598 | 2022-04-18T08:25:48.000Z | 0x390293906cc2e4a893af0e10745f980af926b974149f541db6655cd32522eda8 |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 4697587454822296048841 | 128 | 14611804 | 0x0d3abaa7e088c2c82f54b2f47613da438ea8c598 | 2022-04-18T22:26:36.000Z | 0xd27d6e82dada69882c207004042b9fa8944e2d6d9b586a3839c786cb44dd88b5 |
Example Query
Example Query
Query with partition filter
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.Columns
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__frontEnd | STRING | Ethereum 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__LQTY | STRING | Amount 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. |
Sample Data
Sample Data
| address | removed | in__LQTY | log_index | block_number | in__frontEnd | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 0 | 122 | 17575828 | 0x04e313306c008f704ad6e34a08d6523db3a271f9 | 2023-06-28T05:46:23.000Z | 0x6d650b49e73bffaccf1143cda543c62ed199f6b51b658b53f83d075e53a148d4 |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 0 | 187 | 17579428 | 0x04e313306c008f704ad6e34a08d6523db3a271f9 | 2023-06-28T17:53:11.000Z | 0x4b809d527ab64f58b88f2a1526058710098f7e97d69c5388573de24fad74de94 |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 0 | 176 | 17579388 | 0x04e313306c008f704ad6e34a08d6523db3a271f9 | 2023-06-28T17:45:11.000Z | 0x04e11d7581e25b5ba6c6044029426f474346117713869a4eebada815132fcfeb |
Example Query
Example Query
Query with partition filter
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.Columns
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__newBalance | STRING | New balance after the event or transaction. String-encoded integer representing the balance in smallest unit (wei for ETH, base units for tokens). |
Sample Data
Sample Data
| address | removed | log_index | block_number | in__newBalance | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 372 | 14763311 | 5006546030638529469201 | 2022-05-12T21:02:04.000Z | 0x10601f3205a1314b8fdf7cba1be0ee92f91e880d684dff5d601bca8b612da1b8 |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 51 | 14759212 | 5987463428397513215750 | 2022-05-12T05:15:52.000Z | 0xdb205f8d51fe279c71f0f8889e737f01ee02d300ed01538fc44ac2db5c06bfb1 |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 172 | 14759840 | 6540754457263145806998 | 2022-05-12T07:36:16.000Z | 0x463fbe7b08b17d18232140f618cbdb340e9367662c02e8014debea5e56f46945 |
Example Query
Example Query
Query with partition filter
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.Columns
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__newBalance | STRING | New balance after the event or transaction. String-encoded integer representing the balance in smallest unit (wei for ETH, base units for tokens). |
Sample Data
Sample Data
| address | removed | log_index | block_number | in__newBalance | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 208 | 13446935 | 424002277541834999913678457 | 2021-10-19T07:44:53.000Z | 0xc17f32105bffee8b9d1f739a89fa15e72e7acdd910c9c6cc9adf60c3e55d994e |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 514 | 13448277 | 424372122141154266868508185 | 2021-10-19T12:49:35.000Z | 0x5407fe16d56676b47aa421aec0fd67da06fcc61e6ff311f78cc09ad97d45cdb9 |
| 0x66017d22b0f8556afdd19fc67041899eb65a21bb | false | 114 | 13448081 | 424375177875284530491033339 | 2021-10-19T12:03:29.000Z | 0xb747eb2526908f7bd6cfb692c939b828d022e4f1f4eab21893e60ee26f443468 |
Example Query
Example Query
Query with partition filter
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.Columns
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__attemptedLUSDAmount | STRING | LUSD 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__actualLUSDAmount | STRING | Actual 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__ETHSent | STRING | Amount 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__ETHFee | STRING | ETH 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. |
Sample Data
Sample Data
| address | removed | log_index | in__ETHFee | in__ETHSent | block_number | block_timestamp | transaction_hash | in__actualLUSDAmount | in__attemptedLUSDAmount |
|---|---|---|---|---|---|---|---|---|---|
| 0xa39739ef8b0231dbfa0dcda07d7e29faabcf4bb2 | false | 82 | 482753984000704065 | 91149119224962803764 | 17727619 | 2023-07-19T13:46:47.000Z | 0xb4c7112515317933cdebb1ade5f9b31441aa1098e13f3b79aec90d9bf6cc7f90 | 173900478682579412000033 | 173900478682579412000033 |
| 0xa39739ef8b0231dbfa0dcda07d7e29faabcf4bb2 | false | 155 | 152123844170522624 | 22674961987056379356 | 18337940 | 2023-10-13T00:34:59.000Z | 0x6f348daf60f9104791bb0e3cbb3eddcd494a4552b86a86050b9ca043a643e2b8 | 34903000000000000000000 | 34903000000000000000000 |
| 0xa39739ef8b0231dbfa0dcda07d7e29faabcf4bb2 | false | 232 | 178143151704786804 | 26225334942368619369 | 18337942 | 2023-10-13T00:35:23.000Z | 0xc6908e62964925cc87a8b0153450c0e2481e180a72db4174cf46f01e97cd8d3d | 40368000000000000000000 | 40368000000000000000000 |
Example Query
Example Query
Query with partition filter
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.Columns
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_reward | STRING | Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string. |
Sample Data
Sample Data
| address | in_user | removed | in_reward | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 0xd37a77e71ddf3373a79be2ebb76b6c4808bdf0d5 | 0x024bcbcaad82e67f721799e259ca60bc7d363419 | false | 1003014571024013930659 | 164 | 12404882 | 2021-05-10T05:57:07.000Z | 0x2fa294bc58421d85573a7729e952a7649ebf2f6341f1ce352d37bb906e79e501 |
| 0xd37a77e71ddf3373a79be2ebb76b6c4808bdf0d5 | 0x024bcbcaad82e67f721799e259ca60bc7d363419 | false | 1113654584277586352635 | 256 | 12408329 | 2021-05-10T18:44:11.000Z | 0x14c2d55944146f833a479d334021767435e9db9f9f68dbc327d9e326df5309ee |
| 0xd37a77e71ddf3373a79be2ebb76b6c4808bdf0d5 | 0x024bcbcaad82e67f721799e259ca60bc7d363419 | false | 1356705345761818915281 | 67 | 12403386 | 2021-05-10T00:28:21.000Z | 0xcae96db39673b4bab784e90b88a0fc2e6e017b4ced296abe06f7949ad599ba85 |
Example Query
Example Query
Query with partition filter