Try Quests to earn cryptoINTRO
The blend protocol is a lending protocol with NFT collateral in the blur market. Users who are NFT holders and do not want to sell their NFTs can pledge their tokens on this platform with zero fees and borrow Ether tokens in return. Users who are interested in lending can lend their Ethereum assets in exchange for NFT as collateral. The blend protocol implements a peer-to-peer protocol and connects NFT holders to lenders.
METHOD
Using the ethereum.core.ez_decoded_event_logs table and placing the blend contract address (0x29469395eaf6f95920e59f858042f0e28d98a20b) and filtering the query using ORIGIN_FUNCTION_SIGNATURE='0xe263967e', which is related to the loan process. And placing the contract address of the Blur pool (0x0000000000a39bb272e79075ade125fd351887ac) as the contract address, we called the data related to the lending process of the blend protocol. By joining this table with ethereum.core.ez_nft_transfers, we called the data related to the collections.
