CryptoIcicleOpen Analytics - 12. Osmosis - 2. 2022 Stablecoin of choice ? - To
Updated 2023-01-26
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
›
⌄
-- Submit a deep dive dashboard that explores a specific topic in detail using Osmosis data.
-- Open Analytics (OA) bounties are bounties without specific prompts, just a direction and a reward. It’s your chance to have your brain follow your heart — got a spark of interest,
-- or a loose thread,
-- or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
with
labels as (
select
*
from osmosis.core.dim_labels
where label_type = 'token'
and (
label ilike '%USD%'
or label ilike '%stable%'
or project_name ilike '%USD%'
)
and project_name not ilike '%.grv'
order by label asc
),
txns_from as (
select
project_name,
label,
s.*
from osmosis.core.fact_swaps s
join labels l1 on (l1.address = s.to_currency)
)
select
date_trunc('{{date_range}}',block_timestamp) as date,
project_name as type,
label as category,
count(distinct tx_id) as n_txns,
count(distinct trader) as n_wallets,
Run a query to Download Data