primo_dataTop Investors by Investment Total ($USD)
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
select aa.address
, sum(aa.amount *50) total_invested_usd
, count(distinct aa.asset_id) total_properties
, (total_properties /
(select count(distinct aa.asset_id) total_properties
from algorand.account_asset aa
left join algorand.asset a
on aa.asset_id = a.asset_id
where a.creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
and aa.asset_id != '237267329'
and aa.amount > 0)) pct_properties_invested_in
from algorand.account_asset aa
left join algorand.asset a
on aa.asset_id = a.asset_id
where a.creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
and aa.asset_id != '237267329'
and aa.amount > 0
group by 1
order by 2 desc
Run a query to Download Data