PREVIEW / futures_1hour / 2009-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-24.parquet
  size:    45 KB
  rows:    1,302

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-09-24 00:00:00	ES	Futures	1023.14	1023.39	1019.51	1020.0	10279.0
2009-09-24 01:00:00	ES	Futures	1020.24	1023.87	1020.0	1023.63	9303.0
2009-09-24 02:00:00	ES	Futures	1023.63	1025.57	1022.42	1025.08	14589.0
2009-09-24 03:00:00	ES	Futures	1025.08	1025.57	1019.75	1021.93	31909.0
2009-09-24 04:00:00	ES	Futures	1021.93	1023.63	1020.0	1023.14	22137.0
2009-09-24 05:00:00	ES	Futures	1023.14	1027.75	1022.9	1026.78	24219.0
2009-09-24 06:00:00	ES	Futures	1026.78	1027.02	1023.63	1024.11	18389.0
2009-09-24 07:00:00	ES	Futures	1024.11	1026.54	1023.39	1026.05	19742.0
2009-09-24 08:00:00	ES	Futures	1026.29	1030.9	1024.84	1029.44	84475.0
2009-09-24 09:00:00	ES	Futures	1029.68	1029.93	1023.63	1024.11	238826.0
2009-09-24 10:00:00	ES	Futures	1024.11	1024.36	1010.79	1014.42	620928.0
2009-09-24 11:00:00	ES	Futures	1014.67	1016.36	1011.76	1013.46	193529.0
2009-09-24 12:00:00	ES	Futures	1013.21	1014.42	1010.79	1011.28	119072.0
2009-09-24 13:00:00	ES	Futures	1011.28	1014.67	1009.1	1011.03	178767.0
2009-09-24 14:00:00	ES	Futures	1011.03	1014.18	1008.61	1013.7	216557.0
2009-09-24 15:00:00	ES	Futures	1013.7	1016.12	1012.49	1013.46	332568.0
2009-09-24 16:00:00	ES	Futures	1013.46	1013.94	1011.03	1012.0	113992.0
2009-09-24 17:00:00	ES	Futures	1012.0	1012.49	1010.79	1012.0	4259.0
2009-09-24 18:00:00	ES	Futures	1012.24	1012.49	1011.28	1011.76	2308.0
2009-09-24 19:00:00	ES	Futures	1011.52	1012.0	1010.31	1010.79	5449.0
2009-09-24 20:00:00	ES	Futures	1011.03	1011.52	1009.82	1010.55	8105.0
2009-09-24 21:00:00	ES	Futures	1010.55	1013.7	1009.58	1012.97	12150.0
2009-09-24 22:00:00	ES	Futures	1012.97	1013.94	1012.49	1013.21	3768.0
2009-09-24 23:00:00	ES	Futures	1013.46	1013.46	1012.0	1012.73	2667.0
2009-09-24 00:00:00	NQ	Futures	1964.13	1964.13	1956.43	1958.43	1492.0
2009-09-24 01:00:00	NQ	Futures	1958.71	1965.27	1958.71	1964.99	1085.0
2009-09-24 02:00:00	NQ	Futures	1964.7	1967.84	1962.99	1967.27	1091.0
2009-09-24 03:00:00	NQ	Futures	1967.27	1967.84	1958.14	1961.28	3115.0
2009-09-24 04:00:00	NQ	Futures	1961.0	1966.41	1958.14	1965.56	2185.0
2009-09-24 05:00:00	NQ	Futures	1965.27	1972.4	1964.7	1970.69	1671.0
2009-09-24 06:00:00	NQ	Futures	1970.98	1971.55	1966.7	1967.84	979.0
2009-09-24 07:00:00	NQ	Futures	1967.55	1971.83	1966.41	1971.55	1756.0
2009-09-24 08:00:00	NQ	Futures	1971.55	1981.24	1970.12	1979.53	9535.0
2009-09-24 09:00:00	NQ	Futures	1979.25	1980.1	1966.41	1966.41	46140.0
2009-09-24 10:00:00	NQ	Futures	1966.41	1967.55	1934.76	1943.03	89152.0
2009-09-24 11:00:00	NQ	Futures	1943.03	1949.3	1939.32	1941.89	34768.0
2009-09-24 12:00:00	NQ	Futures	1941.89	1945.02	1938.46	1940.18	22878.0
2009-09-24 13:00:00	NQ	Futures	1940.18	1945.59	1936.47	1939.61	26568.0
2009-09-24 14:00:00	NQ	Futures	1939.61	1947.59	1937.32	1947.02	31240.0
2009-09-24 15:00:00	NQ	Futures	1947.31	1952.72	1945.31	1949.59	51195.0
2009-09-24 16:00:00	NQ	Futures	1949.59	1951.01	1936.47	1937.32	22105.0
2009-09-24 17:00:00	NQ	Futures	1937.32	1937.61	1933.9	1935.9	1113.0
2009-09-24 18:00:00	NQ	Futures	1935.9	1936.18	1934.19	1934.47	385.0
2009-09-24 19:00:00	NQ	Futures	1934.76	1935.33	1931.33	1932.48	992.0
2009-09-24 20:00:00	NQ	Futures	1932.76	1934.47	1931.05	1931.91	754.0
2009-09-24 21:00:00	NQ	Futures	1932.19	1938.46	1931.33	1937.04	1449.0
2009-09-24 22:00:00	NQ	Futures	1936.75	1939.04	1936.75	1938.18	403.0
2009-09-24 23:00:00	NQ	Futures	1938.18	1938.75	1936.18	1937.61	335.0
2009-09-24 00:00:00	YM	Futures	9014.4	9016.3	8985.6	8991.2	809.0
2009-09-24 01:00:00	YM	Futures	8993.0	9019.1	8992.1	9018.1	518.0

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

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