mucryptoA 2 Q 5
    Updated 2023-01-18
    select
    distinct platform_name,
    count(tx_hash) as "Number of Transactions"
    from ethereum.core.ez_nft_sales
    where
    block_timestamp::DATE BETWEEN '2022-07-01' and '2022-07-31'
    group by platform_name
    order by "Number of Transactions" DESC
    -- AND platform_name = 'opensea'
    -- AND platform_name = 'sudoswap'
    -- AND platform_name = 'larva labs'
    -- AND platform_name = 'rarible'
    -- AND platform_name = 'x2y2'
    -- AND platform_name = 'looksrare'
    -- AND platform_name = 'nftx'
    Limit 10;
    Run a query to Download Data