PREVIEW / futures_1hour / 2015-02-05

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-05.parquet
  size:    53 KB
  rows:    1,593

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-02-05 00:00:00	ES	Futures	2132.32	2134.42	2131.0	2132.06	2705.0
2015-02-05 01:00:00	ES	Futures	2132.06	2133.37	2129.16	2129.69	2323.0
2015-02-05 02:00:00	ES	Futures	2129.95	2142.06	2129.95	2139.95	18982.0
2015-02-05 03:00:00	ES	Futures	2139.95	2144.95	2134.69	2140.21	35908.0
2015-02-05 04:00:00	ES	Futures	2140.21	2149.42	2139.95	2148.11	21741.0
2015-02-05 05:00:00	ES	Futures	2148.11	2150.74	2146.27	2147.58	20712.0
2015-02-05 06:00:00	ES	Futures	2147.58	2148.9	2144.69	2148.11	13976.0
2015-02-05 07:00:00	ES	Futures	2148.37	2153.9	2148.37	2150.21	34350.0
2015-02-05 08:00:00	ES	Futures	2150.48	2155.48	2149.42	2151.79	43059.0
2015-02-05 09:00:00	ES	Futures	2152.06	2160.21	2149.69	2156.53	217415.0
2015-02-05 10:00:00	ES	Futures	2156.53	2163.11	2155.74	2161.27	222691.0
2015-02-05 11:00:00	ES	Futures	2161.27	2162.85	2158.11	2161.27	155939.0
2015-02-05 12:00:00	ES	Futures	2161.27	2161.79	2156.27	2157.85	82646.0
2015-02-05 13:00:00	ES	Futures	2157.85	2163.11	2157.32	2161.53	93373.0
2015-02-05 14:00:00	ES	Futures	2161.53	2163.9	2158.9	2161.53	106964.0
2015-02-05 15:00:00	ES	Futures	2161.53	2167.06	2159.95	2165.74	168242.0
2015-02-05 16:00:00	ES	Futures	2165.74	2166.0	2162.32	2164.95	62561.0
2015-02-05 17:00:00	ES	Futures	2164.69	2165.21	2163.9	2164.16	1678.0
2015-02-05 18:00:00	ES	Futures	2164.42	2165.21	2162.85	2162.85	3083.0
2015-02-05 19:00:00	ES	Futures	2162.85	2163.37	2161.79	2162.85	3266.0
2015-02-05 20:00:00	ES	Futures	2162.58	2163.11	2161.79	2162.58	2582.0
2015-02-05 21:00:00	ES	Futures	2162.58	2163.37	2161.79	2163.11	2158.0
2015-02-05 22:00:00	ES	Futures	2163.37	2163.37	2160.74	2161.27	1800.0
2015-02-05 23:00:00	ES	Futures	2161.27	2162.06	2161.0	2161.79	1318.0
2015-02-05 00:00:00	NQ	Futures	4926.92	4931.03	4922.8	4924.27	391.0
2015-02-05 01:00:00	NQ	Futures	4924.86	4928.09	4919.87	4921.04	299.0
2015-02-05 02:00:00	NQ	Futures	4921.63	4945.13	4920.75	4939.25	4608.0
2015-02-05 03:00:00	NQ	Futures	4939.84	4948.65	4926.92	4936.61	8348.0
2015-02-05 04:00:00	NQ	Futures	4936.31	4959.22	4936.02	4957.17	4808.0
2015-02-05 05:00:00	NQ	Futures	4957.17	4963.33	4953.35	4954.82	3985.0
2015-02-05 06:00:00	NQ	Futures	4954.82	4956.58	4946.89	4954.52	2928.0
2015-02-05 07:00:00	NQ	Futures	4955.11	4968.03	4953.94	4959.22	5719.0
2015-02-05 08:00:00	NQ	Futures	4959.22	4971.56	4957.17	4963.33	6788.0
2015-02-05 09:00:00	NQ	Futures	4963.33	4980.66	4950.12	4972.14	34576.0
2015-02-05 10:00:00	NQ	Futures	4972.44	4985.36	4963.04	4980.66	33349.0
2015-02-05 11:00:00	NQ	Futures	4980.66	4985.07	4974.2	4980.37	17488.0
2015-02-05 12:00:00	NQ	Futures	4980.37	4982.13	4968.33	4972.73	11609.0
2015-02-05 13:00:00	NQ	Futures	4973.03	4984.48	4971.26	4981.54	10485.0
2015-02-05 14:00:00	NQ	Futures	4981.25	4988.3	4975.67	4983.01	15984.0
2015-02-05 15:00:00	NQ	Futures	4983.3	4998.28	4978.9	4994.76	25943.0
2015-02-05 16:00:00	NQ	Futures	4995.05	4996.23	4989.47	4996.23	6930.0
2015-02-05 17:00:00	NQ	Futures	4996.23	4996.52	4994.17	4995.05	143.0
2015-02-05 18:00:00	NQ	Futures	4993.88	4995.93	4990.94	4990.94	380.0
2015-02-05 19:00:00	NQ	Futures	4991.23	4993.0	4989.77	4991.82	409.0
2015-02-05 20:00:00	NQ	Futures	4991.53	4992.41	4989.18	4991.82	442.0
2015-02-05 21:00:00	NQ	Futures	4991.82	4993.0	4989.77	4993.0	276.0
2015-02-05 22:00:00	NQ	Futures	4993.0	4993.0	4987.42	4988.59	627.0
2015-02-05 23:00:00	NQ	Futures	4988.59	4990.06	4987.71	4988.88	236.0
2015-02-05 00:00:00	YM	Futures	18302.3	18320.0	18291.9	18298.1	521.0
2015-02-05 01:00:00	YM	Futures	18297.1	18310.7	18276.2	18285.6	623.0

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

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