PREVIEW / futures_1hour / 2014-11-04

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-04.parquet
  size:    51 KB
  rows:    1,571

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-11-04 00:00:00	ES	Futures	2106.48	2106.74	2103.07	2103.34	1815.0
2014-11-04 01:00:00	ES	Futures	2103.34	2104.91	2101.5	2104.12	7136.0
2014-11-04 02:00:00	ES	Futures	2104.38	2106.48	2103.07	2103.6	10917.0
2014-11-04 03:00:00	ES	Futures	2103.86	2110.15	2103.34	2109.36	28634.0
2014-11-04 04:00:00	ES	Futures	2109.62	2110.15	2108.05	2108.84	11030.0
2014-11-04 05:00:00	ES	Futures	2109.1	2109.1	2100.98	2103.34	33881.0
2014-11-04 06:00:00	ES	Futures	2103.07	2105.43	2102.29	2104.91	16613.0
2014-11-04 07:00:00	ES	Futures	2105.17	2105.69	2102.29	2102.29	21927.0
2014-11-04 08:00:00	ES	Futures	2102.29	2103.6	2100.45	2102.55	35054.0
2014-11-04 09:00:00	ES	Futures	2102.29	2106.22	2101.24	2104.12	194865.0
2014-11-04 10:00:00	ES	Futures	2104.12	2107.0	2092.86	2093.12	360188.0
2014-11-04 11:00:00	ES	Futures	2093.12	2096.0	2090.76	2093.91	234068.0
2014-11-04 12:00:00	ES	Futures	2093.91	2102.81	2093.64	2100.98	130028.0
2014-11-04 13:00:00	ES	Futures	2101.24	2104.65	2097.05	2103.34	111178.0
2014-11-04 14:00:00	ES	Futures	2103.6	2104.91	2098.88	2103.07	101217.0
2014-11-04 15:00:00	ES	Futures	2103.07	2103.86	2099.93	2101.5	122567.0
2014-11-04 16:00:00	ES	Futures	2101.76	2103.86	2099.41	2102.03	61830.0
2014-11-04 17:00:00	ES	Futures	2101.76	2102.55	2101.5	2102.03	2229.0
2014-11-04 18:00:00	ES	Futures	2102.29	2102.29	2099.67	2100.45	5079.0
2014-11-04 19:00:00	ES	Futures	2100.45	2103.07	2100.19	2102.29	4547.0
2014-11-04 20:00:00	ES	Futures	2102.29	2102.29	2100.45	2101.24	4769.0
2014-11-04 21:00:00	ES	Futures	2101.24	2105.96	2101.24	2104.38	7363.0
2014-11-04 22:00:00	ES	Futures	2104.38	2108.05	2103.34	2107.0	10404.0
2014-11-04 23:00:00	ES	Futures	2107.0	2107.53	2105.69	2106.48	5568.0
2014-11-04 00:00:00	NQ	Futures	4870.63	4871.81	4863.89	4864.19	490.0
2014-11-04 01:00:00	NQ	Futures	4863.6	4867.12	4859.5	4866.53	845.0
2014-11-04 02:00:00	NQ	Futures	4866.24	4871.22	4863.89	4865.07	1066.0
2014-11-04 03:00:00	NQ	Futures	4865.36	4878.84	4864.77	4877.37	4347.0
2014-11-04 04:00:00	NQ	Futures	4877.37	4880.6	4874.44	4877.37	2401.0
2014-11-04 05:00:00	NQ	Futures	4877.67	4877.96	4860.96	4865.65	5838.0
2014-11-04 06:00:00	NQ	Futures	4865.36	4868.58	4862.43	4867.7	2689.0
2014-11-04 07:00:00	NQ	Futures	4868.0	4869.17	4857.45	4857.74	4885.0
2014-11-04 08:00:00	NQ	Futures	4857.45	4860.67	4853.64	4859.79	5774.0
2014-11-04 09:00:00	NQ	Futures	4859.79	4871.51	4854.23	4868.58	40639.0
2014-11-04 10:00:00	NQ	Futures	4868.88	4874.74	4837.52	4838.4	58959.0
2014-11-04 11:00:00	NQ	Futures	4838.11	4845.44	4828.44	4833.72	39406.0
2014-11-04 12:00:00	NQ	Futures	4833.42	4857.74	4833.42	4853.05	21870.0
2014-11-04 13:00:00	NQ	Futures	4853.35	4863.02	4847.49	4860.67	17960.0
2014-11-04 14:00:00	NQ	Futures	4860.96	4863.89	4854.52	4863.31	18400.0
2014-11-04 15:00:00	NQ	Futures	4863.31	4866.53	4858.33	4862.14	19952.0
2014-11-04 16:00:00	NQ	Futures	4862.14	4862.43	4854.81	4857.74	7732.0
2014-11-04 17:00:00	NQ	Futures	4857.74	4860.96	4855.98	4857.16	1256.0
2014-11-04 18:00:00	NQ	Futures	4857.74	4858.03	4852.47	4853.93	570.0
2014-11-04 19:00:00	NQ	Futures	4853.93	4860.38	4853.93	4859.5	699.0
2014-11-04 20:00:00	NQ	Futures	4859.21	4859.21	4855.4	4857.16	1017.0
2014-11-04 21:00:00	NQ	Futures	4857.16	4867.41	4856.86	4864.77	1294.0
2014-11-04 22:00:00	NQ	Futures	4865.07	4872.1	4862.14	4870.05	1864.0
2014-11-04 23:00:00	NQ	Futures	4870.05	4872.98	4868.29	4870.05	1190.0
2014-11-04 00:00:00	YM	Futures	17966.1	17969.2	17944.2	17944.2	480.0
2014-11-04 01:00:00	YM	Futures	17945.3	17956.7	17928.6	17949.4	1118.0

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

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