andreafiandroPolygon 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
›
⌄
-- 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_polygon}}'
AND BLOCK_TIMESTAMP < '{{end_date_polygon}}'
AND ORIGIN_TO_ADDRESS = '0x2a3dd3eb832af982ec71669e178424b10dca2ede'
AND ORIGIN_FUNCTION_SIGNATURE in ('0xcd586579') -- Deposit ETH
ORDER BY BLOCK_TIMESTAMP
Run a query to Download Data