jackguyDanku_help 3
Updated 2021-12-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab1 as (
SELECT
date_trunc('day', block_timestamp),
-- sum(msg_value:coins[0]['amount'] * msg_value:execute_msg:swap:belief_price) / sum(msg_value:coins[0]['amount'])
sum(msg_value:execute_msg:swap:belief_price ) / count(*) as amt
FROM terra.msgs
WHERE msg_value:contract LIKE 'terra163pkeeuwxzr0yhndf8xd2jprm9hrtk59xf7nqf'
AND msg_value:execute_msg:swap is not NULL
--AND msg_value:execute_msg:swap:belief_price < 1
GROUP BY 1
--LIMIT 100
)
SELECT *
FROM tab1 where amt <= 0.5
Run a query to Download Data