DATE(block_timestamp) AS transaction_date,

from_address,

to_pool_address,

swap_slip_bp,

SUM(liq_fee_rune_usd) AS total_liquidity_fee_usd,

COUNT(*) AS total_high_slippage_transactions

thorchain.defi.fact_swaps

swap_slip_bp > 1000 -- Example threshold for high slippage

GROUP BY

transaction_date,

from_address,

to_pool_address,

swap_slip_bp

ORDER BY

swap_slip_bp DESC

LIMIT 100;