PREVIEW / futures_1hour / 2014-03-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1938.19	1938.71	1937.67	1938.71	985.0
2014-03-21 01:00:00	ES	Futures	1938.45	1939.74	1938.19	1939.22	4755.0
2014-03-21 02:00:00	ES	Futures	1938.96	1942.34	1938.71	1941.04	8519.0
2014-03-21 03:00:00	ES	Futures	1940.78	1942.08	1940.26	1941.56	7241.0
2014-03-21 04:00:00	ES	Futures	1941.56	1944.94	1940.0	1943.9	39329.0
2014-03-21 05:00:00	ES	Futures	1943.9	1944.68	1942.08	1944.16	16698.0
2014-03-21 06:00:00	ES	Futures	1944.16	1944.42	1942.08	1943.12	20584.0
2014-03-21 07:00:00	ES	Futures	1943.12	1944.16	1942.08	1942.6	26310.0
2014-03-21 08:00:00	ES	Futures	1942.86	1943.64	1941.3	1943.38	37303.0
2014-03-21 09:00:00	ES	Futures	1943.38	1949.35	1942.34	1944.42	301962.0
2014-03-21 10:00:00	ES	Futures	1944.42	1945.98	1940.26	1945.2	233633.0
2014-03-21 11:00:00	ES	Futures	1945.2	1948.05	1944.16	1945.2	123843.0
2014-03-21 12:00:00	ES	Futures	1945.46	1946.5	1941.82	1942.08	105523.0
2014-03-21 13:00:00	ES	Futures	1942.08	1942.86	1934.29	1935.33	203306.0
2014-03-21 14:00:00	ES	Futures	1935.59	1937.15	1928.58	1933.51	207356.0
2014-03-21 15:00:00	ES	Futures	1933.77	1934.29	1927.28	1929.36	267773.0
2014-03-21 16:00:00	ES	Futures	1929.1	1930.66	1928.06	1930.66	101131.0
2014-03-21 17:00:00	ES	Futures	1930.4	1930.66	1929.1	1929.1	4169.0
2014-03-21 00:00:00	NQ	Futures	4300.77	4302.81	4300.19	4302.52	105.0
2014-03-21 01:00:00	NQ	Futures	4302.52	4305.43	4301.64	4304.27	481.0
2014-03-21 02:00:00	NQ	Futures	4303.97	4311.55	4303.39	4307.76	1035.0
2014-03-21 03:00:00	NQ	Futures	4307.76	4310.09	4306.3	4309.51	782.0
2014-03-21 04:00:00	NQ	Futures	4309.22	4317.66	4305.14	4315.33	5571.0
2014-03-21 05:00:00	NQ	Futures	4314.75	4315.91	4310.67	4314.75	1868.0
2014-03-21 06:00:00	NQ	Futures	4315.04	4315.62	4310.09	4311.84	2338.0
2014-03-21 07:00:00	NQ	Futures	4311.84	4314.75	4310.09	4311.84	2626.0
2014-03-21 08:00:00	NQ	Futures	4311.84	4314.46	4310.38	4313.29	5621.0
2014-03-21 09:00:00	NQ	Futures	4313.29	4324.94	4284.75	4285.34	75879.0
2014-03-21 10:00:00	NQ	Futures	4285.04	4289.7	4260.29	4278.35	82607.0
2014-03-21 11:00:00	NQ	Futures	4278.35	4285.92	4271.65	4280.09	28989.0
2014-03-21 12:00:00	NQ	Futures	4280.09	4286.5	4273.98	4274.85	19469.0
2014-03-21 13:00:00	NQ	Futures	4274.56	4274.85	4256.21	4258.25	33323.0
2014-03-21 14:00:00	NQ	Futures	4258.54	4262.91	4235.83	4245.15	51048.0
2014-03-21 15:00:00	NQ	Futures	4245.44	4246.6	4232.92	4239.91	55166.0
2014-03-21 16:00:00	NQ	Futures	4239.91	4244.56	4238.45	4242.82	8488.0
2014-03-21 17:00:00	NQ	Futures	4242.82	4243.98	4241.36	4243.69	286.0
2014-03-21 00:00:00	YM	Futures	16748.6	16754.8	16747.6	16754.8	156.0
2014-03-21 01:00:00	YM	Futures	16754.8	16764.1	16751.7	16761.0	571.0
2014-03-21 02:00:00	YM	Futures	16759.9	16789.8	16757.9	16778.5	1297.0
2014-03-21 03:00:00	YM	Futures	16777.4	16785.7	16774.4	16779.5	723.0
2014-03-21 04:00:00	YM	Futures	16779.5	16805.2	16767.1	16799.1	4690.0
2014-03-21 05:00:00	YM	Futures	16797.0	16803.2	16783.6	16797.0	2317.0
2014-03-21 06:00:00	YM	Futures	16798.0	16801.1	16782.6	16788.8	2979.0
2014-03-21 07:00:00	YM	Futures	16789.8	16796.0	16780.5	16782.6	2669.0
2014-03-21 08:00:00	YM	Futures	16782.6	16783.6	16769.2	16782.6	4170.0
2014-03-21 09:00:00	YM	Futures	16782.6	16857.8	16776.4	16811.4	30158.0
2014-03-21 10:00:00	YM	Futures	16810.4	16851.6	16778.5	16839.2	31752.0
2014-03-21 11:00:00	YM	Futures	16838.2	16867.0	16828.9	16832.0	15294.0
2014-03-21 12:00:00	YM	Futures	16832.0	16857.8	16810.4	16817.6	9657.0
2014-03-21 13:00:00	YM	Futures	16817.6	16825.8	16761.0	16771.3	20104.0

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

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