# Is there any way to download daily historical data about website performance (1 year period) in CSV or Excel format for different websites? **URL:** \ **Category:** Uncategorized\ **Created:** [March 5, 2022, 11:02pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325 "2022-03-05T23:02:03Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 5, 2022, 11:02pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/1 "2022-03-05T23:02:03Z")
My name is Imran and I am currently in the last term of my master’s degree and writing my master’s thesis regarding website performance, SEO, and customer engagement. In terms of my thesis topic, I need the below daily historical data (1 year period, for example, the dates between 01.01.2021 - 01.01.2022) for the several websites that I am not the owner of. 1. Page size 2. Load time 3. Page speed 4. Time to First Byte (TTFB) 5. Speed index 6. Google desktop score 7. Google mobile score 8. First Contentful Paint 9. Largest Contentful Paint 10. Number of requests 11. Time to Interactive 12. Cumulative Layout Shift 13. Total Blocking time 14. Performance Score 15. First Input Delay Could you please kindly advise whether I could download daily historical data about website performance (1 year period) in CSV or Excel format in any way? Thank you. ---
**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\ **Post date:** [March 7, 2022, 5:16pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/2 "2022-03-07T17:16:54Z")
Hi, we have this data for millions of websites only on a _monthly_ basis, not daily. If that’s still of use to you, I can point you in the right direction. ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 7, 2022, 6:10pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/3 "2022-03-07T18:10:10Z")
Hi Rick, many thanks for your comment. Yes, that would also be great to reach out to this data on a monthly basis. I would be more than happy to have your point. ---
**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\ **Post date:** [March 7, 2022, 8:34pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/4 "2022-03-07T20:34:54Z")
Sure. What are the websites you’re interested in? ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 7, 2022, 10:04pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/5 "2022-03-07T22:04:12Z")
Do you mean what websites will I test for historical data? If yes, I would like to test 3 news websites and 3 university websites at first. ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 8, 2022, 10:57pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/6 "2022-03-08T22:57:14Z")
Hi again Rick, initial websites that I need to test are as follows: 1. [https://www.hurriyet.com.tr/](https://www.hurriyet.com.tr/) 2. [https://www.milliyet.com.tr/](https://www.milliyet.com.tr/) 3. sozcu.com.tr 4. [https://ku.edu.tr/](https://ku.edu.tr/) 5. [https://www.sabanciuniv.edu/](https://www.sabanciuniv.edu/) 6. [https://www.bilkent.edu.tr/](https://www.bilkent.edu.tr/) Your help is much appreciated. ---
**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\ **Post date:** [March 10, 2022, 5:50pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/7 "2022-03-10T17:50:52Z")
Hi @imranmehmet. Here’s a query that can get you most of the stats you’re looking for. Note that running this query consumes 22.2 TB, which is well beyond the 1 TB of free monthly quota, so proceed with caution. ```sql DECLARE URLs ARRAY DEFAULT [ 'https://www.hurriyet.com.tr/', 'https://www.milliyet.com.tr/', 'https://www.sozcu.com.tr/', 'https://www.ku.edu.tr/', 'https://www.sabanciuniv.edu/', 'https://www.bilkent.edu.tr/' ]; SELECT _TABLE_SUFFIX AS month_client, url, JSON_VALUE(payload, '$._bytesIn') AS page_size, JSON_VALUE(payload, '$._loadTime') AS load_time, NULL AS page_speed, JSON_VALUE(payload, '$._TTFB') AS ttfb, JSON_VALUE(payload, '$._SpeedIndex') AS speed_index, NULL AS google_score, JSON_VALUE(payload, '$."_chromeUserTiming.firstContentfulPaint"') AS fcp, JSON_VALUE(payload, '$."_chromeUserTiming.LargestContentfulPaint"') AS lcp, JSON_VALUE(payload, '$._requests') AS requests, JSON_VALUE(payload, '$._TTIMeasurementEnd') AS tti, JSON_VALUE(payload, '$._chromeUserTiming.CumulativeLayoutShift') AS cls, JSON_VALUE(payload, '$._TotalBlockingTime') AS tbt, NULL AS performance_score, NULL AS fid FROM `httparchive.pages.2021_*` WHERE url IN UNNEST(URLs) ORDER BY month_client ``` There were a few fields that I left `NULL` because I wasn’t sure what you were looking for: - Page speed: is this a different metric from `load_time`? - Google [desktop, mobile] score: do you mean the Lighthouse score? Also all metrics are provided for desktop and mobile when available. - Performance score: do you mean the Lighthouse score? - FID: this metric isn’t available in the lab since we don’t simulate any clicks. We would need to query the CrUX dataset instead, but I’m not sure if that’s what you want. Here are the results in CSV format: ```sql month_client,url,page_size,load_time,page_speed,ttfb,speed_index,google_score,fcp,lcp,requests,tti,cls,tbt,performance_score,fid 01_01_desktop,https://www.ku.edu.tr/,4726659,10240,,1554,5837,,3397,4581,94,13038,,886,, 01_01_desktop,https://www.sabanciuniv.edu/,4280120,10622,,1467,4867,,3376,5143,144,14395,,1501,, 01_01_desktop,https://www.hurriyet.com.tr/,5447172,41903,,438,13465,,1231,3097,667,48002,,21567,, 01_01_desktop,https://www.sozcu.com.tr/,3226816,9095,,340,6842,,1897,5247,153,11702,,1658,, 01_01_desktop,https://www.milliyet.com.tr/,3565356,15849,,435,4727,,1614,2447,232,20359,,4621,, 01_01_mobile,https://www.sozcu.com.tr/,2588009,25163,,1482,11147,,4485,5901,178,34378,,2091,, 01_01_mobile,https://www.hurriyet.com.tr/,3876501,38971,,2284,6276,,5375,7375,234,50998,,6816,, 01_01_mobile,https://www.sabanciuniv.edu/,5165902,34178,,2525,9690,,6541,11791,161,45509,,2025,, 01_01_mobile,https://www.milliyet.com.tr/,2408947,26542,,3284,13244,,5123,6039,204,105130,,3881,, 01_01_mobile,https://www.ku.edu.tr/,4704397,34175,,1613,7987,,3709,5225,93,34192,,449,, 02_01_desktop,https://www.milliyet.com.tr/,3325695,17836,,326,3374,,1431,2297,246,23471,,5103,, 02_01_desktop,https://www.sabanciuniv.edu/,4366838,9544,,839,3804,,2414,4114,141,12816,,1134,, 02_01_desktop,https://www.ku.edu.tr/,4621328,9705,,636,4326,,2215,3199,71,9711,,229,, 02_01_desktop,https://www.sozcu.com.tr/,2923680,7846,,294,4601,,1515,3115,154,10327,,849,, 02_01_desktop,https://www.hurriyet.com.tr/,4881087,19235,,329,3381,,581,2914,377,27414,,8468,, 02_01_mobile,https://www.hurriyet.com.tr/,3202764,38232,,2178,6041,,5145,7192,239,48934,,6654,, 02_01_mobile,https://www.milliyet.com.tr/,2663085,32120,,3444,8376,,5406,6473,250,112316,,6472,, 02_01_mobile,https://www.sabanciuniv.edu/,4908312,31616,,2023,9479,,5758,11208,158,42430,,2179,, 02_01_mobile,https://www.sozcu.com.tr/,2376077,23513,,1497,9963,,4862,6362,148,31257,,2162,, 02_01_mobile,https://www.ku.edu.tr/,4605433,28399,,1636,11444,,3829,11229,72,28428,,326,, 03_01_desktop,https://www.hurriyet.com.tr/,5013859,14675,,559,3363,,951,2057,302,21120,,4318,, 03_01_desktop,https://www.milliyet.com.tr/,3829119,17577,,510,4324,,1624,2853,271,22752,,4912,, 03_01_desktop,https://www.ku.edu.tr/,4606229,11403,,1734,4969,,3684,5765,73,12474,,124,, 03_01_desktop,https://www.sabanciuniv.edu/,4543326,9482,,818,3022,,2255,3042,143,12809,,443,, 03_01_desktop,https://www.sozcu.com.tr/,3027434,8630,,288,5196,,1720,3638,167,11272,,1650,, 03_01_mobile,https://www.ku.edu.tr/,3212056,21111,,1575,10267,,3933,5111,72,21121,,321,, 03_01_mobile,https://www.sabanciuniv.edu/,4982970,32664,,2011,7774,,5781,7900,159,43500,,2145,, 03_01_mobile,https://www.hurriyet.com.tr/,3097691,35938,,2320,7098,,5218,6999,201,46185,,3888,, 03_01_mobile,https://www.milliyet.com.tr/,2612379,29812,,3417,12244,,5238,6243,241,120680,,4487,, 03_01_mobile,https://www.sozcu.com.tr/,2717846,26926,,1425,14788,,4453,5848,164,35151,,2015,, 04_01_desktop,https://www.hurriyet.com.tr/,4567550,16726,,489,1707,,1022,2381,251,20118,,3404,, 04_01_desktop,https://www.sozcu.com.tr/,3273797,10492,,458,6564,,2292,3539,171,13068,,1557,, 04_01_desktop,https://www.milliyet.com.tr/,3965555,15986,,454,3609,,1452,2004,254,23454,,3628,, 04_01_desktop,https://www.sabanciuniv.edu/,4015790,8931,,877,3289,,2451,3355,143,12249,,368,, 04_01_desktop,https://www.ku.edu.tr/,3295167,6503,,429,3057,,1724,3473,73,10604,,263,, 04_01_mobile,https://www.sabanciuniv.edu/,4559424,30140,,2111,9234,,5743,10734,160,40864,,1085,, 04_01_mobile,https://www.hurriyet.com.tr/,4427964,40246,,1788,5781,,3398,6743,240,53318,,4739,, 04_01_mobile,https://www.milliyet.com.tr/,2604126,36121,,2175,8381,,4354,5256,655,120427,,4333,, 04_01_mobile,https://www.ku.edu.tr/,3343999,23718,,3042,11454,,5122,7547,72,23808,,378,, 04_01_mobile,https://www.sozcu.com.tr/,3030914,27324,,1451,12456,,4585,6396,157,34983,,1741,, 05_01_desktop,https://www.sozcu.com.tr/,3175599,9329,,368,5118,,1735,2902,175,11904,,1389,, 05_01_desktop,https://www.bilkent.edu.tr/,3171884,10410,,2079,6282,,4021,7380,97,12676,,1433,, 05_01_desktop,https://www.hurriyet.com.tr/,4796414,14803,,434,5027,,874,2060,263,19570,,2947,, 05_01_desktop,https://www.milliyet.com.tr/,3471680,10686,,504,3754,,1354,2460,225,24857,,2576,, 05_01_desktop,https://www.ku.edu.tr/,3386643,8751,,1834,5061,,3734,6717,73,13009,,145,, 05_01_desktop,https://www.sabanciuniv.edu/,5570769,11596,,818,3210,,2373,4047,150,14699,,307,, 05_01_mobile,https://www.sabanciuniv.edu/,6296849,41055,,2134,10928,,5804,14933,167,51515,,1503,, 05_01_mobile,https://www.hurriyet.com.tr/,3170188,33853,,2309,4766,,4106,6007,185,44720,,3217,, 05_01_mobile,https://www.milliyet.com.tr/,2276999,27115,,2297,9142,,4344,5261,206,120260,,2381,, 05_01_mobile,https://www.bilkent.edu.tr/,2839412,29011,,5565,17163,,9472,18115,92,36783,,4046,, 05_01_mobile,https://www.ku.edu.tr/,3326655,22309,,1591,10303,,4637,8154,72,22321,,382,, 05_01_mobile,https://www.sozcu.com.tr/,2688331,26212,,1580,10661,,4691,6064,160,34056,,2063,, 06_01_desktop,https://www.sabanciuniv.edu/,4741623,10031,,829,2974,,2463,3277,147,13000,,175,, 06_01_desktop,https://www.milliyet.com.tr/,4183851,10790,,328,3113,,1152,15312,245,19479,,2290,, 06_01_desktop,https://www.bilkent.edu.tr/,2919623,11202,,2434,7450,,5309,7651,102,13583,,1117,, 06_01_desktop,https://www.sozcu.com.tr/,3391478,8085,,349,5178,,1566,2553,176,15101,,1454,, 06_01_desktop,https://www.ku.edu.tr/,3292347,6888,,404,3716,,1919,4987,74,11389,,111,, 06_01_desktop,https://www.hurriyet.com.tr/,5063672,14303,,762,3695,,1163,2953,281,17822,,2944,, 06_01_mobile,https://www.ku.edu.tr/,3232357,21935,,1638,10906,,5301,6083,73,22006,,1569,, 06_01_mobile,https://www.hurriyet.com.tr/,3769099,40291,,2384,13869,,4442,6280,210,52872,,11046,, 06_01_mobile,https://www.bilkent.edu.tr/,2751945,30865,,5611,21147,,9920,18200,98,41351,,8398,, 06_01_mobile,https://www.milliyet.com.tr/,2472318,31045,,2458,17394,,4338,6979,179,113110,,10100,, 06_01_mobile,https://www.sabanciuniv.edu/,5288774,34952,,2055,8985,,6022,8756,164,46914,,4092,, 06_01_mobile,https://www.sozcu.com.tr/,2660149,26890,,1955,12533,,5739,8246,159,38406,,5496,, 07_01_desktop,https://www.bilkent.edu.tr/,3252247,11804,,2184,10925,,4317,9771,103,16238,,1536,, 07_01_desktop,https://www.milliyet.com.tr/,3001080,11161,,469,4086,,1180,1439,221,17657,,3044,, 07_01_desktop,https://www.sabanciuniv.edu/,3986765,8699,,857,2800,,2387,2729,147,13833,,456,, 07_01_desktop,https://www.hurriyet.com.tr/,3154225,10004,,413,3467,,826,1668,242,13598,,1861,, 07_01_desktop,https://www.sozcu.com.tr/,3255963,8467,,335,5962,,1719,2743,179,13749,,719,, 07_01_desktop,https://www.ku.edu.tr/,3384298,6262,,409,2655,,1335,4104,71,7532,,229,, 07_01_mobile,https://www.sabanciuniv.edu/,5488153,35642,,1900,8611,,5765,8518,165,47229,,3422,, 07_01_mobile,https://www.ku.edu.tr/,3324383,22367,,1657,10670,,4012,5676,70,22385,,1325,, 07_01_mobile,https://www.bilkent.edu.tr/,2752005,32890,,5848,25883,,10414,21143,98,44381,,10615,, 07_01_mobile,https://www.milliyet.com.tr/,1946397,26211,,2224,26233,,4097,6714,162,111904,,7355,, 07_01_mobile,https://www.hurriyet.com.tr/,2251550,35927,,2240,19249,,4663,6907,177,52854,,12220,, 07_01_mobile,https://www.sozcu.com.tr/,2583466,28077,,1365,12868,,5137,7164,164,39361,,5359,, 08_01_desktop,https://www.hurriyet.com.tr/,3160043,12393,,369,5838,,824,1770,255,16423,,3499,, 08_01_desktop,https://www.ku.edu.tr/,3280068,6724,,673,3309,,2273,3001,71,10675,,271,, 08_01_desktop,https://www.bilkent.edu.tr/,2946900,11876,,1934,10590,,4080,7144,103,16143,,1626,, 08_01_desktop,https://www.sozcu.com.tr/,3261991,7469,,345,4350,,1180,2537,122,14384,,1262,, 08_01_desktop,https://www.sabanciuniv.edu/,4062598,9299,,889,3089,,2593,3331,143,13683,,270,, 08_01_desktop,https://www.milliyet.com.tr/,3269435,11968,,347,4869,,1969,1969,237,19840,,3146,, 08_01_mobile,https://www.sabanciuniv.edu/,5668864,38756,,2118,12195,,6378,13950,160,51084,,4815,, 08_01_mobile,https://www.bilkent.edu.tr/,2778820,35698,,5708,29067,,9953,17730,99,44657,,7165,, 08_01_mobile,https://www.ku.edu.tr/,3276839,21798,,1629,11306,,4463,6966,72,23323,,1571,, 08_01_mobile,https://www.sozcu.com.tr/,3174955,28495,,1387,18654,,4135,27146,133,39549,,4284,, 08_01_mobile,https://www.hurriyet.com.tr/,2705264,35293,,2461,19577,,4628,6351,254,65369,,11223,, 08_01_mobile,https://www.milliyet.com.tr/,1936417,26394,,2170,18770,,4033,6550,161,110048,,6952,, 09_01_desktop,https://www.sabanciuniv.edu/,5811163,12354,,864,3025,,2219,4932,147,15416,,197,, 09_01_desktop,https://www.ku.edu.tr/,3213133,6668,,429,3365,,1937,5301,71,8191,,44,, 09_01_desktop,https://www.milliyet.com.tr/,3049906,13428,,379,4761,,2086,2086,205,18728,,3673,, 09_01_desktop,https://www.bilkent.edu.tr/,2772782,10840,,2374,7332,,3662,6819,102,15260,,1711,, 09_01_desktop,https://www.sozcu.com.tr/,3481789,7206,,360,4072,,1181,2579,155,13972,,1177,, 09_01_desktop,https://www.hurriyet.com.tr/,3380558,13311,,582,5292,,942,2145,679,23257,,5246,, 09_01_mobile,https://www.ku.edu.tr/,3209890,22755,,2685,10558,,5464,8225,72,22808,,1476,, 09_01_mobile,https://www.hurriyet.com.tr/,2637992,32977,,2259,17365,,4311,6066,175,51316,,9582,, 09_01_mobile,https://www.sabanciuniv.edu/,6224402,39237,,1911,9710,,5828,17635,164,51215,,3680,, 09_01_mobile,https://www.bilkent.edu.tr/,2779828,32782,,5995,29426,,8882,17814,97,42242,,621,, 09_01_mobile,https://www.sozcu.com.tr/,3440571,29408,,1360,17869,,3907,27022,149,40725,,3513,, 09_01_mobile,https://www.milliyet.com.tr/,1992544,29016,,2433,19225,,4391,6380,174,111944,,8772,, 10_01_desktop,https://www.bilkent.edu.tr/,2463583,11138,,3133,7040,,4921,7185,100,15400,,1626,, 10_01_desktop,https://www.sabanciuniv.edu/,3992263,8994,,922,2850,,2427,2989,146,13066,,513,, 10_01_desktop,https://www.ku.edu.tr/,3167474,7652,,1539,4072,,2800,6040,71,11891,,108,, 10_01_desktop,https://www.milliyet.com.tr/,4058338,11448,,597,5840,,2996,2996,261,16283,,2458,, 10_01_desktop,https://www.hurriyet.com.tr/,2696117,9020,,427,2697,,878,1585,184,12463,,2154,, 10_01_desktop,https://www.sozcu.com.tr/,3457059,7038,,290,3670,,1002,3328,128,13699,,773,, 10_01_mobile,https://www.sabanciuniv.edu/,4883880,31807,,1960,10027,,5635,12124,165,42682,,2925,, 10_01_mobile,https://www.milliyet.com.tr/,1937556,22894,,2470,22807,,4180,6863,149,110245,,4680,, 10_01_mobile,https://www.hurriyet.com.tr/,2534265,26894,,1802,12004,,3331,5284,179,37339,,5736,, 10_01_mobile,https://www.ku.edu.tr/,3164225,20795,,1551,9902,,4117,5126,72,20807,,804,, 10_01_mobile,https://www.bilkent.edu.tr/,2563150,29333,,6168,20748,,9005,15944,96,37140,,6283,, 10_01_mobile,https://www.sozcu.com.tr/,3387018,30272,,1481,20579,,3785,27229,128,40079,,2456,, 11_01_desktop,https://www.hurriyet.com.tr/,2572401,10384,,361,4605,,1036,1388,183,13976,,2831,, 11_01_desktop,https://www.sozcu.com.tr/,2664663,7530,,362,5415,,1143,2428,117,13898,,733,, 11_01_desktop,https://www.sabanciuniv.edu/,4344324,9346,,823,2973,,2335,3123,148,14783,,538,, 11_01_desktop,https://www.milliyet.com.tr/,2736318,12477,,612,8388,,2454,2454,205,18051,,2199,, 11_01_desktop,https://www.bilkent.edu.tr/,2545446,10710,,2819,6481,,4134,6809,99,14954,,1342,, 11_01_desktop,https://www.ku.edu.tr/,3203945,6208,,708,3077,,1674,2886,70,10187,,89,, 11_01_mobile,https://www.sabanciuniv.edu/,5002261,32552,,1981,8134,,5770,8176,165,43892,,2947,, 11_01_mobile,https://www.milliyet.com.tr/,4391992,39693,,3442,22253,,11010,11010,303,83445,,9461,, 11_01_mobile,https://www.ku.edu.tr/,3200701,21487,,2416,11147,,4878,6162,71,21490,,988,, 11_01_mobile,https://www.hurriyet.com.tr/,2082955,26255,,1802,8852,,4344,7227,144,45129,,6618,, 11_01_mobile,https://www.bilkent.edu.tr/,2646577,28436,,6108,21394,,8998,17400,96,37810,,6758,, 11_01_mobile,https://www.sozcu.com.tr/,2731358,24373,,1400,17342,,3828,23562,118,33671,,3374,, 12_01_desktop,https://www.bilkent.edu.tr/,2773340,10911,,3589,8837,,4845,7956,98,16615,,1420,, 12_01_desktop,https://www.milliyet.com.tr/,3071857,10030,,359,6870,,2168,2168,211,16040,,2753,, 12_01_desktop,https://www.hurriyet.com.tr/,2561861,8745,,298,2181,,868,1686,186,12083,,2433,, 12_01_desktop,https://www.sozcu.com.tr/,2831141,7295,,474,6053,,1779,3656,117,10822,,843,, 12_01_desktop,https://www.sabanciuniv.edu/,4537306,9887,,802,3003,,2426,2982,147,13299,,311,, 12_01_desktop,https://www.ku.edu.tr/,4428789,9151,,515,3923,,2054,5734,71,13154,,165,, 12_01_mobile,https://www.ku.edu.tr/,4425963,27061,,1627,10252,,3306,7084,72,34283,,8,, 12_01_mobile,https://www.sabanciuniv.edu/,5256603,34019,,1913,10728,,5192,11766,166,43845,,278,, 12_01_mobile,https://www.hurriyet.com.tr/,2297033,27027,,1895,15295,,4206,12163,162,37061,,481,, 12_01_mobile,https://www.sozcu.com.tr/,3074641,23859,,1461,18768,,3976,24406,121,32641,,199,, 12_01_mobile,https://www.bilkent.edu.tr/,2417905,24859,,6686,17818,,9119,17086,97,33415,,1347,, 12_01_mobile,https://www.milliyet.com.tr/,2555429,28869,,3427,29143,,6264,9914,179,113288,,5874,, ``` I haven’t gone through each row but it’s possible that some URLs are unavailable for specific month/client combinations due to them having insufficient popularity in the source corpus (CrUX). Hope this helps! ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 10, 2022, 6:44pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/8 "2022-03-10T18:44:25Z")
Hi Rick, Many thanks for the stats and data you provided, much appreciated. I will check all of them very shortly. While I am very new to HTTP Archive, unfortunately, I was not aware that the free monthly quota is 1 TB, I will proceed these stats with caution. - Page speed: This is a Google performance score, sorry for repeating. - Google [desktop, mobile] score: Yes exactly, I mean the Lighthouse score by [desktop, mobile] score. Many thanks for providing all metrics for both desktop and mobile. - Performance score: Yes, I mean the Lighthouse score by performance score. - FID: No problem at all, thanks a lot. I will shortly send you a few queries through message. Best wishes ---
**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\ **Post date:** [March 10, 2022, 7:06pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/9 "2022-03-10T19:06:02Z")
Thanks for clarifying. Here’s the updated query: ```sql DECLARE URLs ARRAY DEFAULT [ 'https://www.hurriyet.com.tr/', 'https://www.milliyet.com.tr/', 'https://www.sozcu.com.tr/', 'https://www.ku.edu.tr/', 'https://www.sabanciuniv.edu/', 'https://www.bilkent.edu.tr/' ]; SELECT _TABLE_SUFFIX AS month_client, url, JSON_VALUE(payload, '$._bytesIn') AS page_size, JSON_VALUE(payload, '$._loadTime') AS load_time, JSON_VALUE(payload, '$._TTFB') AS ttfb, JSON_VALUE(payload, '$._SpeedIndex') AS speed_index, JSON_VALUE(payload, '$."_chromeUserTiming.firstContentfulPaint"') AS fcp, JSON_VALUE(payload, '$."_chromeUserTiming.LargestContentfulPaint"') AS lcp, JSON_VALUE(payload, '$._requests') AS requests, JSON_VALUE(payload, '$._TTIMeasurementEnd') AS tti, JSON_VALUE(payload, '$._chromeUserTiming.CumulativeLayoutShift') AS cls, JSON_VALUE(payload, '$._TotalBlockingTime') AS tbt, JSON_VALUE(report, '$.categories.performance.score') AS performance_score FROM `httparchive.pages.2021_*` LEFT JOIN `httparchive.lighthouse.2021_*` USING (_TABLE_SUFFIX, url) WHERE url IN UNNEST(URLs) ORDER BY month_client ``` Note that to get the Lighthouse score we need to also query the `lighthouse` dataset, which brings the total query cost to 50 TB. Also, we only test mobile pages in Lighthouse, so the score will not be available for desktop pages. ```nohighlight month_client,url,page_size,load_time,ttfb,speed_index,fcp,lcp,requests,tti,cls,tbt,performance_score 01_01_desktop,https://www.ku.edu.tr/,4726659,10240,1554,5837,3397,4581,94,13038,,886, 01_01_desktop,https://www.sozcu.com.tr/,3226816,9095,340,6842,1897,5247,153,11702,,1658, 01_01_desktop,https://www.milliyet.com.tr/,3565356,15849,435,4727,1614,2447,232,20359,,4621, 01_01_desktop,https://www.sabanciuniv.edu/,4280120,10622,1467,4867,3376,5143,144,14395,,1501, 01_01_desktop,https://www.hurriyet.com.tr/,5447172,41903,438,13465,1231,3097,667,48002,,21567, 01_01_mobile,https://www.hurriyet.com.tr/,3876501,38971,2284,6276,5375,7375,234,50998,,6816,0.2 01_01_mobile,https://www.sozcu.com.tr/,2588009,25163,1482,11147,4485,5901,178,34378,,2091,0.28 01_01_mobile,https://www.sabanciuniv.edu/,5165902,34178,2525,9690,6541,11791,161,45509,,2025,0.07 01_01_mobile,https://www.ku.edu.tr/,4704397,34175,1613,7987,3709,5225,93,34192,,449,0.42 01_01_mobile,https://www.milliyet.com.tr/,2408947,26542,3284,13244,5123,6039,204,105130,,3881,0.23 02_01_desktop,https://www.milliyet.com.tr/,3325695,17836,326,3374,1431,2297,246,23471,,5103, 02_01_desktop,https://www.ku.edu.tr/,4621328,9705,636,4326,2215,3199,71,9711,,229, 02_01_desktop,https://www.hurriyet.com.tr/,4881087,19235,329,3381,581,2914,377,27414,,8468, 02_01_desktop,https://www.sozcu.com.tr/,2923680,7846,294,4601,1515,3115,154,10327,,849, 02_01_desktop,https://www.sabanciuniv.edu/,4366838,9544,839,3804,2414,4114,141,12816,,1134, 02_01_mobile,https://www.hurriyet.com.tr/,3202764,38232,2178,6041,5145,7192,239,48934,,6654, 02_01_mobile,https://www.sabanciuniv.edu/,4908312,31616,2023,9479,5758,11208,158,42430,,2179, 02_01_mobile,https://www.milliyet.com.tr/,2663085,32120,3444,8376,5406,6473,250,112316,,6472,0.16 02_01_mobile,https://www.sozcu.com.tr/,2376077,23513,1497,9963,4862,6362,148,31257,,2162,0.22 02_01_mobile,https://www.ku.edu.tr/,4605433,28399,1636,11444,3829,11229,72,28428,,326,0.42 03_01_desktop,https://www.hurriyet.com.tr/,5013859,14675,559,3363,951,2057,302,21120,,4318, 03_01_desktop,https://www.milliyet.com.tr/,3829119,17577,510,4324,1624,2853,271,22752,,4912, 03_01_desktop,https://www.sabanciuniv.edu/,4543326,9482,818,3022,2255,3042,143,12809,,443, 03_01_desktop,https://www.sozcu.com.tr/,3027434,8630,288,5196,1720,3638,167,11272,,1650, 03_01_desktop,https://www.ku.edu.tr/,4606229,11403,1734,4969,3684,5765,73,12474,,124, 03_01_mobile,https://www.sozcu.com.tr/,2717846,26926,1425,14788,4453,5848,164,35151,,2015,0.3 03_01_mobile,https://www.sabanciuniv.edu/,4982970,32664,2011,7774,5781,7900,159,43500,,2145,0.12 03_01_mobile,https://www.ku.edu.tr/,3212056,21111,1575,10267,3933,5111,72,21121,,321,0.34 03_01_mobile,https://www.milliyet.com.tr/,2612379,29812,3417,12244,5238,6243,241,120680,,4487, 03_01_mobile,https://www.hurriyet.com.tr/,3097691,35938,2320,7098,5218,6999,201,46185,,3888, 04_01_desktop,https://www.milliyet.com.tr/,3965555,15986,454,3609,1452,2004,254,23454,,3628, 04_01_desktop,https://www.sozcu.com.tr/,3273797,10492,458,6564,2292,3539,171,13068,,1557, 04_01_desktop,https://www.sabanciuniv.edu/,4015790,8931,877,3289,2451,3355,143,12249,,368, 04_01_desktop,https://www.hurriyet.com.tr/,4567550,16726,489,1707,1022,2381,251,20118,,3404, 04_01_desktop,https://www.ku.edu.tr/,3295167,6503,429,3057,1724,3473,73,10604,,263, 04_01_mobile,https://www.hurriyet.com.tr/,4427964,40246,1788,5781,3398,6743,240,53318,,4739,0.25 04_01_mobile,https://www.sabanciuniv.edu/,4559424,30140,2111,9234,5743,10734,160,40864,,1085,0.2 04_01_mobile,https://www.ku.edu.tr/,3343999,23718,3042,11454,5122,7547,72,23808,,378,0.35 04_01_mobile,https://www.milliyet.com.tr/,2604126,36121,2175,8381,4354,5256,655,120427,,4333,0.3 04_01_mobile,https://www.sozcu.com.tr/,3030914,27324,1451,12456,4585,6396,157,34983,,1741,0.35 05_01_desktop,https://www.hurriyet.com.tr/,4796414,14803,434,5027,874,2060,263,19570,,2947, 05_01_desktop,https://www.ku.edu.tr/,3386643,8751,1834,5061,3734,6717,73,13009,,145, 05_01_desktop,https://www.sozcu.com.tr/,3175599,9329,368,5118,1735,2902,175,11904,,1389, 05_01_desktop,https://www.sabanciuniv.edu/,5570769,11596,818,3210,2373,4047,150,14699,,307, 05_01_desktop,https://www.bilkent.edu.tr/,3171884,10410,2079,6282,4021,7380,97,12676,,1433, 05_01_desktop,https://www.milliyet.com.tr/,3471680,10686,504,3754,1354,2460,225,24857,,2576, 05_01_mobile,https://www.hurriyet.com.tr/,3170188,33853,2309,4766,4106,6007,185,44720,,3217,0.26 05_01_mobile,https://www.ku.edu.tr/,3326655,22309,1591,10303,4637,8154,72,22321,,382,0.47 05_01_mobile,https://www.milliyet.com.tr/,2276999,27115,2297,9142,4344,5261,206,120260,,2381,0.32 05_01_mobile,https://www.bilkent.edu.tr/,2839412,29011,5565,17163,9472,18115,92,36783,,4046,0.02 05_01_mobile,https://www.sabanciuniv.edu/,6296849,41055,2134,10928,5804,14933,167,51515,,1503,0.08 05_01_mobile,https://www.sozcu.com.tr/,2688331,26212,1580,10661,4691,6064,160,34056,,2063,0.38 06_01_desktop,https://www.milliyet.com.tr/,4183851,10790,328,3113,1152,15312,245,19479,,2290, 06_01_desktop,https://www.sozcu.com.tr/,3391478,8085,349,5178,1566,2553,176,15101,,1454, 06_01_desktop,https://www.hurriyet.com.tr/,5063672,14303,762,3695,1163,2953,281,17822,,2944, 06_01_desktop,https://www.bilkent.edu.tr/,2919623,11202,2434,7450,5309,7651,102,13583,,1117, 06_01_desktop,https://www.ku.edu.tr/,3292347,6888,404,3716,1919,4987,74,11389,,111, 06_01_desktop,https://www.sabanciuniv.edu/,4741623,10031,829,2974,2463,3277,147,13000,,175, 06_01_mobile,https://www.milliyet.com.tr/,2472318,31045,2458,17394,4338,6979,179,113110,,10100, 06_01_mobile,https://www.sabanciuniv.edu/,5288774,34952,2055,8985,6022,8756,164,46914,,4092,0.08 06_01_mobile,https://www.hurriyet.com.tr/,3769099,40291,2384,13869,4442,6280,210,52872,,11046, 06_01_mobile,https://www.sozcu.com.tr/,2660149,26890,1955,12533,5739,8246,159,38406,,5496,0.28 06_01_mobile,https://www.ku.edu.tr/,3232357,21935,1638,10906,5301,6083,73,22006,,1569,0.26 06_01_mobile,https://www.bilkent.edu.tr/,2751945,30865,5611,21147,9920,18200,98,41351,,8398,0.01 07_01_desktop,https://www.ku.edu.tr/,3384298,6262,409,2655,1335,4104,71,7532,,229, 07_01_desktop,https://www.milliyet.com.tr/,3001080,11161,469,4086,1180,1439,221,17657,,3044, 07_01_desktop,https://www.sabanciuniv.edu/,3986765,8699,857,2800,2387,2729,147,13833,,456, 07_01_desktop,https://www.sozcu.com.tr/,3255963,8467,335,5962,1719,2743,179,13749,,719, 07_01_desktop,https://www.bilkent.edu.tr/,3252247,11804,2184,10925,4317,9771,103,16238,,1536, 07_01_desktop,https://www.hurriyet.com.tr/,3154225,10004,413,3467,826,1668,242,13598,,1861, 07_01_mobile,https://www.hurriyet.com.tr/,2251550,35927,2240,19249,4663,6907,177,52854,,12220, 07_01_mobile,https://www.sozcu.com.tr/,2583466,28077,1365,12868,5137,7164,164,39361,,5359, 07_01_mobile,https://www.sabanciuniv.edu/,5488153,35642,1900,8611,5765,8518,165,47229,,3422,0.07 07_01_mobile,https://www.milliyet.com.tr/,1946397,26211,2224,26233,4097,6714,162,111904,,7355, 07_01_mobile,https://www.ku.edu.tr/,3324383,22367,1657,10670,4012,5676,70,22385,,1325,0.29 07_01_mobile,https://www.bilkent.edu.tr/,2752005,32890,5848,25883,10414,21143,98,44381,,10615,0.01 08_01_desktop,https://www.sabanciuniv.edu/,4062598,9299,889,3089,2593,3331,143,13683,,270, 08_01_desktop,https://www.milliyet.com.tr/,3269435,11968,347,4869,1969,1969,237,19840,,3146, 08_01_desktop,https://www.ku.edu.tr/,3280068,6724,673,3309,2273,3001,71,10675,,271, 08_01_desktop,https://www.sozcu.com.tr/,3261991,7469,345,4350,1180,2537,122,14384,,1262, 08_01_desktop,https://www.hurriyet.com.tr/,3160043,12393,369,5838,824,1770,255,16423,,3499, 08_01_desktop,https://www.bilkent.edu.tr/,2946900,11876,1934,10590,4080,7144,103,16143,,1626, 08_01_mobile,https://www.sabanciuniv.edu/,5668864,38756,2118,12195,6378,13950,160,51084,,4815,0.05 08_01_mobile,https://www.bilkent.edu.tr/,2778820,35698,5708,29067,9953,17730,99,44657,,7165,0.01 08_01_mobile,https://www.sozcu.com.tr/,3174955,28495,1387,18654,4135,27146,133,39549,,4284,0.28 08_01_mobile,https://www.ku.edu.tr/,3276839,21798,1629,11306,4463,6966,72,23323,,1571,0.3 08_01_mobile,https://www.milliyet.com.tr/,1936417,26394,2170,18770,4033,6550,161,110048,,6952, 08_01_mobile,https://www.hurriyet.com.tr/,2705264,35293,2461,19577,4628,6351,254,65369,,11223, 09_01_desktop,https://www.bilkent.edu.tr/,2772782,10840,2374,7332,3662,6819,102,15260,,1711, 09_01_desktop,https://www.sabanciuniv.edu/,5811163,12354,864,3025,2219,4932,147,15416,,197, 09_01_desktop,https://www.ku.edu.tr/,3213133,6668,429,3365,1937,5301,71,8191,,44, 09_01_desktop,https://www.milliyet.com.tr/,3049906,13428,379,4761,2086,2086,205,18728,,3673, 09_01_desktop,https://www.sozcu.com.tr/,3481789,7206,360,4072,1181,2579,155,13972,,1177, 09_01_desktop,https://www.hurriyet.com.tr/,3380558,13311,582,5292,942,2145,679,23257,,5246, 09_01_mobile,https://www.sozcu.com.tr/,3440571,29408,1360,17869,3907,27022,149,40725,,3513,0.24 09_01_mobile,https://www.ku.edu.tr/,3209890,22755,2685,10558,5464,8225,72,22808,,1476,0.32 09_01_mobile,https://www.bilkent.edu.tr/,2779828,32782,5995,29426,8882,17814,97,42242,,621,0.01 09_01_mobile,https://www.sabanciuniv.edu/,6224402,39237,1911,9710,5828,17635,164,51215,,3680, 09_01_mobile,https://www.milliyet.com.tr/,1992544,29016,2433,19225,4391,6380,174,111944,,8772,0.28 09_01_mobile,https://www.hurriyet.com.tr/,2637992,32977,2259,17365,4311,6066,175,51316,,9582, 10_01_desktop,https://www.sabanciuniv.edu/,3992263,8994,922,2850,2427,2989,146,13066,,513, 10_01_desktop,https://www.ku.edu.tr/,3167474,7652,1539,4072,2800,6040,71,11891,,108, 10_01_desktop,https://www.sozcu.com.tr/,3457059,7038,290,3670,1002,3328,128,13699,,773, 10_01_desktop,https://www.bilkent.edu.tr/,2463583,11138,3133,7040,4921,7185,100,15400,,1626, 10_01_desktop,https://www.milliyet.com.tr/,4058338,11448,597,5840,2996,2996,261,16283,,2458, 10_01_desktop,https://www.hurriyet.com.tr/,2696117,9020,427,2697,878,1585,184,12463,,2154, 10_01_mobile,https://www.hurriyet.com.tr/,2534265,26894,1802,12004,3331,5284,179,37339,,5736,0.31 10_01_mobile,https://www.bilkent.edu.tr/,2563150,29333,6168,20748,9005,15944,96,37140,,6283,0.01 10_01_mobile,https://www.sozcu.com.tr/,3387018,30272,1481,20579,3785,27229,128,40079,,2456,0.24 10_01_mobile,https://www.ku.edu.tr/,3164225,20795,1551,9902,4117,5126,72,20807,,804,0.39 10_01_mobile,https://www.milliyet.com.tr/,1937556,22894,2470,22807,4180,6863,149,110245,,4680, 10_01_mobile,https://www.sabanciuniv.edu/,4883880,31807,1960,10027,5635,12124,165,42682,,2925, 11_01_desktop,https://www.hurriyet.com.tr/,2572401,10384,361,4605,1036,1388,183,13976,,2831, 11_01_desktop,https://www.sozcu.com.tr/,2664663,7530,362,5415,1143,2428,117,13898,,733, 11_01_desktop,https://www.sabanciuniv.edu/,4344324,9346,823,2973,2335,3123,148,14783,,538, 11_01_desktop,https://www.milliyet.com.tr/,2736318,12477,612,8388,2454,2454,205,18051,,2199, 11_01_desktop,https://www.bilkent.edu.tr/,2545446,10710,2819,6481,4134,6809,99,14954,,1342, 11_01_desktop,https://www.ku.edu.tr/,3203945,6208,708,3077,1674,2886,70,10187,,89, 11_01_mobile,https://www.sabanciuniv.edu/,5002261,32552,1981,8134,5770,8176,165,43892,,2947,0.07 11_01_mobile,https://www.milliyet.com.tr/,4391992,39693,3442,22253,11010,11010,303,83445,,9461,0.15 11_01_mobile,https://www.ku.edu.tr/,3200701,21487,2416,11147,4878,6162,71,21490,,988,0.34 11_01_mobile,https://www.hurriyet.com.tr/,2082955,26255,1802,8852,4344,7227,144,45129,,6618,0.15 11_01_mobile,https://www.sozcu.com.tr/,2731358,24373,1400,17342,3828,23562,118,33671,,3374,0.14 11_01_mobile,https://www.bilkent.edu.tr/,2646577,28436,6108,21394,8998,17400,96,37810,,6758,0.01 12_01_desktop,https://www.bilkent.edu.tr/,2773340,10911,3589,8837,4845,7956,98,16615,,1420, 12_01_desktop,https://www.sozcu.com.tr/,2831141,7295,474,6053,1779,3656,117,10822,,843, 12_01_desktop,https://www.milliyet.com.tr/,3071857,10030,359,6870,2168,2168,211,16040,,2753, 12_01_desktop,https://www.sabanciuniv.edu/,4537306,9887,802,3003,2426,2982,147,13299,,311, 12_01_desktop,https://www.hurriyet.com.tr/,2561861,8745,298,2181,868,1686,186,12083,,2433, 12_01_desktop,https://www.ku.edu.tr/,4428789,9151,515,3923,2054,5734,71,13154,,165, 12_01_mobile,https://www.ku.edu.tr/,4425963,27061,1627,10252,3306,7084,72,34283,,8,0.33 12_01_mobile,https://www.hurriyet.com.tr/,2297033,27027,1895,15295,4206,12163,162,37061,,481,0.15 12_01_mobile,https://www.sabanciuniv.edu/,5256603,34019,1913,10728,5192,11766,166,43845,,278,0.07 12_01_mobile,https://www.bilkent.edu.tr/,2417905,24859,6686,17818,9119,17086,97,33415,,1347,0.01 12_01_mobile,https://www.milliyet.com.tr/,2555429,28869,3427,29143,6264,9914,179,113288,,5874,0.15 12_01_mobile,https://www.sozcu.com.tr/,3074641,23859,1461,18768,3976,24406,121,32641,,199,0.14 ``` ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 10, 2022, 7:53pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/10 "2022-03-10T19:53:15Z")
Hi Rick, thank you very much for all these stats, much appreciated. Have a great day! ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 24, 2022, 8:53pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/13 "2022-03-24T20:53:29Z")
Hi Rick, could you please rerun the query for the below websites as well? 1. sabah.com.tr 2. [mynet.com](http://mynet.com) 3. [haberturk.com](http://haberturk.com) 4. cumhuriyet.com.tr 5. metu.edu.tr 6. boun.edu.tr 7. itu.edu.tr 8. ankara.edu.tr 9. hacettepe.edu.tr Your help is much appreciated! ---
**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\ **Post date:** [March 25, 2022, 12:59am UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/14 "2022-03-25T00:59:47Z")
Sure, here’s the CSV for the new URLs ```nohighlight month_client,url,page_size,load_time,ttfb,speed_index,fcp,lcp,requests,tti,cls,tbt,performance_score 01_01_desktop,https://www.itu.edu.tr/,10345913,20448,1018,9374,3081,17014,155,23841,,1214, 01_01_desktop,https://www.mynet.com/,1352315,6756,401,2619,1115,2165,122,12033,,2137, 01_01_desktop,http://boun.edu.tr/,489799,2786,712,2064,1631,2515,27,2809,,21, 01_01_desktop,https://www.cumhuriyet.com.tr/,4527197,20717,1509,8445,1982,6165,406,25049,,8217, 01_01_desktop,https://hacettepe.edu.tr/,3669666,10659,1575,4267,2998,5148,70,13317,,122, 01_01_desktop,https://www.metu.edu.tr/,5156919,13457,1213,7449,3481,4198,97,14154,,569, 01_01_desktop,https://www.haberturk.com/,3995198,10183,1077,5825,1881,3847,222,20371,,4544, 01_01_desktop,https://www.ankara.edu.tr/,8122380,20452,2485,12828,7747,19229,174,25098,,4795, 01_01_desktop,https://www.sabah.com.tr/,3016640,14324,252,5449,2298,3748,227,20731,,7279, 01_01_mobile,https://www.metu.edu.tr/,5138508,35879,2675,11460,7062,8779,99,38843,,759,0.09 01_01_mobile,https://www.ankara.edu.tr/,6938132,49997,3575,18181,16828,42661,180,60440,,6169,0 01_01_mobile,https://www.mynet.com/,1883169,14547,1839,9899,4212,8029,107,119202,,1963,0.18 01_01_mobile,https://www.itu.edu.tr/,8501710,50301,2135,12242,6263,14779,139,58255,,1102,0.05 01_01_mobile,https://hacettepe.edu.tr/,3574659,25958,2910,7854,5926,10093,65,33169,,143,0.45 01_01_mobile,https://www.haberturk.com/,1193718,13000,2465,12811,3209,16109,112,32109,,1798,0.17 01_01_mobile,https://www.cumhuriyet.com.tr/,4421565,47726,1489,6828,3196,6213,322,57184,,8118,0.16 01_01_mobile,http://boun.edu.tr/,1060981,8260,1546,7718,3714,5080,40,100650,,27,0.67 01_01_mobile,https://www.sabah.com.tr/,5188024,47084,2818,13926,6245,7662,243,62659,,13047, 02_01_desktop,https://www.metu.edu.tr/,5493597,13095,1248,7419,3597,4597,99,14546,,523, 02_01_desktop,https://www.mynet.com/,1155496,6117,456,3281,1247,1797,123,10958,,2085, 02_01_desktop,https://www.sabah.com.tr/,2061257,8161,459,3366,2014,3214,171,17012,,1682, 02_01_desktop,https://hacettepe.edu.tr/,4087688,12383,2356,6796,3763,5030,70,15115,,137, 02_01_desktop,https://www.cumhuriyet.com.tr/,4040110,17238,474,7967,1331,5397,262,21852,,6962, 02_01_desktop,http://boun.edu.tr/,441091,2425,582,1843,1497,2114,27,2426,,54, 02_01_desktop,https://www.ankara.edu.tr/,8390627,19466,2408,11475,7329,18028,174,23765,,1327, 02_01_desktop,https://www.haberturk.com/,3355798,4577,418,2823,898,2081,200,13303,,2954, 02_01_desktop,https://www.itu.edu.tr/,12444390,24382,1038,7802,3418,10468,160,27240,,1585, 02_01_mobile,http://boun.edu.tr/,1003891,8196,1609,7208,4066,5466,40,100996,,93,0.66 02_01_mobile,https://www.cumhuriyet.com.tr/,4414756,43890,1630,7271,3380,7980,376,52951,,5246,0.15 02_01_mobile,https://www.haberturk.com/,1221520,13873,2445,12133,3313,15846,115,33521,,1697,0.2 02_01_mobile,https://hacettepe.edu.tr/,4501991,58812,2776,8385,5498,8398,67,65824,,0,0.4 02_01_mobile,https://www.metu.edu.tr/,5347377,35453,2442,9806,6378,12295,95,38516,,1372,0.12 02_01_mobile,https://www.mynet.com/,1117991,15274,1982,5996,4442,7042,125,28118,,3248, 02_01_mobile,https://www.sabah.com.tr/,4470899,28172,2810,11431,5979,6782,195,43021,,2680, 02_01_mobile,https://www.ankara.edu.tr/,8413811,56704,3721,17154,15861,49559,173,70440,,6182,0 02_01_mobile,https://www.itu.edu.tr/,10641305,64722,2263,12793,6761,15094,146,72721,,942,0.06 03_01_desktop,https://www.itu.edu.tr/,8355450,27782,803,6438,2295,9455,162,30379,,430, 03_01_desktop,http://boun.edu.tr/,474292,2870,729,2019,1899,2273,27,2886,,0, 03_01_desktop,https://www.cumhuriyet.com.tr/,3627913,10217,575,4650,1226,4336,159,13984,,3519, 03_01_desktop,https://www.sabah.com.tr/,1985425,6410,407,2466,2031,2702,170,13392,,1124, 03_01_desktop,https://www.haberturk.com/,3535023,5052,625,2540,1112,2269,195,12293,,1053, 03_01_desktop,https://hacettepe.edu.tr/,4953419,12578,2318,6818,3671,6729,78,14952,,106, 03_01_desktop,https://www.metu.edu.tr/,6480304,14844,1170,6739,3387,7246,99,17432,,307, 03_01_desktop,https://www.mynet.com/,1217380,3721,315,1768,755,1702,124,8011,,1131, 03_01_desktop,https://www.ankara.edu.tr/,6845194,17850,2951,11320,7603,16669,175,21734,,2348, 03_01_mobile,https://www.itu.edu.tr/,8427197,49823,1989,12346,6170,15020,142,57404,,1099,0.02 03_01_mobile,https://www.mynet.com/,8936683,46907,1690,4622,3638,38215,229,120302,,1526,0.17 03_01_mobile,https://www.metu.edu.tr/,5869157,38930,2390,9892,6155,9590,95,47005,,951,0.12 03_01_mobile,https://www.ankara.edu.tr/,6814247,46644,4268,18095,16858,41744,168,54621,,3430,0 03_01_mobile,http://boun.edu.tr/,1254278,8764,1604,6252,3950,4779,42,106809,,51,0.79 03_01_mobile,https://www.sabah.com.tr/,2755531,30759,3046,10250,6561,7233,161,42634,,756,0.24 03_01_mobile,https://www.cumhuriyet.com.tr/,5322252,35045,1515,6471,3087,7257,173,44377,,4475,0.17 03_01_mobile,https://www.haberturk.com/,1254267,13695,2565,11955,3404,15597,118,33230,,1679,0.2 03_01_mobile,https://hacettepe.edu.tr/,1455882,45406,2586,11355,5257,8170,72,52745,,0,0.41 04_01_desktop,https://www.metu.edu.tr/,7075883,15507,1158,9289,3168,11225,99,17602,,145, 04_01_desktop,https://www.ankara.edu.tr/,7235740,17498,1851,11154,6438,15598,175,20000,,541, 04_01_desktop,https://www.haberturk.com/,4484218,6426,546,2753,1035,1843,197,14063,,1341, 04_01_desktop,http://boun.edu.tr/,502718,2910,785,2063,1712,2838,27,2921,,26, 04_01_desktop,https://www.itu.edu.tr/,6325165,12870,976,7436,2818,8640,170,15798,,752, 04_01_desktop,https://www.cumhuriyet.com.tr/,8702813,18898,612,5200,923,5553,249,22919,,3614, 04_01_desktop,https://hacettepe.edu.tr/,1777115,6492,1147,2927,2356,3690,77,8531,,29, 04_01_desktop,https://www.sabah.com.tr/,1915892,6766,474,3204,1702,3189,164,12638,,988, 04_01_desktop,https://www.mynet.com/,1185774,4513,314,1048,724,1683,135,8519,,1034, 04_01_mobile,https://www.metu.edu.tr/,7851886,49831,2393,8432,6448,17792,96,55765,,1173,0.09 04_01_mobile,https://www.ankara.edu.tr/,8084360,54769,2864,17745,15821,48249,171,61518,,1988,0 04_01_mobile,https://www.cumhuriyet.com.tr/,9014416,55663,1593,5943,3178,8476,195,65704,,4446,0.18 04_01_mobile,https://www.sabah.com.tr/,2250851,23694,3011,9815,6720,8656,158,35608,,2163,0.22 04_01_mobile,https://www.itu.edu.tr/,6374092,38139,2130,14970,6205,16781,142,45674,,1218,0.04 04_01_mobile,https://www.mynet.com/,6122288,26028,1976,12062,4072,19473,232,120431,,1397,0.18 04_01_mobile,http://boun.edu.tr/,1175099,8020,1472,6680,3702,5112,41,106502,,13,0.84 04_01_mobile,https://hacettepe.edu.tr/,1801093,17766,2750,9753,5663,8463,72,23995,,71,0.46 04_01_mobile,https://www.haberturk.com/,990511,11017,2445,4620,3064,3957,103,30090,,1036,0.61 05_01_desktop,https://www.itu.edu.tr/,6140861,12558,927,6300,2693,7972,168,15234,,368, 05_01_desktop,https://www.sabah.com.tr/,1980468,7027,512,2420,1852,2789,166,11922,,854, 05_01_desktop,https://www.ankara.edu.tr/,7708033,17900,1693,11090,6414,16668,172,20270,,710, 05_01_desktop,http://boun.edu.tr/,494400,2300,593,1742,1346,2252,27,2317,,6, 05_01_desktop,https://www.haberturk.com/,4255178,6152,531,3797,1180,1776,225,15532,,2171, 05_01_desktop,https://www.metu.edu.tr/,5739309,13881,1209,7979,3438,11853,100,14951,,114, 05_01_desktop,https://hacettepe.edu.tr/,3555894,10988,1210,9089,2573,5550,51,13710,,105, 05_01_desktop,https://www.mynet.com/,1157409,4095,340,1342,1185,1763,127,8298,,995, 05_01_desktop,https://www.cumhuriyet.com.tr/,10453694,18845,475,5754,759,9160,306,28947,,3640, 05_01_mobile,https://www.haberturk.com/,1016257,11004,2289,4406,2860,3962,109,30566,,809,0.61 05_01_mobile,https://www.ankara.edu.tr/,7730084,53335,2787,17812,16098,48339,171,60194,,2654,0 05_01_mobile,https://www.itu.edu.tr/,6193024,37196,1998,8053,6020,9831,141,44706,,822,0.15 05_01_mobile,http://boun.edu.tr/,1294021,8957,2425,8214,4664,6072,41,107633,,14,0.65 05_01_mobile,https://www.mynet.com/,6116895,34837,1528,15638,3909,20401,264,120325,,1635,0.19 05_01_mobile,https://www.metu.edu.tr/,5159178,35427,2413,10417,6356,12606,96,38095,,662,0.15 05_01_mobile,https://www.sabah.com.tr/,2437498,23476,3072,9451,6288,7111,159,35313,,559, 05_01_mobile,https://www.cumhuriyet.com.tr/,9471709,60283,1491,6005,3119,8371,495,120188,,6857, 05_01_mobile,https://hacettepe.edu.tr/,6614169,33302,2848,19265,5897,10908,51,43342,,0,0.28 06_01_desktop,https://www.ankara.edu.tr/,8326520,18440,1364,9274,6009,16982,176,20877,,1273, 06_01_desktop,https://www.mynet.com/,1505700,4983,581,1592,1319,3255,120,9703,,1196, 06_01_desktop,https://www.itu.edu.tr/,5803970,11658,812,5552,2380,7204,170,14295,,439, 06_01_desktop,https://www.metu.edu.tr/,5027591,11160,1069,8277,2925,11057,100,13113,,103, 06_01_desktop,http://boun.edu.tr/,457725,3618,1610,2817,2511,3412,27,3624,,33, 06_01_desktop,https://hacettepe.edu.tr/,4171698,9806,1639,4601,3135,5315,49,12985,,44, 06_01_desktop,https://www.cumhuriyet.com.tr/,8058882,13682,444,1931,1118,4256,382,27128,,3463, 06_01_desktop,https://www.haberturk.com/,5147443,7605,532,2789,1088,2046,237,17092,,1922, 06_01_desktop,https://www.sabah.com.tr/,2075938,6999,445,2387,1652,2905,165,12821,,1503, 06_01_mobile,https://www.haberturk.com/,1746362,16860,2317,5441,3434,4441,127,38110,,4495,0.45 06_01_mobile,https://www.ankara.edu.tr/,11099708,58612,2540,46349,14882,50299,220,78419,,6673, 06_01_mobile,https://hacettepe.edu.tr/,2903411,22624,4022,21693,7253,14484,49,30758,,1026,0.22 06_01_mobile,http://boun.edu.tr/,1095959,8089,1405,18697,3861,4949,41,106810,,82,0.76 06_01_mobile,https://www.cumhuriyet.com.tr/,8646102,52825,1578,7298,3419,5979,380,116824,,20413, 06_01_mobile,https://www.metu.edu.tr/,4968946,33769,2349,14879,6403,14942,96,38556,,1749,0.09 06_01_mobile,https://www.mynet.com/,12291050,50765,1744,33519,3863,45385,231,120372,,3186,0.18 06_01_mobile,https://www.sabah.com.tr/,2495899,24821,2945,10780,6544,8028,161,37106,,3577, 06_01_mobile,https://www.itu.edu.tr/,5970935,35657,2069,10061,6245,14699,143,43789,,2468,0.03 07_01_desktop,https://www.itu.edu.tr/,34813447,78454,1014,7430,2732,8496,130,88659,,221, 07_01_desktop,https://www.ankara.edu.tr/,7837935,17358,1279,10778,5599,15839,176,19692,,2605, 07_01_desktop,https://www.mynet.com/,2687173,17823,587,3085,1405,2852,440,22006,,4965, 07_01_desktop,https://www.metu.edu.tr/,4669484,11326,989,8132,2749,10889,100,12921,,101, 07_01_desktop,http://boun.edu.tr/,460619,2909,736,2136,1952,2436,27,2917,,0, 07_01_desktop,https://www.haberturk.com/,5019386,6056,329,2677,817,4073,235,15305,,1927, 07_01_desktop,https://www.sabah.com.tr/,2001365,6482,444,2182,1629,2773,162,11574,,1093, 07_01_desktop,https://www.cumhuriyet.com.tr/,16603750,29870,552,7476,1026,16605,1046,82856,,9051, 07_01_desktop,https://hacettepe.edu.tr/,3860468,8278,1437,6492,2653,4847,52,11479,,74, 07_01_mobile,https://hacettepe.edu.tr/,5080303,26457,3360,14710,6263,9131,50,35597,,995, 07_01_mobile,https://www.cumhuriyet.com.tr/,11348706,70154,1560,24155,3588,6964,413,120710,,22927, 07_01_mobile,https://www.haberturk.com/,1592000,13155,1985,5461,3330,4714,112,34404,,3359, 07_01_mobile,https://www.sabah.com.tr/,2390634,24420,3239,9485,6524,7388,156,36794,,3882, 07_01_mobile,https://www.metu.edu.tr/,4945990,33561,2745,11880,7195,12678,96,39548,,2542,0.09 07_01_mobile,http://boun.edu.tr/,834501,8777,1530,11900,4223,5674,34,65007,,212,0.65 07_01_mobile,https://www.ankara.edu.tr/,7825714,56104,2427,31477,15135,47460,173,63305,,8359,0.01 07_01_mobile,https://www.mynet.com/,6502945,25055,1975,23087,4041,23071,239,120590,,5844, 08_01_desktop,https://www.mynet.com/,2479576,13762,595,4164,1352,2505,288,18717,,3678, 08_01_desktop,https://www.cumhuriyet.com.tr/,13073941,26372,498,4447,1072,16305,973,60095,,10576, 08_01_desktop,https://www.haberturk.com/,4644898,5374,370,2180,870,1632,213,15067,,1480, 08_01_desktop,https://www.sabah.com.tr/,1919729,6704,469,2368,1973,2886,162,11837,,1047, 08_01_desktop,http://boun.edu.tr/,498477,2491,609,1888,1526,2366,27,2497,,0, 08_01_desktop,https://www.itu.edu.tr/,40850911,83492,979,9578,2453,12077,144,92710,,549, 08_01_desktop,https://hacettepe.edu.tr/,6757233,10927,1142,6476,2345,3950,52,14003,,122, 08_01_desktop,https://www.metu.edu.tr/,4633680,11302,983,7809,2671,3932,120,13912,,210, 08_01_desktop,https://www.ankara.edu.tr/,8029206,16981,1316,12981,5672,13498,186,19649,,2493, 08_01_mobile,https://www.cumhuriyet.com.tr/,11697859,69948,1547,21032,3399,5213,540,121021,,24798, 08_01_mobile,https://hacettepe.edu.tr/,4547293,38135,4016,14296,7572,24727,49,38146,,877,0.31 08_01_mobile,https://www.haberturk.com/,1564998,11834,1969,5684,3615,4662,113,33755,,5254,0.54 08_01_mobile,https://www.itu.edu.tr/,20235357,61344,1969,17150,7400,20384,149,120582,,10654,0.03 08_01_mobile,https://www.mynet.com/,6335108,30208,1950,24538,4236,24873,266,120763,,5859, 08_01_mobile,https://www.sabah.com.tr/,2296339,23098,3065,8527,6514,7819,151,36108,,4304,0.21 08_01_mobile,http://boun.edu.tr/,889462,8363,1440,12665,3721,5077,32,52509,,237,0.71 08_01_mobile,https://www.ankara.edu.tr/,8016026,54018,2842,38483,16400,44666,183,61316,,8268, 08_01_mobile,https://www.metu.edu.tr/,5807453,38396,2428,13622,6468,13892,91,46853,,2270,0.17 09_01_desktop,http://boun.edu.tr/,542869,2348,566,1665,1299,2322,27,2354,,0, 09_01_desktop,https://www.metu.edu.tr/,5587443,13059,1056,8231,2884,4253,106,17665,,414, 09_01_desktop,https://www.mynet.com/,1311211,5192,573,1554,1406,2504,130,9045,,651, 09_01_desktop,https://www.sabah.com.tr/,1811914,5411,407,2057,1569,2972,155,11089,,785, 09_01_desktop,https://hacettepe.edu.tr/,5152148,11429,1251,3979,2536,10126,48,11436,,21, 09_01_desktop,https://www.ankara.edu.tr/,11935035,19160,1475,15749,6072,16781,216,25467,,1247, 09_01_desktop,https://www.itu.edu.tr/,39537618,83122,961,7686,2530,8975,160,92498,,948, 09_01_desktop,https://www.haberturk.com/,4658295,5983,373,2413,837,1586,215,15357,,1867, 09_01_mobile,https://www.mynet.com/,6395431,26910,1737,30828,3714,21565,242,120705,,7076,0.23 09_01_mobile,http://boun.edu.tr/,1272244,8561,1512,16289,3815,6326,39,94859,,156,0.65 09_01_mobile,https://hacettepe.edu.tr/,5122011,44590,2653,8177,6100,15008,48,44608,,588,0.44 09_01_mobile,https://www.itu.edu.tr/,10404713,59927,2167,13810,6827,19430,135,72401,,3991,0.04 09_01_mobile,https://www.sabah.com.tr/,2190530,22578,2782,8365,6204,7247,146,34884,,3659,0.25 09_01_mobile,https://www.ankara.edu.tr/,8370807,58745,2639,50945,16014,48006,186,67027,,8661,0.01 09_01_mobile,https://www.metu.edu.tr/,5129070,35511,2726,13541,6765,9678,102,44681,,2193, 09_01_mobile,https://www.haberturk.com/,1642902,12919,1752,5553,3520,4544,112,33874,,3610,0.56 10_01_desktop,https://hacettepe.edu.tr/,4470042,8004,1151,6807,2468,4785,46,10701,,13, 10_01_desktop,https://www.haberturk.com/,5006382,7780,566,4078,1282,2057,219,18104,,2189, 10_01_desktop,https://www.ankara.edu.tr/,9058323,20797,1531,12907,6893,19538,177,23300,,755, 10_01_desktop,http://boun.edu.tr/,472674,2631,683,1961,1567,2651,27,2668,,0, 10_01_desktop,https://www.itu.edu.tr/,39702693,81686,796,6761,2461,8437,170,91179,,788, 10_01_desktop,https://www.metu.edu.tr/,5358275,11784,1010,7027,2711,3939,106,14175,,375, 10_01_desktop,https://www.cumhuriyet.com.tr/,6282200,26555,395,5604,1089,3063,587,33203,,8519, 10_01_desktop,https://www.sabah.com.tr/,1735542,7021,400,2753,2457,3455,151,11951,,1028, 10_01_desktop,https://www.mynet.com/,2150381,13898,913,2767,1852,3171,381,17822,,2250, 10_01_mobile,https://hacettepe.edu.tr/,3395020,20807,2596,20041,5390,10281,46,28984,,303,0.36 10_01_mobile,http://boun.edu.tr/,1229606,8307,1416,12406,3815,5081,39,94667,,196,0.72 10_01_mobile,https://www.haberturk.com/,2433911,16276,1960,6792,3607,4645,162,37998,,3322,0.54 10_01_mobile,https://www.metu.edu.tr/,5297785,34867,2435,13796,6323,9218,102,43997,,1607,0.14 10_01_mobile,https://www.cumhuriyet.com.tr/,4966939,39799,1716,16238,3445,6323,285,63331,,8844,0.11 10_01_mobile,https://www.ankara.edu.tr/,9035929,59060,2459,32372,16212,53346,174,66104,,3768,0.01 10_01_mobile,https://www.mynet.com/,7058331,34396,1828,26676,3982,25806,272,120526,,5520,0.22 11_01_desktop,https://www.haberturk.com/,5545116,7822,535,3210,1179,2122,251,18272,,2106, 11_01_desktop,https://www.metu.edu.tr/,5600824,12955,1024,10709,2836,3886,111,17010,,247, 11_01_desktop,https://www.itu.edu.tr/,49277227,100362,959,12734,2628,9267,163,111974,,1069, 11_01_desktop,https://www.mynet.com/,1325599,5079,561,1488,1252,2612,125,9902,,1554, 11_01_desktop,https://www.ankara.edu.tr/,22844124,43884,1414,22731,6553,43323,179,49440,,1236, 11_01_desktop,http://boun.edu.tr/,2225728,5746,684,2639,1665,6280,28,10334,,60, 11_01_desktop,https://www.sabah.com.tr/,1588656,5998,354,2144,1671,2618,151,11271,,888, 11_01_desktop,https://www.cumhuriyet.com.tr/,6662422,15883,570,3773,964,3642,456,28184,,5508, 11_01_desktop,https://hacettepe.edu.tr/,5651356,8206,820,5065,1802,3855,48,11332,,73, 11_01_mobile,https://www.itu.edu.tr/,12711429,70773,2139,9543,5855,12264,144,81353,,373,0.05 11_01_mobile,https://www.haberturk.com/,2323792,15765,2017,5919,3307,4296,158,38195,,118,0.11 11_01_mobile,https://www.sabah.com.tr/,2210619,22187,3313,9702,6976,8673,151,34144,,2675,0.29 11_01_mobile,http://boun.edu.tr/,10029891,11950,1581,20397,3641,9791,39,95195,,0,0.59 11_01_mobile,https://www.mynet.com/,7311281,46255,1971,27879,4262,31304,327,120725,,5230,0.22 11_01_mobile,https://www.metu.edu.tr/,5541753,37923,2751,15399,7142,8801,107,47054,,1371,0.17 11_01_mobile,https://www.cumhuriyet.com.tr/,6190012,42467,1509,18428,3361,7849,464,118390,,14614, 11_01_mobile,https://hacettepe.edu.tr/,11591193,69801,2202,38972,5313,7737,49,76222,,544,0.4 11_01_mobile,https://www.ankara.edu.tr/,8267972,54133,2430,29021,15020,48775,176,61772,,216,0.02 12_01_desktop,http://boun.edu.tr/,4096949,5685,722,3487,1784,5849,28,13397,,58, 12_01_desktop,https://www.metu.edu.tr/,5723823,13412,1054,7999,2885,4833,106,16406,,264, 12_01_desktop,https://www.itu.edu.tr/,5619308,11446,979,7161,2604,9870,144,15849,,444, 12_01_desktop,https://hacettepe.edu.tr/,13359657,22508,899,11968,1952,3741,50,24542,,118, 12_01_desktop,https://www.mynet.com/,16728025,58955,377,5909,1022,2502,470,63821,,2816, 12_01_desktop,https://www.sabah.com.tr/,1683787,5849,252,2123,1642,3243,147,15507,,440, 12_01_desktop,https://www.cumhuriyet.com.tr/,6239034,24750,463,5720,1166,2336,481,33667,,7971, 12_01_desktop,https://www.haberturk.com/,5516476,7522,610,4327,1102,1983,249,27467,,1283, 12_01_desktop,https://www.ankara.edu.tr/,8395115,18080,1303,10364,5895,16936,176,20540,,656, 12_01_mobile,https://www.haberturk.com/,2426999,14089,1904,5711,3343,4219,145,36985,,264,0.55 12_01_mobile,https://www.metu.edu.tr/,5664634,37417,2437,14125,6442,13590,102,47792,,148,0.14 12_01_mobile,https://www.ankara.edu.tr/,8397854,53699,2365,29454,14834,48332,173,61157,,819,0.01 12_01_mobile,http://boun.edu.tr/,17135968,11832,3434,27203,5935,8733,39,104914,,101,0.61 12_01_mobile,https://www.cumhuriyet.com.tr/,5468449,53042,1986,14824,3911,8841,360,96267,,18639, 12_01_mobile,https://hacettepe.edu.tr/,12147561,81425,2129,8921,4908,15381,45,89243,,584,0.37 12_01_mobile,https://www.sabah.com.tr/,2163470,21260,3035,8536,6854,7686,148,35439,,123,0.27 12_01_mobile,https://www.mynet.com/,6628892,37043,1816,28296,3593,23426,285,120156,,407,0.15 12_01_mobile,https://www.itu.edu.tr/,7384430,44505,2064,9506,5752,12475,132,51828,,297,0.06 ``` ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 25, 2022, 5:46am UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/15 "2022-03-25T05:46:33Z")
Many thanks for this data Rick, I really appreciate it! ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [March 31, 2022, 6:29pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/16 "2022-03-31T18:29:37Z")
Hi Rick, further to my previous comment, I want to thank you once again for the queries that you run so far. Since I need more historical data (for the wider time range and further websites) in order to get more reliable academic research results for my thesis, could you please advise whether it would be possible to get the historical data by June 2017 for below websites? 1. sozcu.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 2. hurriyet.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 3. milliyet.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 4. sabah.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 5. [mynet.com](http://mynet.com) (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 6. [haberturk.com](http://haberturk.com) (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 7. cumhuriyet.com.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 8. [haber7.com](http://haber7.com) 9. [sondakika.com](http://sondakika.com) 10. [haberler.com](http://haberler.com) 11. ku.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 12. sabanciuniv.edu (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 13. metu.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 14. bilkent.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 15. boun.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 16. itu.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 17. ankara.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 18. hacettepe.edu.tr (you already provided the data between January 2021 - December 2021, therefore the data from June 2017 to January 2021 would be great) 19. istanbul.edu.tr 20. anadolu.edu.tr Thank you very much. ---
**Author:** ![charlie.clark](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/charlie.clark/32/842_2.png) [@charlie.clark](https://discuss.httparchive.org/u/charlie.clark)\ **Post date:** [April 1, 2022, 7:32am UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/17 "2022-04-01T07:32:10Z")
FWIW, it’s pretty easy to extract this information yourself from the CSV files provided on [legacy.httparchive.org](http://legacy.httparchive.org) Charlie ---
**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\ **Post date:** [April 1, 2022, 4:30pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/18 "2022-04-01T16:30:18Z")
It looks like none of these URLs were available in the dataset until July 2018, which is when we stopped using the Alexa top 1M and switched to the Chrome UX Report. Also note that many of the metrics weren’t measured until 2019 or later, like LCP and CLS. In any case, hope this helps. Query: ```sql DECLARE URLs ARRAY DEFAULT [ 'https://www.hurriyet.com.tr/', 'https://www.milliyet.com.tr/', 'https://www.sozcu.com.tr/', 'https://www.ku.edu.tr/', 'https://www.sabanciuniv.edu/', 'https://www.bilkent.edu.tr/', 'https://www.sabah.com.tr/', 'https://www.mynet.com/', 'https://www.haberturk.com/', 'https://www.cumhuriyet.com.tr/', 'https://www.haber7.com/', 'https://www.sondakika.com/', 'https://www.haberler.com/', 'https://www.metu.edu.tr/', 'http://boun.edu.tr/', 'https://www.itu.edu.tr/', 'https://www.ankara.edu.tr/', 'https://hacettepe.edu.tr/', 'https://www.istanbul.edu.tr/', 'https://anadolu.edu.tr/' ]; SELECT _TABLE_SUFFIX AS date_client, url, JSON_VALUE(payload, '$._bytesIn') AS page_size, JSON_VALUE(payload, '$._loadTime') AS load_time, JSON_VALUE(payload, '$._TTFB') AS ttfb, JSON_VALUE(payload, '$._SpeedIndex') AS speed_index, JSON_VALUE(payload, '$."_chromeUserTiming.firstContentfulPaint"') AS fcp, JSON_VALUE(payload, '$."_chromeUserTiming.LargestContentfulPaint"') AS lcp, JSON_VALUE(payload, '$._requests') AS requests, JSON_VALUE(payload, '$._TTIMeasurementEnd') AS tti, JSON_VALUE(payload, '$._chromeUserTiming.CumulativeLayoutShift') AS cls, JSON_VALUE(payload, '$._TotalBlockingTime') AS tbt, JSON_VALUE(report, '$.categories.performance.score') AS performance_score FROM `httparchive.pages.*` LEFT JOIN `httparchive.lighthouse.*` USING (_TABLE_SUFFIX, url) WHERE SUBSTR(_TABLE_SUFFIX, 0, 10) BETWEEN '2017_06_01' AND '2021_03_01' AND url IN UNNEST(URLs) ORDER BY date_client ``` The results are too big to share here, so here’s a Drive link: > **[script\_job\_9082854a217d256278e8fe731866eaa2\_0.csv](https://drive.google.com/file/d/17ozyb36eUfssLdhPmMRW8lMXDUrlRYV8/view?usp=sharing)** > > Google Drive file. ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [April 1, 2022, 9:03pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/19 "2022-04-01T21:03:12Z")
Hi Rick, thank you ever so much for the queries that you run. This is really really much appreciated and I will definitely mention HTTP Archive to explain the source of the data in the methodology section of my master’s thesis 🙂 ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [October 13, 2022, 3:46pm UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/20 "2022-10-13T15:46:50Z")
Hi Rick, I hope this message finds you well. Could you please kindly advise what exactly are the types of below web performance data that you have provided and whether these are the sum of the monthly data or the monthly average of the daily data? Page size: Is this in the type of byte and sum of the daily data? Load time: Is this in the type of milliseconds and the sum of the daily data? Time to first byte: Is this in the type of milliseconds and the sum of the daily data? Speed index: Is this in the type of milliseconds and the sum of the daily data? First contentful paint: Is this in the type of milliseconds and the sum of the daily data? Requests: Is this sum of the daily data or the average of the daily data? Time to interactive: Is this in the type of milliseconds and the sum of the daily data? Thank you in advance. ---
**Author:** ![rviscomi](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/rviscomi/32/835_2.png) [@rviscomi](https://discuss.httparchive.org/u/rviscomi)\ **Post date:** [October 19, 2022, 2:54am UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/21 "2022-10-19T02:54:03Z")
HTTP Archive visits pages at most once per month, so a metric like page size is whatever we saw on that day, not an aggregation of multiple visits. So the page size is in bytes, and all timing metrics are in milliseconds, which represent a single visit per month. ---
**Author:** ![imranmehmet](https://yyz1.discourse-cdn.com/flex035/user_avatar/discuss.httparchive.org/imranmehmet/32/1986_2.png) [@imranmehmet](https://discuss.httparchive.org/u/imranmehmet)\ **Post date:** [October 19, 2022, 8:18am UTC](https://discuss.httparchive.org/t/is-there-any-way-to-download-daily-historical-data-about-website-performance-1-year-period-in-csv-or-excel-format-for-different-websites/2325/22 "2022-10-19T08:18:20Z")
Thank you very much Rick, it is much appreciated.