pricet as (

select

hour::date as dt,

avg(price) as token_price_usd

from

aptos.price.ez_prices_hourly

where

symbol = 'APT'

group by 1

),

sales as (

select

tx_hash,

block_timestamp,

seller_address,

buyer_address,

project_name,

nft_address,

nvl(total_price_usd, total_price * token_price_usd) as price_usd,

nvl(platform_fee_usd, platform_fee * token_price_usd) as platform_fee_usd

from

aptos.nft.ez_nft_sales

left join

pricet on block_timestamp::date = dt

where

platform_name = 'Okx'

when price_usd < 10 then 'a. Less than 10 $'

when price_usd <= 50 then 'b. 10 - 50 $'

when price_usd <= 100 then 'c. 50 - 100 $'