flipside

    Identified bots on Flow
    SocioCryptoIdentified bots on Flow
    Updated 2022-07-19
    SELECT DISTINCT trader
    FROM
    (
    SELECT trader,
    date_trunc('hour',block_timestamp) as hours,
    count(tx_id) as n_swaps
    FROM flow.core.fact_swaps
    GROUP BY trader,hours
    )
    WHERE n_swaps >= 30
    Run a query to Download Data