saeedmzn[new accounts on base] project name
Updated 2024-03-21
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
›
⌄
with new_accounts as ( select
FROM_ADDRESS ,
min (BLOCK_TIMESTAMP) min_date
from base.core.fact_transactions
group by 1 having min_date >= current_date - 30
),
labels as (
select ADDRESS ,
LABEL_TYPE,
PROJECT_NAME
from base.core.dim_labels
where LABEL_TYPE <> 'token'
)
select
PROJECT_NAME ,
count (DISTINCT tx_hash) num_transactions ,
count (DISTINCT FROM_ADDRESS ) num_accounts
from base.core.fact_transactions join new_accounts
using ( FROM_ADDRESS)
join labels on (TO_ADDRESS = ADDRESS )
where STATUS = 'SUCCESS'
and PROJECT_NAME <> 'base'
group by 1
QueryRunArchived: QueryRun has been archived