LTirrell1. Most Popular ASAs -- added asset transactions
    Updated 2022-01-10

    -- - What are the most popular ASAs on Algorand?
    -- - How many wallets are holding each ASA?
    -- - How many transactions happen with these ASAs?
    -- - How have these stats changed over time?


    WITH info AS (
    SELECT
    asset_name,
    round(asset_added_at :: number, -4) as blocks,
    count(address) as addresses
    FROM
    algorand.account_asset
    WHERE
    asset_name in (
    'YouNow Pending Props',
    'Camfrog Pending Props',
    'Paltalk Pending Props',
    'Tether USDt',
    'USDC',
    'Opulous',
    'Buy Token',
    'Listia Pending Props',
    'Yieldly',
    'PLANET'
    )
    GROUP BY
    blocks,
    asset_name
    ),
    datetime_info AS (
    SELECT
    block_id,
    block_timestamp
    FROM
    Run a query to Download Data