adriaparcerisasLava wallets created since mainnet launch
Updated 2024-12-05
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 first_appearances AS (
SELECT
tx_from,
MIN(block_timestamp) AS first_appearance
FROM
lava.core.fact_transactions
WHERE
block_timestamp >= '2024-07-30 12:00:00'
GROUP BY
tx_from
),
daily_new_wallets AS (
SELECT
DATE_TRUNC('day', first_appearance) AS day,
COUNT(*) AS new_wallets
FROM
first_appearances
GROUP BY
DATE_TRUNC('day', first_appearance)
)
SELECT
SUM(new_wallets) AS total_new_wallets,
AVG(new_wallets) AS average_new_wallets_per_day,
MIN(day) AS first_day,
MAX(day) AS last_day
FROM
daily_new_wallets
QueryRunArchived: QueryRun has been archived