freemartianTotal Bridges
Updated 2024-10-18
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH txs AS (
SELECT
tx_hash
FROM ethereum.core.ez_decoded_event_logs
-- WHERE to_address = '0x735adbbe72226bd52e818e7181953f42e3b0ff21'
WHERE event_name = 'ETHBridgeInitiated'
AND contract_address = '0x735adbbe72226bd52e818e7181953f42e3b0ff21'
),
eth_bridge AS (
SELECT
block_timestamp,
tx_hash,
from_address AS wallet,
amount,
amount_usd,
'ETH' AS symbol
FROM ethereum.core.ez_native_transfers
WHERE tx_hash IN (SELECT tx_hash from txs)
AND wallet NOT IN ('0x95bdca6c8edeb69c98bd5bd17660bacef1298a6f','0x735adbbe72226bd52e818e7181953f42e3b0ff21')
),
token_bridge AS (
SELECT
block_timestamp,
tx_hash,
from_address AS wallet,
amount,
amount_usd,
symbol
FROM ethereum.core.ez_token_transfers
WHERE to_address = '0x735adbbe72226bd52e818e7181953f42e3b0ff21'
AND origin_function_signature IN ('0x58a997f6','0x838b2520')
AND wallet NOT IN ('0x95bdca6c8edeb69c98bd5bd17660bacef1298a6f','0x735adbbe72226bd52e818e7181953f42e3b0ff21')
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived