PREVIEW / futures_1hour / 2014-11-06

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-06.parquet
  size:    52 KB
  rows:    1,564

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-06 00:00:00	ES	Futures	2109.89	2110.93	2108.58	2110.15	4440.0
2014-11-06 01:00:00	ES	Futures	2110.15	2112.77	2109.89	2111.2	2807.0
2014-11-06 02:00:00	ES	Futures	2111.2	2113.03	2109.36	2110.41	7234.0
2014-11-06 03:00:00	ES	Futures	2110.15	2113.03	2109.36	2110.93	19272.0
2014-11-06 04:00:00	ES	Futures	2110.93	2112.24	2109.36	2110.93	16097.0
2014-11-06 05:00:00	ES	Futures	2110.67	2113.29	2110.41	2113.03	10333.0
2014-11-06 06:00:00	ES	Futures	2113.03	2114.6	2111.98	2113.03	14300.0
2014-11-06 07:00:00	ES	Futures	2113.03	2113.55	2109.89	2110.67	20140.0
2014-11-06 08:00:00	ES	Futures	2110.41	2123.77	2110.15	2120.89	123655.0
2014-11-06 09:00:00	ES	Futures	2120.63	2121.94	2112.24	2114.08	244570.0
2014-11-06 10:00:00	ES	Futures	2114.08	2116.17	2107.0	2115.12	299721.0
2014-11-06 11:00:00	ES	Futures	2115.39	2120.36	2114.86	2117.74	194152.0
2014-11-06 12:00:00	ES	Futures	2117.74	2119.84	2116.17	2119.05	82299.0
2014-11-06 13:00:00	ES	Futures	2119.32	2121.94	2118.27	2121.15	80265.0
2014-11-06 14:00:00	ES	Futures	2121.41	2122.46	2119.05	2121.67	67764.0
2014-11-06 15:00:00	ES	Futures	2121.67	2124.56	2119.32	2123.51	159313.0
2014-11-06 16:00:00	ES	Futures	2123.51	2126.39	2123.25	2126.13	60684.0
2014-11-06 17:00:00	ES	Futures	2125.87	2126.39	2125.34	2125.34	1989.0
2014-11-06 18:00:00	ES	Futures	2124.29	2125.87	2124.03	2125.6	5586.0
2014-11-06 19:00:00	ES	Futures	2125.87	2126.13	2125.08	2126.13	3283.0
2014-11-06 20:00:00	ES	Futures	2126.13	2126.65	2125.34	2125.87	2960.0
2014-11-06 21:00:00	ES	Futures	2126.13	2127.18	2124.82	2126.39	3374.0
2014-11-06 22:00:00	ES	Futures	2126.39	2127.18	2125.87	2127.18	2307.0
2014-11-06 23:00:00	ES	Futures	2127.18	2128.75	2126.65	2128.48	3795.0
2014-11-06 00:00:00	NQ	Futures	4846.31	4848.07	4843.09	4846.02	894.0
2014-11-06 01:00:00	NQ	Futures	4846.02	4852.76	4845.44	4849.83	382.0
2014-11-06 02:00:00	NQ	Futures	4849.83	4853.93	4846.31	4849.24	921.0
2014-11-06 03:00:00	NQ	Futures	4848.37	4855.69	4846.31	4849.54	2450.0
2014-11-06 04:00:00	NQ	Futures	4849.24	4850.71	4845.44	4847.19	2495.0
2014-11-06 05:00:00	NQ	Futures	4847.19	4855.1	4846.61	4854.52	1487.0
2014-11-06 06:00:00	NQ	Futures	4855.1	4858.03	4852.17	4855.1	2555.0
2014-11-06 07:00:00	NQ	Futures	4855.1	4855.69	4846.9	4848.66	3702.0
2014-11-06 08:00:00	NQ	Futures	4848.37	4877.96	4848.07	4871.81	21567.0
2014-11-06 09:00:00	NQ	Futures	4872.1	4874.15	4851.59	4860.96	47064.0
2014-11-06 10:00:00	NQ	Futures	4861.26	4865.07	4840.75	4854.81	52494.0
2014-11-06 11:00:00	NQ	Futures	4855.1	4867.7	4853.64	4859.5	25051.0
2014-11-06 12:00:00	NQ	Futures	4859.5	4861.84	4854.23	4858.03	13027.0
2014-11-06 13:00:00	NQ	Futures	4858.33	4866.82	4858.03	4866.24	12303.0
2014-11-06 14:00:00	NQ	Futures	4866.53	4870.63	4860.67	4868.58	12902.0
2014-11-06 15:00:00	NQ	Futures	4868.88	4878.55	4863.89	4877.08	23078.0
2014-11-06 16:00:00	NQ	Futures	4877.08	4883.82	4877.08	4882.35	6065.0
2014-11-06 17:00:00	NQ	Futures	4882.35	4883.53	4881.77	4882.94	188.0
2014-11-06 18:00:00	NQ	Futures	4880.89	4882.94	4879.13	4882.65	765.0
2014-11-06 19:00:00	NQ	Futures	4882.94	4883.53	4880.89	4883.23	522.0
2014-11-06 20:00:00	NQ	Futures	4882.94	4884.99	4881.77	4884.41	523.0
2014-11-06 21:00:00	NQ	Futures	4883.82	4886.75	4881.48	4884.99	679.0
2014-11-06 22:00:00	NQ	Futures	4884.99	4887.34	4883.82	4886.16	724.0
2014-11-06 23:00:00	NQ	Futures	4886.46	4891.44	4884.7	4890.27	876.0
2014-11-06 00:00:00	YM	Futures	18071.1	18074.2	18057.6	18072.1	1578.0
2014-11-06 01:00:00	YM	Futures	18072.1	18090.8	18072.1	18082.5	550.0

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

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