andreafiandroTop Bridger
Updated 2023-11-20
999
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
SELECT
-- LINEA Network
*
FROM
(
SELECT
'Linea' as NETWORK,
ORIGIN_FROM_ADDRESS,
SUM(AMOUNT) as TOT_BRIDGED
FROM
(
select
AMOUNT,
ORIGIN_FROM_ADDRESS,
date_trunc('hour', BLOCK_TIMESTAMP) as HOUR
from
ethereum.core.ez_ETH_transfers
where
AMOUNT > 0
AND HOUR > '2023-08-16 00:00'
AND HOUR < '2023-08-17 00:00'
AND ORIGIN_TO_ADDRESS = '0xd19d4b5d358258f05d7b411e21a1460d11b0876f'
AND ORIGIN_FUNCTION_SIGNATURE in ('0x9f3ce55a') -- Deposit ETH
ORDER BY
BLOCK_TIMESTAMP
)
GROUP BY
ORIGIN_FROM_ADDRESS
ORDER BY
TOT_BRIDGED DESC
)
-- WHERE TOT_BRIDGED > 1
UNION
all
SELECT
-- Base Network
Run a query to Download Data