0xC2eAf96831Cd62f8dC3B85674D749154F205562cStarknet dust
Updated 2023-08-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
contract AS token_address,
SUM(
iff(
parameters[0]:value = '0x53509b3ead4d93635af5f7bf477d115e635b910fd840821dda8d9c0c6e0e79c', -- deployed contract
- parameters[2]:value[0]:value::decimal,
parameters[2]:value[0]:value::decimal
)
) AS dust
FROM
external.tokenflow_starknet.decoded_events
WHERE
TX_HASH = '0x049c803bceb9aef2bb119170afd66e3fdf912fdd4861c91c0a6e027733eaf039' -- FulfilledOrder tx hash
AND NAME = 'Transfer'
AND parameters[1]:value != '0x1176a1bd84444c89232ec27754698e5d2e7e1a7f1539f12027f28b23ec9f3d8' -- tx fee
GROUP BY contract
Run a query to Download Data