AzinSwaps
    Updated 2025-03-15
    SELECT
    DATE_TRUNC('WEEK' , BLOCK_TIMESTAMP) AS Date
    , COUNT(DISTINCT TX_HASH) AS "Trades"
    , COUNT(DISTINCT SWAPPER) AS "Swappers"
    , SUM(COALESCE(AMOUNT_IN_USD,AMOUNT_OUT_USD)) AS "Trading Volume"
    , SUM("Trading Volume" ) OVER (ORDER BY DATE) AS "Total Trading Volume"
    , SUM("Trades" ) OVER (ORDER BY DATE) AS "Total Trades"
    FROM
    aptos.defi.ez_dex_swaps
    WHERE
    TOKEN_IN = '0x61ed8b048636516b4eaf4c74250fa4f9440d9c3e163d96aeb863fe658a4bdc67::CASH::CASH'
    OR
    TOKEN_OUT = '0x61ed8b048636516b4eaf4c74250fa4f9440d9c3e163d96aeb863fe658a4bdc67::CASH::CASH'
    GROUP BY 1
    ORDER BY 1 DESC
    Last run: about 1 month ago
    DATE
    Trades
    Swappers
    Trading Volume
    Total Trading Volume
    Total Trades
    1
    2025-03-10 00:00:00.00066406699.7120556894577132.32269373155450
    2
    2025-03-03 00:00:00.0001094830532.6443995954570432.61063804155384
    3
    2025-02-24 00:00:00.0001206323167.1080860874539899.96623845155275
    4
    2025-02-17 00:00:00.0001237618853.6626022434516732.85815236155155
    5
    2025-02-10 00:00:00.00088458482.4925191114497879.19555012155032
    6
    2025-02-03 00:00:00.00019910495608.3483138884489396.703031154944
    7
    2025-01-27 00:00:00.00023711935233.9817515774393788.35471712154745
    8
    2025-01-20 00:00:00.00027012535745.9118735284358554.37296554154508
    9
    2025-01-13 00:00:00.00037415599421.9115545144322808.46109201154238
    10
    2025-01-06 00:00:00.000363154101668.7944141014223386.5495375153864
    11
    2024-12-30 00:00:00.00031919944921.0738190944121717.7551234153501
    12
    2024-12-23 00:00:00.00042722071622.0567074294076796.6813043153182
    13
    2024-12-16 00:00:00.0001268375281381.1551505674005174.62459687152755
    14
    2024-12-09 00:00:00.000869339163255.2699100723723793.46944631151487
    15
    2024-12-02 00:00:00.00051629889676.1662444023560538.19953623150618
    16
    2024-11-25 00:00:00.00035819635606.0566764373470862.03329183150102
    17
    2024-11-18 00:00:00.000373628982696.1022364683435255.97661539149744
    18
    2024-11-11 00:00:00.00061410266829242.4143211773352559.87437893146008
    19
    2024-11-04 00:00:00.00022453247425827.9775266872523317.4600577584598
    20
    2024-10-28 00:00:00.0002795304431644.8937170082097489.4825310662145
    25
    2KB
    50s