andreafiandroarbitrum Bridge
Updated 2023-10-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
SELECT
HOUR,
AMOUNT,
SUM(AMOUNT) OVER (ORDER BY HOUR) as CUMULATIVE_BRIDGED_AMOUNT
FROM
(
SELECT
date_trunc('hour', BLOCK_TIMESTAMP) as HOUR,
SUM(AMOUNT) as AMOUNT
FROM
( SELECT DISTINCT TX_HASH, BLOCK_TIMESTAMP, AMOUNT
FROM ethereum.core.ez_ETH_transfers
WHERE
AMOUNT > 0
AND BLOCK_TIMESTAMP > '{{start_date_arbitrum}}'
AND BLOCK_TIMESTAMP < '{{end_date_arbitrum}}'
AND ORIGIN_TO_ADDRESS = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f'
AND ORIGIN_FUNCTION_SIGNATURE in ('0x439370b1','0x0f4d14e9') -- Deposit ETH
)
GROUP BY HOUR
ORDER BY
HOUR
) AS subquery
ORDER BY HOUR
Run a query to Download Data