flipside

    Top 10 NFT projects on Optimism with most number of transactions
    peteerTop 10 NFT projects on Optimism with most number of transactions
    Updated 2022-09-07
    select project_name, count(DISTINCT tx_hash) as total_txs
    from
    (SELECT * from optimism.core.dim_labels
    inner join optimism.core.fact_event_logs
    on contract_address = address)
    where label_type = 'nft'
    GROUP by 1
    order by 2 desc
    limit 10
    Run a query to Download Data