Sajjadiiipolismo111
Updated 2023-01-29
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 base_from_chain AS (
SELECT block_timestamp , tx_id ,
attribute_value AS source_Chain
FROM axelar.core.fact_msg_attributes
WHERE attribute_key = 'sourceChain'
AND tx_succeeded = TRUE
),
base_from_address AS (
SELECT block_timestamp , tx_id ,
attribute_value AS source_Address
FROM axelar.core.fact_msg_attributes
WHERE attribute_key = 'depositAddress'
AND tx_id IN (SELECT tx_id FROM base_from_chain)
AND tx_succeeded = TRUE
),
base_to_chain AS (
SELECT block_timestamp , tx_id ,
attribute_value AS destination_Chain
FROM axelar.core.fact_msg_attributes
WHERE attribute_key = 'destinationChain'
AND tx_id IN (SELECT tx_id FROM base_from_chain)
AND tx_succeeded = TRUE
),
base_to_address AS (
SELECT block_timestamp , tx_id ,
attribute_value AS destination_Address
FROM axelar.core.fact_msg_attributes
WHERE attribute_key = 'destinationAddress'
AND tx_id IN (SELECT tx_id FROM base_from_chain)
AND tx_succeeded = TRUE
),
base_token_bridge AS (
Run a query to Download Data