Query editor
withprice as (selectP.token,P.call_block_number as block_number,P.output_0 as pricefromlevel_finance_bnb.LevelOracle_call_getPrice Pgroup by1,2,3),swap as (selectsubstr(extradata, 13, 20) as address,cast(Swap.amountIn as decimal) * cast(Price.price as decimal) / 1e30 as volume,cast(Swap.fee as decimal) * cast(Price.price as decimal) / 1e30 as feefromlevel_finance_bnb.Pool_evt_Swap Swapjoin price Price on Swap.tokenIn = Price.tokenand Swap.evt_block_number = Price.block_numberjoin level_finance_bnb.Pool_call_swap func_swap on Swap.evt_tx_hash = func_swap.call_tx_hashand func_swap.call_success = true)selectaddress,sum(volume) as volume,sum(fee) as fees_paidfromswapwhere address != 0xgroup byaddressorder byvolume desc