mlhWHALE PRICE
Updated 2022-03-16
9
1
2
3
4
5
6
7
›
⌄
SELECT date_trunc('day', block_timestamp) as day, avg (("EVENT_ATTRIBUTES":"return_amount")/("EVENT_ATTRIBUTES":"amount")) as price
FROM terra.msg_events
WHERE event_type = 'wasm'
AND "EVENT_ATTRIBUTES":"1_contract_address" = 'terra1v4kpj65uq63m4x0mqzntzm27ecpactt42nyp5c' --WHALE-UST Pair
AND day >= CURRENT_DATE - 90
GROUP BY 1
ORDER BY 1 desc
Run a query to Download Data