Data Feeds UTC Date/Half-Hour Cheat Sheet

Analytics Guides
Last Updated:
July 11, 2022
by
Jesse Langstaff
| Version: 12
| 2,068 views
| 2 followers
 
members are following updates on this item.
Last Updated:
July 11, 2022
by
Jesse Langstaff
| Version: 12
2,068
2
 
members are following updates on this item.
Publication details
Published
on
July 10, 2018
by
Jesse Langstaff
Data Feeds

Prior years

start_utc_dtstart_utc_half_hour_keyend_utc_dtend_utc_half_hour_key
1/1/2004 12:00:00 AM +00:0011/31/2004 11:30:00 PM +00:001488
2/1/2004 12:00:00 AM +00:0014892/29/2004 11:30:00 PM +00:002880
3/1/2004 12:00:00 AM +00:0028813/31/2004 11:30:00 PM +00:004368
4/1/2004 12:00:00 AM +00:0043694/30/2004 11:30:00 PM +00:005808
5/1/2004 12:00:00 AM +00:0058095/31/2004 11:30:00 PM +00:007296
6/1/2004 12:00:00 AM +00:0072976/30/2004 11:30:00 PM +00:008736
7/1/2004 12:00:00 AM +00:0087377/31/2004 11:30:00 PM +00:0010224
8/1/2004 12:00:00 AM +00:00102258/31/2004 11:30:00 PM +00:0011712
9/1/2004 12:00:00 AM +00:00117139/30/2004 11:30:00 PM +00:0013152
10/1/2004 12:00:00 AM +00:001315310/31/2004 11:30:00 PM +00:0014640
11/1/2004 12:00:00 AM +00:001464111/30/2004 11:30:00 PM +00:0016080
12/1/2004 12:00:00 AM +00:001608112/31/2004 11:30:00 PM +00:0017568
1/1/2005 12:00:00 AM +00:00175691/31/2005 11:30:00 PM +00:0019056
2/1/2005 12:00:00 AM +00:00190572/28/2005 11:30:00 PM +00:0020400
3/1/2005 12:00:00 AM +00:00204013/31/2005 11:30:00 PM +00:0021888
4/1/2005 12:00:00 AM +00:00218894/30/2005 11:30:00 PM +00:0023328
5/1/2005 12:00:00 AM +00:00233295/31/2005 11:30:00 PM +00:0024816
6/1/2005 12:00:00 AM +00:00248176/30/2005 11:30:00 PM +00:0026256
7/1/2005 12:00:00 AM +00:00262577/31/2005 11:30:00 PM +00:0027744
8/1/2005 12:00:00 AM +00:00277458/31/2005 11:30:00 PM +00:0029232
9/1/2005 12:00:00 AM +00:00292339/30/2005 11:30:00 PM +00:0030672
10/1/2005 12:00:00 AM +00:003067310/31/2005 11:30:00 PM +00:0032160
11/1/2005 12:00:00 AM +00:003216111/30/2005 11:30:00 PM +00:0033600
12/1/2005 12:00:00 AM +00:003360112/31/2005 11:30:00 PM +00:0035088
1/1/2006 12:00:00 AM +00:00350891/31/2006 11:30:00 PM +00:0036576
2/1/2006 12:00:00 AM +00:00365772/28/2006 11:30:00 PM +00:0037920
3/1/2006 12:00:00 AM +00:00379213/31/2006 11:30:00 PM +00:0039408
4/1/2006 12:00:00 AM +00:00394094/30/2006 11:30:00 PM +00:0040848
5/1/2006 12:00:00 AM +00:00408495/31/2006 11:30:00 PM +00:0042336
6/1/2006 12:00:00 AM +00:00423376/30/2006 11:30:00 PM +00:0043776
7/1/2006 12:00:00 AM +00:00437777/31/2006 11:30:00 PM +00:0045264
8/1/2006 12:00:00 AM +00:00452658/31/2006 11:30:00 PM +00:0046752
9/1/2006 12:00:00 AM +00:00467539/30/2006 11:30:00 PM +00:0048192
10/1/2006 12:00:00 AM +00:004819310/31/2006 11:30:00 PM +00:0049680
11/1/2006 12:00:00 AM +00:004968111/30/2006 11:30:00 PM +00:0051120
12/1/2006 12:00:00 AM +00:005112112/31/2006 11:30:00 PM +00:0052608
1/1/2007 12:00:00 AM +00:00526091/31/2007 11:30:00 PM +00:0054096
2/1/2007 12:00:00 AM +00:00540972/28/2007 11:30:00 PM +00:0055440
3/1/2007 12:00:00 AM +00:00554413/31/2007 11:30:00 PM +00:0056928
4/1/2007 12:00:00 AM +00:00569294/30/2007 11:30:00 PM +00:0058368
5/1/2007 12:00:00 AM +00:00583695/31/2007 11:30:00 PM +00:0059856
6/1/2007 12:00:00 AM +00:00598576/30/2007 11:30:00 PM +00:0061296
7/1/2007 12:00:00 AM +00:00612977/31/2007 11:30:00 PM +00:0062784
8/1/2007 12:00:00 AM +00:00627858/31/2007 11:30:00 PM +00:0064272
9/1/2007 12:00:00 AM +00:00642739/30/2007 11:30:00 PM +00:0065712
10/1/2007 12:00:00 AM +00:006571310/31/2007 11:30:00 PM +00:0067200
11/1/2007 12:00:00 AM +00:006720111/30/2007 11:30:00 PM +00:0068640
12/1/2007 12:00:00 AM +00:006864112/31/2007 11:30:00 PM +00:0070128
1/1/2008 12:00:00 AM +00:00701291/31/2008 11:30:00 PM +00:0071616
2/1/2008 12:00:00 AM +00:00716172/29/2008 11:30:00 PM +00:0073008
3/1/2008 12:00:00 AM +00:00730093/31/2008 11:30:00 PM +00:0074496
4/1/2008 12:00:00 AM +00:00744974/30/2008 11:30:00 PM +00:0075936
5/1/2008 12:00:00 AM +00:00759375/31/2008 11:30:00 PM +00:0077424
6/1/2008 12:00:00 AM +00:00774256/30/2008 11:30:00 PM +00:0078864
7/1/2008 12:00:00 AM +00:00788657/31/2008 11:30:00 PM +00:0080352
8/1/2008 12:00:00 AM +00:00803538/31/2008 11:30:00 PM +00:0081840
9/1/2008 12:00:00 AM +00:00818419/30/2008 11:30:00 PM +00:0083280
10/1/2008 12:00:00 AM +00:008328110/31/2008 11:30:00 PM +00:0084768
11/1/2008 12:00:00 AM +00:008476911/30/2008 11:30:00 PM +00:0086208
12/1/2008 12:00:00 AM +00:008620912/31/2008 11:30:00 PM +00:0087696
1/1/2009 12:00:00 AM +00:00876971/31/2009 11:30:00 PM +00:0089184
2/1/2009 12:00:00 AM +00:00891852/28/2009 11:30:00 PM +00:0090528
3/1/2009 12:00:00 AM +00:00905293/31/2009 11:30:00 PM +00:0092016
4/1/2009 12:00:00 AM +00:00920174/30/2009 11:30:00 PM +00:0093456
5/1/2009 12:00:00 AM +00:00934575/31/2009 11:30:00 PM +00:0094944
6/1/2009 12:00:00 AM +00:00949456/30/2009 11:30:00 PM +00:0096384
7/1/2009 12:00:00 AM +00:00963857/31/2009 11:30:00 PM +00:0097872
8/1/2009 12:00:00 AM +00:00978738/31/2009 11:30:00 PM +00:0099360
9/1/2009 12:00:00 AM +00:00993619/30/2009 11:30:00 PM +00:00100800
10/1/2009 12:00:00 AM +00:0010080110/31/2009 11:30:00 PM +00:00102288
11/1/2009 12:00:00 AM +00:0010228911/30/2009 11:30:00 PM +00:00103728
12/1/2009 12:00:00 AM +00:0010372912/31/2009 11:30:00 PM +00:00105216
1/1/2010 12:00:00 AM +00:001052171/31/2010 11:30:00 PM +00:00106704
2/1/2010 12:00:00 AM +00:001067052/28/2010 11:30:00 PM +00:00108048
3/1/2010 12:00:00 AM +00:001080493/31/2010 11:30:00 PM +00:00109536
4/1/2010 12:00:00 AM +00:001095374/30/2010 11:30:00 PM +00:00110976
5/1/2010 12:00:00 AM +00:001109775/31/2010 11:30:00 PM +00:00112464
6/1/2010 12:00:00 AM +00:001124656/30/2010 11:30:00 PM +00:00113904
7/1/2010 12:00:00 AM +00:001139057/31/2010 11:30:00 PM +00:00115392
8/1/2010 12:00:00 AM +00:001153938/31/2010 11:30:00 PM +00:00116880
9/1/2010 12:00:00 AM +00:001168819/30/2010 11:30:00 PM +00:00118320
10/1/2010 12:00:00 AM +00:0011832110/31/2010 11:30:00 PM +00:00119808
11/1/2010 12:00:00 AM +00:0011980911/30/2010 11:30:00 PM +00:00121248
12/1/2010 12:00:00 AM +00:0012124912/31/2010 11:30:00 PM +00:00122736
1/1/2011 12:00:00 AM +00:001227371/31/2011 11:30:00 PM +00:00124224
2/1/2011 12:00:00 AM +00:001242252/28/2011 11:30:00 PM +00:00125568
3/1/2011 12:00:00 AM +00:001255693/31/2011 11:30:00 PM +00:00127056
4/1/2011 12:00:00 AM +00:001270574/30/2011 11:30:00 PM +00:00128496
5/1/2011 12:00:00 AM +00:001284975/31/2011 11:30:00 PM +00:00129984
6/1/2011 12:00:00 AM +00:001299856/30/2011 11:30:00 PM +00:00131424
7/1/2011 12:00:00 AM +00:001314257/31/2011 11:30:00 PM +00:00132912
8/1/2011 12:00:00 AM +00:001329138/31/2011 11:30:00 PM +00:00134400
9/1/2011 12:00:00 AM +00:001344019/30/2011 11:30:00 PM +00:00135840
10/1/2011 12:00:00 AM +00:0013584110/31/2011 11:30:00 PM +00:00137328
11/1/2011 12:00:00 AM +00:0013732911/30/2011 11:30:00 PM +00:00138768
12/1/2011 12:00:00 AM +00:0013876912/31/2011 11:30:00 PM +00:00140256
1/1/2012 12:00:00 AM +00:001402571/31/2012 11:30:00 PM +00:00141744
2/1/2012 12:00:00 AM +00:001417452/29/2012 11:30:00 PM +00:00143136
3/1/2012 12:00:00 AM +00:001431373/31/2012 11:30:00 PM +00:00144624
4/1/2012 12:00:00 AM +00:001446254/30/2012 11:30:00 PM +00:00146064
5/1/2012 12:00:00 AM +00:001460655/31/2012 11:30:00 PM +00:00147552
6/1/2012 12:00:00 AM +00:001475536/30/2012 11:30:00 PM +00:00148992
7/1/2012 12:00:00 AM +00:001489937/31/2012 11:30:00 PM +00:00150480
8/1/2012 12:00:00 AM +00:001504818/31/2012 11:30:00 PM +00:00151968
9/1/2012 12:00:00 AM +00:001519699/30/2012 11:30:00 PM +00:00153408
10/1/2012 12:00:00 AM +00:0015340910/31/2012 11:30:00 PM +00:00154896
11/1/2012 12:00:00 AM +00:0015489711/30/2012 11:30:00 PM +00:00156336
12/1/2012 12:00:00 AM +00:0015633712/31/2012 11:30:00 PM +00:00157824
1/1/2013 12:00:00 AM +00:001578251/31/2013 11:30:00 PM +00:00159312
2/1/2013 12:00:00 AM +00:001593132/28/2013 11:30:00 PM +00:00160656
3/1/2013 12:00:00 AM +00:001606573/31/2013 11:30:00 PM +00:00162144
4/1/2013 12:00:00 AM +00:001621454/30/2013 11:30:00 PM +00:00163584
5/1/2013 12:00:00 AM +00:001635855/31/2013 11:30:00 PM +00:00165072
6/1/2013 12:00:00 AM +00:001650736/30/2013 11:30:00 PM +00:00166512
7/1/2013 12:00:00 AM +00:001665137/31/2013 11:30:00 PM +00:00168000
8/1/2013 12:00:00 AM +00:001680018/31/2013 11:30:00 PM +00:00169488
9/1/2013 12:00:00 AM +00:001694899/30/2013 11:30:00 PM +00:00170928
10/1/2013 12:00:00 AM +00:0017092910/31/2013 11:30:00 PM +00:00172416
11/1/2013 12:00:00 AM +00:0017241711/30/2013 11:30:00 PM +00:00173856
12/1/2013 12:00:00 AM +00:0017385712/31/2013 11:30:00 PM +00:00175344
1/1/2014 12:00:00 AM +00:001753451/31/2014 11:30:00 PM +00:00176832
2/1/2014 12:00:00 AM +00:001768332/28/2014 11:30:00 PM +00:00178176
3/1/2014 12:00:00 AM +00:001781773/31/2014 11:30:00 PM +00:00179664
4/1/2014 12:00:00 AM +00:001796654/30/2014 11:30:00 PM +00:00181104
5/1/2014 12:00:00 AM +00:001811055/31/2014 11:30:00 PM +00:00182592
6/1/2014 12:00:00 AM +00:001825936/30/2014 11:30:00 PM +00:00184032
7/1/2014 12:00:00 AM +00:001840337/31/2014 11:30:00 PM +00:00185520
8/1/2014 12:00:00 AM +00:001855218/31/2014 11:30:00 PM +00:00187008
9/1/2014 12:00:00 AM +00:001870099/30/2014 11:30:00 PM +00:00188448
10/1/2014 12:00:00 AM +00:0018844910/31/2014 11:30:00 PM +00:00189936
11/1/2014 12:00:00 AM +00:0018993711/30/2014 11:30:00 PM +00:00191376
12/1/2014 12:00:00 AM +00:0019137712/31/2014 11:30:00 PM +00:00192864
1/1/2015 12:00:00 AM +00:001928651/31/2015 11:30:00 PM +00:00194352
2/1/2015 12:00:00 AM +00:001943532/28/2015 11:30:00 PM +00:00195696
3/1/2015 12:00:00 AM +00:001956973/31/2015 11:30:00 PM +00:00197184
4/1/2015 12:00:00 AM +00:001971854/30/2015 11:30:00 PM +00:00198624
5/1/2015 12:00:00 AM +00:001986255/31/2015 11:30:00 PM +00:00200112
6/1/2015 12:00:00 AM +00:002001136/30/2015 11:30:00 PM +00:00201552
7/1/2015 12:00:00 AM +00:002015537/31/2015 11:30:00 PM +00:00203040
8/1/2015 12:00:00 AM +00:002030418/31/2015 11:30:00 PM +00:00204528
9/1/2015 12:00:00 AM +00:002045299/30/2015 11:30:00 PM +00:00205968
10/1/2015 12:00:00 AM +00:0020596910/31/2015 11:30:00 PM +00:00207456
11/1/2015 12:00:00 AM +00:0020745711/30/2015 11:30:00 PM +00:00208896
12/1/2015 12:00:00 AM +00:0020889712/31/2015 11:30:00 PM +00:00210384
1/1/2016 12:00:00 AM +00:002103851/31/2016 11:30:00 PM +00:00211872
2/1/2016 12:00:00 AM +00:002118732/29/2016 11:30:00 PM +00:00213264
3/1/2016 12:00:00 AM +00:002132653/31/2016 11:30:00 PM +00:00214752
4/1/2016 12:00:00 AM +00:002147534/30/2016 11:30:00 PM +00:00216192
5/1/2016 12:00:00 AM +00:002161935/31/2016 11:30:00 PM +00:00217680
6/1/2016 12:00:00 AM +00:002176816/30/2016 11:30:00 PM +00:00219120
7/1/2016 12:00:00 AM +00:002191217/31/2016 11:30:00 PM +00:00220608
8/1/2016 12:00:00 AM +00:002206098/31/2016 11:30:00 PM +00:00222096
9/1/2016 12:00:00 AM +00:002220979/30/2016 11:30:00 PM +00:00223536
10/1/2016 12:00:00 AM +00:0022353710/31/2016 11:30:00 PM +00:00225024
11/1/2016 12:00:00 AM +00:0022502511/30/2016 11:30:00 PM +00:00226464
12/1/2016 12:00:00 AM +00:0022646512/31/2016 11:30:00 PM +00:00227952
1/1/2017 12:00:00 AM +00:002279531/31/2017 11:30:00 PM +00:00229440
2/1/2017 12:00:00 AM +00:002294412/28/2017 11:30:00 PM +00:00230784
3/1/2017 12:00:00 AM +00:002307853/31/2017 11:30:00 PM +00:00232272
4/1/2017 12:00:00 AM +00:002322734/30/2017 11:30:00 PM +00:00233712
5/1/2017 12:00:00 AM +00:002337135/31/2017 11:30:00 PM +00:00235200
6/1/2017 12:00:00 AM +00:002352016/30/2017 11:30:00 PM +00:00236640
7/1/2017 12:00:00 AM +00:002366417/31/2017 11:30:00 PM +00:00238128
8/1/2017 12:00:00 AM +00:002381298/31/2017 11:30:00 PM +00:00239616
9/1/2017 12:00:00 AM +00:002396179/30/2017 11:30:00 PM +00:00241056
10/1/2017 12:00:00 AM +00:0024105710/31/2017 11:30:00 PM +00:00242544
11/1/2017 12:00:00 AM +00:0024254511/30/2017 11:30:00 PM +00:00243984
12/1/2017 12:00:00 AM +00:0024398512/31/2017 11:30:00 PM +00:00245472
1/1/2018 12:00:00 AM +00:002454731/31/2018 11:30:00 PM +00:00246960
2/1/2018 12:00:00 AM +00:002469612/28/2018 11:30:00 PM +00:00248304
3/1/2018 12:00:00 AM +00:002483053/31/2018 11:30:00 PM +00:00249792
4/1/2018 12:00:00 AM +00:002497934/30/2018 11:30:00 PM +00:00251232
5/1/2018 12:00:00 AM +00:002512335/31/2018 11:30:00 PM +00:00252720
6/1/2018 12:00:00 AM +00:002527216/30/2018 11:30:00 PM +00:00254160
7/1/2018 12:00:00 AM +00:002541617/31/2018 11:30:00 PM +00:00255648
8/1/2018 12:00:00 AM +00:002556498/31/2018 11:30:00 PM +00:00257136
9/1/2018 12:00:00 AM +00:002571379/30/2018 11:30:00 PM +00:00258576
10/1/2018 12:00:00 AM +00:0025857710/31/2018 11:30:00 PM +00:00260064
11/1/2018 12:00:00 AM +00:0026006511/30/2018 11:30:00 PM +00:00261504
12/1/2018 12:00:00 AM +00:0026150512/31/2018 11:30:00 PM +00:00262992
1/1/2019 12:00:00 AM +00:002629931/31/2019 11:30:00 PM +00:00264480
2/1/2019 12:00:00 AM +00:002644812/28/2019 11:30:00 PM +00:00265824
3/1/2019 12:00:00 AM +00:002658253/31/2019 11:30:00 PM +00:00267312
4/1/2019 12:00:00 AM +00:002673134/30/2019 11:30:00 PM +00:00268752
5/1/2019 12:00:00 AM +00:002687535/31/2019 11:30:00 PM +00:00270240
6/1/2019 12:00:00 AM +00:002702416/30/2019 11:30:00 PM +00:00271680
7/1/2019 12:00:00 AM +00:002716817/31/2019 11:30:00 PM +00:00273168
8/1/2019 12:00:00 AM +00:002731698/31/2019 11:30:00 PM +00:00274656
9/1/2019 12:00:00 AM +00:002746579/30/2019 11:30:00 PM +00:00276096
10/1/2019 12:00:00 AM +00:0027609710/31/2019 11:30:00 PM +00:00277584
11/1/2019 12:00:00 AM +00:0027758511/30/2019 11:30:00 PM +00:00279024
12/1/2019 12:00:00 AM +00:0027902512/31/2019 11:30:00 PM +00:00280512
1/1/2020 12:00:00 AM +00:002805131/31/2020 11:30:00 PM +00:00282000
2/1/2020 12:00:00 AM +00:002820012/29/2020 11:30:00 PM +00:00283392
3/1/2020 12:00:00 AM +00:002833933/31/2020 11:30:00 PM +00:00284880
4/1/2020 12:00:00 AM +00:002848814/30/2020 11:30:00 PM +00:00286320
5/1/2020 12:00:00 AM +00:002863215/31/2020 11:30:00 PM +00:00287808
6/1/2020 12:00:00 AM +00:002878096/30/2020 11:30:00 PM +00:00289248
7/1/2020 12:00:00 AM +00:002892497/31/2020 11:30:00 PM +00:00290736
8/1/2020 12:00:00 AM +00:002907378/31/2020 11:30:00 PM +00:00292224
9/1/2020 12:00:00 AM +00:002922259/30/2020 11:30:00 PM +00:00293664
10/1/2020 12:00:00 AM +00:0029366510/31/2020 11:30:00 PM +00:00295152
11/1/2020 12:00:00 AM +00:0029515311/30/2020 11:30:00 PM +00:00296592
12/1/2020 12:00:00 AM +00:0029659312/31/2020 11:30:00 PM +00:00298080

2021

start_utc_dtstart_utc_half_hour_keyend_utc_dtend_utc_half_hour_key
1/1/2021 12:00:00 AM +00:002980811/31/2021 11:30:00 PM +00:00299568
2/1/2021 12:00:00 AM +00:002995692/28/2021 11:30:00 PM +00:00300912
3/1/2021 12:00:00 AM +00:003009133/31/2021 11:30:00 PM +00:00302400
4/1/2021 12:00:00 AM +00:003024014/30/2021 11:30:00 PM +00:00303840
5/1/2021 12:00:00 AM +00:003038415/31/2021 11:30:00 PM +00:00305328
6/1/2021 12:00:00 AM +00:003053296/30/2021 11:30:00 PM +00:00306768
7/1/2021 12:00:00 AM +00:003067697/31/2021 11:30:00 PM +00:00308256
8/1/2021 12:00:00 AM +00:003082578/31/2021 11:30:00 PM +00:00309744
9/1/2021 12:00:00 AM +00:003097459/30/2021 11:30:00 PM +00:00311184
10/1/2021 12:00:00 AM +00:0031118510/31/2021 11:30:00 PM +00:00312672
11/1/2021 12:00:00 AM +00:0031267311/30/2021 11:30:00 PM +00:00314112
12/1/2021 12:00:00 AM +00:0031411312/31/2021 11:30:00 PM +00:00315600

2022

start_utc_dtstart_utc_half_hour_keyend_utc_dtend_utc_half_hour_key
1/1/2022 12:00:00 AM +00:00315601
1/31/2022 11:30:00 PM +00:00317088
2/1/2022 12:00:00 AM +00:00317089
2/28/2022 11:30:00 PM +00:00318432
3/1/2022 12:00:00 AM +00:00318433
3/31/2022 11:30:00 PM +00:00319920
4/1/2022 12:00:00 AM +00:00319921
4/30/2022 11:30:00 PM +00:00321360
5/1/2022 12:00:00 AM +00:00321361
5/31/2022 11:30:00 PM +00:00322848
6/1/2022 12:00:00 AM +00:00322849
6/30/2022 11:30:00 PM +00:00324288
7/1/2022 12:00:00 AM +00:00324289
7/31/2022 11:30:00 PM +00:00325776
8/1/2022 12:00:00 AM +00:00325777
8/31/2022 11:30:00 PM +00:00327264
9/1/2022 12:00:00 AM +00:00327265
9/30/2022 11:30:00 PM +00:00328704
10/1/2022 12:00:00 AM +00:00328705
10/31/2022 11:30:00 PM +00:00330192
11/1/2022 12:00:00 AM +00:00330193
11/30/2022 11:30:00 PM +00:00331632
12/1/2022 12:00:00 AM +00:00331633
12/31/2022 11:30:00 PM +00:00333120

Related Content (0)

    There is no related content for this article.

    Viewed 2,068 times