Ali3NEvolution of Traders Over Time (SEI NFT Tracker)
    Updated 2025-06-17
    with timetable as (
    select case when '{{Time_Frame}}' = 'Last 7 Days' then 7
    when '{{Time_Frame}}' = 'Last 14 Days' then 14
    when '{{Time_Frame}}' = 'Last 30 Days' then 30
    when '{{Time_Frame}}' = 'Last 60 Days' then 60
    when '{{Time_Frame}}' = 'Last 90 Days' then 90
    when '{{Time_Frame}}' = 'Last 180 Days' then 180
    when '{{Time_Frame}}' = 'Last 365 Days' then 365
    when '{{Time_Frame}}' = 'All Time' then 3000
    else 2000 end as timeframe)

    select date_trunc ({{Time_Interval}},mindate) as date,
    count (distinct buyer_address) as New_Traders,
    sum (New_Traders) over (order by date) as Total_Traders
    from (
    select buyer_address,
    min (block_timestamp) as mindate
    from sei.nft.ez_nft_sales
    where project_name ilike '%{{NFT_Collection}}%'
    group by 1)
    join timetable
    where mindate >= current_date - timeframe
    group by 1
    order by 1 desc



    Last run: 17 days ago
    No Data to Display
    0
    2B
    2s