freemartianDaily Marketcap
    Updated 2025-03-05
    WITH current_price AS (
    SELECT
    hour, AVG(price) AS price

    FROM base.price.ez_prices_hourly
    WHERE token_address = '0x20ef84969f6d81ff74ae4591c331858b20ad82cd'
    GROUP BY 1
    )


    SELECT
    hour AS time,
    1100000000 * price AS marketcap
    FROM current_price







    Last run: 30 days agoAuto-refreshes every 1 hour
    TIME
    MARKETCAP
    1
    2025-01-11 20:00:00.0003464296
    2
    2025-01-02 23:00:00.0008146941
    3
    2025-01-11 10:00:00.0003093365
    4
    2025-02-28 17:00:00.000409189
    5
    2025-01-04 17:00:00.0007793907
    6
    2024-12-26 16:00:00.00011464541
    7
    2025-01-03 06:00:00.0008574192
    8
    2024-12-24 02:00:00.0002363306
    9
    2024-12-25 02:00:00.0004145636
    10
    2025-02-21 20:00:00.000516109
    11
    2025-02-19 13:00:00.000687434
    12
    2025-01-11 03:00:00.0003415225
    13
    2025-02-04 17:00:00.0001448557
    14
    2025-01-05 12:00:00.0006245954
    15
    2025-02-14 16:00:00.000486970
    16
    2025-02-01 13:00:00.0001158641
    17
    2025-02-14 12:00:00.000498322
    18
    2025-01-23 07:00:00.0003252535
    19
    2025-02-04 04:00:00.0001523346
    20
    2025-02-27 07:00:00.000499818
    ...
    1722
    60KB
    231s