PREVIEW / futures_1hour / 2009-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-24.parquet
  size:    43 KB
  rows:    1,313

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
2009-11-24 00:00:00	ES	Futures	1066.99	1067.71	1066.74	1067.23	4120.0
2009-11-24 01:00:00	ES	Futures	1067.23	1067.47	1065.05	1065.53	16333.0
2009-11-24 02:00:00	ES	Futures	1065.53	1066.74	1064.81	1066.26	13829.0
2009-11-24 03:00:00	ES	Futures	1066.02	1067.71	1065.78	1067.23	16715.0
2009-11-24 04:00:00	ES	Futures	1066.99	1068.68	1066.99	1067.96	12670.0
2009-11-24 05:00:00	ES	Futures	1067.96	1072.07	1067.96	1071.59	22755.0
2009-11-24 06:00:00	ES	Futures	1071.83	1072.32	1070.14	1070.38	12115.0
2009-11-24 07:00:00	ES	Futures	1070.38	1072.32	1070.14	1071.83	24876.0
2009-11-24 08:00:00	ES	Futures	1072.07	1072.56	1069.17	1070.62	55593.0
2009-11-24 09:00:00	ES	Futures	1070.62	1072.32	1062.14	1065.29	265858.0
2009-11-24 10:00:00	ES	Futures	1065.29	1070.38	1060.93	1068.92	381626.0
2009-11-24 11:00:00	ES	Futures	1069.17	1069.65	1065.05	1067.47	161351.0
2009-11-24 12:00:00	ES	Futures	1067.47	1068.2	1065.78	1066.02	79556.0
2009-11-24 13:00:00	ES	Futures	1066.26	1068.44	1066.02	1067.71	67586.0
2009-11-24 14:00:00	ES	Futures	1067.96	1072.32	1066.5	1071.35	185424.0
2009-11-24 15:00:00	ES	Futures	1071.1	1071.83	1068.2	1070.38	164902.0
2009-11-24 16:00:00	ES	Futures	1070.38	1070.38	1068.44	1069.17	72377.0
2009-11-24 17:00:00	ES	Futures	1069.17	1069.41	1068.44	1068.68	1630.0
2009-11-24 18:00:00	ES	Futures	1068.92	1069.41	1067.96	1068.92	3540.0
2009-11-24 19:00:00	ES	Futures	1068.92	1070.62	1068.44	1068.68	5184.0
2009-11-24 20:00:00	ES	Futures	1068.68	1070.38	1068.44	1069.65	4747.0
2009-11-24 21:00:00	ES	Futures	1069.65	1070.38	1069.17	1069.89	3408.0
2009-11-24 22:00:00	ES	Futures	1069.89	1070.62	1068.92	1070.38	2523.0
2009-11-24 23:00:00	ES	Futures	1070.38	1070.86	1070.14	1070.86	3065.0
2009-11-24 00:00:00	NQ	Futures	2037.14	2038.28	2036.86	2037.43	106.0
2009-11-24 01:00:00	NQ	Futures	2037.14	2037.43	2033.15	2033.72	586.0
2009-11-24 02:00:00	NQ	Futures	2034.0	2036.0	2032.58	2035.72	630.0
2009-11-24 03:00:00	NQ	Futures	2035.43	2038.0	2034.29	2036.86	1701.0
2009-11-24 04:00:00	NQ	Futures	2037.14	2039.14	2036.29	2037.71	1012.0
2009-11-24 05:00:00	NQ	Futures	2038.0	2044.84	2037.71	2044.27	1912.0
2009-11-24 06:00:00	NQ	Futures	2044.27	2045.41	2041.13	2041.7	1313.0
2009-11-24 07:00:00	NQ	Futures	2041.7	2045.7	2041.13	2044.84	1840.0
2009-11-24 08:00:00	NQ	Futures	2044.84	2045.98	2039.14	2041.7	5507.0
2009-11-24 09:00:00	NQ	Futures	2041.7	2046.27	2026.3	2030.87	41766.0
2009-11-24 10:00:00	NQ	Futures	2030.87	2038.85	2025.73	2035.72	50002.0
2009-11-24 11:00:00	NQ	Futures	2036.0	2038.0	2030.01	2033.15	27646.0
2009-11-24 12:00:00	NQ	Futures	2033.15	2033.72	2028.87	2029.73	18246.0
2009-11-24 13:00:00	NQ	Futures	2029.73	2034.58	2029.44	2032.29	9881.0
2009-11-24 14:00:00	NQ	Futures	2032.58	2041.13	2030.87	2039.99	24678.0
2009-11-24 15:00:00	NQ	Futures	2039.71	2041.7	2035.15	2037.43	25282.0
2009-11-24 16:00:00	NQ	Futures	2037.43	2038.85	2036.57	2038.28	6944.0
2009-11-24 17:00:00	NQ	Futures	2038.28	2038.28	2036.86	2037.71	326.0
2009-11-24 18:00:00	NQ	Futures	2038.57	2039.14	2036.86	2037.71	132.0
2009-11-24 19:00:00	NQ	Futures	2038.0	2041.13	2037.71	2038.0	544.0
2009-11-24 20:00:00	NQ	Futures	2038.0	2041.13	2037.43	2039.42	552.0
2009-11-24 21:00:00	NQ	Futures	2039.42	2041.42	2039.42	2039.99	349.0
2009-11-24 22:00:00	NQ	Futures	2039.42	2041.7	2038.85	2041.42	200.0
2009-11-24 23:00:00	NQ	Futures	2041.13	2042.28	2040.85	2041.99	217.0
2009-11-24 00:00:00	YM	Futures	9670.2	9675.8	9668.3	9673.0	310.0
2009-11-24 01:00:00	YM	Futures	9673.0	9673.9	9655.3	9661.8	1415.0

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

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