COUNT(DISTINCT ORIGIN_FROM_ADDRESS)

(

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

AND HOUR < '{{end_date_base}}'

AND ORIGIN_TO_ADDRESS in (

'0x3154cf16ccdb4c6d922629664174b904d80f2c35',

-- Base: Base Bridge

'0x49048044d57e1c92a77f79988d21fa8faf74e97e' -- Base: Base Portal

)

AND ORIGIN_FUNCTION_SIGNATURE in (

'0x',

-- ETH Transfer to Base: Base Bridge or Base: Base Portal

'0x9a2ac6d5',

-- Deposit ETH (To Another Wallet on Base)