-- forked from ZkSync Bridge @ https://flipsidecrypto.xyz/edit/queries/52c45456-ee6d-4e4e-b98c-4d72eb315b40

count(distinct ORIGIN_FROM_ADDRESS) as "Unique Bridgers"

(

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 > '{{start_date_mantle}}'

AND HOUR < '{{end_date_mantle}}'

AND ORIGIN_TO_ADDRESS = '0x95fc37a27a2f68e3a647cdc081f0a89bb47c3012'

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

ORDER BY

BLOCK_TIMESTAMP

)