Skip to content

Instantly share code, notes, and snippets.

@Haroenv

Haroenv/README.md

Created September 30, 2016 13:58
Show Gist options
  • Save Haroenv/07e2016ae35860b0aa5db53138a614dd to your computer and use it in GitHub Desktop.
Save Haroenv/07e2016ae35860b0aa5db53138a614dd to your computer and use it in GitHub Desktop.
Download ZIP
BigQuery Results of imgur vs reddit image uploads
Raw
README.md

Compares the amount of posts uploaded via imgur vs those via reddit

SELECT USEC_TO_TIMESTAMP(UTC_USEC_TO_Day(TIMESTAMP_TO_USEC(created_utc))) as utc_day,
  SUM(domain CONTAINS 'imgur.com')/COUNT(*) as perc_imgur_submissions,
  SUM(domain CONTAINS 'reddituploads.com' OR domain CONTAINS 'i.redd.it')/COUNT(*) as perc_reddit_submissions,
  COUNT(*) as num_submissions
FROM [pushshift:rt_reddit.submissions]
WHERE created_utc > '2016-05-22 07:00:00'
AND lower(subreddit) IN ('getmotivated', 'earthporn', 'gaming', 'space', 'oldschoolcool', 'sports', 'art', 'aww', 'dataisbeautiful', 'food', 'funny', 'gifs', 'mildlyinteresting', 'movies', 'photoshopbattles', 'pics')
GROUP BY utc_day
ORDER BY utc_day

original link

Numbers "visualisation":

Raw
results-20160930-152338.csv
utc_day perc_imgur_submissions perc_reddit_submissions num_submissions
1.4638752E9 0.4740740740740741 0.07388888888888889 5400
1.4639616E9 0.44542572463768115 0.06884057971014493 8832
1.464048E9 0.4461742298774429 0.08645246770453793 9057
1.4641344E9 0.41983787435262326 0.11337536590857915 8882
1.4642208E9 0.39581920903954804 0.13062146892655369 8850
1.4643072E9 0.4083769633507853 0.13328021852947872 8786
1.4643936E9 0.4619642016015073 0.13942534149788036 8492
1.46448E9 0.4499166346030525 0.14377324612030268 7797
1.4645664E9 0.42043266508098315 0.1325178389398573 8829
1.4646528E9 0.40487592511972137 0.12788419677840662 9188
1.4647392E9 0.3892489941886455 0.12695574430040232 8948
1.4648256E9 0.4048869360197192 0.12345943628764335 9331
1.464912E9 0.4174322204794981 0.13186197624915977 8926
1.4649984E9 0.42326139088729015 0.13621103117505995 8340
1.4650848E9 0.43288161595499874 0.14753260035796473 7822
1.4651712E9 0.4056872037914692 0.1389152185360716 9495
1.4652576E9 0.4103863204559848 0.14112307367532193 9474
1.465344E9 0.3918059299191375 0.12269541778975741 9275
1.4654304E9 0.40365337491646247 0.12486077077300067 8978
1.4655168E9 0.39324847814056446 0.1359158826784726 9035
1.4656032E9 0.41482590789966306 0.1491326594284288 8013
1.4656896E9 0.4163424124513619 0.13898346303501946 8224
1.465776E9 0.38257498469700063 0.1348704346051826 9802
1.4658624E9 0.3754081632653061 0.12428571428571429 9800
1.4659488E9 0.37923393478949036 0.14097288171362246 9477
1.4660352E9 0.3898010220724149 0.14015439817331737 9197
1.4661216E9 0.38290206354405504 0.14433890162681515 9159
1.466208E9 0.4229174519411986 0.14084684005528333 7959
1.4662944E9 0.43241042345276876 0.16030711959050722 8596
1.4663808E9 0.40968783638320777 0.1456404736275565 9290
1.4664672E9 0.38380890618244706 0.15920881971465628 9252
1.4665536E9 0.3555580710889744 0.17534525696173875 8834
1.46664E9 0.37574180114523686 0.16543466944299845 9605
1.4667264E9 0.3810796915167095 0.18560411311053984 9725
1.4668128E9 0.4048872180451128 0.17518796992481203 7980
1.4668992E9 0.4053848107696215 0.18961137922275845 7874
1.4669856E9 0.3646918402777778 0.18858506944444445 9216
1.467072E9 0.3555531663262015 0.18062573916783142 9301
1.4671584E9 0.37209302325581395 0.17761057911536707 8772
1.4672448E9 0.3643866591294517 0.17591859807801016 8845
1.4673312E9 0.3628257093225246 0.19664157498552404 8635
1.4674176E9 0.38535769428718475 0.205609881626351 7772
1.467504E9 0.3971086220369888 0.21086220369887992 7678
1.4675904E9 0.39365529270685706 0.19077728115120463 9173
1.4676768E9 0.3472446391514872 0.19080009222965183 8674
1.4677632E9 0.35217074945428084 0.19136551055056997 8246
1.4678496E9 0.37210796915167094 0.2092973436161097 9336
1.467936E9 0.3768516471368561 0.20274154322352422 9046
1.4680224E9 0.38244274809160306 0.21348600508905852 7860
1.4681088E9 0.39349040563517124 0.2152052465387418 8234
1.4681952E9 0.37399831294812313 0.1968578658793758 9484
1.4682816E9 0.34615384615384615 0.19544962080173348 9230
1.468368E9 0.3557238502908572 0.20458786082757108 9111
1.4684544E9 0.34333000111074086 0.2055981339553482 9003
1.4685408E9 0.3532269257460097 0.20286837844089753 8646
1.4686272E9 0.370782056371576 0.2096069868995633 7557
1.4687136E9 0.3882570748479238 0.20880719386405713 7562
1.4688E9 0.35242489028918644 0.19759198829751323 8887
1.4688864E9 0.35497114957834 0.19562805148690635 9012
1.4689728E9 0.337527415444996 0.19427450075031744 8663
1.4690592E9 0.3384932920536636 0.1928677903910102 8721
1.4691456E9 0.3254451464675474 0.21275129236071225 8705
1.469232E9 0.34916526465639963 0.209525042060308 7727
1.4693184E9 0.36006916733173716 0.22439478584729983 7518
1.4694048E9 0.3337175792507205 0.2225936599423631 8675
1.4694912E9 0.3377579475738985 0.2094813162297825 8965
1.4695776E9 0.3502931091693397 0.19488994580245547 9041
1.469664E9 0.3324411731905877 0.209992193598751 8967
1.4697504E9 0.3310795582600856 0.2361956276763579 8874
1.4698368E9 0.35198912774894986 0.23264146281195947 8094
1.4699232E9 0.35875526080857034 0.23632189771712792 7841
1.4700096E9 0.34912199630314233 0.23324861367837338 8656
1.470096E9 0.3405716818081099 0.21992023044538 9026
1.4701824E9 0.3341769366197183 0.2322843309859155 9088
1.4702688E9 0.34297474691289354 0.21415062854600067 8989
1.4703552E9 0.33771778008538134 0.20976116303219106 8667
1.4704416E9 0.3651750224387742 0.22028465187844595 7799
1.470528E9 0.3629135675814311 0.23070017953321365 7798
1.4706144E9 0.34009928295642583 0.21378929950358522 9065
1.4707008E9 0.3341229554427524 0.2038353073886069 8865
1.4707872E9 0.32894736842105265 0.20356037151702785 9044
1.4708736E9 0.3305055200464846 0.20662405578152238 8605
1.47096E9 0.3369325925149387 0.2206730265226963 9539
1.4710464E9 0.3443716497915426 0.22596783799880882 8395
1.4711328E9 0.3409090909090909 0.25638820638820636 8140
1.4712192E9 0.32877165875731157 0.2270168855534709 9061
1.4713056E9 0.3213828425096031 0.21617584293640632 9372
1.471392E9 0.317495050536626 0.2226737522142336 9597
1.4714784E9 0.3263934070700499 0.2117761873780091 9222
1.4715648E9 0.3204760855190655 0.23043861582543532 9074
1.4716512E9 0.32247557003257327 0.24993735905788023 7982
1.4717376E9 0.3358961431812453 0.2500630199142929 7934
1.471824E9 0.3234750462107209 0.23431553767532892 9197
1.4719104E9 0.31194503171247356 0.23435517970401692 9460
1.4719968E9 0.31888479747501314 0.22156759600210416 9505
1.4720832E9 0.3257775434897206 0.23173431734317343 9485
1.4721696E9 0.3303210716563895 0.23910270040399745 9406
1.472256E9 0.34379959192926773 0.2545907957379279 8822
1.4723424E9 0.3275585130793942 0.2672097292335934 8716
1.4724288E9 0.3213733374574698 0.2329106093411692 9699
1.4725152E9 0.3147255969836615 0.23659405111018014 9548
1.4726016E9 0.3111808637298409 0.23671393007901287 9239
1.472688E9 0.32771009059668854 0.24179943767572634 9603
1.4727744E9 0.3176823176823177 0.24775224775224775 9009
1.4728608E9 0.3152003851245637 0.2634492718738717 8309
1.4729472E9 0.32578077158603796 0.25964482547458667 8165
1.4730336E9 0.30586726514908624 0.25788179972213315 9357
1.47312E9 0.3099931239972496 0.22347008938803575 8726
1.4732064E9 0.2861779518746502 0.24834918858421937 8935
1.4732928E9 0.30453316697858185 0.25888958203368684 9618
1.4733792E9 0.3059006211180124 0.24744897959183673 9016
1.4734656E9 0.3270388292222353 0.25634367992446594 8473
1.473552E9 0.33415695964231085 0.277209083421579 8499
1.4736384E9 0.3062910160669835 0.25956098664856303 8838
1.4737248E9 0.2859802847754655 0.2497261774370208 9130
1.4738112E9 0.28866336062737863 0.25049013954561183 8671
1.4738976E9 0.2960556315549476 0.2610579115367077 8772
1.473984E9 0.31146454605699136 0.2506074663132317 9054
1.4740704E9 0.3069943289224953 0.25015752993068685 7935
1.4741568E9 0.32632325141776936 0.2814272211720227 8464
1.4742432E9 0.3168777741691025 0.25289596189238933 9237
1.4743296E9 0.30728241563055064 0.23479129662522202 9008
1.474416E9 0.3079455164585698 0.24903518728717366 8810
1.4745024E9 0.3195397211772516 0.24795308696614296 9038
1.4745888E9 0.3141839234023603 0.2533956802493877 8982
1.4746752E9 0.309265337036102 0.2649583438525625 7922
1.4747616E9 0.32166328115664955 0.2692077906559924 8369
1.474848E9 0.3116293794850148 0.2539046010975095 9476
1.4749344E9 0.31427959751659174 0.2466281310211946 9342
1.4750208E9 0.31511614858040626 0.2272472225339468 8911
1.4751072E9 0.31423553945779825 0.235978487542531 9111
1.4751936E9 0.3005599104143337 0.21791713325867862 4465
Raw
results-20160930-152338.json
{"utc_day":"1.4638752E9","perc_imgur_submissions":"0.4740740740740741","perc_reddit_submissions":"0.07388888888888889","num_submissions":"5400"}
{"utc_day":"1.4639616E9","perc_imgur_submissions":"0.44542572463768115","perc_reddit_submissions":"0.06884057971014493","num_submissions":"8832"}
{"utc_day":"1.464048E9","perc_imgur_submissions":"0.4461742298774429","perc_reddit_submissions":"0.08645246770453793","num_submissions":"9057"}
{"utc_day":"1.4641344E9","perc_imgur_submissions":"0.41983787435262326","perc_reddit_submissions":"0.11337536590857915","num_submissions":"8882"}
{"utc_day":"1.4642208E9","perc_imgur_submissions":"0.39581920903954804","perc_reddit_submissions":"0.13062146892655369","num_submissions":"8850"}
{"utc_day":"1.4643072E9","perc_imgur_submissions":"0.4083769633507853","perc_reddit_submissions":"0.13328021852947872","num_submissions":"8786"}
{"utc_day":"1.4643936E9","perc_imgur_submissions":"0.4619642016015073","perc_reddit_submissions":"0.13942534149788036","num_submissions":"8492"}
{"utc_day":"1.46448E9","perc_imgur_submissions":"0.4499166346030525","perc_reddit_submissions":"0.14377324612030268","num_submissions":"7797"}
{"utc_day":"1.4645664E9","perc_imgur_submissions":"0.42043266508098315","perc_reddit_submissions":"0.1325178389398573","num_submissions":"8829"}
{"utc_day":"1.4646528E9","perc_imgur_submissions":"0.40487592511972137","perc_reddit_submissions":"0.12788419677840662","num_submissions":"9188"}
{"utc_day":"1.4647392E9","perc_imgur_submissions":"0.3892489941886455","perc_reddit_submissions":"0.12695574430040232","num_submissions":"8948"}
{"utc_day":"1.4648256E9","perc_imgur_submissions":"0.4048869360197192","perc_reddit_submissions":"0.12345943628764335","num_submissions":"9331"}
{"utc_day":"1.464912E9","perc_imgur_submissions":"0.4174322204794981","perc_reddit_submissions":"0.13186197624915977","num_submissions":"8926"}
{"utc_day":"1.4649984E9","perc_imgur_submissions":"0.42326139088729015","perc_reddit_submissions":"0.13621103117505995","num_submissions":"8340"}
{"utc_day":"1.4650848E9","perc_imgur_submissions":"0.43288161595499874","perc_reddit_submissions":"0.14753260035796473","num_submissions":"7822"}
{"utc_day":"1.4651712E9","perc_imgur_submissions":"0.4056872037914692","perc_reddit_submissions":"0.1389152185360716","num_submissions":"9495"}
{"utc_day":"1.4652576E9","perc_imgur_submissions":"0.4103863204559848","perc_reddit_submissions":"0.14112307367532193","num_submissions":"9474"}
{"utc_day":"1.465344E9","perc_imgur_submissions":"0.3918059299191375","perc_reddit_submissions":"0.12269541778975741","num_submissions":"9275"}
{"utc_day":"1.4654304E9","perc_imgur_submissions":"0.40365337491646247","perc_reddit_submissions":"0.12486077077300067","num_submissions":"8978"}
{"utc_day":"1.4655168E9","perc_imgur_submissions":"0.39324847814056446","perc_reddit_submissions":"0.1359158826784726","num_submissions":"9035"}
{"utc_day":"1.4656032E9","perc_imgur_submissions":"0.41482590789966306","perc_reddit_submissions":"0.1491326594284288","num_submissions":"8013"}
{"utc_day":"1.4656896E9","perc_imgur_submissions":"0.4163424124513619","perc_reddit_submissions":"0.13898346303501946","num_submissions":"8224"}
{"utc_day":"1.465776E9","perc_imgur_submissions":"0.38257498469700063","perc_reddit_submissions":"0.1348704346051826","num_submissions":"9802"}
{"utc_day":"1.4658624E9","perc_imgur_submissions":"0.3754081632653061","perc_reddit_submissions":"0.12428571428571429","num_submissions":"9800"}
{"utc_day":"1.4659488E9","perc_imgur_submissions":"0.37923393478949036","perc_reddit_submissions":"0.14097288171362246","num_submissions":"9477"}
{"utc_day":"1.4660352E9","perc_imgur_submissions":"0.3898010220724149","perc_reddit_submissions":"0.14015439817331737","num_submissions":"9197"}
{"utc_day":"1.4661216E9","perc_imgur_submissions":"0.38290206354405504","perc_reddit_submissions":"0.14433890162681515","num_submissions":"9159"}
{"utc_day":"1.466208E9","perc_imgur_submissions":"0.4229174519411986","perc_reddit_submissions":"0.14084684005528333","num_submissions":"7959"}
{"utc_day":"1.4662944E9","perc_imgur_submissions":"0.43241042345276876","perc_reddit_submissions":"0.16030711959050722","num_submissions":"8596"}
{"utc_day":"1.4663808E9","perc_imgur_submissions":"0.40968783638320777","perc_reddit_submissions":"0.1456404736275565","num_submissions":"9290"}
{"utc_day":"1.4664672E9","perc_imgur_submissions":"0.38380890618244706","perc_reddit_submissions":"0.15920881971465628","num_submissions":"9252"}
{"utc_day":"1.4665536E9","perc_imgur_submissions":"0.3555580710889744","perc_reddit_submissions":"0.17534525696173875","num_submissions":"8834"}
{"utc_day":"1.46664E9","perc_imgur_submissions":"0.37574180114523686","perc_reddit_submissions":"0.16543466944299845","num_submissions":"9605"}
{"utc_day":"1.4667264E9","perc_imgur_submissions":"0.3810796915167095","perc_reddit_submissions":"0.18560411311053984","num_submissions":"9725"}
{"utc_day":"1.4668128E9","perc_imgur_submissions":"0.4048872180451128","perc_reddit_submissions":"0.17518796992481203","num_submissions":"7980"}
{"utc_day":"1.4668992E9","perc_imgur_submissions":"0.4053848107696215","perc_reddit_submissions":"0.18961137922275845","num_submissions":"7874"}
{"utc_day":"1.4669856E9","perc_imgur_submissions":"0.3646918402777778","perc_reddit_submissions":"0.18858506944444445","num_submissions":"9216"}
{"utc_day":"1.467072E9","perc_imgur_submissions":"0.3555531663262015","perc_reddit_submissions":"0.18062573916783142","num_submissions":"9301"}
{"utc_day":"1.4671584E9","perc_imgur_submissions":"0.37209302325581395","perc_reddit_submissions":"0.17761057911536707","num_submissions":"8772"}
{"utc_day":"1.4672448E9","perc_imgur_submissions":"0.3643866591294517","perc_reddit_submissions":"0.17591859807801016","num_submissions":"8845"}
{"utc_day":"1.4673312E9","perc_imgur_submissions":"0.3628257093225246","perc_reddit_submissions":"0.19664157498552404","num_submissions":"8635"}
{"utc_day":"1.4674176E9","perc_imgur_submissions":"0.38535769428718475","perc_reddit_submissions":"0.205609881626351","num_submissions":"7772"}
{"utc_day":"1.467504E9","perc_imgur_submissions":"0.3971086220369888","perc_reddit_submissions":"0.21086220369887992","num_submissions":"7678"}
{"utc_day":"1.4675904E9","perc_imgur_submissions":"0.39365529270685706","perc_reddit_submissions":"0.19077728115120463","num_submissions":"9173"}
{"utc_day":"1.4676768E9","perc_imgur_submissions":"0.3472446391514872","perc_reddit_submissions":"0.19080009222965183","num_submissions":"8674"}
{"utc_day":"1.4677632E9","perc_imgur_submissions":"0.35217074945428084","perc_reddit_submissions":"0.19136551055056997","num_submissions":"8246"}
{"utc_day":"1.4678496E9","perc_imgur_submissions":"0.37210796915167094","perc_reddit_submissions":"0.2092973436161097","num_submissions":"9336"}
{"utc_day":"1.467936E9","perc_imgur_submissions":"0.3768516471368561","perc_reddit_submissions":"0.20274154322352422","num_submissions":"9046"}
{"utc_day":"1.4680224E9","perc_imgur_submissions":"0.38244274809160306","perc_reddit_submissions":"0.21348600508905852","num_submissions":"7860"}
{"utc_day":"1.4681088E9","perc_imgur_submissions":"0.39349040563517124","perc_reddit_submissions":"0.2152052465387418","num_submissions":"8234"}
{"utc_day":"1.4681952E9","perc_imgur_submissions":"0.37399831294812313","perc_reddit_submissions":"0.1968578658793758","num_submissions":"9484"}
{"utc_day":"1.4682816E9","perc_imgur_submissions":"0.34615384615384615","perc_reddit_submissions":"0.19544962080173348","num_submissions":"9230"}
{"utc_day":"1.468368E9","perc_imgur_submissions":"0.3557238502908572","perc_reddit_submissions":"0.20458786082757108","num_submissions":"9111"}
{"utc_day":"1.4684544E9","perc_imgur_submissions":"0.34333000111074086","perc_reddit_submissions":"0.2055981339553482","num_submissions":"9003"}
{"utc_day":"1.4685408E9","perc_imgur_submissions":"0.3532269257460097","perc_reddit_submissions":"0.20286837844089753","num_submissions":"8646"}
{"utc_day":"1.4686272E9","perc_imgur_submissions":"0.370782056371576","perc_reddit_submissions":"0.2096069868995633","num_submissions":"7557"}
{"utc_day":"1.4687136E9","perc_imgur_submissions":"0.3882570748479238","perc_reddit_submissions":"0.20880719386405713","num_submissions":"7562"}
{"utc_day":"1.4688E9","perc_imgur_submissions":"0.35242489028918644","perc_reddit_submissions":"0.19759198829751323","num_submissions":"8887"}
{"utc_day":"1.4688864E9","perc_imgur_submissions":"0.35497114957834","perc_reddit_submissions":"0.19562805148690635","num_submissions":"9012"}
{"utc_day":"1.4689728E9","perc_imgur_submissions":"0.337527415444996","perc_reddit_submissions":"0.19427450075031744","num_submissions":"8663"}
{"utc_day":"1.4690592E9","perc_imgur_submissions":"0.3384932920536636","perc_reddit_submissions":"0.1928677903910102","num_submissions":"8721"}
{"utc_day":"1.4691456E9","perc_imgur_submissions":"0.3254451464675474","perc_reddit_submissions":"0.21275129236071225","num_submissions":"8705"}
{"utc_day":"1.469232E9","perc_imgur_submissions":"0.34916526465639963","perc_reddit_submissions":"0.209525042060308","num_submissions":"7727"}
{"utc_day":"1.4693184E9","perc_imgur_submissions":"0.36006916733173716","perc_reddit_submissions":"0.22439478584729983","num_submissions":"7518"}
{"utc_day":"1.4694048E9","perc_imgur_submissions":"0.3337175792507205","perc_reddit_submissions":"0.2225936599423631","num_submissions":"8675"}
{"utc_day":"1.4694912E9","perc_imgur_submissions":"0.3377579475738985","perc_reddit_submissions":"0.2094813162297825","num_submissions":"8965"}
{"utc_day":"1.4695776E9","perc_imgur_submissions":"0.3502931091693397","perc_reddit_submissions":"0.19488994580245547","num_submissions":"9041"}
{"utc_day":"1.469664E9","perc_imgur_submissions":"0.3324411731905877","perc_reddit_submissions":"0.209992193598751","num_submissions":"8967"}
{"utc_day":"1.4697504E9","perc_imgur_submissions":"0.3310795582600856","perc_reddit_submissions":"0.2361956276763579","num_submissions":"8874"}
{"utc_day":"1.4698368E9","perc_imgur_submissions":"0.35198912774894986","perc_reddit_submissions":"0.23264146281195947","num_submissions":"8094"}
{"utc_day":"1.4699232E9","perc_imgur_submissions":"0.35875526080857034","perc_reddit_submissions":"0.23632189771712792","num_submissions":"7841"}
{"utc_day":"1.4700096E9","perc_imgur_submissions":"0.34912199630314233","perc_reddit_submissions":"0.23324861367837338","num_submissions":"8656"}
{"utc_day":"1.470096E9","perc_imgur_submissions":"0.3405716818081099","perc_reddit_submissions":"0.21992023044538","num_submissions":"9026"}
{"utc_day":"1.4701824E9","perc_imgur_submissions":"0.3341769366197183","perc_reddit_submissions":"0.2322843309859155","num_submissions":"9088"}
{"utc_day":"1.4702688E9","perc_imgur_submissions":"0.34297474691289354","perc_reddit_submissions":"0.21415062854600067","num_submissions":"8989"}
{"utc_day":"1.4703552E9","perc_imgur_submissions":"0.33771778008538134","perc_reddit_submissions":"0.20976116303219106","num_submissions":"8667"}
{"utc_day":"1.4704416E9","perc_imgur_submissions":"0.3651750224387742","perc_reddit_submissions":"0.22028465187844595","num_submissions":"7799"}
{"utc_day":"1.470528E9","perc_imgur_submissions":"0.3629135675814311","perc_reddit_submissions":"0.23070017953321365","num_submissions":"7798"}
{"utc_day":"1.4706144E9","perc_imgur_submissions":"0.34009928295642583","perc_reddit_submissions":"0.21378929950358522","num_submissions":"9065"}
{"utc_day":"1.4707008E9","perc_imgur_submissions":"0.3341229554427524","perc_reddit_submissions":"0.2038353073886069","num_submissions":"8865"}
{"utc_day":"1.4707872E9","perc_imgur_submissions":"0.32894736842105265","perc_reddit_submissions":"0.20356037151702785","num_submissions":"9044"}
{"utc_day":"1.4708736E9","perc_imgur_submissions":"0.3305055200464846","perc_reddit_submissions":"0.20662405578152238","num_submissions":"8605"}
{"utc_day":"1.47096E9","perc_imgur_submissions":"0.3369325925149387","perc_reddit_submissions":"0.2206730265226963","num_submissions":"9539"}
{"utc_day":"1.4710464E9","perc_imgur_submissions":"0.3443716497915426","perc_reddit_submissions":"0.22596783799880882","num_submissions":"8395"}
{"utc_day":"1.4711328E9","perc_imgur_submissions":"0.3409090909090909","perc_reddit_submissions":"0.25638820638820636","num_submissions":"8140"}
{"utc_day":"1.4712192E9","perc_imgur_submissions":"0.32877165875731157","perc_reddit_submissions":"0.2270168855534709","num_submissions":"9061"}
{"utc_day":"1.4713056E9","perc_imgur_submissions":"0.3213828425096031","perc_reddit_submissions":"0.21617584293640632","num_submissions":"9372"}
{"utc_day":"1.471392E9","perc_imgur_submissions":"0.317495050536626","perc_reddit_submissions":"0.2226737522142336","num_submissions":"9597"}
{"utc_day":"1.4714784E9","perc_imgur_submissions":"0.3263934070700499","perc_reddit_submissions":"0.2117761873780091","num_submissions":"9222"}
{"utc_day":"1.4715648E9","perc_imgur_submissions":"0.3204760855190655","perc_reddit_submissions":"0.23043861582543532","num_submissions":"9074"}
{"utc_day":"1.4716512E9","perc_imgur_submissions":"0.32247557003257327","perc_reddit_submissions":"0.24993735905788023","num_submissions":"7982"}
{"utc_day":"1.4717376E9","perc_imgur_submissions":"0.3358961431812453","perc_reddit_submissions":"0.2500630199142929","num_submissions":"7934"}
{"utc_day":"1.471824E9","perc_imgur_submissions":"0.3234750462107209","perc_reddit_submissions":"0.23431553767532892","num_submissions":"9197"}
{"utc_day":"1.4719104E9","perc_imgur_submissions":"0.31194503171247356","perc_reddit_submissions":"0.23435517970401692","num_submissions":"9460"}
{"utc_day":"1.4719968E9","perc_imgur_submissions":"0.31888479747501314","perc_reddit_submissions":"0.22156759600210416","num_submissions":"9505"}
{"utc_day":"1.4720832E9","perc_imgur_submissions":"0.3257775434897206","perc_reddit_submissions":"0.23173431734317343","num_submissions":"9485"}
{"utc_day":"1.4721696E9","perc_imgur_submissions":"0.3303210716563895","perc_reddit_submissions":"0.23910270040399745","num_submissions":"9406"}
{"utc_day":"1.472256E9","perc_imgur_submissions":"0.34379959192926773","perc_reddit_submissions":"0.2545907957379279","num_submissions":"8822"}
{"utc_day":"1.4723424E9","perc_imgur_submissions":"0.3275585130793942","perc_reddit_submissions":"0.2672097292335934","num_submissions":"8716"}
{"utc_day":"1.4724288E9","perc_imgur_submissions":"0.3213733374574698","perc_reddit_submissions":"0.2329106093411692","num_submissions":"9699"}
{"utc_day":"1.4725152E9","perc_imgur_submissions":"0.3147255969836615","perc_reddit_submissions":"0.23659405111018014","num_submissions":"9548"}
{"utc_day":"1.4726016E9","perc_imgur_submissions":"0.3111808637298409","perc_reddit_submissions":"0.23671393007901287","num_submissions":"9239"}
{"utc_day":"1.472688E9","perc_imgur_submissions":"0.32771009059668854","perc_reddit_submissions":"0.24179943767572634","num_submissions":"9603"}
{"utc_day":"1.4727744E9","perc_imgur_submissions":"0.3176823176823177","perc_reddit_submissions":"0.24775224775224775","num_submissions":"9009"}
{"utc_day":"1.4728608E9","perc_imgur_submissions":"0.3152003851245637","perc_reddit_submissions":"0.2634492718738717","num_submissions":"8309"}
{"utc_day":"1.4729472E9","perc_imgur_submissions":"0.32578077158603796","perc_reddit_submissions":"0.25964482547458667","num_submissions":"8165"}
{"utc_day":"1.4730336E9","perc_imgur_submissions":"0.30586726514908624","perc_reddit_submissions":"0.25788179972213315","num_submissions":"9357"}
{"utc_day":"1.47312E9","perc_imgur_submissions":"0.3099931239972496","perc_reddit_submissions":"0.22347008938803575","num_submissions":"8726"}
{"utc_day":"1.4732064E9","perc_imgur_submissions":"0.2861779518746502","perc_reddit_submissions":"0.24834918858421937","num_submissions":"8935"}
{"utc_day":"1.4732928E9","perc_imgur_submissions":"0.30453316697858185","perc_reddit_submissions":"0.25888958203368684","num_submissions":"9618"}
{"utc_day":"1.4733792E9","perc_imgur_submissions":"0.3059006211180124","perc_reddit_submissions":"0.24744897959183673","num_submissions":"9016"}
{"utc_day":"1.4734656E9","perc_imgur_submissions":"0.3270388292222353","perc_reddit_submissions":"0.25634367992446594","num_submissions":"8473"}
{"utc_day":"1.473552E9","perc_imgur_submissions":"0.33415695964231085","perc_reddit_submissions":"0.277209083421579","num_submissions":"8499"}
{"utc_day":"1.4736384E9","perc_imgur_submissions":"0.3062910160669835","perc_reddit_submissions":"0.25956098664856303","num_submissions":"8838"}
{"utc_day":"1.4737248E9","perc_imgur_submissions":"0.2859802847754655","perc_reddit_submissions":"0.2497261774370208","num_submissions":"9130"}
{"utc_day":"1.4738112E9","perc_imgur_submissions":"0.28866336062737863","perc_reddit_submissions":"0.25049013954561183","num_submissions":"8671"}
{"utc_day":"1.4738976E9","perc_imgur_submissions":"0.2960556315549476","perc_reddit_submissions":"0.2610579115367077","num_submissions":"8772"}
{"utc_day":"1.473984E9","perc_imgur_submissions":"0.31146454605699136","perc_reddit_submissions":"0.2506074663132317","num_submissions":"9054"}
{"utc_day":"1.4740704E9","perc_imgur_submissions":"0.3069943289224953","perc_reddit_submissions":"0.25015752993068685","num_submissions":"7935"}
{"utc_day":"1.4741568E9","perc_imgur_submissions":"0.32632325141776936","perc_reddit_submissions":"0.2814272211720227","num_submissions":"8464"}
{"utc_day":"1.4742432E9","perc_imgur_submissions":"0.3168777741691025","perc_reddit_submissions":"0.25289596189238933","num_submissions":"9237"}
{"utc_day":"1.4743296E9","perc_imgur_submissions":"0.30728241563055064","perc_reddit_submissions":"0.23479129662522202","num_submissions":"9008"}
{"utc_day":"1.474416E9","perc_imgur_submissions":"0.3079455164585698","perc_reddit_submissions":"0.24903518728717366","num_submissions":"8810"}
{"utc_day":"1.4745024E9","perc_imgur_submissions":"0.3195397211772516","perc_reddit_submissions":"0.24795308696614296","num_submissions":"9038"}
{"utc_day":"1.4745888E9","perc_imgur_submissions":"0.3141839234023603","perc_reddit_submissions":"0.2533956802493877","num_submissions":"8982"}
{"utc_day":"1.4746752E9","perc_imgur_submissions":"0.309265337036102","perc_reddit_submissions":"0.2649583438525625","num_submissions":"7922"}
{"utc_day":"1.4747616E9","perc_imgur_submissions":"0.32166328115664955","perc_reddit_submissions":"0.2692077906559924","num_submissions":"8369"}
{"utc_day":"1.474848E9","perc_imgur_submissions":"0.3116293794850148","perc_reddit_submissions":"0.2539046010975095","num_submissions":"9476"}
{"utc_day":"1.4749344E9","perc_imgur_submissions":"0.31427959751659174","perc_reddit_submissions":"0.2466281310211946","num_submissions":"9342"}
{"utc_day":"1.4750208E9","perc_imgur_submissions":"0.31511614858040626","perc_reddit_submissions":"0.2272472225339468","num_submissions":"8911"}
{"utc_day":"1.4751072E9","perc_imgur_submissions":"0.31423553945779825","perc_reddit_submissions":"0.235978487542531","num_submissions":"9111"}
{"utc_day":"1.4751936E9","perc_imgur_submissions":"0.3005599104143337","perc_reddit_submissions":"0.21791713325867862","num_submissions":"4465"}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment