flipside

    lofty_ai
    primo_datalofty_ai
    /* LoftyAI is a tokenized real estate platform. You can invest in property via tokens distributed by Lofty AI, each being worth $50.
    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 (1) illustrate all the properties(assets), (2) the tokenized revenue Lofty has generated through sales,
    and (3) the total asset value that Lofty AI manages. (4) If you have the ability, set the refresh rate to daily.

    Some of the questions answered in the previous Lofty AI bounty
    (5) Rank the properties listed by LoftyAI based on total token investment price. (Each property has its own asset created by the address 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA').
    (6) How many wallets have bought a token for at least one property?
    (7) What wallet has invested in the most Lofty AI properties? How many properties are they invested in?

    - The total token investment price is $50 multiplied by the total amount of tokens for the property(Asset_id).
    - Look at the assets with a creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    */

    select *
    from algorand.asset
    where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    limit 10

    select *
    from flipside_prod_db.algorand.transactions
    where block_timestamp >= current_date - 7
    and tx_id = 'JJ6ONAOGGRLU4O5ISK2CYJTEL6LTZTIJC5NCDVXDSIPRPFXCOBIQ'
    limit 10


    select aa.*
    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
    and aa.asset_id = '446545048'
    limit 10
    Run a query to Download Data