this is my chosen question :

Draw a chart showing the number of new addresses every day on Arbitrum network . Any specific Events over time?

Whats Arbitrum?

Arbitrum is a type of technology known as an optimistic rollup. It allows Ethereum smart contracts to scale by passing messages between smart contracts on the Ethereum main chain and those on the Arbitrum second layer chain.

What do we want?

we will analyze data of new users of arbitrum chain by each day and in total number.

How we do it?

using arbitrum core database and transactions table of it we will count minimum date of a transaction as creation day of address

look at charts below :

Conclusion

Charts are clear in daily and cumulative form but what is obvious is 22th june that we can see a huge growth in new addresses

so i checked what happened then and figured out it was kick off of Arbitrum Odyssey.

Arbitrum has put together a program titled Arbitrum Odyssey to help onboard users to the network, rewarding them with NFTs and possibly qualifying them for a future airdrop. Arbitrum, through the program, rewards users for learning. The user will learn to bridge, conduct swaps, buy NFTs, and more. Airdrop plus NFTs?!