sum(mint_price_eth) as mint_price_eth,

date_trunc('day', block_timestamp) as day

FROM ethereum.core.ez_nft_mints

where project_name = 'uniswap'

and block_timestamp::date between '2023-01-01' and '2023-01-31'

group by day),

minted as (select

date_trunc('day', block_timestamp) as day,

sum(nft_count) as nfts_minted

from ethereum.core.ez_nft_mints

where project_name = 'uniswap'

and block_timestamp::date between '2023-01-01' and '2023-01-31'

group by day)

select eth.mint_price_eth, minted.nfts_minted, eth.day

from eth

join minted

on eth.day=minted.day

order by eth.mint_price_eth