Spot-WiggumAug 16 + Cumulative Fees by Swap Type
Updated 2024-09-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
›
⌄
-- forked from Jul 26 - Aug 15 Cumulative Fees by Swap Type @ https://flipsidecrypto.xyz/studio/queries/7dd5ed13-2185-4b24-b1f4-46bd6da6d120
-- forked from Cumulative Fees by Swap Type @ https://flipsidecrypto.xyz/studio/queries/3498ddd9-ef35-474c-b907-55155ad8f583
-- forked from Weekly Fees by Swap Type - Base @ https://flipsidecrypto.xyz/studio/queries/472a04ff-4e01-4718-8d9c-14671a61fce8
-- forked from ursa-9r / Weekly Fees by Synth @ https://flipsidecrypto.xyz/ursa-9r/q/2P1hnPolI6Kg/weekly-fees-by-synth
WITH fee_data AS (
SELECT
block_timestamp::date AS day,
CASE
WHEN from_asset LIKE '%/%' OR to_asset LIKE '%/%' THEN 'Synth'
WHEN from_asset LIKE '%~%' OR to_asset LIKE '%~%' THEN 'Trade'
ELSE 'L1'
END AS TYPE,
SUM(liq_fee_asset_usd) AS fees
FROM
thorchain.defi.fact_swaps
WHERE
block_timestamp >= '2024-08-16'
GROUP BY
block_timestamp::date,
CASE
WHEN from_asset LIKE '%/%' OR to_asset LIKE '%/%' THEN 'Synth'
WHEN from_asset LIKE '%~%' OR to_asset LIKE '%~%' THEN 'Trade'
ELSE 'L1'
END
)
SELECT
day,
TYPE,
fees,
SUM(fees) OVER (PARTITION BY TYPE ORDER BY day) AS cumulative_fees
FROM
fee_data
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived