TYPE | WEEKLY | VOLUME | USERS | |
|---|---|---|---|---|
1 | Signle Side | 2024-04-29 00:00:00.000 | 221960.996328502 | 155 |
2 | Signle Side | 2024-10-14 00:00:00.000 | 323605.289884612 | 61 |
3 | Multi Sides | 2024-05-20 00:00:00.000 | 470415.164873782 | 55 |
4 | Signle Side | 2024-07-01 00:00:00.000 | 224951.690472608 | 142 |
5 | Multi Sides | 2024-07-29 00:00:00.000 | 558249.69898082 | 35 |
6 | Multi Sides | 2025-01-20 00:00:00.000 | 562709.603323962 | 49 |
7 | Signle Side | 2024-08-12 00:00:00.000 | 152888.375898952 | 107 |
8 | Signle Side | 2024-04-15 00:00:00.000 | 5158965.34204585 | 179 |
9 | Signle Side | 2024-09-23 00:00:00.000 | 353085.558909941 | 122 |
10 | Multi Sides | 2024-01-15 00:00:00.000 | 336813.54668308 | 30 |
11 | Multi Sides | 2024-11-25 00:00:00.000 | 1022813.12322682 | 60 |
12 | Signle Side | 2024-09-09 00:00:00.000 | 236088.416975964 | 125 |
13 | Multi Sides | 2024-09-02 00:00:00.000 | 713473.89322706 | 23 |
14 | Multi Sides | 2024-09-16 00:00:00.000 | 155456.829097883 | 32 |
15 | Multi Sides | 2024-08-05 00:00:00.000 | 152059.803033089 | 38 |
16 | Multi Sides | 2024-06-03 00:00:00.000 | 348326.137415341 | 39 |
17 | Multi Sides | 2024-03-25 00:00:00.000 | 4011944.26276543 | 108 |
18 | Multi Sides | 2024-12-30 00:00:00.000 | 482406.101430548 | 32 |
19 | Multi Sides | 2024-04-01 00:00:00.000 | 1989132.44885837 | 65 |
20 | Multi Sides | 2024-05-13 00:00:00.000 | 510947.843798316 | 45 |
hessWeekly Single Vs. Multi
Updated 2025-01-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with liquidity as (select block_timestamp,
lp_action,
pool_name,
ifnull(from_address,ASSET_ADDRESS) as user,
rune_amount_usd,
asset_amount_usd,
rune_amount_usd+asset_amount_usd as amount_usd
from thorchain.defi.fact_liquidity_actions
where block_timestamp::date >= '2024-01-01')
select case when (rune_amount_usd = 0 or asset_amount_usd = 0 ) then 'Signle Side'
else 'Multi Sides' end as type,
trunc(block_timestamp,'week') as weekly,
sum(amount_usd) as volume,
count(DISTINCT user) as users
from liquidity
where lp_action = 'add_liquidity'
group by 1,2
Last run: 3 months ago
...
114
7KB
4s