0xaimanUntitled Query
Updated 2022-12-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with id as (select block_timestamp as t, tx_id, nft_id as nid,buyer, seller ,currency, price from flow.core.ez_nft_sales
where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'),
b as (select * from flow.core.dim_allday_metadata),
c as (select id.*, b.* from id inner join b on id.nid=b.NFT_id),
d as (select nft_id, max(t) as tm
from c
group by 1)
, e as (select buyer, d.nft_id, t
from c inner join d on c.t=d.tm)
select PLAYER, count(distinct tx_id) as n_purchase_txn
from c
where t>='2022-09-08' and player !='N/A'
group by 1 order by 2 desc
limit 10
Run a query to Download Data