flipside

    Top 5 Most Expensive ASAs
    PredictionTop 5 Most Expensive ASAs
    Updated 2022-05-11
    SELECT asset_name,
    max(price_usd) as usd_price
    FROM algorand.prices_swap
    WHERE date_trunc('day',block_hour) = date_trunc('day',cast('2022-04-27' as date))
    GROUP BY asset_name
    ORDER BY usd_price DESC

    LIMIT 5

    /* Selected date is 2022-04-27 */
    Run a query to Download Data