abbasian34Untitled Query
Updated 2023-01-23Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with Table1 as (
select tx_sender as New_User,
min (block_timestamp) as mindate
from terra.core.fact_transactions
where tx_succeeded = 'TRUE'
group by 1),
New_Users as (
select block_timestamp,
tx_id,
tx_sender
from terra.core.fact_transactions t1 join Table1 t2 on t1.tx_sender = t2.new_user
where mindate >= '2023-01-14')
select project_name,
count (distinct t1.tx_id) as TX_Count,
count (Distinct tx_sender) as Users_Count
from terra.core.fact_msgs t1 join terra.core.dim_address_labels t2 on t1.msg:attributes[0]:value = t2.address
join New_Users t3 on t1.tx_id = t3.tx_id
where tx_succeeded = 'TRUE'
and t1.block_timestamp >= '2023-01-07'
group by 1
Run a query to Download Data