PREVIEW / futures_1hour / 2014-02-25

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-25.parquet
  size:    49 KB
  rows:    1,552

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-02-25 00:00:00	ES	Futures	1909.12	1909.38	1907.83	1908.09	2628.0
2014-02-25 01:00:00	ES	Futures	1908.09	1908.86	1906.79	1908.6	5686.0
2014-02-25 02:00:00	ES	Futures	1908.6	1909.38	1907.05	1908.34	8127.0
2014-02-25 03:00:00	ES	Futures	1908.34	1908.6	1905.5	1906.79	27533.0
2014-02-25 04:00:00	ES	Futures	1906.79	1907.83	1906.02	1906.27	13100.0
2014-02-25 05:00:00	ES	Futures	1906.27	1907.31	1906.02	1907.05	11534.0
2014-02-25 06:00:00	ES	Futures	1906.79	1907.05	1904.72	1906.02	21265.0
2014-02-25 07:00:00	ES	Futures	1906.27	1907.31	1904.72	1905.76	17783.0
2014-02-25 08:00:00	ES	Futures	1905.76	1909.38	1905.24	1908.09	32537.0
2014-02-25 09:00:00	ES	Futures	1908.34	1911.71	1901.36	1903.17	233815.0
2014-02-25 10:00:00	ES	Futures	1903.17	1909.9	1900.84	1908.86	292673.0
2014-02-25 11:00:00	ES	Futures	1908.86	1915.07	1907.05	1908.86	208748.0
2014-02-25 12:00:00	ES	Futures	1909.12	1910.93	1907.83	1910.41	113910.0
2014-02-25 13:00:00	ES	Futures	1910.41	1913.0	1908.86	1909.64	93593.0
2014-02-25 14:00:00	ES	Futures	1909.64	1910.93	1906.02	1908.09	121569.0
2014-02-25 15:00:00	ES	Futures	1908.09	1908.09	1903.43	1906.79	228224.0
2014-02-25 16:00:00	ES	Futures	1906.79	1911.19	1906.53	1910.93	102628.0
2014-02-25 17:00:00	ES	Futures	1910.93	1911.71	1910.67	1911.45	2775.0
2014-02-25 18:00:00	ES	Futures	1911.45	1911.96	1910.93	1910.93	3941.0
2014-02-25 19:00:00	ES	Futures	1911.19	1913.0	1910.93	1912.22	6424.0
2014-02-25 20:00:00	ES	Futures	1911.96	1914.03	1911.71	1912.48	7704.0
2014-02-25 21:00:00	ES	Futures	1912.48	1915.07	1912.48	1914.03	7340.0
2014-02-25 22:00:00	ES	Futures	1914.03	1916.62	1913.52	1915.33	10838.0
2014-02-25 23:00:00	ES	Futures	1915.33	1915.59	1914.29	1915.33	2820.0
2014-02-25 00:00:00	NQ	Futures	4287.6	4289.05	4285.57	4285.86	221.0
2014-02-25 01:00:00	NQ	Futures	4285.57	4286.73	4282.95	4286.73	388.0
2014-02-25 02:00:00	NQ	Futures	4286.73	4288.47	4284.11	4286.15	600.0
2014-02-25 03:00:00	NQ	Futures	4286.15	4286.44	4280.62	4283.53	3417.0
2014-02-25 04:00:00	NQ	Futures	4283.82	4286.15	4281.5	4282.08	1626.0
2014-02-25 05:00:00	NQ	Futures	4282.08	4284.69	4280.91	4281.79	1990.0
2014-02-25 06:00:00	NQ	Futures	4281.5	4282.66	4277.14	4280.62	2783.0
2014-02-25 07:00:00	NQ	Futures	4280.62	4282.95	4278.59	4281.5	1784.0
2014-02-25 08:00:00	NQ	Futures	4281.2	4290.22	4280.62	4286.73	4630.0
2014-02-25 09:00:00	NQ	Futures	4286.44	4293.12	4269.87	4272.77	34780.0
2014-02-25 10:00:00	NQ	Futures	4272.19	4287.6	4265.51	4284.4	46771.0
2014-02-25 11:00:00	NQ	Futures	4284.69	4298.94	4283.53	4287.31	29236.0
2014-02-25 12:00:00	NQ	Futures	4287.31	4288.47	4278.01	4284.4	22069.0
2014-02-25 13:00:00	NQ	Futures	4284.4	4289.63	4279.17	4279.46	18242.0
2014-02-25 14:00:00	NQ	Futures	4279.46	4283.24	4273.36	4277.14	19510.0
2014-02-25 15:00:00	NQ	Futures	4277.14	4279.17	4269.0	4279.17	34413.0
2014-02-25 16:00:00	NQ	Futures	4278.88	4290.8	4278.88	4290.51	9235.0
2014-02-25 17:00:00	NQ	Futures	4290.51	4292.83	4290.22	4292.83	632.0
2014-02-25 18:00:00	NQ	Futures	4291.96	4292.54	4290.22	4290.22	680.0
2014-02-25 19:00:00	NQ	Futures	4290.22	4293.41	4290.22	4291.38	910.0
2014-02-25 20:00:00	NQ	Futures	4291.67	4295.74	4290.8	4292.54	825.0
2014-02-25 21:00:00	NQ	Futures	4292.83	4298.06	4292.83	4296.32	1005.0
2014-02-25 22:00:00	NQ	Futures	4296.61	4300.68	4295.45	4298.06	1027.0
2014-02-25 23:00:00	NQ	Futures	4298.06	4299.23	4296.61	4298.36	395.0
2014-02-25 00:00:00	YM	Futures	16602.3	16604.3	16591.0	16591.0	172.0
2014-02-25 01:00:00	YM	Futures	16593.1	16593.1	16580.8	16592.0	420.0

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

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