Skip to main content

Tables

BendProtocolIncentivesController_RewardsClaimed_event

Incentive reward claim events from BendDAO lending protocol on Ethereum, tracking user addresses and token amounts claimed from the protocol’s rewards program. Used for analyzing liquidity mining participation and reward distribution patterns.
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 involved in the transaction. Hex-encoded, 0x-prefixed, 42-character string.
in__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
addressremovedin__userlog_indexin__amountblock_numberblock_timestamptransaction_hash
0x26fc1f11e612366d3367fc0cbfff9e819da91c8dfalse0x709a0cb04154ba08ce7e86c92ed82129889e5289451188563922041562421135294157676322022-10-17T11:49:47.000Z0xefa46866f2632d829651fceeebaca9d735bdf6782919a6823dd07bc80cbb2082
0x26fc1f11e612366d3367fc0cbfff9e819da91c8dfalse0x7a69c67db2cd5c5fa60e785fcd8a0a92744671891147953145236080675506689157696832022-10-17T18:42:11.000Z0xd2a223985d2962b4b2b81bd67e0d9c3951345ebcc0a8134ab17239671c8fa7b0
0x26fc1f11e612366d3367fc0cbfff9e819da91c8dfalse0xb87e278d4e487cb4cb8fd503efaf5b40c2739e4117051532319237577056900603157660412022-10-17T06:27:59.000Z0x61697dd0962a2bd7486d7519201e8c68c906ebb5cf6c692d0b57ab57c8783f84
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.BendProtocolIncentivesController_RewardsClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BToken_Burn_event

BToken burn events from BendDAO v1 NFT lending protocol on Ethereum, recording the destruction of interest-bearing bTokens when users withdraw their deposited assets. Useful for analyzing lending pool liquidity changes and user withdrawal patterns.
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_targetSTRINGAddress of the recipient contract or account receiving tokens or funds. 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_valuein_targetlog_indexblock_numberblock_timestamptransaction_hash
0xed1840223484483c0cb050e6fc344d1ebf0778a90x2338d34337dd0811b684640de74717b73f7b8059false110025012978911336690611619823458756206481986850x2338d34337dd0811b684640de74717b73f7b8059131176168712023-07-04T00:01:59.000Z0x5b3a3e03123e21da4b238b7d40fcca8cfefcee1a97996dcece4d01c9a68abe5b
0xed1840223484483c0cb050e6fc344d1ebf0778a90x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88false110029654701113722343131375613973809381679307939910x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88418176176982023-07-04T02:49:23.000Z0x675551542768c1ccb61bc0d5a0e2f49da8c3e98dc74c4703282b05254f9bf59c
0xed1840223484483c0cb050e6fc344d1ebf0778a90x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88false11008112928571965926659220992000840270702211713690x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88159176224612023-07-04T18:53:11.000Z0xa4b04df34277618fbeb27215347dbb7e9f155caa942938e4a8c5c774c2c4e747
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.BToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BToken_Mint_event

BToken mint events from BendDAO v1 NFT lending protocol on Ethereum, tracking interest-bearing token issuance when users deposit collateral. Used for analyzing deposit activity, liquidity provision patterns, and protocol usage across different BToken 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_fromSTRINGAddress originating the transfer or 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_numberblock_timestamptransaction_hash
0x9631c79bfd6123a5b53307b6cdfb35f97606f9540x43078abfb76bd24885fd64effb22049f92a8c495false1001813320608760629733020457493538158178412332023-08-04T11:10:35.000Z0x603e1bc81c27ef067cd5331e4bd471cdf4333a13c60e539037ad7d533dd3bea7
0x9631c79bfd6123a5b53307b6cdfb35f97606f9540x43078abfb76bd24885fd64effb22049f92a8c495false1001813588172505488550406232865487178412902023-08-04T11:21:59.000Z0x9043d8a65f8f4e77a8b05da3365aa7480e32c4fc0d09b22c29394eac3ae825df
0x9631c79bfd6123a5b53307b6cdfb35f97606f9540x472fcc65fab565f75b1e0e861864a86fe5bced7bfalse100181434267589675952015592450000000000138178413262023-08-04T11:29:11.000Z0xb35732c4b279dfc566be23154bcd20c98cdc167804411bf6c547137344d2925d
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.BToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

BToken_Transfer_event

BToken transfer events from BendDAO v1 NFT lending protocol on Ethereum, tracking interest-bearing token movements where mints from zero address represent collateral deposits. Used to analyze protocol deposits, withdrawals, and liquidity provider 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_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
0x43078abfb76bd24885fd64effb22049f92a8c4950xed1840223484483c0cb050e6fc344d1ebf0778a90x0000000000000000000000000000000000000000false19755038163865339266164281112023-01-17T17:47:47.000Z0x017e8f872e95b503cf19629759b9d0dcc67921aab22f5cadfac563ce17a0f28c
0x43078abfb76bd24885fd64effb22049f92a8c4950xed1840223484483c0cb050e6fc344d1ebf0778a90x0000000000000000000000000000000000000000false18457363649971786262164281112023-01-17T17:47:47.000Z0x017e8f872e95b503cf19629759b9d0dcc67921aab22f5cadfac563ce17a0f28c
0x43078abfb76bd24885fd64effb22049f92a8c4950xed1840223484483c0cb050e6fc344d1ebf0778a90x0000000000000000000000000000000000000000false38608908200893764168164292392023-01-17T21:34:11.000Z0x03f637a53863626bf51d2d8a6217c423c4dc18d1a00d816b00cd4b0c480a9362
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.BToken_Transfer_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DebtToken_Burn_event

Debt token burn events from BendDAO NFT lending protocol on Ethereum, recording when users repay borrowed amounts and reduce their debt positions. Tracks repayment amounts, borrower addresses, and protocol index values for analyzing loan repayment activity.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_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
0x87dde3a3f4b629e389ce5894c9a1f34a7eec56480x5c529624d1b7e1e06b9caede6cda8e975eb977d8false1457252340028222444021259038180000000000000000210180843072023-09-07T11:39:47.000Z0xd2e37ebfbefa7179b8e88f9a530aa3c51568246a4518ec1d9db0cb73567acee3
0x87dde3a3f4b629e389ce5894c9a1f34a7eec56480xba34f93dbadd48111982a049f6244507c3276ab8false14571330429990891521234900431120341532952245423162180832852023-09-07T08:12:23.000Z0xde7b37acb08ab226ba78978fbe747b0e04a510122325d66c38c16babcf7a6eda
0x87dde3a3f4b629e389ce5894c9a1f34a7eec56480x2eec6e3e6f8b3b01832ae6902c0052ccf2303df2false1456876217341071934145173401679530030283447144233180810632023-09-07T00:45:59.000Z0x8db370643f45e165b148f38d923d843f34eacab61c6d709824df1706bcb96e8c
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.DebtToken_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DebtToken_Mint_event

Debt token minting events from BendDAO v1 NFT lending protocol on Ethereum, tracking when borrowers receive debt tokens against collateralized NFTs. Enables analysis of borrowing activity, loan origination volumes, and debt accumulation across BendDAO users.
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_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_numberblock_timestamptransaction_hash
0x87dde3a3f4b629e389ce5894c9a1f34a7eec56480x065e5660f14c04074fcfdd80bacfcda72b0c238cfalse10367539531065396382851639042920000000000000000540148711242022-05-30T06:42:14.000Z0x04ea1053d13f6c56ce1dd61ae19db975c6c8df42aae7a441c87b56292209d91e
0x87dde3a3f4b629e389ce5894c9a1f34a7eec56480xb7ef760f30d139097ba547bd6f0dfaecbf148452false10368716474678224424568198512985200000000000000394148727022022-05-30T13:10:33.000Z0xac38e1399a97b3af7f28b5981cf588a5d662e7fc768abfc3397d9cf6193b70ff
0x87dde3a3f4b629e389ce5894c9a1f34a7eec56480xb7ef760f30d139097ba547bd6f0dfaecbf148452false10368716474678224424568198512985200000000000000375148727022022-05-30T13:10:33.000Z0xac38e1399a97b3af7f28b5981cf588a5d662e7fc768abfc3397d9cf6193b70ff
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.DebtToken_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendPool_Deposit_event

Deposit events from BendDAO’s NFT lending protocol on Ethereum, capturing WETH (Wrapped ETH) deposits into lending pools with depositor addresses, amounts, beneficiary accounts, and referral codes. Used for tracking liquidity provision and analyzing lender behavior in NFT-collateralized 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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_reserveSTRINGContract address of the reserve asset in the lending pool 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_onBehalfOfSTRINGAddress of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
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
0x70b97a0da65c15dfb0ffa02aee6fa36e507c27620x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88false1124000000000000000002080xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20184496630x4cf7199daa66ae488a0f07dda34b8b0a735576022023-10-28T15:42:59.000Z0xf9b3314bc19be88649b55881fa1817ddd61455a84f70c4f3a27723da107272e4
0x70b97a0da65c15dfb0ffa02aee6fa36e507c27620x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88false495000000000000000003580xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20165858520x5dca817c0386f5095042d8f67565d554a6f4c7192023-02-08T18:32:11.000Z0x9e48bd4de1d4468b31276552d229c34b2aa46feb7eaaad18023fee7c24641c23
0x70b97a0da65c15dfb0ffa02aee6fa36e507c27620x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88false1050000000000000000002020xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20165822580x1cc7c34ab3e1892fd87970a65fdccaa42c31d1df2023-02-08T06:25:35.000Z0x4488d5bd8a9cb0fcae8b14bf24cb4779137a2f1d93072593f6c554c13c29f414
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.LendPool_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

LendPool_Withdraw_event

Withdrawal events from BendDAO v1 lending pool on Ethereum, recording when users withdraw deposited assets including withdrawal amounts, recipient addresses, and reserve token contracts. Used for tracking liquidity movements and user redemption activity in the NFT lending 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_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_reserveSTRINGContract address of the reserve asset in the lending pool 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_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toaddressin_userremovedin_amountlog_indexin_reserveblock_numberblock_timestamptransaction_hash
0x3b968d2d299b895a5fcf3bba7a64ad0f566e6f880x70b97a0da65c15dfb0ffa02aee6fa36e507c27620x3b968d2d299b895a5fcf3bba7a64ad0f566e6f88false10002892190007651541112590xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2182901652023-10-06T08:06:59.000Z0xddf00003ca4bcaa578590c8192653ec0c8371e4d87833a2a05e59178252a592a
0xf3ab1d58ce6b9e0d42b8958c918649305e1b1d260x70b97a0da65c15dfb0ffa02aee6fa36e507c27620xf3ab1d58ce6b9e0d42b8958c918649305e1b1d26false915471846996051047800xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2182877512023-10-06T00:01:35.000Z0x5cc00f3c6d9d5192de25e7aded2230bf4e482e2612454d1329c973580d2ac5d2
0xf3ab1d58ce6b9e0d42b8958c918649305e1b1d260x70b97a0da65c15dfb0ffa02aee6fa36e507c27620xf3ab1d58ce6b9e0d42b8958c918649305e1b1d26false19771735910xdac17f958d2ee523a2206206994597c13d831ec7182877512023-10-06T00:01:35.000Z0x5cc00f3c6d9d5192de25e7aded2230bf4e482e2612454d1329c973580d2ac5d2
Query with partition filter
SELECT *
FROM `tt-contracts.benddao_v1_ethereum.LendPool_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100