SELECT

price AS current_price

FROM (

SELECT

hour,

price,

RANK() OVER(ORDER BY hour DESC) AS rank

FROM base.price.ez_prices_hourly

WHERE token_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')

ORDER BY hour DESC

) AS a

WHERE rank = 1

SELECT

from_address,

SUM(amount) AS amount,

SUM(amount * price.current_price) AS amount_usd

FROM base.core.ez_token_transfers

JOIN price ON TRUE -- Ensures the join condition is met for a single-row result in `price`

WHERE contract_address = LOWER('0x55cD6469F597452B5A7536e2CD98fDE4c1247ee4')

AND to_address = LOWER('0x2d21235e26c326818ECEEaC82F26996E5202e512')

GROUP BY from_address

ORDER BY amount DESC;