SocioCryptoPolygon Hacker Final Destination
Updated 2023-02-26
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
›
⌄
-- forked from 58bcc1d1-5c23-40d5-bb66-607591ba84d1
-- forked from 3435f317-81c1-44df-b044-977add52fb8e
-- forked from 98049ed4-3946-4dc0-99ba-f4f855a4f481
SELECT
'sent' as direction,
tx_hash,
block_number,
block_timestamp,
matic_from_address as origin,
matic_to_address as destination,
'final 👨💻' as origin_label,
CASE
when matic_to_address = '0x51ef542b956a147684690d3d99e85be15236e872' then '😔 wallet'
when matic_to_address = '0x7444a295ceedb48c620bf20eedcfdda1b03dda6a' then '👾 wallet'
when matic_to_address = '0xaadb2228f4edd9028c0a638198b93a00cd3e3fd6' then 'final 👨💻'
when b.project_name is null then matic_to_address
else b.project_name
end as destination_label,
amount,
'MATIC' as symbol,
amount_usd
FROM
polygon.core.ez_matic_transfers a
LEFT JOIN polygon.core.dim_labels b
ON matic_to_address = b.address
WHERE
matic_from_address = '0xaadb2228f4edd9028c0a638198b93a00cd3e3fd6'
UNION
SELECT
'received' as direction,
tx_hash,
block_number,
block_timestamp,
Run a query to Download Data