NuveveCryptoArchivedMonthly Average
Updated 2023-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with first_deposit as (
select
min(block_timestamp) as timestamp,
receiver
from terra.core.ez_transfers
where block_timestamp < '2023-01-01'
group by receiver
),
monthly as (
select
date_trunc('month', timestamp) as month,
count(distinct receiver) as new_wallets
from first_deposit
group by month
)
select
avg(new_wallets) as monthly_average
from monthly
Run a query to Download Data