amelia-leeadd
Updated 2022-10-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with earning as (select day::DATE as DATEe,
sum (LIQUIDITY_FEES) as "LIQUIDITY FEES",
sum (BLOCK_REWARDS) as "BLOCK REWARDS",
"BLOCK REWARDS" - "LIQUIDITY FEES" as "Fee volume need to offset",
"BLOCK REWARDS" / "LIQUIDITY FEES" as Ratio
from flipside_prod_db.thorchain.daily_earnings where day >= '2022-01-01' and LIQUIDITY_FEES > 0 group by DATEe),
swaps as ( select date_trunc('day',block_timestamp) as DATE,
COUNT (TX_ID) as swaps , sum (LIQ_FEE_RUNE) as Fee
from flipside_prod_db.thorchain.swaps
where DATE >= '2022-01-01' and LIQ_FEE_RUNE > 0 group by DATE)
select sum(swaps) as Total_Swap,sum (Fee) as Total_Fee,sum ("BLOCK REWARDS") as Total_Rewards,sum ("Fee volume need to offset") as Total_Fee_needed,
Total_Rewards/Total_Fee as Total_ratio,
Total_Swap * Total_ratio as "Swap volume need to offset",
Total_Fee / Total_Swap as Fee_Per_Swap,
Total_Rewards / Fee_Per_Swap as "Ideal Number of Swaps",
Total_Fee * Total_ratio as "equal_Fee"
from swaps JOIN earning on swaps.DATE= earning.DATEe
Run a query to Download Data