KaskoazulLofty Asset Transactions
    Updated 2022-02-28
    WITH LOFTYASSETS AS (
    SELECT
    asset_id,
    asset_name,
    total_supply,
    created_at
    FROM
    algorand.asset
    WHERE
    creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    AND asset_deleted ='FALSE'
    AND asset_id != 237267329 --Lofty AI
    )

    SELECT
    asset_name as Property,
    50*total_supply as TokenInvestmentPrice_USD
    FROM
    LOFTYASSETS
    ORDER BY 2 desc

    Run a query to Download Data