mambalooUntitled Query
    Updated 2022-04-14
    SELECT
    asset_name,
    count(*) as count
    from algorand.swaps
    LEFT JOIN algorand.asset on swap_to_asset_id = algorand.asset.asset_id
    where swap_from_asset_id < 1
    and swap_to_asset_id > 0
    and block_timestamp >= '2022-01-01'
    group by asset_name
    order by count Desc
    limit 10
    Run a query to Download Data