shreexDimension X 6
Updated 2023-04-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with users as (
select
buyer,
block_timestamp::date as min_date
from flow.core.ez_nft_sales
where nft_Collection='A.e3ad6030cbaff1c2.DimensionX')
select
RIGHT(nft_collection, CHARINDEX('.', REVERSE(nft_collection))-1) AS nft_collections,
count(distinct s.buyer) as crossover_buyers,
count(distinct tx_id) as crossover_buys
from flow.core.ez_nft_sales s,users where s.buyer=users.buyer and nft_collection != 'A.e3ad6030cbaff1c2.DimensionX'
GROUP BY nft_collections
HAVING crossover_buyers> 9
ORDER BY crossover_buyers DESC
Run a query to Download Data