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 (-- SELECT-- symbol,-- price-- FROM-- prices.latest-- WHERE blockchain = 'flare'-- AND symbol IN ('FXRP', 'WFLR', 'STXRP', 'SFLR')-- GROUP BY 1,2-- ),get_prices AS (SELECTs.collateral_type,s.price_symbol,max_by(p.price, p.timestamp) AS price,max_by(p.timestamp, p.timestamp) AS price_timestampFROM query_6231640 sLEFT JOIN prices.latest pON p.symbol = s.price_symbolAND p.blockchain = 'flare'GROUP BYs.collateral_type,s.price_symbol),