PREVIEW / futures_1hour / 2014-11-14

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-14.parquet
  size:    43 KB
  rows:    1,265

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-14 00:00:00	ES	Futures	2131.63	2132.94	2131.37	2132.94	2292.0
2014-11-14 01:00:00	ES	Futures	2132.94	2133.2	2132.15	2132.94	1127.0
2014-11-14 02:00:00	ES	Futures	2133.2	2136.34	2133.2	2135.3	11485.0
2014-11-14 03:00:00	ES	Futures	2135.03	2135.3	2130.32	2131.37	26951.0
2014-11-14 04:00:00	ES	Futures	2131.1	2136.61	2131.1	2135.3	22042.0
2014-11-14 05:00:00	ES	Futures	2135.3	2136.08	2133.46	2133.99	10802.0
2014-11-14 06:00:00	ES	Futures	2133.99	2134.77	2130.06	2131.63	27680.0
2014-11-14 07:00:00	ES	Futures	2131.89	2132.41	2129.79	2131.89	22569.0
2014-11-14 08:00:00	ES	Futures	2131.89	2135.56	2131.63	2132.94	42891.0
2014-11-14 09:00:00	ES	Futures	2132.94	2135.03	2130.58	2133.46	133699.0
2014-11-14 10:00:00	ES	Futures	2133.2	2137.39	2129.53	2135.03	224156.0
2014-11-14 11:00:00	ES	Futures	2135.3	2136.34	2132.41	2133.72	113814.0
2014-11-14 12:00:00	ES	Futures	2133.72	2135.03	2132.41	2132.94	63562.0
2014-11-14 13:00:00	ES	Futures	2133.2	2133.99	2130.58	2130.58	53549.0
2014-11-14 14:00:00	ES	Futures	2130.84	2132.94	2129.27	2131.37	81154.0
2014-11-14 15:00:00	ES	Futures	2131.63	2135.03	2131.37	2134.77	126755.0
2014-11-14 16:00:00	ES	Futures	2134.77	2136.34	2133.99	2136.08	55008.0
2014-11-14 17:00:00	ES	Futures	2136.08	2136.87	2135.82	2136.87	2003.0
2014-11-14 00:00:00	NQ	Futures	4931.29	4935.39	4931.29	4935.1	389.0
2014-11-14 01:00:00	NQ	Futures	4935.39	4935.68	4932.75	4934.51	213.0
2014-11-14 02:00:00	NQ	Futures	4934.51	4943.3	4934.51	4939.49	1391.0
2014-11-14 03:00:00	NQ	Futures	4939.78	4939.78	4928.36	4929.82	3523.0
2014-11-14 04:00:00	NQ	Futures	4929.53	4941.83	4928.65	4937.73	3313.0
2014-11-14 05:00:00	NQ	Futures	4937.44	4940.66	4934.22	4935.39	1990.0
2014-11-14 06:00:00	NQ	Futures	4935.68	4937.44	4928.36	4931.87	3229.0
2014-11-14 07:00:00	NQ	Futures	4931.87	4934.22	4926.89	4928.94	3144.0
2014-11-14 08:00:00	NQ	Futures	4929.24	4937.44	4928.94	4931.87	5196.0
2014-11-14 09:00:00	NQ	Futures	4931.87	4938.9	4920.45	4929.24	36206.0
2014-11-14 10:00:00	NQ	Futures	4929.24	4944.76	4917.51	4943.89	54848.0
2014-11-14 11:00:00	NQ	Futures	4944.18	4948.57	4938.9	4943.59	27628.0
2014-11-14 12:00:00	NQ	Futures	4943.59	4948.28	4939.78	4944.47	14924.0
2014-11-14 13:00:00	NQ	Futures	4944.47	4947.99	4937.15	4937.44	11674.0
2014-11-14 14:00:00	NQ	Futures	4937.44	4943.89	4930.99	4941.25	17642.0
2014-11-14 15:00:00	NQ	Futures	4940.96	4950.33	4940.66	4950.33	22057.0
2014-11-14 16:00:00	NQ	Futures	4950.33	4951.21	4946.23	4950.92	7220.0
2014-11-14 17:00:00	NQ	Futures	4950.92	4952.68	4950.92	4951.8	379.0
2014-11-14 00:00:00	YM	Futures	18300.9	18313.3	18297.8	18313.3	289.0
2014-11-14 01:00:00	YM	Futures	18311.3	18312.3	18305.0	18311.3	158.0
2014-11-14 02:00:00	YM	Futures	18312.3	18340.4	18312.3	18332.1	1827.0
2014-11-14 03:00:00	YM	Futures	18332.1	18333.1	18290.5	18299.8	4186.0
2014-11-14 04:00:00	YM	Futures	18298.8	18338.3	18297.8	18327.9	3653.0
2014-11-14 05:00:00	YM	Futures	18328.9	18335.2	18309.2	18314.4	2180.0
2014-11-14 06:00:00	YM	Futures	18314.4	18318.5	18291.5	18300.9	4372.0
2014-11-14 07:00:00	YM	Futures	18300.9	18305.0	18285.3	18298.8	3226.0
2014-11-14 08:00:00	YM	Futures	18299.8	18324.8	18297.8	18308.2	5028.0
2014-11-14 09:00:00	YM	Futures	18308.2	18318.5	18287.4	18307.1	14081.0
2014-11-14 10:00:00	YM	Futures	18309.2	18330.0	18280.1	18313.3	17142.0
2014-11-14 11:00:00	YM	Futures	18313.3	18323.7	18295.7	18301.9	8193.0
2014-11-14 12:00:00	YM	Futures	18301.9	18308.2	18287.4	18293.6	4736.0
2014-11-14 13:00:00	YM	Futures	18294.6	18304.0	18283.2	18284.2	4469.0

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

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