KaskoazulNet Synth Amounts
Updated 2022-05-02
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 MINTS_CHAIN AS (
select from_asset as mint_asset,
count(distinct tx_id) as mints,
sum(to_amount) as to_volume_RUNE,
sum(liq_fee_rune) as mint_fees
from thorchain.swaps
where from_asset like '%/%'
group by 1
--order by 3 desc
),
BURNS_CHAIN AS (
select to_asset as burn_asset,
count(distinct tx_id) as burns,
sum(from_amount) as from_volume_RUNE,
sum(liq_fee_rune) as burn_fees
from thorchain.swaps
where to_asset like '%/%'
group by 1
-- order by 3 desc
)
select split_part(m.mint_asset,'-',1) as asset_name,
split_part(asset_name,'/',1) as chain,
split_part(asset_name,'/',2) as asset,
case asset
when 'WBTC' then 'BTC'
when 'BTCB' then 'BTC'
else asset
end as asset_mod,
m.mints,
m.to_volume_RUNE,
m.mint_fees,
--b.burn_asset,
b.burns,
b.from_volume_RUNE,
Run a query to Download Data