PREVIEW / futures_1hour / 2009-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-06.parquet
  size:    44 KB
  rows:    1,309

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-06 00:00:00	ES	Futures	1004.49	1004.49	1003.52	1003.77	2469.0
2009-10-06 01:00:00	ES	Futures	1003.77	1005.46	1003.52	1005.22	3467.0
2009-10-06 02:00:00	ES	Futures	1004.98	1005.7	1004.01	1005.22	6638.0
2009-10-06 03:00:00	ES	Futures	1005.46	1007.88	1004.49	1007.16	26471.0
2009-10-06 04:00:00	ES	Futures	1006.92	1008.85	1006.92	1008.61	17692.0
2009-10-06 05:00:00	ES	Futures	1008.37	1014.42	1008.37	1012.0	46974.0
2009-10-06 06:00:00	ES	Futures	1012.24	1014.42	1011.52	1013.94	19262.0
2009-10-06 07:00:00	ES	Futures	1013.7	1015.15	1012.97	1013.94	21957.0
2009-10-06 08:00:00	ES	Futures	1013.94	1014.18	1011.28	1012.0	37797.0
2009-10-06 09:00:00	ES	Futures	1012.0	1018.54	1010.06	1017.57	319561.0
2009-10-06 10:00:00	ES	Futures	1017.57	1020.0	1016.36	1019.51	304037.0
2009-10-06 11:00:00	ES	Futures	1019.75	1023.87	1019.03	1020.48	259639.0
2009-10-06 12:00:00	ES	Futures	1020.24	1022.18	1018.3	1018.54	102624.0
2009-10-06 13:00:00	ES	Futures	1018.78	1019.03	1013.94	1015.39	187701.0
2009-10-06 14:00:00	ES	Futures	1015.64	1015.64	1010.31	1014.42	326134.0
2009-10-06 15:00:00	ES	Futures	1014.42	1019.75	1013.7	1018.06	355690.0
2009-10-06 16:00:00	ES	Futures	1018.06	1018.54	1015.64	1016.6	101269.0
2009-10-06 17:00:00	ES	Futures	1016.85	1016.85	1016.12	1016.36	1136.0
2009-10-06 18:00:00	ES	Futures	1016.36	1017.09	1016.12	1016.85	2146.0
2009-10-06 19:00:00	ES	Futures	1016.85	1017.57	1016.85	1017.33	2438.0
2009-10-06 20:00:00	ES	Futures	1017.33	1017.82	1015.88	1016.6	4326.0
2009-10-06 21:00:00	ES	Futures	1016.6	1017.57	1015.39	1015.88	4205.0
2009-10-06 22:00:00	ES	Futures	1015.64	1016.85	1014.91	1016.36	2803.0
2009-10-06 23:00:00	ES	Futures	1016.12	1018.54	1016.12	1018.06	3872.0
2009-10-06 00:00:00	NQ	Futures	1912.51	1913.37	1911.94	1911.94	290.0
2009-10-06 01:00:00	NQ	Futures	1911.94	1915.08	1911.94	1913.94	297.0
2009-10-06 02:00:00	NQ	Futures	1913.65	1914.51	1911.94	1914.22	818.0
2009-10-06 03:00:00	NQ	Futures	1914.22	1917.93	1912.51	1916.5	2575.0
2009-10-06 04:00:00	NQ	Futures	1916.5	1918.79	1916.22	1917.65	1425.0
2009-10-06 05:00:00	NQ	Futures	1917.65	1926.77	1917.65	1922.78	4079.0
2009-10-06 06:00:00	NQ	Futures	1923.06	1926.77	1921.64	1925.63	1224.0
2009-10-06 07:00:00	NQ	Futures	1925.35	1927.63	1923.35	1925.92	2281.0
2009-10-06 08:00:00	NQ	Futures	1925.63	1925.92	1920.21	1920.78	4038.0
2009-10-06 09:00:00	NQ	Futures	1920.78	1938.46	1918.22	1936.75	58595.0
2009-10-06 10:00:00	NQ	Futures	1936.75	1946.45	1936.18	1943.6	63303.0
2009-10-06 11:00:00	NQ	Futures	1943.6	1952.15	1942.74	1944.45	40282.0
2009-10-06 12:00:00	NQ	Futures	1944.45	1949.59	1943.31	1943.88	20742.0
2009-10-06 13:00:00	NQ	Futures	1943.6	1945.31	1934.76	1937.04	28615.0
2009-10-06 14:00:00	NQ	Futures	1937.04	1937.32	1923.35	1933.62	53026.0
2009-10-06 15:00:00	NQ	Futures	1933.9	1944.17	1932.48	1942.74	47938.0
2009-10-06 16:00:00	NQ	Futures	1942.74	1943.31	1939.04	1941.6	14624.0
2009-10-06 17:00:00	NQ	Futures	1941.6	1941.89	1940.18	1940.18	32.0
2009-10-06 18:00:00	NQ	Futures	1940.75	1941.6	1940.75	1941.6	85.0
2009-10-06 19:00:00	NQ	Futures	1941.32	1942.46	1941.03	1942.46	140.0
2009-10-06 20:00:00	NQ	Futures	1942.46	1943.03	1939.61	1940.46	614.0
2009-10-06 21:00:00	NQ	Futures	1940.75	1942.46	1938.46	1939.04	404.0
2009-10-06 22:00:00	NQ	Futures	1939.04	1941.03	1937.32	1940.46	313.0
2009-10-06 23:00:00	NQ	Futures	1940.18	1943.88	1939.89	1943.03	376.0
2009-10-06 00:00:00	YM	Futures	8875.8	8875.8	8863.7	8865.6	1117.0
2009-10-06 01:00:00	YM	Futures	8866.5	8882.3	8865.6	8877.7	401.0

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

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