X as(

select buyer_address as user, platform_name as platform, price_usd, tx_hash, block_timestamp from near.nft.ez_nft_sales union all

select seller_address as user, platform_name as platform, price_usd, tx_hash, block_timestamp from near.nft.ez_nft_sales ),

A as(

select date_trunc('month',block_timestamp) as time, case when platform in ('Mitte','TradePort','Paras','Mintbase') then platform else 'OTHER' end as platform,

sum(price_usd)/2 as vol, count(distinct tx_hash) as txs, count(distinct user) as user

from X

group by 1,2),

B as(

select *, sum(vol) over(partition by platform order by time) as vol_all

from A )

select * from B

where platform = 'Paras'

order by 1 desc