John_GaltFirst Week of PRISM Price
    Updated 2022-04-23
    select ---Selling Prism for UST
    date_trunc('hour', block_timestamp) as Day_Hour,
    sum(event_attributes:offer_amount) / pow(10, 6) as Prism_Sold,
    sum(event_attributes:return_amount) / pow(10, 6) as UST_Returned,
    UST_Returned / Prism_Sold as Prism_Price
    from terra.msg_events
    where date(block_timestamp) > '2022-02-01'
    and event_attributes:offer_asset = 'cw20:terra1dh9478k2qvqhqeajhn75a2a7dsnf74y5ukregw'
    and event_attributes:ask_asset = 'native:uusd'
    and event_index = 3
    and day_hour between '2022-02-06 16:00:00.000' and '2022-02-013 16:00:00.000'
    group by Day_Hour
    order by Day_Hour

    Run a query to Download Data