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 | 176.139434002 | 120.414358727 | 176.139434002 | 120.414358727 | 296.553792729 | 26296.418382294 | 17862.40808021 | 44158.826462503 | 114 | 75 |
krom1Draft - V2 S1 Volume Figs
Updated 5 days ago
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}}' = '24hours' THEN CURRENT_TIMESTAMP() - INTERVAL '24 hours'
WHEN '{{date_range_toggle}}' = '12hours' THEN CURRENT_TIMESTAMP() - INTERVAL '12 hours'
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}}' = 'Season2' THEN '2025-04-17 19:00:00.000'
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}}' = '24hours' THEN CURRENT_TIMESTAMP()
WHEN '{{date_range_toggle}}' = '12hours' THEN CURRENT_TIMESTAMP()
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}}' = 'Season2' THEN '2025-08-15'
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,
Last run: 1 day ago
1
127B
2s