nickpayiatis_lofty ai property tvl
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
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