rw2023HadeSwap ranking volumen colecciones
Updated 2023-10-16
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 HadeSwap collection volume @ https://flipsidecrypto.xyz/edit/queries/24bd3016-a948-48e0-8e30-d97c1a85b243
-- forked from UW Marketplace trade volume @ https://flipsidecrypto.xyz/edit/queries/4fc55011-d597-4828-a2b0-679fdfa611f6
-- forked from Collection - Marketplace trade volume @ https://flipsidecrypto.xyz/edit/queries/d284e672-9c55-4f10-938a-644d135fd434
-- 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
ME_TRADES AS (
SELECT
DATE_TRUNC('Day', BLOCK_TIMESTAMP) AS DAY,
MARKETPLACE,
SALES_AMOUNT,
CLOSE,
TX_ID,
SALES.MINT,
COALESCE(LABELS.label, 'Other') AS label
FROM
solana.core.fact_nft_sales SALES
LEFT JOIN solana.core.ez_token_prices_hourly prices ON DATE_TRUNC('hour', SALES.BLOCK_TIMESTAMP) = prices.recorded_hour
AND prices.symbol = 'sol'
LEFT JOIN solana.core.dim_labels LABELS ON SALES.MINT = LABELS.address
WHERE
DAY >= TIMESTAMP '2021-04-26'
AND SUCCEEDED
AND MARKETPLACE ILIKE 'hadeswap'
),
ME_TRADES_EDITED AS (
SELECT
DAY,
MARKETPLACE,
label AS MINT_LABEL,
SUM(SALES_AMOUNT) AS VOLUME_SOL,
Run a query to Download Data