with xmetrics_out AS

select

block_timestamp,

tx_hash,

raw_amount/pow(10,18) as amount_usd,

from_address,

to_address

from

polygon.core.fact_token_transfers

where contract_address=lower('0x15848C9672e99be386807b9101f83A16EB017bb5')

select dayname(block_timestamp) as day,hour(block_timestamp) as hour,

count(distinct tx_hash) as number_of_payments, avg(amount_usd) as average_usd_amount from xmetrics_out

group by day , hour