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_deets as (selectq4.block_time,q4.block_number,q4.tx_hash,gt.owner,q4.trove_id,q4.collateral_type,q4.debt_change,abs(q4.debt_change) / (tu.debt - q4.debt_change) as debt_share,tu.debt - q4.debt_change as previous_debt,q4.collateral_change,q4.interest_rates,rf.redemption_fee * pu.price as redemption_feefromquery_6370673 q4 -- Trove Operationsleft joinget_trove_id gton q4.trove_id = gt.trove_idand q4.collateral_type = gt.collateral_typeleft joinquery_6370622 tu -- trove updates (v2 of the query)on q4.trove_id = tu.trove_idand q4.collateral_type = tu.collateral_typeand q4.block_number = tu.block_numberand q4.tx_hash = tu.tx_hashleft joinquery_6370412 rf -- redemption feeson q4.trove_id = rf.trove_idand q4.collateral_type = rf.collateral_typeand q4.block_number = rf.block_numberand q4.tx_hash = rf.tx_hashLEFT JOIN prices.day puON date_trunc('day', rf.block_minute) = date_trunc('day', pu.timestamp)AND pu.symbol = q4.collateral_typeAND pu.blockchain = 'flare'WHERE CAST(q4.operation AS double) = 6)selectblock_time,block_number,get_href(get_chain_explorer_tx_hash('flare', tx_hash),concat('', substring(cast(tx_hash as varchar), 1, 5), '...', "RIGHT"(cast(tx_hash as varchar), 4))) as tx_hash,get_href(get_chain_explorer_address('flare', owner),concat('', substring(cast(owner as varchar), 1, 5), '...', "RIGHT"(cast(owner as varchar), 4))) as owner,