Updated 2024-12-05

    -- Get 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.

    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.xyz/our-app/getting-started

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

    Last run: 7 days ago
    PLATFORM_NAME
    SALES_COUNT
    1
    opensea267925
    2
    blur162918
    3
    nftx3442
    4
    magic eden3426
    5
    x2y21220
    6
    sudoswap1169
    7
    element1049
    8
    rarible313
    9
    looksrare189
    10
    larva labs131
    10
    172B
    4s