@jebonn / Contract methods from trace

SQL query

1SELECT DISTINCT left(substring(input::varchar from 3),8) as method
2FROM ethereum."traces"
3WHERE "to"='\xD533a949740bb3306d119CC777fa900bA034cd52'
4ORDER BY method
5LIMIT 100
6
7/*
806fdde03    name()
9095ea7b3    approve(address,uint256)
101652e9fc
1118160ddd    totalSupply()
121e83409a    claim(address)
1323b872dd    transferFrom(address,address,uint256)
142c4e722e    rate()
15313ce567    decimals()
1640c10f19    mint(address,uint256)
1742966c68    burn(uint256)
184e71d92d    claim()
1970a08231    balanceOf(address)
2095d89b41    symbol()
21a9059cbb    transfer(address,uint256)
22ae591d54    ?? tradeWithHintAndFee(address,uint256,address,address,uint256,uint256,address,uint256,bytes)
23b26b238e    ??
24c45a0155    factory()
25dd62ed3e    allowance(address,address)...