kidaStargate Latency (Polygon)
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_swaps as (
select
block_timestamp,
tx_hash,
replace(data, '0x') as trunc_data,
tokenflow_eth.hextoint(substr(trunc_data, 1, 64)) as dstChainId,
substr(trunc_data, 153, 40) as recipient,
substr(trunc_data, 193, 64) as amount,
substr(trunc_data, 321, 64) as dstFee,
substr(trunc_data, 385, 64) as protocolFee,
data
from polygon.core.fact_event_logs
where topics[0] = '0x34660fc8af304464529f48a778e03d03e4d34bcd5f9b6f0cfbf3cd238c642f7f' -- Swap
),
origin_nonces as (
select
block_timestamp,
tx_hash,
replace(data, '0x') as trunc_data,
substr(trunc_data, 65, 64) as nonce
from polygon.core.fact_event_logs
where topics[0] = '0x8d3ee0df6a4b7e82a7f20a763f1c6826e6176323e655af64f32318827d2112d4' -- SendMsg
),
origin_deposits as (
select
s.block_timestamp,
s.tx_hash,
s.dstChainId,
s.recipient,
s.amount,
s.dstFee,
s.protocolFee,
n.nonce,
Run a query to Download Data