flipside

    price weekly
    ellerydurwinprice weekly
    Updated 2025-04-17
    SELECT
    SYMBOL,
    date_trunc('week',hour) as date,
    AVG(price) as avg_price,
    FROM
    aptos.price.ez_prices_hourly
    WHERE
    SYMBOL = 'GUI'
    AND date >= '2025-01-01'
    GROUP BY 1,2
    Last run: about 2 months ago
    SYMBOL
    DATE
    AVG_PRICE
    1
    		GUI2025-03-17 00:00:00.0000.00000530047619
    2
    		GUI2025-02-17 00:00:00.0000.000009386785714
    3
    		GUI2025-01-06 00:00:00.0000.00002052422619
    4
    		GUI2025-03-10 00:00:00.0000.000005390952381
    5
    		GUI2025-01-13 00:00:00.0000.00001771559524
    6
    		GUI2025-04-14 00:00:00.0000.000004581025641
    7
    		GUI2025-04-07 00:00:00.0000.000004170238095
    8
    		GUI2025-02-10 00:00:00.0000.00001014017857
    9
    		GUI2025-03-03 00:00:00.0000.00000626672619
    10
    		GUI2025-02-24 00:00:00.0000.000008121964286
    11
    		GUI2025-02-03 00:00:00.0000.00001077410714
    12
    		GUI2025-03-24 00:00:00.0000.00000532202381
    13
    		GUI2025-01-20 00:00:00.0000.00001358035714
    14
    		GUI2025-01-27 00:00:00.0000.00001145922619
    15
    		GUI2025-03-31 00:00:00.0000.000005008809524
    15
    772B
    3s