Afonso_Diaz2024-07-06 05:51 PM
Updated 2024-07-06
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 tab AS (
SELECT
origin_from_address AS user,
block_timestamp,
tx_hash
FROM ethereum.core.ez_decoded_event_logs
WHERE origin_to_address = '0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
AND decoded_log:integrator = 'jumper.exchange'
AND event_name = 'LiFiGenericSwapCompleted'
AND tx_status = 'SUCCESS'
),
labels AS (
SELECT
label as project_name,
address
FROM ethereum.core.dim_labels
WHERE label_type = 'bridge'
UNION
SELECT
'layer zero',
'0xe55e5fde6c25ac4ad75d867817d2d8a45836af49'
UNION
SELECT
'scroll',
'0x6774bcbd5cecef1336b5300fb5186a12ddd8b367'
),
tab2 AS (
SELECT
c.project_name,
QueryRunArchived: QueryRun has been archived