andreafiandrobase Bridge sum
Updated 2023-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- forked from zkSync Bridge sum @ https://flipsidecrypto.xyz/edit/queries/0650bb85-e01c-45f1-b0ad-91e7b1fdbcab
select
SUM(AMOUNT) as AMOUNT_BRIDGED
from
ethereum.core.ez_ETH_transfers
where
AMOUNT > 0
AND BLOCK_TIMESTAMP > '{{start_date_base}}'
AND BLOCK_TIMESTAMP < '{{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)
'0xb1a1a882' -- Deposit ETH (In Base: Base Bridge Contract)
)
ORDER BY
BLOCK_TIMESTAMP
Run a query to Download Data