Query editor
selectEXTRACT(day from date_add('day', cast(loan_duration as bigint), evt_block_time) - current_date) as "Loan Due in",a.Borrower as "Borrower Address",cast(a.lender as varchar) as "Lender Address",'NFTfi' as Protocol,name as Collection,cast(collateral_id as uint256) as "NFT ID",loan_amount_original as "Principal",loan_token_symbol as "Currency",APR/100 as APR,loan_duration as Duration,date_add('day', cast(loan_duration as bigint), evt_block_time) as "Maturity Date",evt_tx_hash as "Loan Start tx",loan_id as loanId,collateral_contract as nft_collection,evt_block_time as "Start Date",isProRata,CASEWHEN isProRata = TRUE THEN 'Flexible'ELSE 'Fixed'END AS "Loan Type",'<a href="https://app.nftfi.com/assets/' || cast(collateral_contract as varchar) || '/' || cast(collateral_id as varchar) || '" target="_blank">' || 'https://app.nftfi.com/assets/' || cast(collateral_contract as varchar) || '/' || cast(collateral_id as varchar) || '</a>' as "Link to Loan",loan_amount_original * price as "Principal [in USD]",al.od + n.od + g.od + x.od + z.od as "Borrower OD [in USD]",al.loans + n.loans + g.loans + x.loans + z.loans as "Borrower Active Loans",n.od as "Borrower OD on NFTfi [in USD]",n.loans as "Borrower Active Loans on NFTfi",g.od as "Borrower OD on Gondi [in USD]",g.loans as "Borrower Active Loans on Gondi",al.od as "Borrower OD on Arcade [in USD]",al.loans as "Borrower Active Loans on Arcade",x.od as "Borrower OD on X2Y2 [in USD]",x.loans as "Borrower Active Loans on X2Y2",z.od as "Borrower OD on Zharta [in USD]",z.loans as "Borrower Active Loans on Zharta",al_len.od + n_len.od + g_len.od + x_len.od + z_len.od as "Lender OD [in USD]",al_len.loans + n_len.loans + g_len.loans + x_len.loans + z_len.loans as "Lender Active Loans",n_len.od as "Lender OD on NFTfi [in USD]",n_len.loans as "Lender Active Loans on NFTfi",g_len.od as "Lender OD on Gondi [in USD]",g_len.loans as "Lender Active Loans on Gondi",al_len.od as "Lender OD on Arcade [in USD]",al_len.loans as "Lender Active Loans on Arcade",x_len.od as "Lender OD on X2Y2 [in USD]",x_len.loans as "Lender Active Loans on X2Y2",z_len.od as "Lender OD on Zharta [in USD]",z_len.loans as "Lender Active Loans on Zharta","Lender Balance [in USD]","Lender WETH/ETH Balance","USDC Balance"fromquery_3015748 aleft join query_3675587 p on p.symbol = loan_token_symbolleft join dune."nftfi-team".result_active_borrowers al on a.borrower = al.borrower and al.protocol = 'arcade'left join dune."nftfi-team".result_active_borrowers n on a.borrower = n.borrower and n.protocol = 'nftfi'left join dune."nftfi-team".result_active_borrowers g on a.borrower = g.borrower and g.protocol = 'gondi'left join dune."nftfi-team".result_active_borrowers x on a.borrower = x.borrower and x.protocol = 'x2y2'left join dune."nftfi-team".result_active_borrowers z on a.borrower = z.borrower and z.protocol = 'zharta'left join dune."nftfi-team".result_active_lenders al_len on cast(a.lender as varchar) = al_len.lender and al_len.protocol = 'arcade'