Is there an indexed database for ERC20 allowances?

Question

For instance, I'd like to make the following query:

Return all the addresses that have approved spender x on a particular token

It seems that I can only query for a specific (address, spender) pair on Etherscan.

Mikhail Vladimirov · Accepted Answer · 2019-08-04 21:29:36Z

0

I assume, that you want to query this for particular token, not for all tokens.

Via Web3 API query Ethereum node for all Approval events with _spender equal to x logged by particular token contract.
Extract _owner values from all such events and deduplicate these values. This will give you all addresses that have ever approved anything to x.
Query current allowance these addresses currently have for x to remove addresses that do not have allowance for x anymore.

answered Aug 4, 2019 at 21:29

7,0901 gold badge21 silver badges36 bronze badges

Interesting. How long til I get all events? Can I use infura?
– Parker Applebye
Aug 4, 2019 at 21:51
Yes, sure, infura supports such queries. This will be indexed query, so performance should be good unless you have too many Approval events with _spander equal to x.
– Mikhail Vladimirov
Aug 4, 2019 at 22:14

Add a comment |

1 Answer 1