SELECT

*

(

SELECT

ORIGIN_FROM_ADDRESS,

SUM(AMOUNT) as TOT_BRIDGED

FROM

(

select

AMOUNT,

AMOUNT_USD,

date_trunc('hour', BLOCK_TIMESTAMP) as HOUR,

TX_HASH,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

ETH_FROM_ADDRESS as FROM_ADDRESS,

ETH_TO_ADDRESS as TO_ADDRESS

from

ethereum.core.ez_ETH_transfers

where

AMOUNT > 0

AND HOUR > '2023-03-24'

AND HOUR < '2023-03-25'

AND ORIGIN_TO_ADDRESS = '0x32400084c286cf3e17e7b677ea9583e60a000324'

AND ORIGIN_FUNCTION_SIGNATURE in ('0xeb672419') -- Deposit ETH

ORDER BY

BLOCK_TIMESTAMP

)

GROUP BY

ORIGIN_FROM_ADDRESS

ORDER BY

TOT_BRIDGED DESC