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'

),

price AS (

SELECT hour, price, rank() over(ORDER BY hour DESC) AS rank

FROM ethereum.price.ez_hourly_token_prices

WHERE symbol = 'WETH'

AND hour::date = current_date

qualify rank = 1

SELECT

count(tx_hash) AS transactions,

count(DISTINCT from_address) AS wallets,

SUM(amount) AS eth_value,

SUM(amount*price) AS usd_value

FROM puffer

INNER JOIN price