What a break down, I never knew there is a place to know the amount of bitcoin addresses with funds inside.

how do you collect the data and also determined how they transacted?

Credits
Blockchair Database Dumps has a staggering amount of data, easily accessible (at 10 kB/s) with daily updates. All data presented in this topic comes from Blockchair.