chibestEth NFT Market Place By Sales In The Last 30days
    Updated 2024-03-16

    -- I'm getting started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.


    select
    platform_name,
    count(*) as sales_count
    from ethereum.nft.ez_nft_sales
    where block_timestamp > current_date - interval '30 days'
    group by platform_name
    order by sales_count desc
    limit 8

    Last run: 20 days ago
    PLATFORM_NAME
    SALES_COUNT
    1
    opensea334067
    2
    blur29067
    3
    nftx2371
    4
    element703
    5
    magic eden410
    6
    sudoswap316
    7
    rarible207
    8
    larva labs103
    8
    136B
    1s