with txns as (

select BLOCK_TIMESTAMP::date date ,

ORIGIN_FROM_ADDRESS user ,

EVENT_NAME ,

tx_hash

from blast.core.ez_decoded_event_logs

where CONTRACT_ADDRESS ='0x4b17a9318238403ddac8e3a790c3b06d18132bf4'

and EVENT_NAME ='PostListed'

),

transfers as (

select tx_hash ,

symbol ,

amount ,

iff(amount_usd is not NULL,amount_usd,amount * 0.02554098355)amount_usd ,

FROM_ADDRESS,

TO_ADDRESS,

ORIGIN_FROM_ADDRESS,

from blast.core.ez_token_transfers join txns using(tx_hash)

select tx_hash ,

'ETH' symbol ,

amount ,

amount_usd,

FROM_ADDRESS,

TO_ADDRESS,

ORIGIN_FROM_ADDRESS,

from blast.core.ez_native_transfers join txns using(tx_hash)

select date ,

count (DISTINCT user) num_users ,