flipside

    top 10 pairs were most popular among bot swappers in the past 30 days.
    headitmanagertop 10 pairs were most popular among bot swappers in the past 30 days.
    Updated 2022-04-27
    select count(*) as cnt,swap_pair from terra.swaps where msg_index>0 and block_timestamp::date >= DATEADD(month, -1, CURRENT_DATE) and swap_pair is not null
    group by swap_pair
    order by cnt desc
    limit 10
    Run a query to Download Data