jgvf2023-06-05 05:13 PM
Updated 2023-06-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
28
29
30
31
32
33
34
35
36
›
⌄
with new_wallets_evmos as (SELECT
first_use,
COUNT(DISTINCT(tx_from)) as new_wallets_evmos
FROM (SELECT
tx_from,
MIN(DATE(block_timestamp)) as first_use
FROM evmos.core.fact_transactions
GROUP BY 1) f
GROUP BY 1),
osmosis_new_wallets as (
SELECT
first_use,
COUNT(DISTINCT(tx_from)) as new_wallets_osmosis
FROM (SELECT
tx_from,
MIN(DATE(block_timestamp)) as first_use
FROM osmosis.core.fact_transactions
GROUP BY 1) f
GROUP BY 1),
active_osmsosis as (
SELECT
date_trunc('week',block_timestamp) as date_time,
COUNT(DISTINCT(tx_from)) as active_users_osmosis
FROM osmosis.core.fact_transactions
GROUP BY 1
),
active_evmos as (
SELECT
date_trunc('week',block_timestamp) as date_time,
COUNT(DISTINCT(tx_from)) as active_users_evmos
FROM evmos.core.fact_transactions
GROUP BY 1