flipside

    Unique NFT Traders
    Eman-RazUnique NFT Traders
    Updated 2024-04-28
    with tab3 as (with tab1 as (select seller_address as trader
    from sei.nft.ez_nft_sales
    where project_name='Yaka Voyager' and tx_succeeded='TRUE' and currency='usei'),

    tab2 as (select buyer_address as trader
    from sei.nft.ez_nft_sales
    where project_name='Yaka Voyager' and tx_succeeded='TRUE' and currency='usei')

    select * from tab1 union all
    select * from tab2)

    select count(distinct trader) as trader_count
    from tab3

    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived