Elprognerd3 - Daily New
Updated 2023-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with t1 as (SELECT
tx_from,
min(date_trunc('day', block_timestamp)) as date1
FROM axelar.core.fact_transactions
GROUP BY 1
)
SELECT
date1,
count(tx_from) as "Number of new wallets",
sum("Number of new wallets") over (ORDER BY date1) as "Cumulative number of new wallets"
from t1
where date1>= '2022-9-19'
GROUP by 1
order by 1
Run a query to Download Data