shreexMost Popular Swaps In Flow
    Updated 2022-06-20
    select
    split_part(token_in_contract,'.',-1) as swap_for,
    count(tx_id) as swap_for_count,
    sum(token_in_amount) as swapped_token_amount
    from flow.core.fact_swaps
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 4