msafadoost2024-03-14 07:47 PM
    Updated 2024-03-14
    SELECT
    tx_hash,
    nft_address,
    tokenid,
    block_timestamp,
    seller_address,
    buyer_address,
    project_name,
    aggregator_name,
    price_usd,
    total_fees_usd,
    platform_fee_usd,
    platform_name,
    creator_fee_usd
    FROM ethereum.Nft.ez_nft_sales
    WHERE
    block_timestamp >= GETDATE() - interval'1 year'
    AND project_name IS NOT NULL
    ORDER BY block_timestamp DESC
    LIMIT 50000
    QueryRunArchived: QueryRun has been archived