PREVIEW / futures_1hour / 2008-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-16.parquet
  size:    47 KB
  rows:    1,283

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
2008-09-16 00:00:00	ES	Futures	1114.38	1117.46	1114.15	1116.28	2957.0
2008-09-16 01:00:00	ES	Futures	1116.28	1124.09	1115.33	1122.9	10261.0
2008-09-16 02:00:00	ES	Futures	1122.9	1128.35	1122.67	1127.16	19720.0
2008-09-16 03:00:00	ES	Futures	1127.16	1130.48	1124.09	1124.56	30414.0
2008-09-16 04:00:00	ES	Futures	1124.8	1128.82	1124.56	1127.64	15025.0
2008-09-16 05:00:00	ES	Futures	1127.4	1136.39	1127.16	1134.97	36199.0
2008-09-16 06:00:00	ES	Futures	1134.97	1135.21	1121.96	1122.67	42329.0
2008-09-16 07:00:00	ES	Futures	1122.67	1123.61	1116.75	1121.72	84241.0
2008-09-16 08:00:00	ES	Futures	1121.72	1124.56	1106.81	1109.41	210796.0
2008-09-16 09:00:00	ES	Futures	1109.41	1122.19	1100.89	1111.54	595188.0
2008-09-16 10:00:00	ES	Futures	1111.78	1138.05	1111.54	1133.08	797759.0
2008-09-16 11:00:00	ES	Futures	1133.08	1141.6	1120.06	1130.71	544504.0
2008-09-16 12:00:00	ES	Futures	1130.95	1136.63	1126.45	1134.26	264443.0
2008-09-16 13:00:00	ES	Futures	1134.5	1137.1	1127.64	1129.77	207587.0
2008-09-16 14:00:00	ES	Futures	1129.77	1147.04	1113.2	1144.2	824361.0
2008-09-16 15:00:00	ES	Futures	1143.96	1152.48	1139.7	1150.83	541870.0
2008-09-16 16:00:00	ES	Futures	1151.06	1155.8	1133.55	1135.44	209371.0
2008-09-16 17:00:00	ES	Futures	1135.44	1144.91	1135.44	1142.07	18339.0
2008-09-16 18:00:00	ES	Futures	1139.7	1141.83	1136.15	1141.36	18786.0
2008-09-16 19:00:00	ES	Futures	1141.36	1163.84	1141.12	1157.45	51773.0
2008-09-16 20:00:00	ES	Futures	1157.45	1162.66	1156.27	1156.27	12145.0
2008-09-16 21:00:00	ES	Futures	1156.51	1162.9	1156.03	1160.06	15670.0
2008-09-16 22:00:00	ES	Futures	1160.06	1161.48	1156.51	1156.74	7036.0
2008-09-16 23:00:00	ES	Futures	1156.74	1156.98	1152.48	1155.32	7565.0
2008-09-16 00:00:00	NQ	Futures	1927.26	1931.22	1926.7	1929.81	193.0
2008-09-16 01:00:00	NQ	Futures	1930.66	1940.0	1930.38	1940.0	763.0
2008-09-16 02:00:00	NQ	Futures	1940.0	1949.9	1939.43	1948.2	1249.0
2008-09-16 03:00:00	NQ	Futures	1947.92	1951.03	1941.13	1941.69	2022.0
2008-09-16 04:00:00	NQ	Futures	1941.98	1947.92	1941.41	1944.52	971.0
2008-09-16 05:00:00	NQ	Futures	1945.37	1966.6	1945.37	1962.35	2968.0
2008-09-16 06:00:00	NQ	Futures	1962.07	1962.63	1949.33	1950.47	1887.0
2008-09-16 07:00:00	NQ	Futures	1949.62	1949.62	1930.94	1943.96	7199.0
2008-09-16 08:00:00	NQ	Futures	1943.96	1944.81	1917.36	1921.6	22349.0
2008-09-16 09:00:00	NQ	Futures	1921.89	1929.53	1912.83	1916.79	101000.0
2008-09-16 10:00:00	NQ	Futures	1917.08	1954.71	1916.23	1951.6	140408.0
2008-09-16 11:00:00	NQ	Futures	1951.6	1962.63	1927.55	1943.96	82949.0
2008-09-16 12:00:00	NQ	Futures	1943.96	1956.41	1940.0	1950.75	44614.0
2008-09-16 13:00:00	NQ	Futures	1950.75	1952.45	1934.9	1939.71	29554.0
2008-09-16 14:00:00	NQ	Futures	1940.0	1963.2	1915.66	1958.67	131089.0
2008-09-16 15:00:00	NQ	Futures	1958.11	1978.76	1949.62	1958.11	79904.0
2008-09-16 16:00:00	NQ	Futures	1957.82	1967.44	1941.69	1941.69	20130.0
2008-09-16 17:00:00	NQ	Futures	1942.83	1956.97	1942.26	1950.75	1298.0
2008-09-16 18:00:00	NQ	Futures	1949.33	1953.01	1946.79	1948.77	525.0
2008-09-16 19:00:00	NQ	Futures	1950.18	1976.22	1950.18	1973.95	3078.0
2008-09-16 20:00:00	NQ	Futures	1973.95	1978.2	1968.86	1969.14	880.0
2008-09-16 21:00:00	NQ	Futures	1969.43	1975.93	1969.43	1974.24	232.0
2008-09-16 22:00:00	NQ	Futures	1973.95	1976.22	1971.12	1971.12	247.0
2008-09-16 23:00:00	NQ	Futures	1971.69	1971.69	1966.03	1969.43	176.0
2008-09-16 00:00:00	YM	Futures	9829.2	9848.3	9824.6	9838.3	267.0
2008-09-16 01:00:00	YM	Futures	9838.3	9895.6	9838.3	9884.7	486.0

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

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