date_trunc('month',BLOCK_TIMESTAMP) AS month,

sum(Price) AS total_eth,

sum(total_eth) over (order by month) AS Cum_eth

from ethereum.core.ez_nft_sales

where Price is not NULL

and month >= '2022-08-01'

group by 1

) ,

sol as (

date_trunc('month',BLOCK_TIMESTAMP) AS month,

sum(SALES_AMOUNT)AS total_sol,

sum(total_sol) over (order by month) AS Cum_sol

from solana.core.fact_nft_sales

where SALES_AMOUNT is not NULL

and month >= '2022-08-01'

group by 1

)

select

e.month ,

e.total_eth , e.Cum_eth ,

s.total_sol , s.Cum_sol

from eth e

full outer join sol s

on e.month = s.month

order by 1