kidaCeler Latency (Optimism)
Updated 2023-01-07Copy Reference Fork
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
›
⌄
with
origin_bridge_txs as (
select
block_timestamp,
tx_hash,
event_inputs:token as token_address,
event_inputs:transferId as transferId,
event_inputs:amount as bridged_amount
from optimism.core.fact_event_logs
where origin_to_address in (
'0x9d39fc627a6d9d9f8c831c16995b209548cc3401' --v2
)
and tx_status = 'SUCCESS'
and event_name = 'Send'
),
polygon_relay_txs as (
select
block_timestamp,
tx_hash,
event_inputs:token as token_address,
event_inputs:srcTransferId as srcTransferId,
event_inputs:amount as received_amount
from polygon.core.fact_event_logs b
where b.origin_to_address in (
'0x88dcdc47d2f83a99cf0000fdf667a468bb958a78', --v2
'0xa251c4691c1ffd7d9b128874c023427513d8ac5c' --2.0
)
and b.tx_status = 'SUCCESS'
and b.event_name = 'Relay'
),
ethereum_relay_txs as (
select
block_timestamp,
tx_hash,
Run a query to Download Data