PREVIEW / futures_1hour / 2014-11-12

all futures 1-hour files

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

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-12 00:00:00	ES	Futures	2130.84	2131.37	2130.06	2130.58	2637.0
2014-11-12 01:00:00	ES	Futures	2130.58	2131.37	2130.06	2131.37	1828.0
2014-11-12 02:00:00	ES	Futures	2131.1	2131.63	2130.06	2130.84	4881.0
2014-11-12 03:00:00	ES	Futures	2130.84	2132.41	2127.7	2128.22	27141.0
2014-11-12 04:00:00	ES	Futures	2128.48	2129.53	2127.7	2127.96	14253.0
2014-11-12 05:00:00	ES	Futures	2127.96	2131.37	2127.96	2129.27	16505.0
2014-11-12 06:00:00	ES	Futures	2129.27	2129.53	2125.34	2126.13	26544.0
2014-11-12 07:00:00	ES	Futures	2126.13	2127.18	2124.82	2126.13	26599.0
2014-11-12 08:00:00	ES	Futures	2125.87	2127.18	2123.77	2125.6	36893.0
2014-11-12 09:00:00	ES	Futures	2125.6	2129.01	2124.82	2128.75	136466.0
2014-11-12 10:00:00	ES	Futures	2128.75	2131.63	2126.65	2126.91	181316.0
2014-11-12 11:00:00	ES	Futures	2126.91	2133.46	2125.6	2132.68	157800.0
2014-11-12 12:00:00	ES	Futures	2132.68	2134.25	2131.1	2132.68	76932.0
2014-11-12 13:00:00	ES	Futures	2132.68	2134.51	2131.37	2132.15	82846.0
2014-11-12 14:00:00	ES	Futures	2131.89	2133.99	2129.27	2130.06	69301.0
2014-11-12 15:00:00	ES	Futures	2130.06	2134.77	2129.01	2132.15	136087.0
2014-11-12 16:00:00	ES	Futures	2132.15	2134.25	2131.37	2132.68	50389.0
2014-11-12 17:00:00	ES	Futures	2132.68	2132.68	2131.89	2131.89	1706.0
2014-11-12 18:00:00	ES	Futures	2132.15	2132.41	2130.84	2131.63	2842.0
2014-11-12 19:00:00	ES	Futures	2131.63	2132.41	2131.1	2132.15	2057.0
2014-11-12 20:00:00	ES	Futures	2132.15	2133.99	2132.15	2133.2	4036.0
2014-11-12 21:00:00	ES	Futures	2133.2	2133.72	2131.89	2132.94	2701.0
2014-11-12 22:00:00	ES	Futures	2132.94	2134.25	2131.89	2133.46	3357.0
2014-11-12 23:00:00	ES	Futures	2133.72	2135.3	2133.46	2134.25	4765.0
2014-11-12 00:00:00	NQ	Futures	4897.3	4899.06	4896.42	4896.71	473.0
2014-11-12 01:00:00	NQ	Futures	4896.42	4899.06	4895.83	4899.06	496.0
2014-11-12 02:00:00	NQ	Futures	4898.76	4899.35	4895.25	4896.71	1069.0
2014-11-12 03:00:00	NQ	Futures	4896.71	4900.52	4887.34	4890.56	5114.0
2014-11-12 04:00:00	NQ	Futures	4889.97	4892.9	4889.09	4890.27	2312.0
2014-11-12 05:00:00	NQ	Futures	4889.97	4899.06	4889.68	4894.07	2636.0
2014-11-12 06:00:00	NQ	Futures	4894.66	4894.95	4885.58	4887.04	4075.0
2014-11-12 07:00:00	NQ	Futures	4887.34	4891.44	4885.58	4888.8	3952.0
2014-11-12 08:00:00	NQ	Futures	4888.8	4890.27	4883.23	4887.04	6910.0
2014-11-12 09:00:00	NQ	Futures	4886.75	4897.3	4884.99	4894.37	28716.0
2014-11-12 10:00:00	NQ	Futures	4894.37	4904.04	4891.44	4892.02	29615.0
2014-11-12 11:00:00	NQ	Futures	4891.73	4910.19	4888.51	4908.14	30288.0
2014-11-12 12:00:00	NQ	Futures	4908.43	4913.12	4906.97	4911.95	16129.0
2014-11-12 13:00:00	NQ	Futures	4911.95	4915.76	4909.9	4910.48	14262.0
2014-11-12 14:00:00	NQ	Futures	4910.48	4915.76	4903.74	4906.38	18493.0
2014-11-12 15:00:00	NQ	Futures	4906.67	4919.57	4904.04	4914.88	25527.0
2014-11-12 16:00:00	NQ	Futures	4914.88	4921.03	4913.71	4915.76	9027.0
2014-11-12 17:00:00	NQ	Futures	4915.76	4916.34	4913.71	4914.58	191.0
2014-11-12 18:00:00	NQ	Futures	4914.88	4914.88	4912.53	4914.0	679.0
2014-11-12 19:00:00	NQ	Futures	4914.29	4915.76	4912.83	4914.29	409.0
2014-11-12 20:00:00	NQ	Futures	4914.88	4918.39	4914.88	4916.93	599.0
2014-11-12 21:00:00	NQ	Futures	4916.93	4917.81	4914.58	4915.76	359.0
2014-11-12 22:00:00	NQ	Futures	4916.05	4920.74	4914.58	4918.98	745.0
2014-11-12 23:00:00	NQ	Futures	4919.27	4922.79	4919.27	4921.62	843.0
2014-11-12 00:00:00	YM	Futures	18242.6	18245.8	18235.4	18236.4	622.0
2014-11-12 01:00:00	YM	Futures	18236.4	18245.8	18236.4	18244.7	359.0

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

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