John_GaltFirst Week of PRISM Price
Updated 2022-04-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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