1- Part one ---> 5 most and least expensive ASA'S

To address this part of the table algorand.prices_swap, on 2022-04-25 we filter table by ---> [asset_id != 0 and block_hour >= current_date - 30 and day(block_hour) = 25] and take all the asa's assets and group them and get the max/min price_usd for each group (asa's),then we get 5 most/ least expensive

2- Part one ---> distribution of prices across all ASAs

To address this part of the table algorand.prices_swap, on 2022-04-25 -12PM we filter table by ---> [asset_id != 0 and block_hour >= current_date - 30 and day(block_hour) = 25 and hour(block_hour) = 12] and We chunk the price into 8 intervals, ---> [0 - 0.5 USD], [0.5 - 1 USD], [1 - 5 USD],[5 -10 USD], [10 - 50 USD], [50 - 100 USD], [100 - 1000 USD] AND [OVER 1000 USD] then count any number of ASA'S in these chunks and group them based on these chunks.

Based on these results, it is determined that the highest price distribution is in the price range of 0 to 0.5 USD and the lowest price distribution is in the range of 50-100 USD.

3- Part two ---> top 10 ASAs by volume in the last 90 days

To address this part of the table algorand.prices_swap, on the last 90 days we filter table by ---> [asset_id != 0 and block_hour >= current_date - 90 and volume_usd_in_hour != 0 and volatility_measure != 0] and calculate sum(volume_usd_in_hour), avg(volatility_measure) and count(swapped)for each ASA'S in this time by group the each ASA'S

most volume ---> [AlgoScout Token] -- highest average volatility ----> [goBTC] -- most swapped ---> [yieldly]