Pine AnalyticsToken Swaps ONDO
    Updated 2025-03-18
    SELECT
    date(block_timestamp) as day,
    count(DISTINCT sender) as swappers,
    count(DISTINCT tx_hash) as swaps,
    sum(CASE when not amount_in_usd is null then amount_in_usd
    else amount_out_usd end) as volume_usd

    FROM ethereum.defi.ez_dex_swaps
    WHERE (
    token_in LIKE lower('0xfAbA6f8e4a5E8Ab82F62fe7C39859FA577269BE3')
    OR token_out LIKE lower('0xfAbA6f8e4a5E8Ab82F62fe7C39859FA577269BE3')
    )
    GROUP BY 1


    Last run: 27 days agoAuto-refreshes every 3 hours
    DAY
    SWAPPERS
    SWAPS
    VOLUME_USD
    1
    2025-03-03 00:00:00.0006412727705145.45
    2
    2024-01-29 00:00:00.000337415908547.78
    3
    2024-06-27 00:00:00.000545153310574.2
    4
    2024-09-25 00:00:00.000513572746972.42
    5
    2024-03-30 00:00:00.000717665991400.29
    6
    2024-04-27 00:00:00.000474372808880.21
    7
    2024-04-09 00:00:00.000444153180670.07
    8
    2024-01-23 00:00:00.00047237216847995.04
    9
    2024-03-18 00:00:00.000312824615431.27
    10
    2024-06-28 00:00:00.000454542460518.22
    11
    2024-08-12 00:00:00.000664862082258.74
    12
    2025-03-12 00:00:00.0005611406898414.13
    13
    2024-07-19 00:00:00.000413743065368.16
    14
    2024-10-26 00:00:00.00028226748932.07
    15
    2024-06-01 00:00:00.000948585556093.33
    16
    2024-12-29 00:00:00.000324881137648.31
    17
    2025-01-26 00:00:00.0004910757029972.84
    18
    2024-10-20 00:00:00.000232471506633.44
    19
    2024-07-06 00:00:00.000766422885156.51
    20
    2025-02-03 00:00:00.00062192722507404.63
    ...
    426
    19KB
    49s