Premium Listings

-- Use the premium database
USE DATABASE ETHEREUM;

-- Query DEX swaps
SELECT
    block_timestamp,
    platform,
    trader,
    token_in,
    token_out,
    amount_in_usd,
    amount_out_usd
FROM ethereum.defi.ez_dex_swaps
WHERE block_timestamp >= CURRENT_DATE - 7
ORDER BY amount_in_usd DESC
LIMIT 100;

-- Query NFT sales
SELECT
    block_timestamp,
    marketplace,
    nft_address,
    token_id,
    buyer,
    seller,
    price_usd
FROM ethereum.nft.ez_nft_sales
WHERE block_timestamp >= CURRENT_DATE - 1
ORDER BY price_usd DESC
LIMIT 50;

-- Query price data
SELECT
    hour,
    symbol,
    price,
    volume_24h
FROM ethereum.price.ez_prices_hourly
WHERE symbol IN ('ETH', 'USDC', 'WBTC')
  AND hour >= CURRENT_DATE - 30
ORDER BY hour DESC;