0x_spadePUDGY PENGUINS TOP 5 BUYERS
Updated 2024-08-19
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
›
⌄
SELECT
date_trunc('month',BLOCK_TIMESTAMP_HOUR) as month,
BLOCKCHAIN,
sum (TRANSACTION_COUNT_SUCCESS) AS N_TRANSACTIONS
FROM crosschain.stats.ez_core_metrics_hourly
WHERE BLOCK_TIMESTAMP_HOUR :: DATE BETWEEN ('2024-01-01') AND ('2024-08-19')
GROUP BY month, BLOCKCHAIN
limit 500
;
--SELECT
--BUYER_ADDRESS,
--COUNT (DISTINCT TOKENID) AS n_tokens,
--FROM ethereum.nft.ez_nft_sales
--WHERE NFT_ADDRESS = LOWER('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8')
--AND BLOCK_TIMESTAMP :: DATE >= '2024-01-01'
--GROUP BY BUYER_ADDRESS
--ORDER BY n_tokens DESC
--LIMIT 5
QueryRunArchived: QueryRun has been archived