Mr_AceTRANSACTIONS ON ON SHIBA
    Updated 2024-11-05
    SELECT
    trunc(block_timestamp,'day') as date,
    COUNT(DISTINCT tx_hash) as Dex_Trades_SHIBA,
    SUM(COUNT(DISTINCT tx_hash)) OVER () as Dex_Trades_Total_SHIBA,
    COUNT(DISTINCT origin_from_address) as Dex_Traders_SHIBA,
    SUM(ABS(amount_in_usd) + ABS(amount_out_usd)) as Volume_SHIB
    FROM
    ethereum.defi.ez_dex_swaps
    WHERE
    block_timestamp >= '2023-12-01'
    AND block_timestamp <= '2024-03-01'
    AND (
    TOKEN_IN = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'
    OR TOKEN_OUT = '0x95ad61b0a150d79219dcf64e1e6cc01f0b64c4ce'
    )
    GROUP BY 1
    Last run: 3 months ago
    DATE
    DEX_TRADES_SHIBA
    DEX_TRADES_TOTAL_SHIBA
    DEX_TRADERS_SHIBA
    VOLUME_SHIB
    1
    2024-01-14 00:00:00.000297409132451042596.24
    2
    2023-12-15 00:00:00.000356409132982005946.88
    3
    2023-12-19 00:00:00.000367409133191296278.5
    4
    2023-12-14 00:00:00.000481409133752629172.29
    5
    2024-02-05 00:00:00.00030140913260634184.23
    6
    2024-01-31 00:00:00.000442409133271108496.39
    7
    2024-01-03 00:00:00.000597409134755521878.66
    8
    2024-01-15 00:00:00.000430409133361227468.9
    9
    2023-12-10 00:00:00.000636409134583221463.83
    10
    2024-02-23 00:00:00.000258409132111590512.49
    11
    2023-12-17 00:00:00.000725409134844329544.69
    12
    2024-01-05 00:00:00.000469409133931795653.39
    13
    2024-02-21 00:00:00.00029040913224993220.32
    14
    2023-12-28 00:00:00.000535409134062301178.14
    15
    2024-01-20 00:00:00.000654409134242077711.75
    16
    2023-12-30 00:00:00.000414409133491159954.94
    17
    2024-02-17 00:00:00.00037340913297583865.46
    18
    2024-01-24 00:00:00.00043940913339940852.97
    19
    2024-02-27 00:00:00.000638409134169658228.37
    20
    2024-01-13 00:00:00.000508409134091767316.23
    91
    5KB
    3s