flyingfishNFT Buyers in period
Updated 2022-12-27
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 buyssells AS (
SELECT
*
/*
block_timestamp,
tx_hash,
nft_address,
project_name,
price,
price_usd,
currency_symbol,
buyer_address,
seller_address,
event_type,
*/
FROM ethereum.core.ez_nft_sales
WHERE nft_address = lower('{{nft_collection}}')
AND block_timestamp BETWEEN '{{startDate}}' AND '{{endDate}}'
ORDER BY block_timestamp ASC
)
SELECT
DISTINCT(buyer_address) AS buyers,
count(buyer_address) AS tokens_bought
FROM buyssells
GROUP BY buyers
ORDER BY tokens_bought DESC
/*
SELECT
nft_address,
project_name,
tx_type,
sum(pl) as profit_loss
FROM base
GROUP BY nft_address, project_name, tx_type
ORDER BY nft_address DESC
Run a query to Download Data