Query editor
with fills as (selectevt_block_time,solver,concat('0x', substr(json_extract_scalar(json_parse(output), '$.token'), 27)) as token_address,finalAmountfrom lifi_robinhood.output_evt_outputfilledwhere evt_block_time >= cast('2026-05-26' as date) --launched),priced as (selectf.solver,f.finalAmount / power(10, e.decimals) * p.price as final_amount_usdfrom fills fleft join tokens.erc20 eon cast(e.contract_address as varchar) = f.token_addressand e.blockchain = 'robinhood'left join prices.usd pon cast(p.contract_address as varchar) = f.token_addressand p.blockchain = 'robinhood'and p.minute = date_trunc('minute', f.evt_block_time))selectsolver,count(*) as orders_filled,sum(final_amount_usd) as total_usd_filled,sum(final_amount_usd) * 1.0 / sum(sum(final_amount_usd)) over () as pct_of_volumefrom pricedgroup by solverorder by total_usd_filled desc