manuelggOsmosis - DEX Change (daily users)
Updated 2022-11-12
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
›
⌄
--This week has highlighted the need for transparency & decentralization in crypto markets. Let's see how users have reacted to this wild week in Web3.
--Have behaviors changed? Analyze growth in Osmosis Volumes & User Count this week.
--Has more money flowed into Osmosis this week compared to the past few weeks/months? -- ES PARTE DEL ANÁLISIS DE VOLUMES, medirlo todo en USD value como un total
--Where is this money coming from? Centralized Exchanges? -- TRAER LABELS DEL FROM
--Have wallets moved more into stables? -- VER CON QUÉ MONEDA SE SWAPPEA MÁS SEGUIDO
--BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
--Daily number of active users:
with daily_users AS (
select date(block_timestamp) as days,
tx_from as users
from osmosis.core.fact_transactions
where days >= '2022-07-01'
group by 1, 2
)
select days,
case
when days < '2022-11-06' then 'Pre-crisis'
else 'Crisis'
end as crisis, -- CZ tweet: https://twitter.com/cz_binance/status/1589283421704290306
count(distinct users) as daily_users
from daily_users
group by days
Run a query to Download Data