Query editor
withtrades as (Selecttrades.blockchain,count(distinct taker) as users,count(distinct trades.tx_hash) as trades,sum(amount_usd) as usd_volume,count(distinct token_pair) as pairs,sum( amount_usd * (cast(fee as double)/1e6)) as fees,sum(tx_fee_usd) as gas_feesfromuniswap.trades tradesleft join uniswap.pools pools on trades.blockchain = pools.blockchain and pools.pool = trades.project_contract_addressleft join gas.fees gas on gas.blockchain = trades.blockchain and trades.tx_hash = gas.tx_hash and gas.block_date >= NOW() - INTERVAL '{{Enter Period in Days}}' daywheretrades.block_date >= NOW() - INTERVAL '{{Enter Period in Days}}' dayand trades.version = '3'group by1),tokens as (selectblockchain,count(distinct token) as tokensfrom(select distinctblockchain,token_bought_address as tokenfromuniswap.tradeswhereblock_date >= NOW() - INTERVAL '{{Enter Period in Days}}' dayand version = '3'UNIONselect distinctblockchain,token_sold_address as tokenfromuniswap.tradeswhereblock_date >= NOW() - INTERVAL '{{Enter Period in Days}}' dayand version = '3')group byblockchain),ranks as (selecttrades.blockchain,(rank() over (order by users desc)+ rank() over (order by trades desc)+ rank() over (order by usd_volume desc)+ rank() over (order by fees desc)+ rank() over (order by gas_fees/cast(trades as double) asc))/cast(5 as double) as rank_index,rank() over (order by users desc) as trader_rank,rank() over (order by trades desc) as trades_rank,rank() over (order by trades/cast(users as double) desc) as trades_per_user_rank,rank() over (order by usd_volume desc) as usd_volume_rank,rank() over (order by usd_volume/cast(users as double) desc) as usd_volume_per_user_rank,