SocioCryptoBSC Hacker - transfers
Updated 2023-02-25
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
›
⌄
SELECT
'sent' as direction,
tx_hash,
block_number,
block_timestamp,
bnb_from_address as origin,
bnb_to_address as destination,
'👾 wallet' as origin_label,
CASE
when bnb_to_address = '0x51ef542b956a147684690d3d99e85be15236e872' then '😔 wallet'
when bnb_to_address = '0x7444a295ceedb48c620bf20eedcfdda1b03dda6a' then '👾 wallet'
when b.project_name is null then bnb_to_address
else b.project_name
end as destination_label,
amount,
'BNB' as symbol,
amount_usd
FROM
bsc.core.ez_bnb_transfers a
LEFT JOIN bsc.core.dim_labels b
ON bnb_to_address = b.address
WHERE
bnb_from_address = '0x7444a295ceedb48c620bf20eedcfdda1b03dda6a'
UNION
SELECT
'received' as direction,
tx_hash,
block_number,
block_timestamp,
bnb_from_address as origin,
bnb_to_address as destination,
CASE
when bnb_from_address = '0x51ef542b956a147684690d3d99e85be15236e872' then '😔 wallet'
when bnb_from_address = '0x7444a295ceedb48c620bf20eedcfdda1b03dda6a' then '👾 wallet'
when project_name is null then bnb_from_address
else project_name
Run a query to Download Data