pietrektSwap Fees
    Updated 2 hours ago
    SELECT
    day,
    SUM(total_swap_fees_usd) AS swap_fees_usd,
    SUM(swap_fees_usd) OVER (
    ORDER BY
    day
    ) AS swap_fees_usd_cumulative
    from
    thorchain.defi.fact_daily_pool_stats
    WHERE
    day <> '2021-07-15'
    AND day IS NOT NULL
    GROUP BY
    day
    ORDER BY
    day DESC
    Last run: about 2 hours agoAuto-refreshes every 24 hours
    DAY
    SWAP_FEES_USD
    SWAP_FEES_USD_CUMULATIVE
    1
    2025-06-17 00:00:00.0005071.93329924780892599.5732522
    2
    2025-06-16 00:00:00.00053235.51913960180887527.6399529
    3
    2025-06-15 00:00:00.00022170.35112878580834292.1208133
    4
    2025-06-14 00:00:00.00047519.97923258480812121.7696845
    5
    2025-06-13 00:00:00.000102282.73837874980764601.7904519
    6
    2025-06-12 00:00:00.00097011.9432770780662319.0520732
    7
    2025-06-11 00:00:00.00083751.08941402280565307.1087961
    8
    2025-06-10 00:00:00.00042119.90181304480481556.0193821
    9
    2025-06-09 00:00:00.00066384.65800339580439436.1175691
    10
    2025-06-08 00:00:00.00029357.50130942480373051.4595657
    11
    2025-06-07 00:00:00.00030793.45887895580343693.9582562
    12
    2025-06-06 00:00:00.00072071.94934317880312900.4993773
    13
    2025-06-05 00:00:00.00046425.15844641280240828.5500341
    14
    2025-06-04 00:00:00.00028641.65746758480194403.3915877
    15
    2025-06-03 00:00:00.00076310.8127097880165761.7341201
    16
    2025-06-02 00:00:00.00056559.33589674580089450.9214103
    17
    2025-06-01 00:00:00.00068097.1578594880032891.5855136
    18
    2025-05-31 00:00:00.00090760.4609049979964794.4276541
    19
    2025-05-30 00:00:00.00071056.35774900779874033.9667491
    20
    2025-05-29 00:00:00.00068235.07449047779802977.6090001
    ...
    1505
    89KB
    2s