buyers as (

select

buyer as user,

count(distinct tx_id) as sales,

-1*sum(price) as volume

from

flow.core.ez_nft_sales

where

nft_collection in ( 'A.921ea449dffec68a.FlovatarComponent' )

and block_timestamp::date < current_date

and block_timestamp::date >= current_date - {{past_days}}

and not buyer is null

group by

1

order by

2 desc

)

,

sellers as (

select

seller as user,

count(distinct tx_id) as sales,

sum(price) as volume

from

flow.core.ez_nft_sales

where

nft_collection in ( 'A.921ea449dffec68a.FlovatarComponent' )

and block_timestamp::date < current_date

and block_timestamp::date >= current_date - {{past_days}}

and not seller is null

group by

1

order by

2 desc

)