PREVIEW / futures_1hour / 2014-03-10

all futures 1-hour files

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

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-10 00:00:00	ES	Futures	1937.57	1938.61	1936.54	1937.05	2822.0
2014-03-10 01:00:00	ES	Futures	1937.05	1937.57	1935.24	1935.76	5743.0
2014-03-10 02:00:00	ES	Futures	1935.76	1937.05	1934.99	1935.24	4891.0
2014-03-10 03:00:00	ES	Futures	1935.5	1936.28	1932.4	1936.02	19023.0
2014-03-10 04:00:00	ES	Futures	1936.02	1941.71	1935.5	1941.45	34895.0
2014-03-10 05:00:00	ES	Futures	1941.71	1943.78	1941.19	1941.97	24856.0
2014-03-10 06:00:00	ES	Futures	1941.97	1942.49	1940.68	1941.19	12824.0
2014-03-10 07:00:00	ES	Futures	1940.93	1942.49	1939.38	1941.19	22838.0
2014-03-10 08:00:00	ES	Futures	1940.93	1941.19	1936.8	1938.86	31521.0
2014-03-10 09:00:00	ES	Futures	1938.86	1942.23	1936.8	1941.19	157558.0
2014-03-10 10:00:00	ES	Futures	1941.19	1941.45	1930.33	1932.14	232513.0
2014-03-10 11:00:00	ES	Futures	1932.14	1938.61	1930.85	1935.5	151640.0
2014-03-10 12:00:00	ES	Futures	1935.24	1940.16	1934.47	1939.64	97519.0
2014-03-10 13:00:00	ES	Futures	1939.64	1939.9	1934.99	1935.76	62036.0
2014-03-10 14:00:00	ES	Futures	1936.02	1939.38	1934.73	1938.86	54332.0
2014-03-10 15:00:00	ES	Futures	1939.12	1942.49	1936.54	1941.71	122054.0
2014-03-10 16:00:00	ES	Futures	1941.97	1943.78	1940.93	1942.74	48629.0
2014-03-10 17:00:00	ES	Futures	1942.74	1942.74	1941.45	1941.71	5185.0
2014-03-10 18:00:00	ES	Futures	1941.19	1941.71	1940.68	1940.93	2771.0
2014-03-10 19:00:00	ES	Futures	1940.93	1941.45	1940.68	1941.19	1416.0
2014-03-10 20:00:00	ES	Futures	1941.19	1942.23	1940.93	1941.45	3530.0
2014-03-10 21:00:00	ES	Futures	1941.19	1944.04	1941.19	1943.26	4279.0
2014-03-10 22:00:00	ES	Futures	1943.26	1943.78	1941.97	1943.26	3740.0
2014-03-10 23:00:00	ES	Futures	1943.52	1943.52	1941.19	1941.71	4092.0
2014-03-10 00:00:00	NQ	Futures	4299.23	4301.55	4296.61	4297.77	453.0
2014-03-10 01:00:00	NQ	Futures	4297.77	4298.06	4293.99	4295.74	525.0
2014-03-10 02:00:00	NQ	Futures	4295.74	4298.36	4293.12	4293.99	423.0
2014-03-10 03:00:00	NQ	Futures	4293.7	4295.45	4287.31	4294.29	1612.0
2014-03-10 04:00:00	NQ	Futures	4294.87	4307.37	4293.41	4306.79	3344.0
2014-03-10 05:00:00	NQ	Futures	4307.08	4312.31	4306.79	4308.24	3650.0
2014-03-10 06:00:00	NQ	Futures	4308.24	4309.4	4305.62	4307.66	1752.0
2014-03-10 07:00:00	NQ	Futures	4307.66	4310.85	4303.88	4307.37	2257.0
2014-03-10 08:00:00	NQ	Futures	4307.37	4307.66	4300.1	4303.88	4543.0
2014-03-10 09:00:00	NQ	Futures	4303.88	4313.76	4298.06	4312.89	33354.0
2014-03-10 10:00:00	NQ	Futures	4312.89	4313.76	4283.53	4288.76	39957.0
2014-03-10 11:00:00	NQ	Futures	4288.47	4307.08	4285.57	4299.23	26748.0
2014-03-10 12:00:00	NQ	Futures	4298.94	4307.95	4297.19	4307.37	16884.0
2014-03-10 13:00:00	NQ	Futures	4307.66	4308.24	4294.58	4296.9	16480.0
2014-03-10 14:00:00	NQ	Futures	4296.9	4306.49	4294.29	4305.33	10512.0
2014-03-10 15:00:00	NQ	Futures	4305.33	4311.15	4297.77	4310.85	19843.0
2014-03-10 16:00:00	NQ	Futures	4310.85	4316.09	4308.82	4313.47	3538.0
2014-03-10 17:00:00	NQ	Futures	4313.18	4313.47	4311.44	4312.6	271.0
2014-03-10 18:00:00	NQ	Futures	4310.85	4311.44	4309.11	4309.98	334.0
2014-03-10 19:00:00	NQ	Futures	4310.27	4310.85	4309.69	4309.98	140.0
2014-03-10 20:00:00	NQ	Futures	4310.27	4312.89	4309.98	4310.56	419.0
2014-03-10 21:00:00	NQ	Futures	4310.85	4316.96	4310.27	4316.09	661.0
2014-03-10 22:00:00	NQ	Futures	4316.09	4316.67	4313.76	4316.09	629.0
2014-03-10 23:00:00	NQ	Futures	4316.38	4316.38	4310.85	4311.44	459.0
2014-03-10 00:00:00	YM	Futures	16823.8	16831.0	16823.8	16831.0	2.0
2014-03-10 01:00:00	YM	Futures	16819.7	16820.7	16803.2	16807.3	30.0

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

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