BlockTrackerGMP based on chains
Updated 2023-10-30
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 tb0 as
(
SELECT
DISTINCT tx_id
FROM axelar.core.fact_msg_attributes
WHERE ATTRIBUTE_VALUE = 'Event_ContractCallWithToken'
)
,
tb1 as (
SELECT
'squid' as platform,
tx_id,
block_timestamp,
ATTRIBUTE_VALUE as chain
FROM axelar.core.fact_msg_attributes a
JOIN tb0 b using(tx_id)
WHERE MSG_TYPE = 'eventConfirmation' AND ATTRIBUTE_KEY = 'chain'
),
tb3 as (
SELECT
DISTINCT tx_id
FROM axelar.core.fact_msg_attributes
WHERE ATTRIBUTE_VALUE = 'Event_ContractCall'
)
,
tb4 as (
SELECT
'[MintDAO Bridge | Prime Protocol | etc]' as platform,
tx_id,
block_timestamp,
ATTRIBUTE_VALUE as chain
FROM axelar.core.fact_msg_attributes a
JOIN tb3 b using(tx_id)
WHERE MSG_TYPE = 'eventConfirmation' AND ATTRIBUTE_KEY = 'chain'
Run a query to Download Data