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 | 556.027975115 | 447.66463048 | 556.027975115 | 447.66463048 | 1003.692605595 | 61061.72822741 | 59399.104179303 | 120460.832406714 | 318 | 254 |
krom1ALL NFTS - Volume FIGS
Updated 2025-05-15
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_toggle}}' = 'MagicEden' AND (
MARKETPLACE ILIKE '%magic eden%'
OR MARKETPLACE ILIKE '%magic eden v2%'
OR MARKETPLACE ILIKE '%magic eden v3%'
))
OR ('{{marketplace_toggle}}' = 'TensorSwap' AND MARKETPLACE ILIKE '%tensorswap%')
OR ('{{marketplace_toggle}}' = 'All' AND (
MARKETPLACE ILIKE '%magic eden%'
OR MARKETPLACE ILIKE '%magic eden v2%'
OR MARKETPLACE ILIKE '%magic eden v3%'
OR MARKETPLACE ILIKE '%tensorswap%'
))
)
AND SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP >= CASE
WHEN '{{date_range_toggle}}' = '2021' THEN '2021-01-01'
WHEN '{{date_range_toggle}}' = '2022' THEN '2022-01-01'
WHEN '{{date_range_toggle}}' = '2023' THEN '2023-01-01'
WHEN '{{date_range_toggle}}' = '2024' THEN '2024-01-01'
WHEN '{{date_range_toggle}}' = '2025' THEN '2025-01-01'
WHEN '{{date_range_toggle}}' = 'All' THEN '2015-01-01'
ELSE '2015-01-01'
END
Last run: 13 days ago
1
128B
3s