flipside

    meteor details
    boomer77meteor details
    Updated 2021-11-16
    select date_trunc('hour',block_timestamp) as blockhour, ROW_NUMBER() OVER(ORDER BY blockhour ASC) + 1 AS meteor_number, concat('#', meteor_number) as Meteor_Session,
    count (distinct msg_value:from_address::string) as participants, sum(msg_value:amount[0]:amount::string/1e6) as dono,
    max(msg_value:amount[0]:amount::string/1e6) as max_dono, count(distinct tx_id) as tx_count
    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
    order by 2 asc
    Run a query to Download Data