KaskoazulLofty Assets Stats
Updated 2022-02-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
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
count(asset_name) as number_Properties,
AVG(50*total_supply) as AveragePrice_USD,
median(50*total_supply) as MedianPrice_USD
FROM
LOFTYASSETS