crypto_edgarNFT Trades
Updated 2024-03-27
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 FLASH_TRADE_NFT_ADDRESSES AS (
SELECT
ADDRESS AS MINT
FROM
solana.core.dim_labels
WHERE
LABEL = 'flash trade'
),
ME_TRADES as (
select
DATE_TRUNC('DAY', BLOCK_TIMESTAMP) as DAY,
CASE
WHEN MARKETPLACE = 'tensorswap' THEN 'Tensorswap'
WHEN MARKETPLACE = 'Magic Eden' THEN 'Magic Eden'
WHEN MARKETPLACE = 'magic eden v2' THEN 'Magic Eden'
WHEN MARKETPLACE = 'hyperspace' THEN 'Hyperspace'
ELSE MARKETPLACE
END AS MARKETPLACE,
SALES_AMOUNT,
CLOSE,
TX_ID,
SALES.MINT
from
solana.nft.fact_nft_sales SALES
INNER JOIN FLASH_TRADE_NFT_ADDRESSES USING (MINT)
left join solana.price.ez_token_prices_hourly prices on DATE_TRUNC('hour', SALES.BLOCK_TIMESTAMP) = prices.recorded_hour
and prices.symbol = 'sol'
where
DAY >= TIMESTAMP '2023-12-28'
and SUCCEEDED
),
ME_TRADES_EDITED AS (
SELECT
DAY,
MARKETPLACE,
SUM(SALES_AMOUNT) AS VOLUME_SOL,
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived