binhachon22. [Elite] Network Shutdown - Swap volume
Updated 2021-11-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
›
⌄
with exit_volume as(
select
day,
sum(to_asset_volume - to_rune_volume)/ 1e8 as exit_volume
from
thorchain.pool_block_statistics
where
to_asset_volume > to_rune_volume
and day > getdate() - interval '30 days'
group by
day
),
enter_volume as(
select
day,
- sum(to_asset_volume - to_rune_volume)/ 1e8 as enter_volume
from
thorchain.pool_block_statistics
where
to_asset_volume < to_rune_volume
and day > getdate() - interval '30 days'
group by
day
),
exit_frequency as(
select
day,
sum(to_asset_count - to_rune_count) as exit_frequency
from
thorchain.pool_block_statistics
where
to_asset_count > to_rune_count
and day > getdate() - interval '30 days'
group by
day
),
Run a query to Download Data