Pricing ASAs

In this Presentation i'm Using the Price Swap table, i pick a single day in the last 30 days and find the top 5 most and least expensive ASAs I pick an hour in that day and visualize the distribution of prices across all ASAs for that hour. I find the top 10 ASAs by volume in the last 90 days using the VOLUME_USD_IN_HOUR. Which had the highest average volatility? Which was the most swapped?

Method

I found from the price change table by filtering SWAPS_IN_HOUR> 0 and date(t1.BLOCK_HOUR) = '2022-04-17' the top 5 most and least expensive ASAs. I check the distribution of prices across all ASAs for time(t1.BLOCK_HOUR) between '11:00:00' and '12:00:00'. I found the top 10 ASAs by volume in the last 90 days using the VOLUME_USD_IN_HOUR.

Top 5 most and least expensive ASAs

The next query show top 5 most expensive ASAs on april 17st 2022.

According to the review , goBTC has been the most expensive currency on april 17st 2022.

The next query show top 5 least expensive ASAs on april 17st 2022.

distribution of prices across all ASAs for that hour on 2022-4-17

The next query shows distribution of prices across all ASAs for time between 11:00:00 and 12:00:00 on 2022-4-17

According to this review, goBTC and goETH had the highest price distribution and Svansy Coin and MoonX had the lowest price distribution between the hour 11:00:00 and 12:00:00 on April 17, 2021.

Top 10 ASAS By volume and swap in the last 90 days

The next query shows top 10 ASAS By volume in the last 90 days.

According to the review , SnoopDoge has been the least expensive currency on april 17st 2022.

The next query shows top 10 ASAS By swap in the last 90 days.

The next query shows top 10 ASAS By highest average volatility in the last 90 days.

According to reviews in the last 90 days