rw2023Collection - Marketplace trade volume
Updated 2023-04-23
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
›
⌄
-- forked from Aurory - Marketplace trade volume @ https://flipsidecrypto.xyz/edit/queries/93d98034-114c-4561-8721-8b3e85b3939d
-- forked from crypto_edgar / NFT Trades @ https://flipsidecrypto.xyz/crypto_edgar/q/2023-04-20-07-50-am-GEYhMz
with
aurory AS (
SELECT
ADDRESS AS MINT
FROM
solana.core.dim_labels
WHERE
label = '{{collection_label}}'
),
ME_TRADES as (
select
DATE_TRUNC('Day', BLOCK_TIMESTAMP) as DAY,
CASE
WHEN MARKETPLACE = 'tensorswap' THEN 'Tensorswap'
WHEN MARKETPLACE = 'magic eden v1' THEN 'Magic Eden'
WHEN MARKETPLACE = 'magic eden v2' THEN 'Magic Eden'
WHEN MARKETPLACE = 'hyperspace' THEN 'Hyperspace'
WHEN MARKETPLACE = 'opensea' THEN 'OpenSea'
WHEN MARKETPLACE = 'solanart' THEN 'Other'
WHEN MARKETPLACE = 'yawww' THEN 'Other'
WHEN MARKETPLACE = 'coral cube' THEN 'Other'
WHEN MARKETPLACE = 'Coral Cube' THEN 'Other'
WHEN MARKETPLACE = 'hadeswap' THEN 'HadeSwap'
ELSE MARKETPLACE
END AS MARKETPLACE,
SALES_AMOUNT,
CLOSE,
TX_ID,
SALES.MINT
from
solana.core.fact_nft_sales SALES
Run a query to Download Data