date_trunc('week',BLOCK_TIMESTAMP) AS week,

sum(Price) AS total_eth,

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

from ethereum.core.ez_nft_sales

where Price is not NULL

and week >= '2022-08-01'

group by 1

) ,

sol as (

date_trunc('week',BLOCK_TIMESTAMP) AS week,

sum(SALES_AMOUNT)AS total_sol,

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

from solana.core.fact_nft_sales

where SALES_AMOUNT is not NULL

and week >= '2022-08-01'

group by 1

)

select

e.week ,

e.total_eth , e.Cum_eth ,

s.total_sol , s.Cum_sol

from eth e

full outer join sol s

on e.week = s.week

order by 1