andurilAnchor Depositor Analysis (Past 6 Months)
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
⌄
/*
Who are the top users (by address) of Anchor Protocol? Are they retail investors or protocol/enterprise users?
Whales or small fry? Note: you may define “top user” as you wish, but your definition and results should be defensible using data and at least one visualization.
select msg_value:sender as depositor,
SUM(msg_value:coins[0]:amount::float)/POW(10,6) as total_deposit_amt
from terra.msgs
where
tx_status = 'SUCCEEDED' AND
msg_value:contract::string='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' AND
msg_value:execute_msg::string='{"deposit_stable":{}}' AND
date(block_timestamp) >= CURRENT_DATE() -60
group by depositor
order by total_deposit_amt desc
*/
select
msg_value:sender as depositor,
SUM(msg_value:coins[0]:amount::float)/POW(10,6) as total_deposit_amt
from terra.msgs
where
tx_status = 'SUCCEEDED' AND
msg_value:contract::string='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' AND
msg_value:execute_msg::string='{"deposit_stable":{}}' AND
date(block_timestamp) >= CURRENT_DATE() -180
group by depositor
order by total_deposit_amt desc
Run a query to Download Data