Updated 2024-07-08
    with sales as (
    select
    date_trunc('month', block_timestamp) as date,
    sum(price_usd) as volume
    from
    ethereum.nft.ez_nft_sales
    where
    nft_address = lower('0xa7d8d9ef8D8Ce8992Df33D8b8CF4Aebabd5bD270')
    group by
    1
    ),
    mint as(
    select
    date_trunc('month', block_timestamp) as date,
    sum(MINT_PRICE_USD) as volume
    from
    ethereum.nft.ez_nft_mints
    where
    nft_address = lower('0xa7d8d9ef8D8Ce8992Df33D8b8CF4Aebabd5bD270')
    group by
    1
    )
    select

    s.volume,
    m.volume
    from
    sales s
    join mint m on s.date = m.date
    where
    s.date >= '2024-01-01'
    QueryRunArchived: QueryRun has been archived