0xC2eAf96831Cd62f8dC3B85674D749154F205562cStarknet dust query
Updated 2023-08-14
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
›
⌄
SELECT
contract AS token_address,
TX_HASH,
SUM(
iff(
parameters[0]:value IN (
'0x53509b3ead4d93635af5f7bf477d115e635b910fd840821dda8d9c0c6e0e79c',
'0x7244f625106ad12fe95e1dd5a4d52576a4bfa2c129d2785afabc57d71ad6b27',
'0x7ee4864babdb42fb752870241a8613b28b575b159cab931ce71c10de31be070',
'0x1b64371585074b2c333e8b9fea28198ed8b75efcec2f3e3f7650a63de2999c1'
), -- WITHOUR ZERO
- parameters[2]:value[0]:value,
parameters[2]:value[0]:value
)
) AS dust
FROM
external.tokenflow_starknet.decoded_events
WHERE
TX_HASH IN (
SELECT
TX_HASH
FROM
external.tokenflow_starknet.decoded_events
WHERE
CONTRACT IN (
'0x053509b3ead4d93635af5f7bf477d115e635b910fd840821dda8d9c0c6e0e79c',
'0x07244f625106ad12fe95e1dd5a4d52576a4bfa2c129d2785afabc57d71ad6b27',
'0x07ee4864babdb42fb752870241a8613b28b575b159cab931ce71c10de31be070',
'0x01b64371585074b2c333e8b9fea28198ed8b75efcec2f3e3f7650a63de2999c1'
) -- ADDITIONAL ZERO
)
AND NAME = 'Transfer'
AND (
parameters[1]:value IN (
'0x53509b3ead4d93635af5f7bf477d115e635b910fd840821dda8d9c0c6e0e79c',
'0x7244f625106ad12fe95e1dd5a4d52576a4bfa2c129d2785afabc57d71ad6b27',
Run a query to Download Data