select
    txn_hash,
    dex,
    from_token,
    from_token_name,
    (1.0 * from_token_amt / POWER(10, from_token_dec)) from_normalized_amt,
    to_token,
    to_token_name,
    to_token_amt,
    (1.0 * to_token_amt / POWER(10, to_token_dec)) to_normalized_amt,
    CASE
        WHEN 1.0 * from_token_usd > 0 THEN (1.0 * from_token_amt / POWER(10, from_token_dec)) * (1.0 * from_token_usd / POWER(10, from_token_usd_dec))
        WHEN 1.0 * to_token_usd > 0 THEN (1.0 * to_token_amt / POWER(10, to_token_dec)) * (1.0 * to_token_usd / POWER(10, to_token_usd_dec))
        ELSE 0
    END AS trade_volume
from @sim.dex_trades
order by trade_volume desc
limit 100;