TOTAL_SELLS_AMOUNT | TOTAL_BUYS_AMOUNT | TOTAL_SELL_AMOUNT | TOTAL_BUY_AMOUNT | TOTAL_SELL_AND_BUY_AMOUNT | TOTAL_SELLS_AMOUNT_USD | TOTAL_BUYS_AMOUNT_USD | TOTAL_VOLUME_USD | TOTAL_SELL_TRANSACTIONS | TOTAL_BUY_TRANSACTIONS | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 80.445141231 | 89.991577312 | 80.445141231 | 89.991577312 | 170.436718543 | 11651.649828397 | 13854.836908885 | 25506.486737282 | 60 | 63 |
krom1prACTICE FOR TOGGLE
Updated 2025-04-10
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 nft_data AS (
SELECT
SUM(CASE WHEN SELLER_ADDRESS = '{{wallet}}' THEN PRICE ELSE 0 END) AS total_sells_amount,
SUM(CASE WHEN BUYER_ADDRESS = '{{wallet}}' THEN PRICE ELSE 0 END) AS total_buys_amount,
SUM(CASE WHEN SELLER_ADDRESS = '{{wallet}}' THEN PRICE_USD ELSE 0 END) AS total_sells_amount_usd,
SUM(CASE WHEN BUYER_ADDRESS = '{{wallet}}' THEN PRICE_USD ELSE 0 END) AS total_buys_amount_usd,
COUNT(CASE WHEN SELLER_ADDRESS = '{{wallet}}' THEN TX_ID END) AS total_sells_count,
COUNT(CASE WHEN BUYER_ADDRESS = '{{wallet}}' THEN TX_ID END) AS total_buys_count
FROM
solana.nft.ez_nft_sales
WHERE
(SELLER_ADDRESS = '{{wallet}}' OR BUYER_ADDRESS = '{{wallet}}')
AND (MARKETPLACE ILIKE '%magic eden%' OR MARKETPLACE ILIKE '%magic eden v2%' OR MARKETPLACE ILIKE '%magic eden v3%')
AND SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP >= CASE
WHEN '{{date_range_toggle}}' = 'Season1' THEN '2024-12-10 00:00:00.000' -- Start date for Season 1
WHEN '{{date_range_toggle}}' = 'BonusSeason' THEN '2025-04-01 00:00:00.000' -- Start date for Bonus Season
WHEN '{{date_range_toggle}}' = 'All Time' THEN '2015-01-01' -- Start date for All Time (earliest possible)
ELSE '2024-12-10 00:00:00.000' -- Default start date (Season 1)
END
AND BLOCK_TIMESTAMP <= CASE
WHEN '{{date_range_toggle}}' = 'Season1' THEN '2025-03-31 23:59:00.000' -- End date for Season 1
WHEN '{{date_range_toggle}}' = 'BonusSeason' THEN '2025-04-17' -- End date for Bonus Season
WHEN '{{date_range_toggle}}' = 'AllTime' THEN '2026-12-31' -- End date for All Time (far future)
ELSE '2025-03-31 23:59:00.000' -- Default end date (Season 1)
END
)
SELECT
nft_data.total_sells_amount,
nft_data.total_buys_amount,
-- Aggregated totals for amounts (selling and buying)
nft_data.total_sells_amount AS total_sell_amount,
nft_data.total_buys_amount AS total_buy_amount,
Last run: about 2 months ago
1
123B
1s