Hessishstark - daily new wallets
Updated 2024-05-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with new_w as (SELECT DISTINCT CONTRACT, min(TIMESTAMP::date) as date
from external.tokenflow_starknet.decoded_transactions
where CHAIN_ID = 'mainnet'
group by 1)
SELECT date , count(DISTINCT CONTRACT ) as "New wallets",
case
when date >= '2023-05-01' and date <= '2023-05-09' then 'Week 1 - Argent Xplorer'
when date >= '2023-05-10' and date <= '2023-05-16' then 'Week 2 - Starkfighter'
when date >= '2023-05-17' and date <= '2023-05-23' then 'Week 3 - Jediswap'
when date >= '2023-05-24' and date <= '2023-05-30' then 'Week 4 - Mintsquare'
when date >= '2023-05-31' and date <= '2023-06-06' then 'Week 5 - Layerswap'
when date >= '2023-06-07' and date <= '2023-06-14' then 'Week 6 - Briq'
when date >= '2023-06-15' and date <= '2023-06-22' then 'Week 7 - AVNU'
when date >= '2023-06-23' and date <= '2023-07-01' then 'Week 8 - Dappland'
else 'Other days' end as period
from new_w
where date >= '2023-01-01'
group by 1,period
QueryRunArchived: QueryRun has been archived