2844FREQUENCY OF SWAPS-TABLE
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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