Query editor
WITHget_trove_id AS (SELECTmax_by(address, day) AS owner,collateral_type,token_id AS trove_idFROMquery_6370564WHERE balance > 0GROUP BY 2, 3),get_latest AS (SELECTtv.*,gt.ownerFROM (SELECTtrove_id,collateral_type,max_by(debt, (block_number, tx_index)) AS debt,max_by(collateral, (block_number, tx_index)) AS collateral,max_by(interest_rates, (block_number, tx_index)) AS interest_rates,min(block_time) AS created_time,max(block_time) AS last_modified_timeFROMquery_6370622GROUP BY 1, 2) tvLEFT JOINget_trove_id gtON tv.trove_id = gt.trove_idAND tv.collateral_type = gt.collateral_type),get_prices AS (SELECTsymbol,priceFROMprices.latestWHERE blockchain = 'flare'AND symbol IN ('FXRP', 'WFLR')GROUP BY 1,2),-- get_prices AS (-- SELECT-- cs.collateral_type,-- p.price AS collateral_price-- FROM query_6231640 cs-- INNER JOIN prices.latest p-- ON p.symbol = cs.price_symbol-- WHERE p.blockchain = 'flare'-- )enrich AS (SELECTconcat('', substring(cast(gl.owner AS varchar), 1, 5), '...', "RIGHT"(cast(gl.owner AS varchar), 4)) AS owner_slim,gl.owner,concat('', substring(cast(gl.trove_id AS varchar), 1, 5), '...', "RIGHT"(cast(gl.trove_id AS varchar), 4)) AS trove_id,