with tab1 as (

select date_trunc('{{Time_Frame}}',BLOCK_TIMESTAMP) as date

,SUCCEEDED

,count(distinct MINT) as nft_sold

,count(distinct PURCHASER) as nft_buyer

,count(distinct SELLER) as nft_seller

,sum(SALES_AMOUNT) as sales_volume

from solana.core.fact_nft_sales

where MARKETPLACE='exchange art'

and SUCCEEDED='TRUE'

group by 1,2)

select SUCCEEDED

,avg(nft_sold) as art_avg_nft_sold

,avg(nft_buyer) as art_avg_nft_buyer

,avg(nft_seller) as art_avg_nft_seller

,avg(sales_volume) as art_avg_sales_volume

from tab1

group by 1),

act2 as (

with tab1 as (

select date_trunc('{{Time_Frame}}',BLOCK_TIMESTAMP) as date

,SUCCEEDED

,count(distinct MINT) as nft_sold

,count(distinct PURCHASER) as nft_buyer

,count(distinct SELLER) as nft_seller

,sum(SALES_AMOUNT) as sales_volume

from solana.core.fact_nft_sales

where SUCCEEDED='TRUE'

group by 1,2)

select SUCCEEDED

,avg(nft_sold) as avg_nft_sold

,avg(nft_buyer) as avg_nft_buyer

,avg(nft_seller) as avg_nft_seller

,avg(sales_volume) as avg_sales_volume

from tab1