Query editor
with ranked AS (SELECTdate_trunc('day', evt_block_time) AS day,name,SUM(loan_amount_usd) AS volume_usd,SUM(loan_amount_eth) AS volume_eth,RANK() OVER (PARTITION BY date_trunc('day', evt_block_time) ORDER BY SUM(loan_amount_usd) DESC) AS rFROMquery_3015748GROUP BY 1, 2)/*top14od as (selectnft_collection_name,sum(amount*price) as odfrom query_3525878 left join query_3675587 on token = symbolwhere loan_status = 'Active'group by 1order by 2 desclimit 14)week_end_dates as (select distinct date_trunc('day', evt_block_time) as datefrom query_4244652where evt_block_time >= CAST(NOW() as timestamp) - interval '90' Day),loan_start as (SELECTloan_amount_usd,loan_amount_original,loan_token_address,loan_token_symbol,evt_block_time as day,unique_id, name, collateral_contract, collateral_id,(date_add('day', CAST(loan_duration as BIGINT), evt_block_time)) as maturityFROMdune.nftfifoundation.result_nf_tfi_loans_started_events),loans_reneg as (SELECT-loan_amount_usd as loan_amount_usd,evt_block_time as day,unique_id,date_add('day', CAST(loan_duration as BIGINT), loan_start_time) as maturity,ROW_NUMBER() OVER (PARTITION BY CONCAT(loan_id, CAST(contract_address as VARCHAR)) ORDER BY evt_block_time DESC) as rnFROMquery_3715138),loans_ended as (SELECTloan_amount_usd,