OneDataAnalystDaily past 5 months
    Updated 2022-10-05
    WITH Ethereum AS (
    SELECT
    Date_trunc('day',BLOCK_TIMESTAMP) AS Date,
    BUYER_ADDRESS,
    SELLER_ADDRESS,
    PROJECT_NAME AS Collection,
    PRICE_USD
    FROM ethereum.core.ez_nft_sales
    WHERE tx_hash != '0xc5531fa64ce1e5c609489e734325835471215ad5f8e0972c94b64d12242d97e4'
    ),

    OP AS (
    SELECT
    Date_trunc('day',BLOCK_TIMESTAMP) AS Date,
    BUYER_ADDRESS,
    SELLER_ADDRESS,
    NFT_ADDRESS AS Collection,
    PRICE_USD
    FROM optimism.core.ez_nft_sales
    ),

    SOLP AS (
    SELECT DATE_TRUNC('Day',HOUR) AS dt, AVG(PRICE) AS SOL_PRICE
    FROM ethereum.core.fact_hourly_token_prices
    WHERE TOKEN_ADDRESS = '0xd31a59c85ae9d8edefec411d448f90841571b89c'
    GROUP BY 1
    ),
    Solana AS (
    SELECT
    Date_trunc('day',BLOCK_TIMESTAMP) AS Date,
    PURCHASER,
    SELLER,
    MINT AS Collection,
    SALES_AMOUNT*SOL_PRICE AS PRICE_USD
    FROM solana.core.fact_nft_sales
    Run a query to Download Data