PREVIEW / futures_1hour / 2008-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-15.parquet
  size:    44 KB
  rows:    1,238

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-07-15 00:00:00	ES	Futures	1136.98	1137.44	1135.35	1135.81	1764.0
2008-07-15 01:00:00	ES	Futures	1135.81	1136.28	1134.42	1136.28	2631.0
2008-07-15 02:00:00	ES	Futures	1136.51	1137.91	1134.65	1136.51	5668.0
2008-07-15 03:00:00	ES	Futures	1136.51	1137.67	1132.56	1133.26	25232.0
2008-07-15 04:00:00	ES	Futures	1133.02	1134.88	1131.17	1133.95	20562.0
2008-07-15 05:00:00	ES	Futures	1133.72	1135.58	1130.7	1131.17	18782.0
2008-07-15 06:00:00	ES	Futures	1131.17	1131.86	1125.12	1127.21	48752.0
2008-07-15 07:00:00	ES	Futures	1126.98	1130.0	1126.75	1129.31	36469.0
2008-07-15 08:00:00	ES	Futures	1129.31	1131.86	1126.05	1131.63	66430.0
2008-07-15 09:00:00	ES	Futures	1131.86	1134.65	1125.12	1126.28	352822.0
2008-07-15 10:00:00	ES	Futures	1126.28	1128.14	1116.29	1126.28	684497.0
2008-07-15 11:00:00	ES	Futures	1126.28	1138.37	1126.05	1136.05	623571.0
2008-07-15 12:00:00	ES	Futures	1136.05	1143.25	1133.02	1141.39	458624.0
2008-07-15 13:00:00	ES	Futures	1141.62	1146.74	1135.35	1140.23	344326.0
2008-07-15 14:00:00	ES	Futures	1140.46	1144.88	1135.81	1143.95	284497.0
2008-07-15 15:00:00	ES	Futures	1143.72	1148.83	1129.31	1129.77	513505.0
2008-07-15 16:00:00	ES	Futures	1129.77	1129.77	1125.36	1128.38	140053.0
2008-07-15 17:00:00	ES	Futures	1128.14	1128.61	1126.98	1127.21	3790.0
2008-07-15 18:00:00	ES	Futures	1126.75	1127.45	1125.12	1127.21	4774.0
2008-07-15 19:00:00	ES	Futures	1127.21	1129.31	1127.21	1129.07	2344.0
2008-07-15 20:00:00	ES	Futures	1129.07	1130.0	1128.84	1129.54	2784.0
2008-07-15 21:00:00	ES	Futures	1129.54	1130.0	1127.45	1128.38	3877.0
2008-07-15 22:00:00	ES	Futures	1127.91	1129.77	1127.91	1128.84	6165.0
2008-07-15 23:00:00	ES	Futures	1128.84	1130.24	1128.61	1130.24	6650.0
2008-07-15 00:00:00	NQ	Futures	2020.22	2021.06	2017.4	2018.53	148.0
2008-07-15 01:00:00	NQ	Futures	2019.09	2019.09	2016.0	2017.4	250.0
2008-07-15 02:00:00	NQ	Futures	2017.4	2021.06	2014.87	2018.53	395.0
2008-07-15 03:00:00	NQ	Futures	2018.81	2020.78	2012.06	2013.18	2177.0
2008-07-15 04:00:00	NQ	Futures	2012.9	2016.28	2009.53	2016.0	1391.0
2008-07-15 05:00:00	NQ	Futures	2015.72	2018.25	2009.81	2009.81	903.0
2008-07-15 06:00:00	NQ	Futures	2009.53	2010.65	1999.4	2004.46	4219.0
2008-07-15 07:00:00	NQ	Futures	2004.75	2010.37	2003.62	2008.68	3970.0
2008-07-15 08:00:00	NQ	Futures	2008.96	2019.65	2005.59	2017.97	12371.0
2008-07-15 09:00:00	NQ	Futures	2017.97	2023.31	2001.65	2007.56	63295.0
2008-07-15 10:00:00	NQ	Futures	2007.84	2010.93	1986.18	2005.59	114641.0
2008-07-15 11:00:00	NQ	Futures	2005.87	2032.59	2005.03	2025.28	132936.0
2008-07-15 12:00:00	NQ	Futures	2025.0	2047.78	2020.78	2043.28	101614.0
2008-07-15 13:00:00	NQ	Futures	2043.28	2052.28	2030.06	2041.88	74999.0
2008-07-15 14:00:00	NQ	Futures	2041.88	2055.66	2034.28	2052.28	60521.0
2008-07-15 15:00:00	NQ	Futures	2052.28	2062.97	2028.65	2029.5	94356.0
2008-07-15 16:00:00	NQ	Futures	2029.22	2034.28	2022.19	2032.59	15411.0
2008-07-15 17:00:00	NQ	Futures	2032.59	2033.72	2030.91	2032.87	401.0
2008-07-15 18:00:00	NQ	Futures	2032.03	2033.72	2028.94	2033.72	347.0
2008-07-15 19:00:00	NQ	Futures	2033.16	2035.12	2033.16	2034.56	207.0
2008-07-15 20:00:00	NQ	Futures	2034.28	2034.84	2032.31	2033.72	375.0
2008-07-15 21:00:00	NQ	Futures	2033.44	2035.41	2030.62	2030.62	119.0
2008-07-15 22:00:00	NQ	Futures	2030.62	2033.44	2030.62	2033.44	40.0
2008-07-15 23:00:00	NQ	Futures	2033.44	2035.12	2033.16	2034.28	24.0
2008-07-15 00:00:00	YM	Futures	9987.6	9991.3	9971.3	9974.9	170.0
2008-07-15 01:00:00	YM	Futures	9976.7	9984.0	9967.6	9984.0	173.0

> showing 50 of 1,238 rows — these rows as CSV

> unlock the full archive -- $79 one-time