select

'Last 60 days' as time_type,

count(distinct nft_address) as number_of_unique_nft_sales,

count(tx_hash) total_number_of_sales,

sum(price_usd) as total_sales_volume

from ethereum.core.ez_nft_sales

where platform_name = 'nftx'

and block_timestamp::date >= current_date - 60

),

total_unique_nft as (

select

'Over time' as time_type,

count(distinct nft_address) as number_of_unique_nft_sales,

count(tx_hash) total_number_of_sales,

sum(price_usd) as total_sales_volume

from ethereum.core.ez_nft_sales

where platform_name = 'nftx'

select * from total_unique_nft_last_60

union

select * from total_unique_nft