boomer77top 10 first shower
Updated 2021-11-16
9
1
2
3
4
5
6
7
8
›
⌄
with xx as (select distinct(msg_value:from_address::string) as participants, sum(msg_value:amount[0]:amount::string/1e6) as amount, ROW_NUMBER() OVER (ORDER BY amount desc) as num
from terra.msgs
where msg_value:to_address='terra1dax9mddsycvzkc429wwy494vhzhggw3d5594rt' and tx_status='SUCCEEDED' and block_timestamp < '2021-11-08T07:00:00Z'
group by 1)
select participants, amount, num, '#1' as Meteor_Session
from xx
where num < 11
Run a query to Download Data