crypto_edgarNFT Trades
    Updated 2024-03-27
    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