PREVIEW / futures_1hour / 2008-01-28

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-28.parquet
  size:    30 KB
  rows:    804

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-01-28 00:00:00	ES	Futures	1234.33	1234.56	1223.14	1226.87	11147.0
2008-01-28 01:00:00	ES	Futures	1226.87	1230.13	1221.97	1227.1	7059.0
2008-01-28 02:00:00	ES	Futures	1227.1	1231.06	1225.24	1230.37	17220.0
2008-01-28 03:00:00	ES	Futures	1230.37	1238.53	1230.37	1238.53	34074.0
2008-01-28 04:00:00	ES	Futures	1238.53	1238.99	1234.1	1236.89	18309.0
2008-01-28 05:00:00	ES	Futures	1236.89	1237.59	1232.7	1235.26	12318.0
2008-01-28 06:00:00	ES	Futures	1235.26	1236.43	1232.46	1236.19	11094.0
2008-01-28 07:00:00	ES	Futures	1236.19	1239.46	1234.8	1237.36	22268.0
2008-01-28 08:00:00	ES	Futures	1237.13	1243.19	1236.66	1240.39	52459.0
2008-01-28 09:00:00	ES	Futures	1240.39	1245.75	1235.96	1241.32	252514.0
2008-01-28 10:00:00	ES	Futures	1241.32	1252.98	1233.63	1250.42	419599.0
2008-01-28 11:00:00	ES	Futures	1250.42	1255.78	1246.92	1250.88	201010.0
2008-01-28 12:00:00	ES	Futures	1251.12	1254.15	1246.92	1252.51	127946.0
2008-01-28 13:00:00	ES	Futures	1252.28	1258.11	1251.58	1254.15	172219.0
2008-01-28 14:00:00	ES	Futures	1254.15	1260.44	1253.91	1254.61	176926.0
2008-01-28 15:00:00	ES	Futures	1254.61	1264.87	1249.25	1264.87	344381.0
2008-01-28 16:00:00	ES	Futures	1264.87	1266.74	1260.91	1261.61	99551.0
2008-01-28 17:00:00	ES	Futures	1261.84	1266.5	1261.84	1265.11	10037.0
2008-01-28 18:00:00	ES	Futures	1264.41	1265.57	1263.71	1265.11	3745.0
2008-01-28 19:00:00	ES	Futures	1265.11	1265.8	1263.71	1264.17	3352.0
2008-01-28 20:00:00	ES	Futures	1264.17	1265.11	1261.84	1262.54	3120.0
2008-01-28 21:00:00	ES	Futures	1262.54	1263.24	1261.14	1261.61	2422.0
2008-01-28 22:00:00	ES	Futures	1261.61	1262.31	1260.68	1261.14	3346.0
2008-01-28 23:00:00	ES	Futures	1261.14	1264.87	1260.91	1263.24	2702.0
2008-01-28 00:00:00	NQ	Futures	2017.56	2017.56	2000.81	2005.07	934.0
2008-01-28 01:00:00	NQ	Futures	2003.94	2013.02	1999.96	2007.63	800.0
2008-01-28 02:00:00	NQ	Futures	2007.34	2014.15	2001.1	2012.45	1546.0
2008-01-28 03:00:00	NQ	Futures	2011.6	2026.93	2011.6	2026.93	1293.0
2008-01-28 04:00:00	NQ	Futures	2026.93	2028.35	2017.84	2023.81	1057.0
2008-01-28 05:00:00	NQ	Futures	2023.81	2023.81	2014.72	2018.7	418.0
2008-01-28 06:00:00	NQ	Futures	2018.7	2019.26	2012.74	2018.7	348.0
2008-01-28 07:00:00	NQ	Futures	2019.26	2028.63	2018.98	2028.63	1990.0
2008-01-28 08:00:00	NQ	Futures	2027.21	2037.71	2027.21	2035.73	5481.0
2008-01-28 09:00:00	NQ	Futures	2035.73	2042.54	2019.83	2037.15	66591.0
2008-01-28 10:00:00	NQ	Futures	2037.15	2052.76	2020.97	2047.93	87429.0
2008-01-28 11:00:00	NQ	Futures	2047.65	2057.02	2041.97	2047.36	40972.0
2008-01-28 12:00:00	NQ	Futures	2047.93	2050.2	2041.12	2046.23	33041.0
2008-01-28 13:00:00	NQ	Futures	2046.23	2057.87	2045.38	2050.77	34106.0
2008-01-28 14:00:00	NQ	Futures	2051.05	2059.85	2045.66	2046.51	36937.0
2008-01-28 15:00:00	NQ	Futures	2046.51	2056.73	2031.47	2056.73	73047.0
2008-01-28 16:00:00	NQ	Futures	2057.02	2060.42	2046.51	2047.36	12089.0
2008-01-28 17:00:00	NQ	Futures	2048.22	2054.46	2047.93	2050.49	1375.0
2008-01-28 18:00:00	NQ	Futures	2050.2	2052.19	2047.93	2050.2	406.0
2008-01-28 19:00:00	NQ	Futures	2049.07	2051.62	2047.93	2049.64	177.0
2008-01-28 20:00:00	NQ	Futures	2049.64	2050.2	2045.09	2046.8	382.0
2008-01-28 21:00:00	NQ	Futures	2045.66	2046.8	2044.24	2045.38	244.0
2008-01-28 22:00:00	NQ	Futures	2044.81	2045.66	2043.39	2045.66	137.0
2008-01-28 23:00:00	NQ	Futures	2045.38	2049.07	2043.39	2043.39	175.0
2008-01-28 00:00:00	YM	Futures	11051.9	11051.9	10987.4	10993.7	920.0
2008-01-28 01:00:00	YM	Futures	10995.6	11029.2	10977.4	11004.6	706.0

> showing 50 of 804 rows — these rows as CSV

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