0xC2eAf96831Cd62f8dC3B85674D749154F205562c2023-08-14 05:42 PM copy
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,
parameters[2]:value[0]:value as amount,
parameters[0]:value as from_address,
parameters[1]:value as to_address
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
-- )
TX_HASH = '0x004f33e620085dbc7b65cecebdc9937cfccf937c2251f4d6f6049191a1407db0'
AND NAME = 'Transfer'
AND (
parameters[1]:value IN (
'0x53509b3ead4d93635af5f7bf477d115e635b910fd840821dda8d9c0c6e0e79c',
'0x7244f625106ad12fe95e1dd5a4d52576a4bfa2c129d2785afabc57d71ad6b27',
'0x7ee4864babdb42fb752870241a8613b28b575b159cab931ce71c10de31be070',
'0x1b64371585074b2c333e8b9fea28198ed8b75efcec2f3e3f7650a63de2999c1'
) -- WITHOUR ZERO
OR parameters[0]:value IN (
'0x53509b3ead4d93635af5f7bf477d115e635b910fd840821dda8d9c0c6e0e79c',
'0x7244f625106ad12fe95e1dd5a4d52576a4bfa2c129d2785afabc57d71ad6b27',
'0x7ee4864babdb42fb752870241a8613b28b575b159cab931ce71c10de31be070',
'0x1b64371585074b2c333e8b9fea28198ed8b75efcec2f3e3f7650a63de2999c1'
Run a query to Download Data