2844FREQUENCY OF SWAPS-TABLE
    Updated 2022-07-07
    SELECT DISTINCT SWAPPER AS WALLET, COUNT (SWAPPER) AS "NUMBER OF SWAPS", "NUMBER OF SWAPS"/61 AS "FREQUENCY",

    case
    WHEN "FREQUENCY" <= 0.033 then 'ONCE OR less than once a month'
    WHEN "FREQUENCY" > 0.033 AND "FREQUENCY" <= 0.14 then 'ONCE OR less than once a week'
    WHEN "FREQUENCY" > 0.14 AND "FREQUENCY" <= 1 then 'ONCE OR less than once a day'
    WHEN "FREQUENCY" > 1 AND "FREQUENCY" <= 5 then 'FIFTH OR less than FIFTH a day'
    WHEN "FREQUENCY" > 5 AND "FREQUENCY" <= 10 then 'TENTH OR less than TENTH a day'
    WHEN "FREQUENCY" > 10 AND "FREQUENCY" <=50 then 'Fiftieth OR less than Fiftieth a day'
    WHEN "FREQUENCY" > 50 AND "FREQUENCY" <=100 then 'Hundredth OR less than Hundredth a day'
    WHEN "FREQUENCY" > 100 AND "FREQUENCY" <=1000 then '1000th OR less than 1000th a day'
    WHEN "FREQUENCY" > 1000 then 'MORE than 1000th a day'
    end as FREQUENCY

    from flipside_prod_db.algorand.swaps S
    where S.block_timestamp>= '2022-05-01' and S.block_timestamp <'2022-07-01'
    group by 1
    ORDER BY 3 DESC
    Run a query to Download Data