LTirrellacme_all_users
Updated 2022-07-07
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 flattened_transactions as (
select
t.block_timestamp,
t.tx_id,
w.value as wallet
from
terra.transactions t,
lateral flatten(input => t.tx_from) w
where
tx_status = 'SUCCEEDED'
),
wallets as (
select
wallet,
min(block_timestamp) :: date as join_date
from
flattened_transactions
group by
wallet
)
SELECT
join_date,
count(wallet) as new_users
from
wallets
group by
join_date
Run a query to Download Data