dannerNon-Sellers (v1)
Updated 2022-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with potential_vault_transfers as
(
with minter_map as
(
select
nft_to_address,
tokenid
from
ethereum.core.ez_nft_mints
where nft_address = lower('{{contract}}')
),
transfer_2x as
(
select
tokenid
from
ethereum.core.ez_nft_transfers
where nft_address = lower('{{contract}}')
group by 1
having count(tx_hash) > 3
)
select
transfer_2x.tokenid,
minter_map.nft_to_address as minter
from
transfer_2x
left join minter_map on transfer_2x.tokenid = minter_map.tokenid
),
sales as
(
select
buyer_address,
tokenid
from
ethereum.core.ez_nft_sales
Run a query to Download Data