PlaywoDAU Comparison
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 timeframe AS (
SELECT date_day AS date
FROM crosschain.core.dim_dates
WHERE date_day >= CURRENT_DATE - 180
AND date_day < CURRENT_DATE
),
osmo_dau AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(DISTINCT tx_from) AS dau
FROM osmosis.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND tx_succeeded
GROUP BY date
),
cosm_dau AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(DISTINCT tx_from) AS dau
FROM cosmos.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND tx_succeeded
GROUP BY date
),
evmo_dau AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(DISTINCT tx_from) AS dau
FROM evmos.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND tx_succeeded
GROUP BY date
),
eth_dau AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(DISTINCT from_address) AS dau
FROM ethereum.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND status = 'SUCCESS'
GROUP BY date
),
poly_dau AS (
SELECT TRUNC(block_timestamp, 'day') AS date, count(DISTINCT from_address) AS dau
FROM polygon.core.fact_transactions
WHERE block_timestamp >= (SELECT min(date) FROM timeframe) AND status = 'SUCCESS'
GROUP BY date
),
Run a query to Download Data