PREVIEW / futures_1hour / 2015-06-11

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-06-11.parquet
  size:    49 KB
  rows:    1,490

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
2015-06-11 00:00:00	ES	Futures	2222.55	2223.34	2222.55	2223.08	1325.0
2015-06-11 01:00:00	ES	Futures	2223.34	2224.14	2223.08	2223.87	1859.0
2015-06-11 02:00:00	ES	Futures	2223.87	2224.14	2222.55	2222.82	6629.0
2015-06-11 03:00:00	ES	Futures	2222.82	2226.51	2222.02	2225.46	22753.0
2015-06-11 04:00:00	ES	Futures	2225.46	2225.72	2222.82	2223.61	17450.0
2015-06-11 05:00:00	ES	Futures	2223.87	2225.19	2223.34	2223.87	11409.0
2015-06-11 06:00:00	ES	Futures	2223.87	2225.19	2223.34	2224.93	9698.0
2015-06-11 07:00:00	ES	Futures	2224.93	2228.1	2223.87	2227.57	27806.0
2015-06-11 08:00:00	ES	Futures	2227.57	2228.89	2225.98	2227.83	51933.0
2015-06-11 09:00:00	ES	Futures	2227.57	2233.12	2226.51	2232.32	182493.0
2015-06-11 10:00:00	ES	Futures	2232.59	2234.17	2224.66	2225.72	233077.0
2015-06-11 11:00:00	ES	Futures	2225.72	2230.21	2224.66	2228.63	115817.0
2015-06-11 12:00:00	ES	Futures	2228.63	2230.21	2226.51	2228.89	53078.0
2015-06-11 13:00:00	ES	Futures	2228.89	2231.8	2227.57	2230.47	45133.0
2015-06-11 14:00:00	ES	Futures	2230.47	2231.0	2228.36	2229.15	39141.0
2015-06-11 15:00:00	ES	Futures	2229.15	2230.74	2225.46	2228.89	121400.0
2015-06-11 16:00:00	ES	Futures	2228.89	2230.47	2227.83	2229.15	65933.0
2015-06-11 17:00:00	ES	Futures	2229.15	2229.68	2228.89	2229.42	1497.0
2015-06-11 18:00:00	ES	Futures	2228.1	2228.36	2226.25	2227.31	2600.0
2015-06-11 19:00:00	ES	Futures	2227.57	2227.57	2226.25	2226.51	882.0
2015-06-11 20:00:00	ES	Futures	2226.25	2226.78	2224.4	2225.46	2487.0
2015-06-11 21:00:00	ES	Futures	2225.46	2225.46	2223.08	2224.4	3324.0
2015-06-11 22:00:00	ES	Futures	2224.4	2224.66	2223.08	2223.61	2249.0
2015-06-11 23:00:00	ES	Futures	2223.61	2224.14	2223.08	2223.87	2102.0
2015-06-11 00:00:00	NQ	Futures	5272.85	5274.62	5272.56	5274.62	158.0
2015-06-11 01:00:00	NQ	Futures	5274.32	5276.68	5274.32	5275.79	185.0
2015-06-11 02:00:00	NQ	Futures	5275.5	5276.38	5271.09	5271.68	843.0
2015-06-11 03:00:00	NQ	Futures	5271.97	5284.62	5268.74	5281.68	2601.0
2015-06-11 04:00:00	NQ	Futures	5281.68	5282.56	5276.38	5280.2	1925.0
2015-06-11 05:00:00	NQ	Futures	5280.2	5283.15	5277.56	5279.62	1231.0
2015-06-11 06:00:00	NQ	Futures	5279.03	5281.38	5277.26	5280.2	1002.0
2015-06-11 07:00:00	NQ	Futures	5280.2	5288.73	5278.15	5288.14	5582.0
2015-06-11 08:00:00	NQ	Futures	5287.85	5293.14	5286.67	5288.73	6709.0
2015-06-11 09:00:00	NQ	Futures	5288.73	5307.26	5287.56	5304.61	27646.0
2015-06-11 10:00:00	NQ	Futures	5304.61	5307.55	5277.26	5282.85	31469.0
2015-06-11 11:00:00	NQ	Futures	5282.85	5293.14	5280.2	5284.03	15209.0
2015-06-11 12:00:00	NQ	Futures	5284.32	5287.56	5273.15	5283.44	7228.0
2015-06-11 13:00:00	NQ	Futures	5283.15	5291.09	5279.32	5287.56	6110.0
2015-06-11 14:00:00	NQ	Futures	5287.56	5289.61	5282.26	5283.44	4927.0
2015-06-11 15:00:00	NQ	Futures	5283.15	5286.97	5276.38	5282.56	11360.0
2015-06-11 16:00:00	NQ	Futures	5282.26	5286.09	5279.32	5283.15	4441.0
2015-06-11 17:00:00	NQ	Futures	5283.15	5284.62	5281.38	5283.73	212.0
2015-06-11 18:00:00	NQ	Futures	5280.5	5282.85	5276.68	5279.91	164.0
2015-06-11 19:00:00	NQ	Futures	5279.62	5279.62	5277.26	5278.15	64.0
2015-06-11 20:00:00	NQ	Futures	5277.56	5278.44	5274.32	5275.5	229.0
2015-06-11 21:00:00	NQ	Futures	5275.79	5275.79	5271.68	5274.32	325.0
2015-06-11 22:00:00	NQ	Futures	5274.32	5274.62	5271.09	5271.68	263.0
2015-06-11 23:00:00	NQ	Futures	5271.97	5274.03	5271.09	5272.85	184.0
2015-06-11 00:00:00	YM	Futures	18871.7	18881.2	18871.7	18877.0	16.0
2015-06-11 01:00:00	YM	Futures	18880.1	18883.3	18878.0	18881.2	9.0

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

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