PREVIEW / futures_1hour / 2014-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-03-07.parquet
  size:    42 KB
  rows:    1,265

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-07 00:00:00	ES	Futures	1942.74	1944.81	1942.74	1944.56	3257.0
2014-03-07 01:00:00	ES	Futures	1944.81	1945.33	1943.26	1944.81	4497.0
2014-03-07 02:00:00	ES	Futures	1944.56	1945.33	1943.26	1944.04	4547.0
2014-03-07 03:00:00	ES	Futures	1943.78	1944.3	1940.93	1941.97	24744.0
2014-03-07 04:00:00	ES	Futures	1941.97	1943.26	1940.42	1942.49	16378.0
2014-03-07 05:00:00	ES	Futures	1942.49	1943.26	1941.71	1942.74	9308.0
2014-03-07 06:00:00	ES	Futures	1942.49	1944.81	1941.97	1943.0	14689.0
2014-03-07 07:00:00	ES	Futures	1943.0	1943.78	1941.97	1943.0	15816.0
2014-03-07 08:00:00	ES	Futures	1943.0	1952.83	1941.71	1951.02	134549.0
2014-03-07 09:00:00	ES	Futures	1951.02	1951.28	1938.86	1941.97	366961.0
2014-03-07 10:00:00	ES	Futures	1941.97	1946.37	1938.86	1940.42	300358.0
2014-03-07 11:00:00	ES	Futures	1940.42	1941.97	1933.95	1941.19	275258.0
2014-03-07 12:00:00	ES	Futures	1941.19	1942.74	1938.86	1940.16	78289.0
2014-03-07 13:00:00	ES	Futures	1940.16	1940.68	1936.54	1938.86	98756.0
2014-03-07 14:00:00	ES	Futures	1939.12	1940.93	1934.99	1939.38	114113.0
2014-03-07 15:00:00	ES	Futures	1939.64	1942.23	1936.54	1941.97	169573.0
2014-03-07 16:00:00	ES	Futures	1942.23	1943.52	1940.93	1942.49	77708.0
2014-03-07 17:00:00	ES	Futures	1942.49	1942.49	1941.45	1941.71	1731.0
2014-03-07 00:00:00	NQ	Futures	4329.17	4333.82	4329.17	4332.95	287.0
2014-03-07 01:00:00	NQ	Futures	4333.53	4333.82	4330.62	4333.53	236.0
2014-03-07 02:00:00	NQ	Futures	4333.24	4334.11	4330.62	4332.37	432.0
2014-03-07 03:00:00	NQ	Futures	4332.37	4333.24	4325.1	4327.42	1904.0
2014-03-07 04:00:00	NQ	Futures	4327.13	4329.46	4323.35	4328.3	1527.0
2014-03-07 05:00:00	NQ	Futures	4328.3	4328.59	4325.68	4327.42	878.0
2014-03-07 06:00:00	NQ	Futures	4327.71	4333.53	4326.55	4332.07	1730.0
2014-03-07 07:00:00	NQ	Futures	4331.78	4332.37	4327.42	4328.59	2651.0
2014-03-07 08:00:00	NQ	Futures	4328.3	4349.23	4325.1	4344.86	19938.0
2014-03-07 09:00:00	NQ	Futures	4344.57	4346.9	4298.94	4307.95	77041.0
2014-03-07 10:00:00	NQ	Futures	4307.66	4319.28	4301.84	4305.04	58477.0
2014-03-07 11:00:00	NQ	Futures	4304.75	4306.2	4288.18	4304.46	42750.0
2014-03-07 12:00:00	NQ	Futures	4304.75	4305.04	4297.19	4297.77	13005.0
2014-03-07 13:00:00	NQ	Futures	4297.77	4298.94	4285.57	4297.48	22276.0
2014-03-07 14:00:00	NQ	Futures	4297.19	4299.23	4287.02	4296.32	20746.0
2014-03-07 15:00:00	NQ	Futures	4296.32	4307.08	4291.96	4307.08	29502.0
2014-03-07 16:00:00	NQ	Futures	4307.08	4309.4	4305.33	4306.79	7074.0
2014-03-07 17:00:00	NQ	Futures	4307.66	4307.66	4306.79	4307.08	85.0
2014-03-07 00:00:00	YM	Futures	16843.3	16863.8	16843.3	16861.7	597.0
2014-03-07 01:00:00	YM	Futures	16860.7	16865.8	16851.5	16865.8	365.0
2014-03-07 02:00:00	YM	Futures	16864.8	16867.9	16851.5	16855.6	370.0
2014-03-07 03:00:00	YM	Futures	16856.6	16858.6	16829.9	16841.2	2920.0
2014-03-07 04:00:00	YM	Futures	16840.2	16847.4	16825.8	16842.2	2164.0
2014-03-07 05:00:00	YM	Futures	16843.3	16845.3	16834.0	16841.2	1282.0
2014-03-07 06:00:00	YM	Futures	16841.2	16862.8	16838.1	16849.4	2053.0
2014-03-07 07:00:00	YM	Futures	16848.4	16850.4	16837.1	16844.3	2235.0
2014-03-07 08:00:00	YM	Futures	16844.3	16927.4	16839.2	16919.1	15314.0
2014-03-07 09:00:00	YM	Futures	16919.1	16921.2	16845.3	16873.0	34345.0
2014-03-07 10:00:00	YM	Futures	16873.0	16916.1	16847.4	16865.8	30261.0
2014-03-07 11:00:00	YM	Futures	16865.8	16872.0	16817.6	16865.8	28644.0
2014-03-07 12:00:00	YM	Futures	16865.8	16872.0	16850.4	16857.6	8567.0
2014-03-07 13:00:00	YM	Futures	16856.6	16856.6	16828.9	16840.2	10559.0

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

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