yasminTOP SELLER
Updated 2024-09-11
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
›
⌄
-- Top seller by volume
SELECT
SELLER_ADDRESS AS address,
SUM(TOTAL_PRICE_USD) AS total_volume
FROM
aptos.nft.ez_nft_sales
WHERE platform_name in (
'{{platform_name}}')
AND TOTAL_PRICE_USD IS NOT NULL
AND block_timestamp::date >= '{{Start_Date}}' AND block_timestamp::date <= '{{End_Date}}'
GROUP BY
SELLER_ADDRESS
ORDER BY
total_volume DESC
LIMIT 10;
-- -- Top buyer by volume
-- SELECT
-- BUYER_ADDRESS AS address,
-- SUM(TOTAL_PRICE_USD) AS total_volume
-- FROM
-- aptos.nft.ez_nft_sales
-- WHERE
-- PLATFORM_NAME = 'Wapal'
-- GROUP BY
-- BUYER_ADDRESS
-- ORDER BY
-- total_volume DESC
-- LIMIT 1;
QueryRunArchived: QueryRun has been archived