messariFlow of UST in dApps
Updated 2022-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- Tarik - revised from query by Ava@Flipside https://app.flipsidecrypto.com/velocity/queries/93f25d4f-62cc-46e0-aa92-769763b98da8
select
metric_date,
currency as curr,
CASE
WHEN from_segment = 'dApps' then to_segment
WHEN to_segment = 'dApps' then from_segment
END AS SEGMENT,
SUM(volume_outflow) as volume_outflow,
SUM(volume_inflow) as volume_inflow,
SUM(tx_outflow) as tx_outflow,
SUM(tx_inflow) as tx_inflow
from consoles_terra.dapp_flows
WHERE curr = 'UST'
group by 1,2,3
order by metric_date desc
Run a query to Download Data