replace(date_trunc('hour', block_timestamp), ':00.000', '') as hour,

round(

sum(amount),

2

) as tot_redeemed_amt

from

ethereum.core.ez_token_transfers

where

ethereum.core.ez_token_transfers.tx_hash in (

select

tx_hash

FROM

ethereum.core.fact_event_logs

WHERE

contract_address = '0x6c4e530a6f5cec117bbd1ed2937584a71c75ca22'

AND event_inputs :

from

LIKE '0x0000000000000000000000000000000000000000'

)

AND symbol like 'WETH'

group by

hour

order by

hour desc