PREVIEW / futures_1hour / 2009-10-07

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-07.parquet
  size:    45 KB
  rows:    1,336

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-07 00:00:00	ES	Futures	1018.3	1021.21	1017.57	1019.03	5337.0
2009-10-07 01:00:00	ES	Futures	1019.03	1020.0	1018.54	1018.78	2309.0
2009-10-07 02:00:00	ES	Futures	1018.78	1020.0	1018.06	1019.51	5385.0
2009-10-07 03:00:00	ES	Futures	1019.27	1021.93	1016.85	1020.48	27687.0
2009-10-07 04:00:00	ES	Futures	1020.48	1021.69	1019.51	1020.72	21042.0
2009-10-07 05:00:00	ES	Futures	1020.48	1021.69	1019.51	1020.0	12650.0
2009-10-07 06:00:00	ES	Futures	1020.0	1020.72	1017.57	1017.57	13100.0
2009-10-07 07:00:00	ES	Futures	1017.33	1018.78	1016.12	1016.85	19745.0
2009-10-07 08:00:00	ES	Futures	1017.09	1017.33	1012.73	1013.7	56199.0
2009-10-07 09:00:00	ES	Futures	1013.46	1019.27	1013.21	1017.09	265867.0
2009-10-07 10:00:00	ES	Futures	1017.09	1020.48	1015.39	1018.54	334716.0
2009-10-07 11:00:00	ES	Futures	1018.78	1021.69	1015.15	1015.15	182267.0
2009-10-07 12:00:00	ES	Futures	1015.15	1018.54	1014.91	1018.54	101782.0
2009-10-07 13:00:00	ES	Futures	1018.54	1018.78	1016.12	1017.82	97981.0
2009-10-07 14:00:00	ES	Futures	1017.82	1018.78	1014.91	1018.06	158258.0
2009-10-07 15:00:00	ES	Futures	1018.06	1021.45	1016.6	1020.72	269910.0
2009-10-07 16:00:00	ES	Futures	1020.72	1025.81	1019.27	1023.87	103798.0
2009-10-07 17:00:00	ES	Futures	1023.87	1024.11	1022.9	1024.11	3012.0
2009-10-07 18:00:00	ES	Futures	1023.87	1024.6	1023.63	1023.87	4315.0
2009-10-07 19:00:00	ES	Futures	1023.87	1026.78	1023.39	1025.81	8349.0
2009-10-07 20:00:00	ES	Futures	1025.81	1031.38	1024.84	1028.47	26722.0
2009-10-07 21:00:00	ES	Futures	1028.47	1031.38	1028.47	1030.65	15423.0
2009-10-07 22:00:00	ES	Futures	1030.65	1030.9	1029.44	1029.93	5688.0
2009-10-07 23:00:00	ES	Futures	1029.93	1030.65	1029.44	1029.68	2618.0
2009-10-07 00:00:00	NQ	Futures	1942.74	1948.16	1941.89	1944.45	654.0
2009-10-07 01:00:00	NQ	Futures	1944.74	1945.88	1943.03	1943.31	186.0
2009-10-07 02:00:00	NQ	Futures	1943.6	1945.88	1942.74	1945.02	507.0
2009-10-07 03:00:00	NQ	Futures	1945.02	1948.16	1940.46	1946.45	3593.0
2009-10-07 04:00:00	NQ	Futures	1947.02	1948.73	1945.02	1947.88	1682.0
2009-10-07 05:00:00	NQ	Futures	1947.31	1949.02	1946.74	1947.88	1336.0
2009-10-07 06:00:00	NQ	Futures	1947.88	1948.73	1943.31	1943.6	739.0
2009-10-07 07:00:00	NQ	Futures	1943.88	1945.02	1941.03	1942.46	1291.0
2009-10-07 08:00:00	NQ	Futures	1942.46	1943.03	1934.76	1936.47	4088.0
2009-10-07 09:00:00	NQ	Futures	1936.47	1945.88	1935.04	1940.75	41797.0
2009-10-07 10:00:00	NQ	Futures	1940.75	1949.3	1937.61	1944.45	53682.0
2009-10-07 11:00:00	NQ	Futures	1944.45	1949.02	1938.46	1938.75	26527.0
2009-10-07 12:00:00	NQ	Futures	1938.75	1945.88	1938.46	1944.74	19123.0
2009-10-07 13:00:00	NQ	Futures	1944.74	1945.31	1940.18	1942.17	11199.0
2009-10-07 14:00:00	NQ	Futures	1942.17	1944.45	1936.18	1943.31	20652.0
2009-10-07 15:00:00	NQ	Futures	1943.31	1949.3	1940.75	1948.45	36443.0
2009-10-07 16:00:00	NQ	Futures	1948.73	1955.86	1946.74	1952.44	11266.0
2009-10-07 17:00:00	NQ	Futures	1951.87	1953.58	1950.73	1953.01	390.0
2009-10-07 18:00:00	NQ	Futures	1953.58	1954.44	1952.72	1953.58	356.0
2009-10-07 19:00:00	NQ	Futures	1953.01	1958.14	1953.01	1956.72	459.0
2009-10-07 20:00:00	NQ	Futures	1956.72	1964.99	1955.58	1961.28	2505.0
2009-10-07 21:00:00	NQ	Futures	1961.85	1966.13	1961.28	1964.99	1068.0
2009-10-07 22:00:00	NQ	Futures	1964.99	1965.56	1963.28	1963.56	948.0
2009-10-07 23:00:00	NQ	Futures	1963.56	1964.99	1962.99	1963.28	226.0
2009-10-07 00:00:00	YM	Futures	8995.8	9019.1	8991.2	9004.2	570.0
2009-10-07 01:00:00	YM	Futures	9006.0	9008.8	8997.7	9001.4	152.0

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

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