-count(distinct seller_address) as "Seller",

count(distinct buyer_address) as "Buyer"

FROM near.nft.ez_nft_sales

where platform_name='Paras'

and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

group by 1

order by 1),

table2 as (with tab1 as (select block_timestamp, seller_address as nft_trader

from near.nft.ez_nft_sales

where platform_name='Paras' and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'

union all

select block_timestamp, buyer_address as nft_trader

from near.nft.ez_nft_sales

where platform_name='Paras' and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}')

select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct nft_trader) as "NFT Trader"

from tab1

group by 1)

select table1."Date" as "Date", "Seller", "Buyer", "NFT Trader"

from table1 left join table2 on table1."Date"=table2."Date"

order by 1