maybeyonasthorchain_swap_cost
Updated 2021-12-24
999
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 multi_swaps_txs as (
select tx_id from (
select
tx_id,
count(tx_id) as swaps
from thorchain.swaps
group by 1
)
where swaps > 1
),
native_swaps as (
select
block_timestamp,
tx_id,
split(from_asset,'-')[0]::string as from_asset,
split(to_asset,'-')[0]::string as to_asset,
split(from_asset,'.')[0]::string as from_chain,
split(to_asset,'.')[0]::string as to_chain,
split(from_asset,'-')[0]::string || ' to ' || split(to_asset,'-')[0]::string as asset_route,
from_chain || ' to ' || to_chain as chain_route,
case when from_chain=to_chain then 'Same chain'
else 'Different chain' end as swap_type,
from_amount,
to_amount,
from_amount_usd,
to_amount_usd,
liq_fee_rune,
liq_fee_asset,
liq_fee_rune_usd,
liq_fee_asset_usd,
(liq_fee_asset_usd+liq_fee_rune_usd)*100/from_amount_usd as lp_fee_percent
-- count(tx_id) as swaps,
-- sum(from_amount) as from_amount,
-- sum(to_amount) as to_amount,
-- sum(from_amount_usd) as from_amount_usd,
-- sum(to_amount_usd) as to_amount_usd
Run a query to Download Data