NavidCopy of Copy of Untitled Query
    Updated 2022-10-18
    with eth_sales as (
    select
    'Ethereum' as network,
    date(block_timestamp) as day,
    price,
    case
    when price <= 0.01 then '0.01 ETH'
    when price > 0.01 and price <= 0.1 then '0.1 ETH'
    when price > 0.1 and price <= 1 then '1 ETH'
    else '>1 ETH'
    end as price_label
    from
    ethereum.core.ez_nft_sales
    where currency_symbol = 'ETH' -- 'OP'
    and block_timestamp > CURRENT_DATE-60
    ), op_sales as (
    select
    'Optimism' as network,
    date(block_timestamp) as day,
    price,
    case
    when price <= 0.01 then '0.01 ETH'
    when price > 0.01 and price <= 0.1 then '0.1 ETH'
    when price > 0.1 and price <= 1 then '1 ETH'
    else '>1 ETH'
    end as price_label
    from
    optimism.core.ez_nft_sales
    where currency_symbol = 'ETH' -- 'OP'
    and block_timestamp > CURRENT_DATE-60
    )
    select
    day,
    network,
    price_label,
    count(*) as cnt
    Run a query to Download Data