DAY | LABEL | FEE_USD | CUMULATIVE_FEE_USD | TOTAL_CUMULATIVE_FEE_USD | |
|---|---|---|---|---|---|
1 | 2025-04-02 00:00:00.000 | TrustWallet | 545.518725642 | 13945650.1867741 | 32363230.2276903 |
2 | 2025-04-02 00:00:00.000 | Swapkit | 29.626842933 | 769713.047465426 | 32363230.2276903 |
3 | 2025-04-02 00:00:00.000 | Others | 90.371974273 | 1766463.66409483 | 32363230.2276903 |
4 | 2025-04-02 00:00:00.000 | THORSwap | 229.65914979 | 7408427.00508304 | 32363230.2276903 |
5 | 2025-04-02 00:00:00.000 | Asgardex | 8.840242724 | 1944608.19605199 | 32363230.2276903 |
6 | 2025-04-01 00:00:00.000 | THORWallet | 419.699791387 | 1881433.30384109 | 32362326.2107549 |
7 | 2025-04-01 00:00:00.000 | CS | 66.18891524 | 319.355214874 | 32362326.2107549 |
8 | 2025-04-01 00:00:00.000 | Ledger | 9942.035088557 | 3484195.23762286 | 32362326.2107549 |
9 | 2025-04-01 00:00:00.000 | TrustWallet | 15129.625453311 | 13945104.6680485 | 32362326.2107549 |
10 | 2025-04-01 00:00:00.000 | brt | 0.1230363728 | 0.1230363728 | 32362326.2107549 |
11 | 2025-04-01 00:00:00.000 | THORSwap | 6352.85280771 | 7408197.34593325 | 32362326.2107549 |
12 | 2025-04-01 00:00:00.000 | Swapkit | 3405.813434843 | 769683.420622493 | 32362326.2107549 |
13 | 2025-04-01 00:00:00.000 | Asgardex | 3197.508677473 | 1944599.35580926 | 32362326.2107549 |
14 | 2025-04-01 00:00:00.000 | Others | 10978.271094699 | 1766373.29212056 | 32362326.2107549 |
15 | 2025-03-31 00:00:00.000 | THORWallet | 24.926846241 | 1881013.60404971 | 32312834.0924553 |
16 | 2025-03-31 00:00:00.000 | - | 10.49311609 | 1472.57868722 | 32312834.0924553 |
17 | 2025-03-31 00:00:00.000 | THORSwap | 9227.383692777 | 7401844.49312554 | 32312834.0924553 |
18 | 2025-03-31 00:00:00.000 | ShapeShift | 168.353523508 | 1016771.94101753 | 32312834.0924553 |
19 | 2025-03-31 00:00:00.000 | eld | 0.1273855656 | 2344.239021847 | 32312834.0924553 |
20 | 2025-03-31 00:00:00.000 | TrustWallet | 19626.858119126 | 13929975.0425952 | 32312834.0924553 |
pietrektTC Aff Fees
Updated 19 hours ago
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
›
⌄
-- Query by @banbannard -- RELEVANT UP TO 01.11.2024
with base as (select tx_id,
to_date(block_timestamp) as date,
affiliate_address, affiliate_fee_basis_points,
split(from_asset, '-')[0] as from_assets,
case
when from_assets ilike '%/%' then split(from_assets, '/')[1]
else split(from_assets, '.')[1]
end as from_asset_names,
split(to_asset, '-')[0] as to_assets,
case
when to_assets ilike '%/%' then split(to_assets, '/')[1]
else split(to_assets, '.')[1]
end as to_asset_names,
concat(from_asset_names, ' -> ', to_asset_names) as assets,
case when assets ilike '%RUNE' then 2
else 1
end as numbering,
sum(from_amount_usd) as swap_volume
from thorchain.defi.fact_swaps
where date < '2024-11-01'
group by tx_id, date,
affiliate_address, affiliate_fee_basis_points,
from_asset, to_asset),
base2 as (select date,
tx_id,
affiliate_address, affiliate_fee_basis_points,
array_agg(distinct assets) within group (order by assets asc) as swap_direction, --merging 2 sep path to 1
sum(swap_volume) as swap_volume
from base
group by 1,2,3,4),
base3 as (select date,
tx_id,
affiliate_address, affiliate_fee_basis_points,
Last run: about 19 hours agoAuto-refreshes every 24 hours
...
10333
803KB
14s