flipside

    Pools and Piars Bots Loving.
    mboveiriPools and Piars Bots Loving.
    Updated 2022-04-26
    with BOTS as (select date_trunc('minute',block_timestamp) time,TRADER, count(*) count
    from terra.swaps WHERE block_timestamp >= CURRENT_DATE - 60
    group by time,trader
    having count(*)>10
    )
    --TX_IDS as ( select DISTINCT(tx_id) from terra.swaps WHERE trader in (select trader from BOTS) and block_timestamp >= CURRENT_DATE - 30 )


    select swap_pair,
    count(1) as Number_Of_Transaction
    from terra.swaps
    where TRADER in (select trader from BOTS) and swap_pair is not null and block_timestamp >= CURRENT_DATE - 30
    group by 1
    order by 2 desc

    Run a query to Download Data