Lofty AI Platform Dashboard
Question:
Q116. LoftyAI is a tokenized real estate platform(https://www.lofty.ai/). You can invest in property via tokens distributed by Lofty AI, each being worth $50.
We previously ran a bounty on Lofty AI to look at the properties that had are tokenized on the platform. For this bounty use the grand prize winner: https://app.flipsidecrypto.com/dashboard/lofty-ai-tokenized-real-estate-Lyv-06 or other submissions as a starting point- feel free to borrow their SQL as well.
The goal of this bounty is to create a visually appealing dashboard using the new multicolumn layout or the visualization tool of your choice to illustrate all the properties(assets), the tokenized revenue Lofty has generated through sales, and the total asset value that Lofty AI manages. If you have the ability, set the refresh rate to daily.
Overview of Essay:
As mentioned in the question, the LoftyAI provide an opportunity for people to invest in tokenized real estate for only $50 and sell anytime. Now the main purpose of this essay is to establish a dashboard to explore the participants on LoftyAI and their features.
Additionally, the top ranked assets listed by LoftyAI based on total token investment price have been clarified.
Approach:
- LoftyAI
SELECT * FROM algorand.account_asset
WHERE asset_id IN (SELECT asset_id FROM algorand.asset
WHERE creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA')
-
ALGO balance of participants
when BALANCE between 0 and 100 then '0-100 ALGOs' when BALANCE between 100 and 500 then '100-500 ALGOs' when BALANCE between 500 and 1500 then '500-1500 ALGOs' when BALANCE>=1500 then 'above 1500 ALGOs'
\
-
NFT behavior
select * from algorand.asset where TOTAL_SUPPLY=1 and DECIMALS=0 -- NFT identify
==Find out users hold NFT among participants on LoftyAI==
Key findings:
- According to the results, the count of unique users participate on LoftyAI is 5580 users.
- The Lofty 621 E Le Claire Rd asset has the highest total investment in USD by 2.488 million $.
- The second most ranked asset is Lofty 7542 & 7656 S Colfax Ave with more than 808k $.
- The most participated user has 122 properties invested on LoftyAI.
- An interesting observation revealed by ALGO balance of these participants. According to the bar graph, about 4118 unique participants have under 100 ALGO and 609 participants have more than 1500 ALGO balance.
- According to the pie-chart related to the NFT behavior of LoftyAI participants, only 16.9% of participants hold NFT and rest of them did not hold NFTs.