flipside

    draft for meteor shower
    boomer77draft for meteor shower
    Updated 2021-11-17
    with satu as (select
    date_trunc('hour',block_timestamp) as blockhour,
    msg_value:from_address::string as participants,
    sum(msg_value:amount[0]:amount::string/1e6) as amount
    from terra.msgs
    where msg_value:to_address='terra1dax9mddsycvzkc429wwy494vhzhggw3d5594rt' and tx_status='SUCCEEDED' and block_timestamp between '2021-11-08T07:00:00Z' and '2021-11-10T02:00:00Z'
    group by 1,2
    order by 1 asc)

    select * from satu

    --select meteor_session, participants, amount, ROW_NUMBER() OVER (PARTITION BY Meteor_session ORDER BY amount desc) as num
    --from damn

    --select participants, amount, num, Meteor_Session
    --from secondz
    --where num < 11

    --ROW_NUMBER() OVER (PARTITION BY Meteor_session ORDER BY amount desc) as num
    Run a query to Download Data