zakkisyedUnique land nft owners (Daily)
    Updated 2022-04-19
    select date_trunc('day', latest_time) as block_time, count (owners) as no_of_newcomers
    from
    (
    select min(block_timestamp) as latest_time, (event_inputs:owner::string) as owners

    /*case when latest_time=CURRENT_DATE then 'today'
    when latest_time >current_date-7 and latest_time != current_date then 'this week'
    else 'old' end as date_purchased */

    from polygon.events_emitted
    where contract_address=lower('0xA2a13cE1824F3916fC84C65e559391fc6674e6e8') --crypto_unicorns nft contract

    group by 2
    order by 1 desc
    )

    group by 1
    order by 1 desc
    Run a query to Download Data