Updated 2024-01-18
    with
    -- eth
    eth_sales as (
    select
    date(block_timestamp) as day,
    sum(price_usd) as daily_sales,
    platform_name,
    'ethereum' as chain
    from
    ethereum.nft.ez_nft_sales
    group by
    day, platform_name, chain
    ),
    -- solana
    sol_tx as (
    select
    date_trunc('hour',block_timestamp) as hour,
    tx_id,
    case when lower(marketplace) like ('magic eden%') then 'magic eden' else lower(marketplace) end as marketplace2,
    mint,
    sales_amount
    -- ,project_name
    from
    solana.nft.fact_nft_sales
    left join
    solana.nft.dim_nft_metadata using (mint)
    ),

    sol_price as (
    select
    recorded_hour,
    close
    from
    solana.price.ez_token_prices_hourly
    where
    symbol like 'sol'
    QueryRunArchived: QueryRun has been archived