PREVIEW / futures_1hour / 2014-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-13.parquet
  size:    50 KB
  rows:    1,515

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-13 00:00:00	ES	Futures	2133.99	2135.03	2133.46	2135.03	3664.0
2014-11-13 01:00:00	ES	Futures	2134.77	2140.8	2134.51	2139.49	12795.0
2014-11-13 02:00:00	ES	Futures	2139.49	2139.75	2137.39	2137.65	9037.0
2014-11-13 03:00:00	ES	Futures	2137.92	2138.96	2136.08	2137.39	21313.0
2014-11-13 04:00:00	ES	Futures	2137.39	2139.49	2137.13	2137.92	10226.0
2014-11-13 05:00:00	ES	Futures	2137.92	2141.06	2137.13	2140.27	12887.0
2014-11-13 06:00:00	ES	Futures	2140.27	2141.58	2138.7	2140.01	25178.0
2014-11-13 07:00:00	ES	Futures	2140.01	2140.27	2136.61	2137.65	26983.0
2014-11-13 08:00:00	ES	Futures	2137.65	2137.65	2132.68	2134.25	53977.0
2014-11-13 09:00:00	ES	Futures	2134.25	2139.49	2133.46	2138.44	186615.0
2014-11-13 10:00:00	ES	Futures	2138.18	2141.06	2136.08	2138.96	234334.0
2014-11-13 11:00:00	ES	Futures	2139.23	2139.49	2129.53	2132.94	241031.0
2014-11-13 12:00:00	ES	Futures	2132.68	2135.03	2130.32	2131.89	129915.0
2014-11-13 13:00:00	ES	Futures	2131.63	2132.41	2123.77	2127.7	155484.0
2014-11-13 14:00:00	ES	Futures	2127.7	2130.84	2124.29	2128.75	124683.0
2014-11-13 15:00:00	ES	Futures	2128.75	2135.56	2128.22	2134.25	212679.0
2014-11-13 16:00:00	ES	Futures	2134.25	2134.51	2130.32	2131.1	55929.0
2014-11-13 17:00:00	ES	Futures	2131.1	2131.37	2130.32	2130.58	1168.0
2014-11-13 18:00:00	ES	Futures	2130.32	2132.94	2129.27	2132.41	4313.0
2014-11-13 19:00:00	ES	Futures	2132.41	2133.2	2131.63	2132.41	3578.0
2014-11-13 20:00:00	ES	Futures	2132.41	2132.68	2129.53	2130.84	4001.0
2014-11-13 21:00:00	ES	Futures	2131.1	2132.41	2130.84	2132.15	1692.0
2014-11-13 22:00:00	ES	Futures	2132.15	2132.68	2131.63	2132.41	1281.0
2014-11-13 23:00:00	ES	Futures	2132.41	2132.41	2131.1	2131.63	1301.0
2014-11-13 00:00:00	NQ	Futures	4921.62	4924.55	4920.74	4923.67	1215.0
2014-11-13 01:00:00	NQ	Futures	4923.67	4938.32	4923.38	4936.27	2084.0
2014-11-13 02:00:00	NQ	Futures	4936.27	4936.27	4930.41	4930.7	1533.0
2014-11-13 03:00:00	NQ	Futures	4930.7	4933.63	4926.01	4929.53	3058.0
2014-11-13 04:00:00	NQ	Futures	4929.24	4935.1	4928.65	4930.99	1906.0
2014-11-13 05:00:00	NQ	Futures	4930.7	4937.73	4928.94	4935.97	1724.0
2014-11-13 06:00:00	NQ	Futures	4935.68	4938.9	4932.17	4934.51	2657.0
2014-11-13 07:00:00	NQ	Futures	4934.51	4934.8	4927.77	4930.99	3706.0
2014-11-13 08:00:00	NQ	Futures	4930.7	4930.7	4920.74	4923.08	7813.0
2014-11-13 09:00:00	NQ	Futures	4923.08	4946.23	4922.2	4945.64	45629.0
2014-11-13 10:00:00	NQ	Futures	4945.94	4954.14	4940.96	4948.28	43926.0
2014-11-13 11:00:00	NQ	Futures	4948.28	4948.57	4922.79	4931.87	48300.0
2014-11-13 12:00:00	NQ	Futures	4932.17	4945.94	4926.6	4940.37	22753.0
2014-11-13 13:00:00	NQ	Futures	4940.37	4942.71	4912.53	4927.48	38930.0
2014-11-13 14:00:00	NQ	Futures	4927.48	4932.75	4915.17	4926.31	27155.0
2014-11-13 15:00:00	NQ	Futures	4926.31	4936.85	4924.55	4935.1	31890.0
2014-11-13 16:00:00	NQ	Futures	4935.1	4936.56	4925.43	4927.48	6778.0
2014-11-13 17:00:00	NQ	Futures	4927.77	4928.65	4926.01	4927.77	299.0
2014-11-13 18:00:00	NQ	Futures	4926.31	4932.75	4923.96	4931.58	635.0
2014-11-13 19:00:00	NQ	Futures	4931.87	4933.63	4929.82	4933.63	967.0
2014-11-13 20:00:00	NQ	Futures	4932.75	4932.75	4925.43	4928.94	697.0
2014-11-13 21:00:00	NQ	Futures	4928.94	4933.04	4928.94	4932.46	467.0
2014-11-13 22:00:00	NQ	Futures	4932.46	4933.92	4931.58	4932.75	334.0
2014-11-13 23:00:00	NQ	Futures	4932.75	4933.04	4930.41	4932.17	303.0
2014-11-13 00:00:00	YM	Futures	18280.1	18290.5	18277.0	18286.3	511.0
2014-11-13 01:00:00	YM	Futures	18287.4	18339.3	18286.3	18333.1	2297.0

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

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