Updated 2025-04-11
    select
    date_trunc('day', hour) as Date,
    median(price) as Price

    from base.price.ez_prices_hourly
    where token_address ILIKE '0x940181a94A35A4569E4529A3CDfB74e38FD98631'
    group by 1
    order by date desc
    Last run: 15 days ago
    DATE
    PRICE
    1
    2025-04-11 00:00:00.0000.370926
    2
    2025-04-10 00:00:00.0000.375927
    3
    2025-04-09 00:00:00.0000.3105185
    4
    2025-04-08 00:00:00.0000.335634
    5
    2025-04-07 00:00:00.0000.313503
    6
    2025-04-06 00:00:00.0000.3625055
    7
    2025-04-05 00:00:00.0000.3579895
    8
    2025-04-04 00:00:00.0000.366037
    9
    2025-04-03 00:00:00.0000.401959
    10
    2025-04-02 00:00:00.0000.42673
    11
    2025-04-01 00:00:00.0000.4487695
    12
    2025-03-31 00:00:00.0000.44497
    13
    2025-03-30 00:00:00.0000.4723915
    14
    2025-03-29 00:00:00.0000.4875575
    15
    2025-03-28 00:00:00.0000.502139
    16
    2025-03-27 00:00:00.0000.5159995
    17
    2025-03-26 00:00:00.0000.5306515
    18
    2025-03-25 00:00:00.0000.53229
    19
    2025-03-24 00:00:00.0000.534735
    20
    2025-03-23 00:00:00.0000.515763
    ...
    575
    21KB
    4s