zakkisyedUnique land nft owners (Daily)
Updated 2022-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
⌄
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