Note that we will not be able to tag bots as DEX vs NFTs since we don't have these marketplaces mapped. But this may be tough anyway, since many L2 bots will rarely tough tokens, since they'll spam transactions that only execute if there's an opportunity.
Expected result is something like:
Chain | Address
But also TBD if we want to identify bots ona. chain-level, a superchain-wide level, or both?
Leaning towards Superchain-Wide level, so then the table is just 'Address'
Another Variant: Explore if we can use the address summary table, rather than hit raw transactions
Re-build logic to tag addresses as likely high-frequency or automated bots based on transaction throughput, hours active, etc.
See old logic we developed here (used in the World Chain announcement): https://dune.com/queries/3618075/6096208
Note that we will not be able to tag bots as DEX vs NFTs since we don't have these marketplaces mapped. But this may be tough anyway, since many L2 bots will rarely tough tokens, since they'll spam transactions that only execute if there's an opportunity.
Expected result is something like:
Chain | Address
But also TBD if we want to identify bots ona. chain-level, a superchain-wide level, or both?
Another Variant: Explore if we can use the address summary table, rather than hit raw transactions