-- 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_linea}}'

AND HOUR < '{{end_date_linea}}'

AND ORIGIN_TO_ADDRESS = '0xd19d4b5d358258f05d7b411e21a1460d11b0876f'

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

ORDER BY

BLOCK_TIMESTAMP

)