messariAvalanche New Users per Dapp
Updated 2023-05-30
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
contracts as (
select
distinct el.contract_address as contract,
case
when dl.project_name is not null then dl.project_name
when el.contract_address = '0xf9ad3f5eab7e9214387c75d58ce40d3a6d05b930' then 'project galaxy'
when el.contract_address in ('0x3b3e4b4741e91af52d0e9ad8660573e951c88524','0x51af494f1b4d3f77835951fa827d66fc4a18dae8','0xc22fbb3133df781e6c25ea6acebe2d2bb8cea2f9') then 'woofi'
else el.contract_address
end as dapp
from
avalanche.core.fact_decoded_event_logs el
left join
avalanche.core.dim_labels dl
on el.contract_address = dl.address
),
first_interaction as (
select
min(date(ft.block_timestamp)) as first_date,
from_address as address,
c.dapp as dapp
from
avalanche.core.fact_transactions ft
left join
avalanche.core.fact_decoded_event_logs el
on ft.tx_hash = el.tx_hash
left join
contracts c
on el.contract_address = c.contract
group by
2,3
)
select
first_date as date,
dapp as dapp,
count(address) as new_addresses
Run a query to Download Data