HitmonleeCryptoJUP Wallet Most Bought Asset
    Updated 2024-11-03
    select
    DISTINCT swap_to_symbol as most_bought_asset,
    sum(swap_to_amount_usd) as total_swap_to_amount_usd,
    sum(swap_from_amount_usd) as total_swap_from_amount_usd,
    sum(swap_to_amount_usd) - sum(swap_from_amount_usd) AS slippage_usd
    -- sum(sum(swap_to_amount_usd) - sum(swap_from_amount_usd)) over () as total_slippage_usd

    from
    solana.defi.ez_dex_swaps
    where
    swapper = '{{Address}}' and
    swap_to_amount_usd >= 1 AND
    swap_from_amount_usd >= 1
    and swap_program ILIKE '%jupiter%'

    group by
    swap_to_symbol
    order by
    total_swap_to_amount_usd DESC
    limit 100;