Marketplace | Tier | Total volume (USD) | Total volume (SOL) | Total sales | Total buyer | Total seller | |
---|---|---|---|---|---|---|---|
1 | Tensor | Lower than 1$ NFTs | 949426.878316769 | 21571.637708364 | 4151236 | 460028 | 240815 |
2 | Tensor | 1-5$ NFTs | 5245680.32877923 | 107014.339642186 | 1957013 | 165284 | 172728 |
3 | Tensor | 5-10$ NFTs | 12835995.6048788 | 284225.713606626 | 1689461 | 133595 | 116711 |
4 | Tensor | 50-100$ NFTs | 43517916.7082442 | 1039270.22597474 | 616263 | 111406 | 89799 |
5 | Tensor | 10-50$ NFTs | 59706919.5222808 | 1385855.14612499 | 2658458 | 237380 | 191277 |
6 | Tensor | 100-500$ NFTs | 222984588.772263 | 5319070.01480592 | 1017160 | 158309 | 116094 |
7 | Tensor | more than 500$ NFTs | 419376158.461622 | 8553043.23985521 | 263845 | 63170 | 51642 |
MrftiTensor users sales analysis
Updated 2025-02-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
35
36
›
⌄
with price_tbl AS (
SELECT
hour :: date as date,
AVG(price) as price
from
solana.price.ez_prices_hourly
where
symbol = 'SOL'
GROUP BY
1
),
tbl AS (
SELECT
marketplace,
date_trunc (day ,block_timestamp) as "Date",
tx_id ,
purchaser,
seller,
sales_amount,
sales_amount * price as "sale volume"
FROM
solana.nft.fact_nft_sales a
JOIN price_tbl b ON a.block_timestamp :: date = b.date
where
marketplace in ('tensorswap'--,'magic eden v1', 'magic eden v2', 'Magic Eden')
)
and succeeded = 'true'
)
SELECT
CASE
when marketplace IN ('magic eden v1', 'magic eden v2', 'Magic Eden') then 'Magic Eden'
when marketplace IN ('tensorswap') then 'Tensor'
END as "Marketplace",
CASE when "sale volume" <1 then 'Lower than 1$ NFTs'
Last run: about 1 month agoAuto-refreshes every 12 hours
7
577B
19s