nickpayiatis_lofty ai property tvl
    Updated 2023-01-03
    with aa as (
    select
    asset_id,
    asset_name
    from algorand.asset
    where creator_address = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    and asset_id <> '237267329'
    and asset_name like 'Lofty%'
    and asset_deleted = 'FALSE'
    )

    select
    b.asset_id,
    b.asset_name,
    count(distinct tx_id) as sales_count,
    sum(asset_amount) as token_amount,
    sum(asset_amount * 50) as sales_amount_usd,
    token_amount/sales_count as avg_token_amount
    from algorand.asset_transfer_transaction a
    join aa b
    on a.asset_id = b.asset_id
    where sender = 'LOFTYRITC3QUX6TVQBGT3BARKWAZDEB2TTJWYQMH6YITKNH7IOMWRLC7SA'
    group by 1,2
    order by 4 desc
    Run a query to Download Data