#AA 03 AA aggregation table of EVM chains
The EntryPoint
contract of ERC4337 has been deployed on multiple EVM chains. You can view the list of all chains that have deployed the EntryPoint
contract here:
If you want to analyze the combined data of all EVM chains, it would clearly be too cumbersome to write the analyses one by one. Therefore, based on the spellbook of the dune platform, we have aggregated the data of the EntryPoint contracts of two versions on 9 major blockchains into two new data tables. These tables can currently be directly used on the dune platform for easy analysis. The specific source code can be found at:
https://github.com/duneanalytics/spellbook/tree/main/models/account_abstraction/erc4337
account_abstraction_erc4337.userops
: contains UserOperationEvent event data from 9 chains, also joined with the transactions table and price table to get information like the bundler of eachuserOp
and the gas fee paid for that transaction.account_abstraction_erc4337.account_deployed
: includes AccountDeployed event data from 9 chains
Including blockchains:
Ethereum | Base |
Polygon | BNB |
Arbitrum | Celo |
Optimism | Gnosis |
Avalanche |
userops
For a detailed definition of UserOps
, see the link below:
https://spellbook-docs.dune.com/#!/model/model.spellbook.account_abstraction_erc4337_userops
The aggregated table UserOps contains more information; the included field information is as follows:
COLUMN | DESCRIPTION |
---|---|
blockchain | blockchain which EntryPoint was deployed |
version | version of the EntryPoint contract |
block_month | UTC event block date of each User Operation |
block_time | UTC event block time of each User Operation |
entrypoint_contract | the contract address of the EntryPoint |
tx_hash | Unique transaction hash value tied to each transaction on the User Operation |
sender | the sender(AA wallet address) that submmited the user operation |
userop_hash | Unique user operation hash |
success | weather the user operation is successfully execuated |
paymaster | the address that pay for the user operation gas fees on behalf of the user |
op_fee | The gas paid by sender or paymaster It depends on the chain gas setting |
op_fee_usd | The user operation gas (in usd) paid by sender or paymaster. |
bundler | address that bundle UserOps and submit those UserOps to the final on-chain by send a EOA transaction. It is the transaction from address |
tx_to | address where the bundler send the transaction |
gas_symbol | the gas symbol paied for the transaction |
tx_fee | the bundler paied gas value for the transaction |
tx_fee_usd | the bundler paied gas (in usd) value for the transaction |
beneficiary | the address where the bundler setting for the user operation pay for thier gas fee |
The analysis will then be much simpler. For example, analyzing the distribution of user operations across 9 chains:
For another example, analyzing the monthly profit of bundlers:
account_deployed
The information contained in account_deployed is relatively small, it just integrates the data of the two contract versions and several EVM chains together. See the link for detailed definitions:
https://spellbook-docs.dune.com/#!/model/model.spellbook.account_abstraction_erc4337_userops
The fields included in the aggregated account_deployed table are as follows:
COLUMN | DESCRIPTION |
---|---|
blockchain | blockchain which EntryPoint was deployed |
version | version of the EntryPoint contract |
block_time | UTC event block time of each User Operation |
block_month | UTC event block date of each User Operation |
userop_hash | Unique user operation hash |
entrypoint_contract | the contract address of the EntryPoint |
tx_hash | Unique transaction hash value tied to each transaction on the User Operation |
sender | the sender(AA wallet address) that submmited the user operation |
paymaster | the address that pay for the user operation gas fees on behalf of the user |
factory | who can create a new AA Wallet. It's smart contract address |
Using account_deployed
aggregated tables makes analysis simpler as well. For example, getting the number of wallet factories on each chain:
For complete examples, please refer to the following link. This dashboard contains analyses of various aspects of EntryPoint
:
Last updated