Hessish2023-08-07 11:14 PM
Updated 2023-08-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with t0 as (SELECT distinct CONTRACT as wlt , case when
CLASS_HASH = '0x03530cc4759d78042f1b543bf797f5f3d647cde0388c33734cf91b7f7b9314a9' then 'Okex'
When CLASS_HASH = '0x058d97f7d76e78f44905cc30cb65b91ea49a4b908a76703c54197bca90f81773' then 'bitstamp'
When CLASS_HASH = '0x025ec026985a3bf9d0cc1fe17326b245dfdc3ff89b8fde106542a3ea56c5a918' then 'argentx'
When CLASS_HASH = '0x03131fa018d520a037686ce3efddeab8f28895662f019ca3ca18a626650f7d1e' then 'braavos' else 'other' end as provider
from external.tokenflow_starknet.decoded_traces
where
CHAIN_ID = 'mainnet'
and
FUNCTION = 'constructor'
)
SELECT
Timestamp::date as day,
COUNT(distinct wlt) AS users, provider
FROM external.tokenflow_starknet.decoded_transactions Join t0 on contract = wlt
where CHAIN_ID = 'mainnet'
GROUP BY
1,3
order by 1 desc
Run a query to Download Data