PREVIEW / futures_1hour / 2015-09-01

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-01.parquet
  size:    53 KB
  rows:    1,579

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-09-01 00:00:00	ES	Futures	2062.89	2067.68	2062.89	2066.09	12636.0
2015-09-01 01:00:00	ES	Futures	2065.82	2067.15	2059.43	2059.7	13879.0
2015-09-01 02:00:00	ES	Futures	2059.96	2065.29	2057.83	2065.02	25228.0
2015-09-01 03:00:00	ES	Futures	2065.02	2069.55	2050.38	2050.91	62980.0
2015-09-01 04:00:00	ES	Futures	2051.18	2054.11	2044.25	2045.32	54632.0
2015-09-01 05:00:00	ES	Futures	2045.32	2053.57	2044.79	2050.38	40533.0
2015-09-01 06:00:00	ES	Futures	2050.11	2058.37	2050.11	2055.7	37694.0
2015-09-01 07:00:00	ES	Futures	2055.97	2060.5	2052.24	2054.64	36267.0
2015-09-01 08:00:00	ES	Futures	2054.37	2055.97	2038.93	2039.46	96403.0
2015-09-01 09:00:00	ES	Futures	2039.73	2065.55	2038.4	2055.97	374090.0
2015-09-01 10:00:00	ES	Futures	2055.97	2064.22	2046.38	2055.17	363395.0
2015-09-01 11:00:00	ES	Futures	2055.17	2062.63	2050.64	2054.9	207012.0
2015-09-01 12:00:00	ES	Futures	2054.9	2057.57	2040.79	2041.33	220526.0
2015-09-01 13:00:00	ES	Futures	2041.33	2049.58	2038.66	2049.05	207789.0
2015-09-01 14:00:00	ES	Futures	2048.78	2051.71	2037.6	2042.12	217880.0
2015-09-01 15:00:00	ES	Futures	2042.12	2043.99	2022.16	2031.74	552003.0
2015-09-01 16:00:00	ES	Futures	2031.74	2043.46	2026.95	2037.07	128065.0
2015-09-01 17:00:00	ES	Futures	2037.33	2038.66	2036.8	2037.07	1562.0
2015-09-01 18:00:00	ES	Futures	2037.86	2040.26	2031.21	2038.66	11850.0
2015-09-01 19:00:00	ES	Futures	2038.66	2045.85	2035.47	2043.72	7623.0
2015-09-01 20:00:00	ES	Futures	2043.99	2057.57	2043.46	2055.97	35636.0
2015-09-01 21:00:00	ES	Futures	2055.97	2059.43	2053.04	2055.97	18568.0
2015-09-01 22:00:00	ES	Futures	2055.97	2057.03	2051.18	2053.31	9920.0
2015-09-01 23:00:00	ES	Futures	2053.04	2065.02	2052.51	2062.36	14504.0
2015-09-01 00:00:00	NQ	Futures	4965.71	4978.43	4963.64	4970.45	2260.0
2015-09-01 01:00:00	NQ	Futures	4970.74	4973.11	4949.44	4950.04	3224.0
2015-09-01 02:00:00	NQ	Futures	4950.33	4966.6	4945.89	4965.42	2756.0
2015-09-01 03:00:00	NQ	Futures	4965.71	4973.99	4924.89	4929.92	9304.0
2015-09-01 04:00:00	NQ	Futures	4930.22	4941.46	4918.09	4920.46	8222.0
2015-09-01 05:00:00	NQ	Futures	4919.87	4944.12	4919.87	4935.25	6174.0
2015-09-01 06:00:00	NQ	Futures	4934.65	4954.18	4934.65	4945.3	3787.0
2015-09-01 07:00:00	NQ	Futures	4945.89	4957.43	4938.5	4944.42	5350.0
2015-09-01 08:00:00	NQ	Futures	4944.42	4948.56	4906.55	4909.22	11985.0
2015-09-01 09:00:00	NQ	Futures	4909.51	4996.47	4907.44	4971.63	85202.0
2015-09-01 10:00:00	NQ	Futures	4971.63	5002.69	4948.26	4979.61	72287.0
2015-09-01 11:00:00	NQ	Futures	4979.91	4997.66	4964.53	4975.77	35252.0
2015-09-01 12:00:00	NQ	Futures	4975.77	4982.28	4926.67	4930.81	35618.0
2015-09-01 13:00:00	NQ	Futures	4930.81	4955.36	4921.34	4951.51	35651.0
2015-09-01 14:00:00	NQ	Futures	4951.51	4951.81	4911.58	4921.94	41133.0
2015-09-01 15:00:00	NQ	Futures	4922.23	4927.85	4872.54	4896.5	76460.0
2015-09-01 16:00:00	NQ	Futures	4896.5	4924.6	4885.26	4910.99	15576.0
2015-09-01 17:00:00	NQ	Futures	4910.7	4913.36	4910.4	4910.99	179.0
2015-09-01 18:00:00	NQ	Futures	4910.99	4917.5	4893.54	4913.95	1788.0
2015-09-01 19:00:00	NQ	Futures	4913.36	4935.84	4904.48	4927.85	1255.0
2015-09-01 20:00:00	NQ	Futures	4928.44	4966.9	4926.96	4960.98	4856.0
2015-09-01 21:00:00	NQ	Futures	4960.68	4972.81	4952.7	4962.46	3715.0
2015-09-01 22:00:00	NQ	Futures	4962.75	4967.78	4947.97	4957.43	2822.0
2015-09-01 23:00:00	NQ	Futures	4958.02	4981.39	4957.73	4977.54	3609.0
2015-09-01 00:00:00	YM	Futures	17133.5	17174.6	17133.5	17156.7	1369.0
2015-09-01 01:00:00	YM	Futures	17154.5	17165.1	17099.8	17102.9	1792.0

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

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