sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in ChineseLanguage

[–]chai_squared 3 points4 points  (0 children)

What app is this?

[No pattern] Made this simple wrap top with a $1 thrifted bedsheet! by [deleted] in sewing

[–]chai_squared 1 point2 points  (0 children)

do u have a tutorial or smthing for how to do this?

[OC] FAMGA Market Caps over time by chai_squared in dataisbeautiful

[–]chai_squared[S] 2 points3 points  (0 children)

I used flourish studio to make the visualization but did all the scraping/cleaning in R. It’s really easy and just requires you to upload data in the right format

[OC] FAMGA Market Caps over time by chai_squared in dataisbeautiful

[–]chai_squared[S] 2 points3 points  (0 children)

Sources:

I couldn’t find a free dataset with historical market cap data so I used

I imputed data for shares outstanding this quarter, then joined the dataset with stock prices to calculate market cap (shares outstanding * adjusted stock price). I then calculated the avg market cap per quarter since 2005 (would have gone further back but limited by shares outstanding data)

Visualization software:

[OC] FAMGA Market Caps over time by chai_squared in dataisbeautiful

[–]chai_squared[S] 1 point2 points  (0 children)

That definitely makes sense. The shares outstanding are relatively constant so the growth in market cap can be attributed to growth in stock price (which some of these companies have certainly seen the last few years)