flipside

    efficient-bronze
    MoDeFiefficient-bronze
    Updated 2024-12-02
    with base_nft_mints as (
    select a.* --BLOCK_TIMESTAMP, NFT_ADDRESS, TOKENID, PROJECT_NAME, NFT_TO_ADDRESS, a.tx_hash
    , value as price
    from base.nft.ez_nft_transfers a
    left join base.core.fact_transactions b
    on a.tx_hash=b.tx_hash
    where EVENT_TYPE='mint' and a.tx_hash not in (select tx_hash from base.defi.ez_lending_borrows)
    and a.tx_hash not in (select tx_hash from base.defi.ez_lending_deposits)
    order by price desc
    -- limit 123
    )

    select *
    from base_nft_mints
    where not PROJECT_NAME ilike ANY ('Slipstream Position NFT%', 'Fluid Vault', 'Maverick v2 Position','Maverick BP%','Truth Seeker Patron NFT')
    and PROJECT_NAME not ilike '%Positions NFT%'
    order by price desc
    limit 1000

    -- select count(*), count(distinct NFT_ADDRESS), count(distinct NFT_TO_ADDRESS), sum(price)
    -- from base_nft_mints
    -- limit 1000
    QueryRunArchived: QueryRun has been archived