PREVIEW / futures_1hour / 2014-12-10

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-10.parquet
  size:    48 KB
  rows:    1,461

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-12-10 00:00:00	ES	Futures	2153.9	2155.99	2153.63	2155.73	3922.0
2014-12-10 01:00:00	ES	Futures	2155.99	2158.61	2155.47	2157.83	6578.0
2014-12-10 02:00:00	ES	Futures	2157.83	2158.35	2154.68	2155.21	10739.0
2014-12-10 03:00:00	ES	Futures	2155.21	2158.61	2154.16	2155.99	29046.0
2014-12-10 04:00:00	ES	Futures	2155.73	2156.78	2153.63	2155.99	20218.0
2014-12-10 05:00:00	ES	Futures	2155.73	2156.78	2154.16	2155.73	9980.0
2014-12-10 06:00:00	ES	Futures	2155.47	2155.99	2153.9	2154.42	7159.0
2014-12-10 07:00:00	ES	Futures	2154.42	2156.25	2149.7	2151.54	28478.0
2014-12-10 08:00:00	ES	Futures	2151.54	2153.11	2150.23	2151.54	23305.0
2014-12-10 09:00:00	ES	Futures	2151.54	2152.59	2143.42	2145.77	240252.0
2014-12-10 10:00:00	ES	Futures	2146.04	2147.35	2138.7	2147.08	298347.0
2014-12-10 11:00:00	ES	Futures	2146.82	2147.08	2139.49	2144.99	181824.0
2014-12-10 12:00:00	ES	Futures	2144.99	2145.25	2137.92	2141.85	134719.0
2014-12-10 13:00:00	ES	Futures	2141.58	2144.46	2131.37	2131.63	183070.0
2014-12-10 14:00:00	ES	Futures	2131.63	2134.25	2121.41	2121.41	387635.0
2014-12-10 15:00:00	ES	Futures	2121.67	2132.68	2120.1	2122.72	423779.0
2014-12-10 16:00:00	ES	Futures	2122.98	2126.39	2121.67	2123.25	131335.0
2014-12-10 17:00:00	ES	Futures	2123.51	2123.51	2122.2	2122.72	3488.0
2014-12-10 18:00:00	ES	Futures	2123.25	2124.82	2121.15	2122.98	13024.0
2014-12-10 19:00:00	ES	Futures	2122.98	2125.34	2120.63	2124.56	8486.0
2014-12-10 20:00:00	ES	Futures	2124.56	2127.96	2123.51	2127.18	11618.0
2014-12-10 21:00:00	ES	Futures	2126.91	2127.7	2124.82	2126.65	5457.0
2014-12-10 22:00:00	ES	Futures	2126.65	2127.44	2124.03	2126.91	4955.0
2014-12-10 23:00:00	ES	Futures	2127.18	2129.01	2126.39	2128.75	4527.0
2014-12-10 00:00:00	NQ	Futures	5020.65	5027.1	5020.36	5027.1	1091.0
2014-12-10 01:00:00	NQ	Futures	5027.1	5032.37	5025.93	5031.49	945.0
2014-12-10 02:00:00	NQ	Futures	5031.79	5032.37	5023.29	5024.46	1465.0
2014-12-10 03:00:00	NQ	Futures	5024.17	5033.84	5022.7	5028.27	4343.0
2014-12-10 04:00:00	NQ	Futures	5027.98	5030.03	5020.65	5027.39	2820.0
2014-12-10 05:00:00	NQ	Futures	5027.1	5029.44	5024.46	5027.1	903.0
2014-12-10 06:00:00	NQ	Futures	5026.81	5028.27	5024.76	5028.27	1425.0
2014-12-10 07:00:00	NQ	Futures	5027.69	5032.08	5019.48	5021.83	3787.0
2014-12-10 08:00:00	NQ	Futures	5021.83	5030.91	5019.48	5023.88	5331.0
2014-12-10 09:00:00	NQ	Futures	5023.58	5037.65	5010.69	5019.19	53513.0
2014-12-10 10:00:00	NQ	Futures	5019.19	5022.12	4995.75	5020.36	58457.0
2014-12-10 11:00:00	NQ	Futures	5020.36	5021.53	5002.78	5019.48	30781.0
2014-12-10 12:00:00	NQ	Futures	5019.19	5019.48	4996.92	5003.66	25064.0
2014-12-10 13:00:00	NQ	Futures	5003.37	5013.03	4977.0	4978.46	34985.0
2014-12-10 14:00:00	NQ	Futures	4978.46	4982.86	4950.04	4950.33	59669.0
2014-12-10 15:00:00	NQ	Futures	4950.33	4975.24	4944.76	4954.43	64400.0
2014-12-10 16:00:00	NQ	Futures	4954.43	4960.88	4949.45	4952.97	11988.0
2014-12-10 17:00:00	NQ	Futures	4953.26	4954.73	4952.38	4953.55	291.0
2014-12-10 18:00:00	NQ	Futures	4955.61	4958.83	4950.04	4954.73	1974.0
2014-12-10 19:00:00	NQ	Futures	4954.43	4959.12	4947.69	4958.83	2472.0
2014-12-10 20:00:00	NQ	Futures	4959.12	4965.86	4955.61	4964.4	3041.0
2014-12-10 21:00:00	NQ	Futures	4964.4	4965.86	4958.24	4962.64	1552.0
2014-12-10 22:00:00	NQ	Futures	4962.34	4963.22	4955.61	4962.64	1186.0
2014-12-10 23:00:00	NQ	Futures	4962.64	4965.86	4960.29	4964.98	901.0
2014-12-10 00:00:00	YM	Futures	18467.2	18491.2	18467.2	18491.2	30.0
2014-12-10 01:00:00	YM	Futures	18494.4	18516.3	18491.2	18512.1	60.0

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

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