platform||' ' ||pool_name as "LP",

count (distinct tx_hash) as "Swaps",

count (distinct origin_from_address) as "Swappers",

pool_address as "LP Address"

from avalanche.core.ez_decoded_event_logs join avalanche.defi.dim_dex_liquidity_pools on contract_address = pool_address

where tx_hash != creation_tx and block_timestamp >= '2023-01-01'

group by 1,4 order by 2 desc

limit 10