theericstoneLatest Luna Bet Probability
    Updated 2023-01-31
    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