PREVIEW / futures_1hour / 2015-10-01

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-01.parquet
  size:    52 KB
  rows:    1,578

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
2015-10-01 00:00:00	ES	Futures	2059.0	2061.68	2058.2	2059.54	8303.0
2015-10-01 01:00:00	ES	Futures	2059.54	2061.14	2058.2	2059.54	6771.0
2015-10-01 02:00:00	ES	Futures	2059.8	2064.09	2057.4	2063.02	20702.0
2015-10-01 03:00:00	ES	Futures	2063.28	2065.16	2060.07	2063.02	25026.0
2015-10-01 04:00:00	ES	Futures	2063.02	2063.28	2055.52	2058.2	25086.0
2015-10-01 05:00:00	ES	Futures	2058.2	2061.95	2057.4	2057.93	21499.0
2015-10-01 06:00:00	ES	Futures	2057.93	2059.0	2053.38	2056.86	26290.0
2015-10-01 07:00:00	ES	Futures	2056.59	2057.66	2045.89	2046.43	63988.0
2015-10-01 08:00:00	ES	Futures	2046.16	2049.1	2043.48	2045.62	69724.0
2015-10-01 09:00:00	ES	Futures	2045.89	2052.05	2036.26	2036.79	255337.0
2015-10-01 10:00:00	ES	Futures	2037.06	2046.96	2031.71	2035.46	355260.0
2015-10-01 11:00:00	ES	Futures	2035.46	2039.74	2026.63	2029.3	268392.0
2015-10-01 12:00:00	ES	Futures	2029.3	2031.98	2023.15	2029.84	175325.0
2015-10-01 13:00:00	ES	Futures	2029.84	2035.19	2024.75	2034.65	149457.0
2015-10-01 14:00:00	ES	Futures	2034.65	2045.09	2032.51	2043.75	181194.0
2015-10-01 15:00:00	ES	Futures	2043.75	2049.37	2037.06	2048.03	245180.0
2015-10-01 16:00:00	ES	Futures	2048.3	2053.65	2047.76	2052.05	63499.0
2015-10-01 18:00:00	ES	Futures	2051.78	2052.85	2050.97	2052.31	3544.0
2015-10-01 19:00:00	ES	Futures	2052.31	2054.72	2049.9	2050.71	4813.0
2015-10-01 20:00:00	ES	Futures	2050.71	2058.2	2050.44	2053.92	11818.0
2015-10-01 21:00:00	ES	Futures	2054.19	2056.59	2052.58	2054.19	7107.0
2015-10-01 22:00:00	ES	Futures	2054.19	2056.06	2052.85	2054.45	4690.0
2015-10-01 23:00:00	ES	Futures	2054.45	2054.72	2050.71	2052.05	4953.0
2015-10-01 00:00:00	NQ	Futures	4989.65	4996.76	4987.87	4989.05	2213.0
2015-10-01 01:00:00	NQ	Futures	4989.65	4995.58	4987.57	4991.13	1888.0
2015-10-01 02:00:00	NQ	Futures	4990.83	5005.66	4985.5	5004.77	5381.0
2015-10-01 03:00:00	NQ	Futures	5005.06	5011.59	4998.84	5005.36	6003.0
2015-10-01 04:00:00	NQ	Futures	5005.95	5005.95	4981.94	4989.05	4840.0
2015-10-01 05:00:00	NQ	Futures	4988.76	4998.54	4985.2	4985.79	2806.0
2015-10-01 06:00:00	NQ	Futures	4985.2	4988.76	4973.34	4982.24	3767.0
2015-10-01 07:00:00	NQ	Futures	4982.24	4984.61	4951.7	4953.48	8858.0
2015-10-01 08:00:00	NQ	Futures	4953.48	4959.7	4941.62	4945.77	12848.0
2015-10-01 09:00:00	NQ	Futures	4945.47	4954.07	4899.22	4901.29	50945.0
2015-10-01 10:00:00	NQ	Futures	4901.59	4935.69	4887.36	4907.22	68366.0
2015-10-01 11:00:00	NQ	Futures	4907.22	4922.94	4892.4	4900.7	43467.0
2015-10-01 12:00:00	NQ	Futures	4900.7	4913.45	4881.72	4904.26	30914.0
2015-10-01 13:00:00	NQ	Futures	4903.96	4913.45	4886.77	4912.86	26556.0
2015-10-01 14:00:00	NQ	Futures	4912.56	4943.69	4906.04	4940.13	36334.0
2015-10-01 15:00:00	NQ	Futures	4940.43	4960.89	4927.09	4958.81	38253.0
2015-10-01 16:00:00	NQ	Futures	4959.11	4971.86	4958.81	4970.38	7691.0
2015-10-01 18:00:00	NQ	Futures	4967.11	4971.56	4965.93	4970.38	489.0
2015-10-01 19:00:00	NQ	Futures	4970.97	4976.6	4966.22	4968.0	926.0
2015-10-01 20:00:00	NQ	Futures	4968.0	4987.87	4967.41	4976.9	2493.0
2015-10-01 21:00:00	NQ	Futures	4977.79	4982.83	4973.93	4977.79	2326.0
2015-10-01 22:00:00	NQ	Futures	4978.08	4983.42	4974.82	4978.68	1853.0
2015-10-01 23:00:00	NQ	Futures	4978.08	4979.86	4969.49	4973.93	734.0
2015-10-01 00:00:00	YM	Futures	17256.3	17280.7	17252.1	17269.0	1081.0
2015-10-01 01:00:00	YM	Futures	17269.0	17279.6	17257.4	17267.9	1201.0
2015-10-01 02:00:00	YM	Futures	17266.9	17300.8	17248.9	17292.3	2798.0
2015-10-01 03:00:00	YM	Futures	17294.4	17313.5	17272.2	17299.7	3804.0

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

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