genaico-h0eQjRETH Balance (Starknet) copy copy
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 ETH Balance (Starknet) copy @ https://flipsidecrypto.xyz/edit/queries/5eb697be-a14d-433a-960a-d95f6bacfb6d
-- 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,
Run a query to Download Data