PREVIEW / futures_1hour / 2009-09-25

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-25.parquet
  size:    37 KB
  rows:    1,047

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-25 00:00:00	ES	Futures	1012.73	1016.85	1012.24	1016.6	8394.0
2009-09-25 01:00:00	ES	Futures	1016.6	1016.85	1014.42	1014.67	4180.0
2009-09-25 02:00:00	ES	Futures	1014.67	1016.6	1013.94	1014.91	8690.0
2009-09-25 03:00:00	ES	Futures	1014.91	1016.12	1012.49	1013.46	25622.0
2009-09-25 04:00:00	ES	Futures	1013.21	1014.67	1011.28	1014.18	16792.0
2009-09-25 05:00:00	ES	Futures	1014.18	1015.64	1012.73	1015.15	10229.0
2009-09-25 06:00:00	ES	Futures	1015.15	1016.36	1013.94	1014.67	12210.0
2009-09-25 07:00:00	ES	Futures	1014.67	1015.88	1013.94	1015.39	12776.0
2009-09-25 08:00:00	ES	Futures	1015.15	1015.39	1007.4	1009.82	94647.0
2009-09-25 09:00:00	ES	Futures	1009.58	1015.64	1008.61	1013.46	258538.0
2009-09-25 10:00:00	ES	Futures	1013.46	1016.36	1009.82	1012.0	361382.0
2009-09-25 11:00:00	ES	Futures	1011.76	1013.46	1008.37	1008.85	207239.0
2009-09-25 12:00:00	ES	Futures	1009.1	1009.82	1004.49	1005.46	216691.0
2009-09-25 13:00:00	ES	Futures	1005.7	1010.31	1004.01	1009.82	165676.0
2009-09-25 14:00:00	ES	Futures	1010.06	1012.24	1008.37	1012.0	146361.0
2009-09-25 15:00:00	ES	Futures	1012.0	1012.24	1006.92	1008.13	213663.0
2009-09-25 16:00:00	ES	Futures	1008.13	1009.1	1007.4	1008.85	76612.0
2009-09-25 00:00:00	NQ	Futures	1937.61	1945.59	1936.75	1944.74	794.0
2009-09-25 01:00:00	NQ	Futures	1944.74	1946.16	1941.89	1942.46	801.0
2009-09-25 02:00:00	NQ	Futures	1942.17	1946.45	1942.17	1943.6	1297.0
2009-09-25 03:00:00	NQ	Futures	1943.88	1945.59	1939.04	1940.18	3494.0
2009-09-25 04:00:00	NQ	Futures	1939.89	1943.6	1937.61	1942.46	2090.0
2009-09-25 05:00:00	NQ	Futures	1942.17	1943.03	1938.46	1941.89	2343.0
2009-09-25 06:00:00	NQ	Futures	1941.6	1944.74	1938.46	1939.89	2530.0
2009-09-25 07:00:00	NQ	Futures	1939.61	1944.45	1938.75	1941.32	1007.0
2009-09-25 08:00:00	NQ	Futures	1941.32	1941.89	1929.05	1935.33	8871.0
2009-09-25 09:00:00	NQ	Futures	1935.61	1949.59	1934.47	1943.88	47404.0
2009-09-25 10:00:00	NQ	Futures	1943.88	1948.45	1936.18	1939.89	59688.0
2009-09-25 11:00:00	NQ	Futures	1939.61	1942.74	1933.9	1935.04	38750.0
2009-09-25 12:00:00	NQ	Futures	1934.76	1935.33	1927.63	1929.91	38334.0
2009-09-25 13:00:00	NQ	Futures	1930.19	1938.46	1926.49	1938.46	25948.0
2009-09-25 14:00:00	NQ	Futures	1938.46	1940.46	1934.19	1939.89	25928.0
2009-09-25 15:00:00	NQ	Futures	1940.18	1941.03	1929.91	1931.62	34561.0
2009-09-25 16:00:00	NQ	Futures	1931.62	1936.47	1931.05	1935.9	9500.0
2009-09-25 00:00:00	YM	Futures	8964.2	8998.6	8964.2	8996.7	530.0
2009-09-25 01:00:00	YM	Futures	8996.7	9001.4	8984.7	8985.6	687.0
2009-09-25 02:00:00	YM	Futures	8985.6	9001.4	8980.0	8988.4	915.0
2009-09-25 03:00:00	YM	Futures	8987.4	8997.7	8967.9	8973.5	1951.0
2009-09-25 04:00:00	YM	Futures	8974.4	8984.7	8958.6	8975.4	1047.0
2009-09-25 05:00:00	YM	Futures	8977.2	8989.3	8969.8	8989.3	612.0
2009-09-25 06:00:00	YM	Futures	8989.3	8998.6	8979.1	8981.9	1040.0
2009-09-25 07:00:00	YM	Futures	8981.9	8994.9	8978.1	8989.3	698.0
2009-09-25 08:00:00	YM	Futures	8989.3	8990.2	8930.7	8944.7	4349.0
2009-09-25 09:00:00	YM	Futures	8944.7	8993.0	8939.1	8974.4	19595.0
2009-09-25 10:00:00	YM	Futures	8975.4	8998.6	8943.7	8964.2	31718.0
2009-09-25 11:00:00	YM	Futures	8964.2	8978.1	8938.1	8944.7	17415.0
2009-09-25 12:00:00	YM	Futures	8944.7	8952.1	8909.3	8917.7	16026.0
2009-09-25 13:00:00	YM	Futures	8917.7	8954.9	8907.4	8954.0	12090.0
2009-09-25 14:00:00	YM	Futures	8954.0	8976.3	8943.7	8972.6	14420.0
2009-09-25 15:00:00	YM	Futures	8972.6	8972.6	8926.1	8938.1	16454.0

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

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