Open mfcastellani opened 3 years ago
@tclemos query
SELECT DISTINCT ('0x' || encode(a.eth_addr, 'hex')) eth_addr
FROM account a
INNER JOIN token t
ON a.token_id = a.token_id
WHERE t.symbol = 'HEZ'
AND a.idx > 256
AND lower(encode(a.eth_addr, 'hex')) != 'ffffffffffffffffffffffffffffffffffffffff'
AND lower(encode(a.eth_addr, 'hex')) != '9fffffffffffffffffffffffffffffffffffffff'
LIMIT 2000;
Testing with 100k transactions we got a lot of this: