glass_blossomsTop 10 assets by number of transfers
    Updated 2022-04-09
    WITH top_asa as (
    SELECT
    block_id,
    asset_id,
    asset_receiver as holders,
    tx_id as number_of_transactions
    FROM algorand.asset_transfer_transaction
    where asset_id is not null
    ),

    time_line as (
    SELECT
    block_id,
    date_trunc('day', block_timestamp) as day
    FROM algorand.block
    ),
    asset_names as (
    SELECT
    asset_id,
    asset_name
    FROM algorand.asset
    )

    SELECT
    COUNT(DISTINCT top_asa.holders) as holder,
    COUNT(top_asa.number_of_transactions) as tx_number,
    time_line.day as day,
    asset_names.asset_name as asa_name

    FROM top_asa
    INNER JOIN time_line
    ON top_asa.block_id = time_line.block_id
    INNER JOIN asset_names
    ON top_asa.asset_id = asset_names.asset_id
    where day>'2022-02-01'
    Run a query to Download Data