count(*) tx_count

from ethereum.core.ez_nft_sales a

where PLATFORM_NAME = 'blur'

and BLOCK_TIMESTAMP::date >= '2022-10-19'

and EVENT_TYPE = 'sale'

group by 1

order by 1