farid-c9j0VMThe time of creation wallet for swappers
Updated 2022-07-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select count(DISTINCT a.SWAPPER) as swaper,date_trunc('day',c.block_timestamp) as date_created,
case
when date_created BETWEEN '2022-05-01' and '2022-06-30' then 'may-june2022'
when date_created BETWEEN '2022-03-01' and '2022-04-30' then 'mars-april2022'
when date_created BETWEEN '2022-01-01' and '2022-02-28' then 'january-februry2022'
when date_created <'2022-01-01' then 'before 2022'
else 'null'
end as Wallet_Creation_Type
from flipside_prod_db.algorand.swaps a
LEFT JOIN flipside_prod_db.algorand.account b
ON a.SWAPPER = b.address
LEFT JOIN flipside_prod_db.algorand.block c
ON b.created_at = c.block_id
WHERE a.SWAPPER IN (select DISTINCT SWAPPER
from flipside_prod_db.algorand.swaps
where BLOCK_TIMESTAMP >='2022-05-01' and BLOCK_TIMESTAMP <= '2022-06-30')
group by 2
Run a query to Download Data