The Ethereum core fact transactions, dim_labels and ez_decoded_events tables of the Flipside web app shall be used for this analysis. --- Important contract addresses: - 0x29469395eaf6f95920e59f858042f0e28d98a20b: is the blend protocol general contract address - 0x97bdb4aed0b50a335a78ed24f68528ce3222af72: is the blend protocol contract creating address(not used in the analysis) - 0x0000000000a39bb272e79075ade125fd351887ac and 0x000000000000ad05ccc4f10045630fb830b95127: are the blend protocol bidding contract addresses. --- To filter out transactions on the Blend protocol, the fact transaction tables is used and to_address = '0x29469395eaf6f95920e59f858042f0e28d98a20b' is used as the filter. To get the type of action performed by users on the Blend protocol, the first 10 strings of the input hex data is used ant the following coditions are used as filters: ```CASE WHEN input_data LIKE '0xc87df1c2%' THEN 'Repay' WHEN input_data LIKE '0xe263967e%' THEN 'Borrow' WHEN input_data LIKE '0x736da5ad%' THEN 'Refinance' WHEN input_data LIKE '0x5e05b33c%' THEN 'Start Aunction' WHEN input_data LIKE '0x3ed7d74d%' THEN 'Buy To Borrow ETH' WHEN input_data LIKE '0x06aec5ef%' THEN 'Take Bid' WHEN input_data LIKE '0x8553b234%' THEN 'Buy Locked ETH' WHEN input_data LIKE '0x4ae25a86%' THEN 'Cancel Offers' WHEN input_data LIKE '0x41af3763%' THEN 'Refinance Auction By Other' WHEN input_data LIKE '0x8593d5fc%' THEN 'Buy To Borrow' ELSE 'Others' END AS actions ``` The Others in the above code refers to actions that could not be manually filled from the transaction history of the general contract address on [Etherscan](https://etherscan.io/txs?a=0x29469395eaf6f95920e59f858042f0e28d98a20b&p=4) --- For the volume analysis, all amounts are in the $ETH token. This is to follow the convention found on [Etherscan](https://etherscan.io/token/0x0000000000a39bb272e79075ade125fd351887ac) showing that all borrowing amount are in the Blur pool and the value is pegged to the $ETH token. --- The top collections used on the platform are gotten from joining the decoded logs table to the dim_labels table on the contract_address = address. this filter gives the names of the collections used on Blend.

BLEND PROTOCOL