KuramaUntitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select date_trunc('day', block_timestamp) as date, seller, sum(price) as amount
from flow.core.ez_nft_sales
where tx_succeeded = 'TRUE'
and nft_id is not null
and nft_collection = 'A.0b2a3299cc857e29.TopShot'
group by date, seller
select distinct nft_collection from flow.core.ez_nft_sales
where nft_collection like '%TopShot%'
select date_trunc('day', block_timestamp) as date, a.seller, count(*) as num_transact
from flow.core.ez_nft_sales a
where a.nft_id is not null
and a.nft_collection is not null
and A.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
group by date, a.seller
Run a query to Download Data