PREVIEW / futures_1hour / 2014-11-03

all futures 1-hour files

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

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-03 00:00:00	ES	Futures	2104.91	2105.69	2104.12	2104.91	1002.0
2014-11-03 01:00:00	ES	Futures	2105.17	2107.53	2104.91	2105.43	2383.0
2014-11-03 02:00:00	ES	Futures	2105.69	2106.22	2103.86	2104.65	5990.0
2014-11-03 03:00:00	ES	Futures	2104.65	2107.27	2103.6	2105.17	19956.0
2014-11-03 04:00:00	ES	Futures	2105.43	2105.96	2103.86	2105.43	20326.0
2014-11-03 05:00:00	ES	Futures	2105.43	2107.27	2104.91	2105.69	12843.0
2014-11-03 06:00:00	ES	Futures	2105.96	2106.48	2104.38	2105.17	14390.0
2014-11-03 07:00:00	ES	Futures	2105.17	2105.96	2103.07	2105.69	18536.0
2014-11-03 08:00:00	ES	Futures	2105.69	2108.58	2104.12	2107.79	28906.0
2014-11-03 09:00:00	ES	Futures	2107.53	2112.77	2107.27	2109.89	184662.0
2014-11-03 10:00:00	ES	Futures	2109.89	2113.55	2104.12	2109.62	260406.0
2014-11-03 11:00:00	ES	Futures	2109.62	2111.46	2107.27	2110.67	147975.0
2014-11-03 12:00:00	ES	Futures	2110.93	2115.91	2109.89	2114.86	92367.0
2014-11-03 13:00:00	ES	Futures	2114.86	2115.65	2112.77	2112.77	85988.0
2014-11-03 14:00:00	ES	Futures	2112.77	2113.55	2106.22	2107.27	150799.0
2014-11-03 15:00:00	ES	Futures	2107.27	2109.62	2103.86	2108.31	225115.0
2014-11-03 16:00:00	ES	Futures	2108.31	2109.36	2105.69	2107.0	60507.0
2014-11-03 17:00:00	ES	Futures	2106.74	2107.79	2106.74	2107.53	1479.0
2014-11-03 18:00:00	ES	Futures	2106.74	2107.27	2105.17	2105.43	4413.0
2014-11-03 19:00:00	ES	Futures	2105.43	2105.69	2102.55	2103.6	10696.0
2014-11-03 20:00:00	ES	Futures	2103.34	2104.12	2102.29	2103.07	5937.0
2014-11-03 21:00:00	ES	Futures	2103.34	2106.74	2102.81	2106.48	4700.0
2014-11-03 22:00:00	ES	Futures	2106.74	2108.58	2104.91	2105.43	5281.0
2014-11-03 23:00:00	ES	Futures	2105.43	2106.74	2105.17	2106.48	1686.0
2014-11-03 00:00:00	NQ	Futures	4856.57	4859.79	4855.98	4857.74	194.0
2014-11-03 01:00:00	NQ	Futures	4858.03	4863.02	4857.74	4859.5	320.0
2014-11-03 02:00:00	NQ	Futures	4859.79	4860.38	4854.81	4857.45	413.0
2014-11-03 03:00:00	NQ	Futures	4857.16	4864.48	4854.81	4859.79	2113.0
2014-11-03 04:00:00	NQ	Futures	4859.79	4860.67	4854.52	4858.03	2568.0
2014-11-03 05:00:00	NQ	Futures	4858.33	4863.02	4857.45	4859.5	1683.0
2014-11-03 06:00:00	NQ	Futures	4859.79	4861.55	4858.03	4859.5	1931.0
2014-11-03 07:00:00	NQ	Futures	4859.5	4861.84	4855.1	4860.67	2534.0
2014-11-03 08:00:00	NQ	Futures	4860.96	4868.0	4858.62	4866.53	3965.0
2014-11-03 09:00:00	NQ	Futures	4866.53	4887.34	4865.07	4884.7	32456.0
2014-11-03 10:00:00	NQ	Futures	4884.7	4891.73	4869.17	4883.53	46123.0
2014-11-03 11:00:00	NQ	Futures	4883.53	4886.16	4876.49	4882.35	21109.0
2014-11-03 12:00:00	NQ	Futures	4882.35	4888.51	4877.67	4884.11	14800.0
2014-11-03 13:00:00	NQ	Futures	4884.41	4885.28	4880.3	4881.18	12297.0
2014-11-03 14:00:00	NQ	Futures	4881.18	4883.53	4869.17	4871.81	26561.0
2014-11-03 15:00:00	NQ	Futures	4871.51	4880.01	4865.36	4878.25	32765.0
2014-11-03 16:00:00	NQ	Futures	4878.25	4880.01	4869.46	4871.22	9296.0
2014-11-03 17:00:00	NQ	Futures	4871.51	4873.27	4871.22	4873.27	114.0
2014-11-03 18:00:00	NQ	Futures	4872.69	4872.98	4868.29	4868.58	622.0
2014-11-03 19:00:00	NQ	Futures	4868.88	4869.17	4862.43	4863.6	1387.0
2014-11-03 20:00:00	NQ	Futures	4863.6	4866.24	4860.38	4863.89	1035.0
2014-11-03 21:00:00	NQ	Futures	4863.89	4871.51	4863.6	4871.51	835.0
2014-11-03 22:00:00	NQ	Futures	4871.81	4876.2	4867.41	4868.29	1095.0
2014-11-03 23:00:00	NQ	Futures	4868.0	4871.22	4867.41	4870.93	438.0
2014-11-03 00:00:00	YM	Futures	17968.1	17976.5	17965.0	17969.2	235.0
2014-11-03 01:00:00	YM	Futures	17970.2	17984.8	17970.2	17973.3	346.0

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

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