with puffer AS (

SELECT

block_timestamp,

tx_hash,

origin_function_signature,

from_address,

to_address,

amount,

amount_usd,

symbol

FROM ethereum.core.ez_token_transfers

WHERE to_address = '0x4aa799c5dfc01ee7d790e3bf1a7c2257ce1dceff'

AND origin_from_address = from_address

AND block_timestamp::date >= '2024-02-01'

SELECT

date_trunc('hour',block_timestamp) AS hour,

count(tx_hash) AS transactions,

count(DISTINCT from_address) AS wallets,

SUM(amount) AS steth_value,

SUM(amount_usd) AS usd_value

FROM puffer

GROUP BY 1