with price as (

select

date_trunc('day', a.hour) as date,

avg(a.price) as price,

a.decimals as decimals,

a.symbol as symbol,

a.token_address as token_address

from

aptos.price.ez_prices_hourly a

where

a.token_address = '0x1::aptos_coin::AptosCoin'

group by

1,

3,

4,

5

order by

1 desc

),

table_final as (

select

a.project_name as "nft",

to_char(count(distinct a.tokenid), 'FM999,999,999,999') as "total items",

to_char(

count(distinct a.buyer_address),

'FM999,999,999,999'

) as "total buyer addresses",

to_char(

count(distinct a.seller_address),