flipside

    Weekly and cummulative Volume
    datavortexWeekly and cummulative Volume
    Updated 2025-05-07
    WITH WeeklyVolume AS (
    SELECT
    DATE_TRUNC('week', block_timestamp) AS TimelineWeek,
    SUM(from_amount_usd) AS TotalWeeklySwapVolumeUSD
    FROM
    thorchain.defi.fact_swaps
    GROUP BY
    DATE_TRUNC('week', block_timestamp)
    )
    SELECT
    TimelineWeek,
    TotalWeeklySwapVolumeUSD,
    LAG(TotalWeeklySwapVolumeUSD) OVER (
    ORDER BY
    TimelineWeek
    ) AS PreviousWeekVolumeUSD,
    SUM(TotalWeeklySwapVolumeUSD) OVER (
    ORDER BY
    TimelineWeek
    ) AS CumulativeSwapVolumeUSD
    FROM
    WeeklyVolume
    ORDER BY
    TimelineWeek;

    Last run: 17 days ago
    TIMELINEWEEK
    TOTALWEEKLYSWAPVOLUMEUSD
    PREVIOUSWEEKVOLUMEUSD
    CUMULATIVESWAPVOLUMEUSD
    1
    		2021-04-05 00:00:00.00016756.89661804116756.896618041
    2
    		2021-04-12 00:00:00.0008730992.7137092816756.8966180418747749.61032732
    3
    		2021-04-19 00:00:00.00012625043.52307048730992.7137092821372793.1333977
    4
    		2021-04-26 00:00:00.00014493325.149555112625043.523070435866118.2829529
    5
    		2021-05-03 00:00:00.00034582268.734051814493325.149555170448387.0170047
    6
    		2021-05-10 00:00:00.00049769264.042845434582268.7340518120217651.05985
    7
    		2021-05-17 00:00:00.00087245502.579968849769264.0428454207463153.639819
    8
    		2021-05-24 00:00:00.00079747467.541809287245502.5799688287210621.181628
    9
    		2021-05-31 00:00:00.00042784467.835806679747467.5418092329995089.017435
    10
    		2021-06-07 00:00:00.00072863118.528028342784467.8358066402858207.545463
    11
    		2021-06-14 00:00:00.000105390080.62921472863118.5280283508248288.174677
    12
    		2021-06-21 00:00:00.000160882360.283464105390080.629214669130648.458141
    13
    		2021-06-28 00:00:00.00098788011.2878088160882360.283464767918659.74595
    14
    		2021-07-05 00:00:00.00044120644.237589598788011.2878088812039303.983539
    15
    		2021-07-12 00:00:00.00048742120.757944644120644.2375895860781424.741484
    16
    		2021-09-13 00:00:00.00010433633.139901348742120.7579446871215057.881385
    17
    		2021-09-20 00:00:00.00042849871.3878910433633.1399013914064929.269275
    18
    		2021-09-27 00:00:00.00029259224.700242849871.38789943324153.969475
    19
    		2021-10-04 00:00:00.00023443720.240666429259224.7002966767874.210141
    20
    		2021-10-11 00:00:00.00064713912.504541423443720.24066641031481786.71468
    ...
    206
    16KB
    6s