PREVIEW / futures_1hour / 2009-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-16.parquet
  size:    44 KB
  rows:    1,304

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-16 00:00:00	ES	Futures	1015.39	1015.88	1013.21	1013.7	3863.0
2009-09-16 01:00:00	ES	Futures	1013.46	1015.39	1012.97	1015.39	3947.0
2009-09-16 02:00:00	ES	Futures	1015.15	1016.12	1014.91	1015.88	8218.0
2009-09-16 03:00:00	ES	Futures	1015.64	1017.82	1015.39	1016.85	35349.0
2009-09-16 04:00:00	ES	Futures	1016.85	1017.82	1016.12	1016.85	12785.0
2009-09-16 05:00:00	ES	Futures	1016.85	1018.3	1016.6	1017.82	11831.0
2009-09-16 06:00:00	ES	Futures	1017.82	1019.03	1017.33	1018.78	11572.0
2009-09-16 07:00:00	ES	Futures	1018.54	1019.51	1017.09	1018.54	19199.0
2009-09-16 08:00:00	ES	Futures	1018.54	1019.03	1016.36	1018.78	34236.0
2009-09-16 09:00:00	ES	Futures	1018.54	1020.72	1015.15	1017.33	312406.0
2009-09-16 10:00:00	ES	Futures	1017.33	1022.66	1017.33	1021.93	406327.0
2009-09-16 11:00:00	ES	Futures	1021.69	1025.81	1020.48	1025.57	270663.0
2009-09-16 12:00:00	ES	Futures	1025.57	1027.5	1025.32	1025.81	192396.0
2009-09-16 13:00:00	ES	Futures	1025.81	1030.17	1025.57	1028.72	195322.0
2009-09-16 14:00:00	ES	Futures	1028.96	1030.65	1027.5	1027.75	246542.0
2009-09-16 15:00:00	ES	Futures	1027.75	1030.9	1026.78	1030.65	287766.0
2009-09-16 16:00:00	ES	Futures	1030.65	1030.9	1029.44	1030.17	124282.0
2009-09-16 17:00:00	ES	Futures	1030.17	1031.62	1029.93	1030.41	3824.0
2009-09-16 18:00:00	ES	Futures	1030.41	1030.9	1029.44	1029.93	2552.0
2009-09-16 19:00:00	ES	Futures	1029.93	1031.62	1029.93	1031.14	2580.0
2009-09-16 20:00:00	ES	Futures	1031.14	1031.38	1030.65	1030.9	2480.0
2009-09-16 21:00:00	ES	Futures	1030.9	1031.38	1030.65	1030.9	1812.0
2009-09-16 22:00:00	ES	Futures	1030.65	1031.62	1030.41	1030.41	3942.0
2009-09-16 23:00:00	ES	Futures	1030.41	1031.38	1030.17	1030.65	2727.0
2009-09-16 00:00:00	NQ	Futures	1937.89	1939.04	1934.19	1934.47	453.0
2009-09-16 01:00:00	NQ	Futures	1934.47	1937.32	1933.33	1937.04	498.0
2009-09-16 02:00:00	NQ	Futures	1936.75	1937.89	1935.9	1937.32	411.0
2009-09-16 03:00:00	NQ	Futures	1937.04	1941.32	1937.04	1939.32	1930.0
2009-09-16 04:00:00	NQ	Futures	1939.04	1940.46	1937.89	1939.32	867.0
2009-09-16 05:00:00	NQ	Futures	1939.61	1942.17	1938.75	1939.32	1752.0
2009-09-16 06:00:00	NQ	Futures	1939.04	1941.6	1938.18	1940.46	817.0
2009-09-16 07:00:00	NQ	Futures	1940.75	1943.31	1936.47	1940.75	2485.0
2009-09-16 08:00:00	NQ	Futures	1940.46	1943.31	1937.61	1942.46	4172.0
2009-09-16 09:00:00	NQ	Futures	1942.17	1945.59	1936.47	1940.75	41669.0
2009-09-16 10:00:00	NQ	Futures	1940.75	1946.74	1938.18	1945.31	47672.0
2009-09-16 11:00:00	NQ	Futures	1945.59	1953.29	1942.74	1952.72	37773.0
2009-09-16 12:00:00	NQ	Futures	1952.72	1962.71	1951.87	1954.72	42795.0
2009-09-16 13:00:00	NQ	Futures	1954.72	1964.42	1954.72	1961.85	28380.0
2009-09-16 14:00:00	NQ	Futures	1961.85	1966.13	1959.85	1959.85	30052.0
2009-09-16 15:00:00	NQ	Futures	1959.57	1964.99	1958.71	1963.28	36186.0
2009-09-16 16:00:00	NQ	Futures	1963.28	1963.28	1957.57	1958.14	17658.0
2009-09-16 17:00:00	NQ	Futures	1958.14	1959.85	1958.14	1959.0	388.0
2009-09-16 18:00:00	NQ	Futures	1959.57	1960.71	1958.43	1958.43	647.0
2009-09-16 19:00:00	NQ	Futures	1958.71	1961.57	1958.43	1961.57	225.0
2009-09-16 20:00:00	NQ	Futures	1961.28	1962.14	1959.28	1960.14	578.0
2009-09-16 21:00:00	NQ	Futures	1960.42	1960.71	1959.57	1959.85	179.0
2009-09-16 22:00:00	NQ	Futures	1959.85	1961.57	1959.57	1959.57	355.0
2009-09-16 23:00:00	NQ	Futures	1959.28	1961.28	1959.0	1959.85	338.0
2009-09-16 00:00:00	YM	Futures	8954.9	8956.7	8937.2	8940.0	368.0
2009-09-16 01:00:00	YM	Futures	8939.1	8952.1	8935.4	8950.2	478.0

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

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