theericstoneLatest Luna Bet Probability
Updated 2023-01-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with allprobs as (
select
distinct
value:prob_do_wins as prob_do_wins,
value:updated_at::datetime as updated_at
from
(select * from "FLIPSIDE_PROD_DB"."BRONZE"."PROD_DATA_SCIENCE_UPLOADS_1748940988"
where record_metadata:key::string like '%luna-bet%'),
lateral flatten(input => record_content) AS f
)
select
distinct
last_value(prob_do_wins) over (order by updated_at asc) as prob_do_wins,
last_value(updated_at) over (order by updated_at asc) as updated_at
from allprobs
where prob_do_wins > .69 and prob_do_wins < 1;
Run a query to Download Data