datavortexTop Traders By Transaction Counts
Updated 2024-10-07
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 BuyerCount AS (
SELECT
buyer_address AS "buyer address",
COUNT(DISTINCT tx_hash) AS "transaction count"
FROM
arbitrum.nft.ez_nft_sales
WHERE
block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'
GROUP BY
buyer_address
ORDER BY
"transaction count" DESC
LIMIT 5
),
SellerCount AS (
SELECT
seller_address AS "seller address",
COUNT(DISTINCT tx_hash) AS "transaction count"
FROM
arbitrum.nft.ez_nft_sales
WHERE
block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'
GROUP BY
seller_address
ORDER BY
"transaction count" DESC
LIMIT 5
)
SELECT
'Top Buyers by Transaction Count' AS category,
NULL AS "seller address",
"buyer address",
CASE
WHEN "transaction count" >= 1e9 THEN TO_CHAR(ROUND("transaction count" / 1e9, 2)) || 'B'
WHEN "transaction count" >= 1e6 THEN TO_CHAR(ROUND("transaction count" / 1e6, 2)) || 'M'
QueryRunArchived: QueryRun has been archived