PREVIEW / futures_1hour / 2015-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-02-04.parquet
  size:    54 KB
  rows:    1,599

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-04 00:00:00	ES	Futures	2147.85	2150.48	2147.85	2149.16	2176.0
2015-02-04 01:00:00	ES	Futures	2149.16	2149.16	2147.32	2148.11	2267.0
2015-02-04 02:00:00	ES	Futures	2148.37	2148.37	2145.74	2147.58	6803.0
2015-02-04 03:00:00	ES	Futures	2147.58	2149.16	2144.69	2147.06	20859.0
2015-02-04 04:00:00	ES	Futures	2147.06	2149.16	2142.32	2142.58	18427.0
2015-02-04 05:00:00	ES	Futures	2142.85	2150.48	2140.21	2144.95	41563.0
2015-02-04 06:00:00	ES	Futures	2144.95	2147.06	2143.9	2146.53	7923.0
2015-02-04 07:00:00	ES	Futures	2146.53	2147.85	2141.0	2143.9	17383.0
2015-02-04 08:00:00	ES	Futures	2143.9	2146.53	2141.79	2142.32	29551.0
2015-02-04 09:00:00	ES	Futures	2142.32	2146.53	2138.64	2145.48	186587.0
2015-02-04 10:00:00	ES	Futures	2145.48	2150.21	2140.21	2146.53	260915.0
2015-02-04 11:00:00	ES	Futures	2146.53	2153.9	2144.16	2151.53	193342.0
2015-02-04 12:00:00	ES	Futures	2151.53	2152.32	2143.11	2146.0	121807.0
2015-02-04 13:00:00	ES	Futures	2146.27	2149.95	2144.95	2146.79	106061.0
2015-02-04 14:00:00	ES	Futures	2146.79	2150.21	2142.85	2148.63	146680.0
2015-02-04 15:00:00	ES	Futures	2148.63	2157.06	2137.06	2143.11	387351.0
2015-02-04 16:00:00	ES	Futures	2143.11	2143.9	2129.16	2131.53	120180.0
2015-02-04 17:00:00	ES	Futures	2131.53	2132.32	2130.21	2130.48	4148.0
2015-02-04 18:00:00	ES	Futures	2131.53	2133.11	2128.11	2128.37	10093.0
2015-02-04 19:00:00	ES	Futures	2128.64	2133.11	2128.37	2132.06	6615.0
2015-02-04 20:00:00	ES	Futures	2132.06	2133.11	2131.0	2131.53	5600.0
2015-02-04 21:00:00	ES	Futures	2131.27	2131.79	2127.06	2131.27	6953.0
2015-02-04 22:00:00	ES	Futures	2131.27	2134.16	2130.74	2133.64	3860.0
2015-02-04 23:00:00	ES	Futures	2133.37	2133.64	2130.48	2132.32	1943.0
2015-02-04 00:00:00	NQ	Futures	4946.01	4950.71	4945.71	4948.06	597.0
2015-02-04 01:00:00	NQ	Futures	4948.06	4948.36	4943.66	4945.42	293.0
2015-02-04 02:00:00	NQ	Futures	4945.71	4947.18	4941.6	4946.89	1473.0
2015-02-04 03:00:00	NQ	Futures	4947.47	4950.41	4940.43	4946.01	2527.0
2015-02-04 04:00:00	NQ	Futures	4945.42	4951.0	4935.14	4936.31	2616.0
2015-02-04 05:00:00	NQ	Futures	4936.9	4954.52	4931.32	4943.07	6072.0
2015-02-04 06:00:00	NQ	Futures	4942.48	4947.47	4940.13	4946.3	1359.0
2015-02-04 07:00:00	NQ	Futures	4946.01	4948.36	4932.79	4938.37	3284.0
2015-02-04 08:00:00	NQ	Futures	4938.66	4944.83	4933.67	4935.14	6292.0
2015-02-04 09:00:00	NQ	Futures	4935.14	4946.01	4927.8	4940.43	34929.0
2015-02-04 10:00:00	NQ	Futures	4941.01	4951.88	4923.69	4941.6	42891.0
2015-02-04 11:00:00	NQ	Futures	4941.31	4972.44	4937.49	4968.03	31107.0
2015-02-04 12:00:00	NQ	Futures	4968.33	4969.5	4948.94	4957.17	21920.0
2015-02-04 13:00:00	NQ	Futures	4957.75	4970.97	4955.11	4963.92	14079.0
2015-02-04 14:00:00	NQ	Futures	4963.92	4975.08	4956.87	4969.8	23332.0
2015-02-04 15:00:00	NQ	Futures	4969.8	4984.48	4937.78	4951.29	61080.0
2015-02-04 16:00:00	NQ	Futures	4951.0	4952.47	4919.28	4925.45	12021.0
2015-02-04 17:00:00	NQ	Futures	4924.86	4926.33	4922.22	4923.1	328.0
2015-02-04 18:00:00	NQ	Futures	4923.39	4928.97	4916.93	4917.52	1190.0
2015-02-04 19:00:00	NQ	Futures	4917.81	4928.09	4917.81	4924.27	1187.0
2015-02-04 20:00:00	NQ	Futures	4924.57	4927.5	4922.8	4924.57	618.0
2015-02-04 21:00:00	NQ	Futures	4924.57	4925.15	4912.23	4923.98	2110.0
2015-02-04 22:00:00	NQ	Futures	4924.27	4931.03	4923.1	4929.27	754.0
2015-02-04 23:00:00	NQ	Futures	4928.97	4929.85	4922.51	4926.33	329.0
2015-02-04 00:00:00	YM	Futures	18350.3	18369.1	18349.3	18359.7	434.0
2015-02-04 01:00:00	YM	Futures	18359.7	18359.7	18342.0	18347.2	436.0

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

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