No Data to Display
genaico-h0eQjRETH Balance (Starknet) copy
Updated 2024-02-16
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
›
⌄
-- forked from mamad-5XN3k3 / ETH Balance (Starknet) @ https://flipsidecrypto.xyz/mamad-5XN3k3/q/_aHVGauDG3Lr/eth-balance-starknet
-- forked from arabianhorses-jZtVNa / MAIN @ https://flipsidecrypto.xyz/arabianhorses-jZtVNa/q/Ew5-UbZsYWoV/main
WITH address_edit AS (
SELECT
CASE
WHEN LOWER('{{Account_address}}') LIKE '0x0000%' THEN CONCAT(
'0x',
SUBSTR(
LOWER('{{Account_address}}'),
7,
LENGTH('{{Account_address}}')
)
)
WHEN LOWER('{{Account_address}}') LIKE '0x000%' THEN CONCAT(
'0x',
SUBSTR(
LOWER('{{Account_address}}'),
6,
LENGTH('{{Account_address}}')
)
)
WHEN LOWER('{{Account_address}}') LIKE '0x00%' THEN CONCAT(
'0x',
SUBSTR(
LOWER('{{Account_address}}'),
5,
LENGTH('{{Account_address}}')
)
)
WHEN LOWER('{{Account_address}}') LIKE '0x0%' THEN CONCAT(
'0x',
SUBSTR(
LOWER('{{Account_address}}'),
4,
LENGTH('{{Account_address}}')
)
Last run: about 1 year ago
0
2B
1s