KaskoazulLofty Wallets Properties Ownership stats
    Updated 2022-03-02
    WITH LOFTYWALLETS AS (
    SELECT
    att.asset_receiver,
    --att.asset_sender,
    --att.asset_transferred,
    a.asset_id,
    a.asset_name,
    att.asset_amount,
    a.total_supply,
    --a.created_at,
    att.tx_id
    --att.tx_type,
    --att.tx_type_name
    FROM
    algorand.asset a
    INNER JOIN
    algorand.asset_transfer_transaction att
    ON a.asset_id = att.asset_id
    WHERE
    creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    AND asset_deleted ='FALSE'
    AND a.asset_id != 237267329 --Lofty AI
    AND att.asset_amount != 0
    ORDER BY a.asset_name, att.asset_amount desc
    ),

    LOFTYTX AS (
    SELECT
    t.sender,
    a.asset_id,
    a.asset_name,
    a.total_supply,
    --a.created_at,
    t.tx_id
    --att.tx_type,
    --att.tx_type_name
    Run a query to Download Data