PREVIEW / futures_1hour / 2009-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-29.parquet
  size:    47 KB
  rows:    1,371

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-10-29 00:00:00	ES	Futures	1007.64	1009.1	1007.4	1008.85	3008.0
2009-10-29 01:00:00	ES	Futures	1008.85	1009.34	1007.88	1008.37	3674.0
2009-10-29 02:00:00	ES	Futures	1008.13	1008.37	1006.43	1007.88	4436.0
2009-10-29 03:00:00	ES	Futures	1007.64	1011.03	1007.64	1010.31	17906.0
2009-10-29 04:00:00	ES	Futures	1010.06	1011.76	1007.88	1010.31	42550.0
2009-10-29 05:00:00	ES	Futures	1010.31	1011.76	1009.58	1011.28	20109.0
2009-10-29 06:00:00	ES	Futures	1011.52	1011.52	1009.34	1011.28	18723.0
2009-10-29 07:00:00	ES	Futures	1011.03	1011.76	1008.85	1009.58	29814.0
2009-10-29 08:00:00	ES	Futures	1009.58	1017.09	1007.64	1017.09	174147.0
2009-10-29 09:00:00	ES	Futures	1017.09	1017.33	1012.24	1015.64	338297.0
2009-10-29 10:00:00	ES	Futures	1015.64	1021.45	1014.67	1019.51	387524.0
2009-10-29 11:00:00	ES	Futures	1019.51	1021.93	1019.27	1020.72	203194.0
2009-10-29 12:00:00	ES	Futures	1020.72	1026.78	1020.0	1025.32	234796.0
2009-10-29 13:00:00	ES	Futures	1025.32	1027.5	1024.36	1026.29	149624.0
2009-10-29 14:00:00	ES	Futures	1026.29	1029.2	1025.08	1028.96	157617.0
2009-10-29 15:00:00	ES	Futures	1028.96	1030.9	1025.81	1028.47	366134.0
2009-10-29 16:00:00	ES	Futures	1028.47	1028.96	1027.02	1027.26	100912.0
2009-10-29 17:00:00	ES	Futures	1027.02	1028.47	1027.02	1028.23	1711.0
2009-10-29 18:00:00	ES	Futures	1028.47	1029.68	1028.23	1029.2	3940.0
2009-10-29 19:00:00	ES	Futures	1029.2	1029.68	1027.75	1028.23	3393.0
2009-10-29 20:00:00	ES	Futures	1028.23	1028.72	1026.54	1027.26	4663.0
2009-10-29 21:00:00	ES	Futures	1027.26	1027.5	1026.78	1027.5	1980.0
2009-10-29 22:00:00	ES	Futures	1027.26	1027.75	1026.54	1027.26	1993.0
2009-10-29 23:00:00	ES	Futures	1027.02	1028.47	1027.02	1028.23	2754.0
2009-10-29 00:00:00	NQ	Futures	1918.22	1919.64	1917.93	1919.36	181.0
2009-10-29 01:00:00	NQ	Futures	1919.64	1920.78	1918.5	1919.07	208.0
2009-10-29 02:00:00	NQ	Futures	1918.79	1918.79	1916.5	1918.79	326.0
2009-10-29 03:00:00	NQ	Futures	1918.5	1922.78	1918.5	1921.64	1376.0
2009-10-29 04:00:00	NQ	Futures	1921.92	1924.2	1918.22	1922.21	3249.0
2009-10-29 05:00:00	NQ	Futures	1921.92	1923.63	1920.5	1923.06	1240.0
2009-10-29 06:00:00	NQ	Futures	1923.35	1923.63	1919.36	1921.92	1158.0
2009-10-29 07:00:00	NQ	Futures	1921.92	1923.63	1918.5	1919.36	2485.0
2009-10-29 08:00:00	NQ	Futures	1919.36	1938.75	1916.79	1937.89	13154.0
2009-10-29 09:00:00	NQ	Futures	1938.18	1938.75	1924.2	1931.91	52811.0
2009-10-29 10:00:00	NQ	Futures	1932.19	1944.45	1931.05	1942.46	52911.0
2009-10-29 11:00:00	NQ	Futures	1942.17	1945.59	1939.32	1941.6	30866.0
2009-10-29 12:00:00	NQ	Futures	1941.6	1949.02	1939.89	1945.59	25296.0
2009-10-29 13:00:00	NQ	Futures	1945.31	1947.88	1942.46	1945.59	21086.0
2009-10-29 14:00:00	NQ	Futures	1945.59	1951.87	1942.74	1951.01	24587.0
2009-10-29 15:00:00	NQ	Futures	1950.73	1954.15	1945.31	1949.59	50819.0
2009-10-29 16:00:00	NQ	Futures	1949.87	1949.87	1945.59	1945.88	12290.0
2009-10-29 17:00:00	NQ	Futures	1945.88	1948.16	1945.59	1947.88	169.0
2009-10-29 18:00:00	NQ	Futures	1948.16	1950.16	1948.16	1950.16	321.0
2009-10-29 19:00:00	NQ	Futures	1949.87	1950.44	1947.59	1948.45	210.0
2009-10-29 20:00:00	NQ	Futures	1948.45	1948.45	1944.45	1946.16	288.0
2009-10-29 21:00:00	NQ	Futures	1946.16	1946.45	1945.02	1946.45	133.0
2009-10-29 22:00:00	NQ	Futures	1946.45	1947.02	1945.31	1946.16	201.0
2009-10-29 23:00:00	NQ	Futures	1945.88	1948.16	1945.88	1948.16	152.0
2009-10-29 00:00:00	YM	Futures	9044.2	9056.3	9044.2	9053.5	266.0
2009-10-29 01:00:00	YM	Futures	9054.4	9058.1	9047.9	9048.8	275.0

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

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