cypherTop 10 Donators
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
-- *
-- block_timestamp,
-- tx_id,
sum(msg_value:coins[0]:amount/1000000) as amount_donated_UST,
msg_value:sender::string as donator
from terra.msgs
where msg_value:contract = 'terra19cevhng6nunl7gmc90sph0syuqyvtqn7mlhwz0' and msg_value:execute_msg:deposit:fund_id in ('6', '7')
group by donator
order by amount_donated_UST desc
limit 10
Run a query to Download Data