PREVIEW / futures_1hour / 2008-03-17

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-03-17.parquet
  size:    44 KB
  rows:    1,241

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-03-17 00:00:00	ES	Futures	1176.56	1179.82	1175.16	1175.63	7242.0
2008-03-17 01:00:00	ES	Futures	1175.63	1180.05	1174.46	1178.65	5349.0
2008-03-17 02:00:00	ES	Futures	1178.65	1181.22	1177.02	1177.02	6422.0
2008-03-17 03:00:00	ES	Futures	1177.26	1183.54	1172.14	1174.46	19920.0
2008-03-17 04:00:00	ES	Futures	1174.46	1184.01	1174.23	1174.93	31003.0
2008-03-17 05:00:00	ES	Futures	1174.93	1181.91	1174.0	1180.98	24613.0
2008-03-17 06:00:00	ES	Futures	1180.98	1184.48	1177.96	1181.22	27200.0
2008-03-17 07:00:00	ES	Futures	1181.22	1184.24	1176.79	1179.82	50292.0
2008-03-17 08:00:00	ES	Futures	1180.05	1180.75	1170.04	1173.07	98005.0
2008-03-17 09:00:00	ES	Futures	1172.83	1186.34	1172.14	1183.31	370312.0
2008-03-17 10:00:00	ES	Futures	1183.31	1198.91	1181.91	1192.39	475001.0
2008-03-17 11:00:00	ES	Futures	1192.39	1194.02	1179.35	1179.82	316342.0
2008-03-17 12:00:00	ES	Futures	1179.59	1183.31	1174.0	1181.45	305086.0
2008-03-17 13:00:00	ES	Futures	1181.45	1182.38	1171.44	1181.91	282400.0
2008-03-17 14:00:00	ES	Futures	1182.15	1192.86	1178.89	1189.13	340901.0
2008-03-17 15:00:00	ES	Futures	1189.13	1201.24	1186.57	1188.43	488297.0
2008-03-17 16:00:00	ES	Futures	1188.43	1194.02	1187.27	1191.46	95773.0
2008-03-17 17:00:00	ES	Futures	1191.46	1196.35	1191.0	1195.65	4679.0
2008-03-17 18:00:00	ES	Futures	1194.95	1197.52	1194.72	1197.05	3994.0
2008-03-17 19:00:00	ES	Futures	1197.05	1197.52	1194.49	1194.49	3396.0
2008-03-17 20:00:00	ES	Futures	1194.49	1197.52	1194.26	1196.35	3695.0
2008-03-17 21:00:00	ES	Futures	1196.12	1196.58	1195.42	1196.58	1462.0
2008-03-17 22:00:00	ES	Futures	1196.58	1199.61	1193.79	1194.95	5010.0
2008-03-17 23:00:00	ES	Futures	1194.95	1194.95	1192.63	1192.86	1761.0
2008-03-17 00:00:00	NQ	Futures	1900.33	1905.98	1900.33	1901.74	596.0
2008-03-17 01:00:00	NQ	Futures	1901.74	1909.09	1897.21	1908.24	263.0
2008-03-17 02:00:00	NQ	Futures	1905.7	1911.36	1904.0	1907.68	224.0
2008-03-17 03:00:00	NQ	Futures	1906.83	1921.82	1900.61	1900.61	1075.0
2008-03-17 04:00:00	NQ	Futures	1901.74	1916.73	1901.74	1904.29	1054.0
2008-03-17 05:00:00	NQ	Futures	1904.85	1913.62	1902.87	1913.62	1175.0
2008-03-17 06:00:00	NQ	Futures	1910.22	1918.71	1908.53	1912.49	645.0
2008-03-17 07:00:00	NQ	Futures	1913.05	1919.84	1904.29	1909.38	2412.0
2008-03-17 08:00:00	NQ	Futures	1910.22	1911.07	1896.37	1900.89	12009.0
2008-03-17 09:00:00	NQ	Futures	1900.61	1931.15	1898.06	1919.84	71727.0
2008-03-17 10:00:00	NQ	Futures	1919.84	1938.22	1915.6	1927.19	70541.0
2008-03-17 11:00:00	NQ	Futures	1927.48	1932.85	1908.81	1909.09	58883.0
2008-03-17 12:00:00	NQ	Futures	1909.09	1913.34	1900.89	1908.81	54157.0
2008-03-17 13:00:00	NQ	Futures	1908.81	1911.64	1893.82	1910.51	55910.0
2008-03-17 14:00:00	NQ	Futures	1910.51	1924.65	1901.74	1918.43	64602.0
2008-03-17 15:00:00	NQ	Futures	1918.71	1937.94	1913.9	1914.18	97400.0
2008-03-17 16:00:00	NQ	Futures	1914.18	1925.21	1912.2	1919.84	18733.0
2008-03-17 17:00:00	NQ	Futures	1919.84	1925.21	1919.56	1924.93	368.0
2008-03-17 18:00:00	NQ	Futures	1924.65	1928.33	1923.23	1926.91	418.0
2008-03-17 19:00:00	NQ	Futures	1926.91	1927.19	1924.08	1926.06	183.0
2008-03-17 20:00:00	NQ	Futures	1924.65	1928.61	1924.37	1924.65	165.0
2008-03-17 21:00:00	NQ	Futures	1925.78	1927.48	1924.93	1927.48	41.0
2008-03-17 22:00:00	NQ	Futures	1927.19	1931.72	1921.25	1923.23	252.0
2008-03-17 23:00:00	NQ	Futures	1923.52	1923.52	1919.56	1919.84	66.0
2008-03-17 00:00:00	YM	Futures	10682.1	10710.3	10682.1	10682.1	393.0
2008-03-17 01:00:00	YM	Futures	10682.1	10707.5	10672.1	10702.1	404.0

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

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