PREVIEW / futures_1hour / 2014-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-06.parquet
  size:    49 KB
  rows:    1,547

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
2014-03-06 00:00:00	ES	Futures	1940.42	1940.93	1938.61	1939.12	4720.0
2014-03-06 01:00:00	ES	Futures	1939.38	1939.38	1938.09	1938.86	3198.0
2014-03-06 02:00:00	ES	Futures	1938.86	1941.19	1938.61	1940.93	7077.0
2014-03-06 03:00:00	ES	Futures	1940.93	1942.74	1940.42	1942.49	20513.0
2014-03-06 04:00:00	ES	Futures	1942.49	1942.49	1940.42	1940.42	10963.0
2014-03-06 05:00:00	ES	Futures	1940.68	1941.45	1939.9	1940.68	15624.0
2014-03-06 06:00:00	ES	Futures	1940.68	1941.45	1938.86	1939.9	22341.0
2014-03-06 07:00:00	ES	Futures	1939.9	1941.19	1938.35	1939.9	27728.0
2014-03-06 08:00:00	ES	Futures	1940.16	1942.49	1938.61	1940.68	64573.0
2014-03-06 09:00:00	ES	Futures	1940.68	1946.11	1940.42	1945.59	199758.0
2014-03-06 10:00:00	ES	Futures	1945.59	1945.85	1940.93	1944.56	190733.0
2014-03-06 11:00:00	ES	Futures	1944.81	1945.33	1943.26	1945.07	81542.0
2014-03-06 12:00:00	ES	Futures	1944.81	1946.11	1944.3	1945.33	75654.0
2014-03-06 13:00:00	ES	Futures	1945.33	1945.59	1938.86	1939.38	151940.0
2014-03-06 14:00:00	ES	Futures	1939.38	1943.52	1938.61	1942.49	119535.0
2014-03-06 15:00:00	ES	Futures	1942.74	1944.3	1939.64	1941.71	156839.0
2014-03-06 16:00:00	ES	Futures	1941.71	1941.97	1940.42	1941.71	65776.0
2014-03-06 17:00:00	ES	Futures	1941.71	1941.97	1941.45	1941.97	2463.0
2014-03-06 18:00:00	ES	Futures	1941.19	1943.52	1941.19	1942.49	5094.0
2014-03-06 19:00:00	ES	Futures	1942.74	1943.52	1942.23	1942.23	2654.0
2014-03-06 20:00:00	ES	Futures	1942.23	1944.04	1941.97	1943.26	3968.0
2014-03-06 21:00:00	ES	Futures	1943.26	1943.78	1942.49	1942.74	1000.0
2014-03-06 22:00:00	ES	Futures	1942.74	1943.0	1941.19	1942.23	2227.0
2014-03-06 23:00:00	ES	Futures	1942.49	1943.0	1941.45	1943.0	1902.0
2014-03-06 00:00:00	NQ	Futures	4341.09	4341.67	4337.6	4338.76	467.0
2014-03-06 01:00:00	NQ	Futures	4339.34	4339.92	4337.02	4339.34	331.0
2014-03-06 02:00:00	NQ	Futures	4339.34	4341.67	4339.34	4341.38	717.0
2014-03-06 03:00:00	NQ	Futures	4341.67	4342.83	4339.34	4342.54	2465.0
2014-03-06 04:00:00	NQ	Futures	4342.54	4342.83	4338.76	4339.92	1208.0
2014-03-06 05:00:00	NQ	Futures	4339.92	4341.09	4337.89	4339.92	1381.0
2014-03-06 06:00:00	NQ	Futures	4339.63	4341.67	4336.73	4338.47	1495.0
2014-03-06 07:00:00	NQ	Futures	4338.76	4341.09	4336.73	4338.47	2829.0
2014-03-06 08:00:00	NQ	Futures	4338.18	4342.83	4336.14	4338.76	10371.0
2014-03-06 09:00:00	NQ	Futures	4338.76	4345.45	4337.89	4341.09	32997.0
2014-03-06 10:00:00	NQ	Futures	4340.8	4341.67	4330.91	4340.5	34096.0
2014-03-06 11:00:00	NQ	Futures	4340.5	4343.12	4336.43	4342.54	16097.0
2014-03-06 12:00:00	NQ	Futures	4342.54	4343.41	4337.02	4338.47	11790.0
2014-03-06 13:00:00	NQ	Futures	4338.47	4339.92	4315.21	4315.51	33040.0
2014-03-06 14:00:00	NQ	Futures	4315.51	4330.04	4312.89	4327.71	32204.0
2014-03-06 15:00:00	NQ	Futures	4327.71	4332.07	4320.74	4327.71	25947.0
2014-03-06 16:00:00	NQ	Futures	4327.71	4330.04	4325.39	4329.75	4916.0
2014-03-06 17:00:00	NQ	Futures	4329.46	4330.62	4329.46	4330.33	196.0
2014-03-06 18:00:00	NQ	Futures	4330.04	4331.49	4327.13	4330.33	750.0
2014-03-06 19:00:00	NQ	Futures	4330.04	4331.49	4329.46	4330.04	312.0
2014-03-06 20:00:00	NQ	Futures	4329.75	4332.07	4328.88	4330.91	512.0
2014-03-06 21:00:00	NQ	Futures	4331.2	4331.2	4329.17	4330.04	148.0
2014-03-06 22:00:00	NQ	Futures	4330.04	4330.33	4326.55	4328.88	373.0
2014-03-06 23:00:00	NQ	Futures	4329.17	4329.46	4326.26	4328.88	384.0
2014-03-06 00:00:00	YM	Futures	16797.1	16800.2	16780.7	16785.8	333.0
2014-03-06 01:00:00	YM	Futures	16787.9	16787.9	16777.6	16783.8	232.0

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

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