SpiltadavidNew User Count Over Time
Updated 2022-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with escaper_from_FTX as (
SELECT
block_timestamp::date as date,
to_address
FROM ethereum.core.ez_token_transfers LEFT outer join ethereum.core.dim_labels on address = from_address
WHERE label iLIKE any ('%alameda%', 'ftx')
AND block_timestamp > '2022-11-01'
GROUP BY 1,2
)
,newUser as (
select
min(block_timestamp) as min_date,
'dydx' as platform,
origin_from_address
from ethereum.core.fact_token_transfers a join escaper_from_FTX b on a.origin_from_address = b.to_address
where origin_to_address in (SELECT ADDRESS FROM ethereum.core.dim_labels WHERE LABEL ilike ('dydx'))
and from_address != '0x0000000000000000000000000000000000000000'
group by 2,3
UNION
select
min(block_timestamp) as min_date,
'GMX' as platform,
origin_from_address
from arbitrum.core.fact_token_transfers a join escaper_from_FTX b on a.origin_from_address = b.to_address
where origin_to_address in ('0x3d6ba331e3d9702c5e8a8d254e5d8a285f223aba','0xb87a436b93ffe9d75c5cfa7bacfff96430b09868')
and from_address != '0x0000000000000000000000000000000000000000'
group by 2,3
UNION
select
min(block_timestamp) as min_date,
'GNS' as platform,
origin_from_address
Run a query to Download Data