PREVIEW / futures_1hour / 2014-07-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-07-08.parquet
  size:    48 KB
  rows:    1,528

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-07-08 00:00:00	ES	Futures	2052.86	2053.12	2052.6	2052.6	663.0
2014-07-08 01:00:00	ES	Futures	2052.86	2053.64	2052.07	2052.86	1573.0
2014-07-08 02:00:00	ES	Futures	2052.86	2054.16	2052.86	2053.38	4399.0
2014-07-08 03:00:00	ES	Futures	2053.12	2053.9	2051.55	2053.64	24112.0
2014-07-08 04:00:00	ES	Futures	2053.64	2053.64	2051.03	2051.29	16246.0
2014-07-08 05:00:00	ES	Futures	2051.29	2052.07	2050.77	2051.03	9783.0
2014-07-08 06:00:00	ES	Futures	2050.77	2052.34	2049.99	2051.81	12287.0
2014-07-08 07:00:00	ES	Futures	2051.81	2052.86	2051.03	2052.07	12072.0
2014-07-08 08:00:00	ES	Futures	2052.34	2052.34	2050.25	2050.77	19980.0
2014-07-08 09:00:00	ES	Futures	2051.03	2051.03	2042.95	2045.82	264018.0
2014-07-08 10:00:00	ES	Futures	2045.82	2045.82	2038.78	2042.17	339203.0
2014-07-08 11:00:00	ES	Futures	2042.17	2042.43	2036.44	2038.78	275195.0
2014-07-08 12:00:00	ES	Futures	2038.52	2040.35	2035.66	2039.57	173988.0
2014-07-08 13:00:00	ES	Futures	2039.83	2044.52	2038.26	2043.21	146409.0
2014-07-08 14:00:00	ES	Futures	2043.47	2043.47	2040.61	2040.87	115443.0
2014-07-08 15:00:00	ES	Futures	2040.87	2041.91	2038.78	2041.13	242415.0
2014-07-08 16:00:00	ES	Futures	2041.13	2044.0	2040.87	2043.21	97679.0
2014-07-08 17:00:00	ES	Futures	2043.47	2043.73	2043.21	2043.73	3379.0
2014-07-08 18:00:00	ES	Futures	2043.73	2044.0	2043.21	2043.47	2153.0
2014-07-08 19:00:00	ES	Futures	2043.73	2044.0	2043.21	2043.47	1232.0
2014-07-08 20:00:00	ES	Futures	2043.47	2045.04	2043.47	2044.78	5662.0
2014-07-08 21:00:00	ES	Futures	2044.52	2045.04	2043.73	2044.26	3046.0
2014-07-08 22:00:00	ES	Futures	2044.26	2045.56	2043.73	2044.78	5773.0
2014-07-08 23:00:00	ES	Futures	2045.04	2045.04	2043.73	2044.26	2644.0
2014-07-08 00:00:00	NQ	Futures	4559.52	4560.1	4558.93	4559.23	216.0
2014-07-08 01:00:00	NQ	Futures	4559.23	4560.39	4558.06	4559.81	320.0
2014-07-08 02:00:00	NQ	Futures	4559.81	4563.31	4559.52	4561.56	997.0
2014-07-08 03:00:00	NQ	Futures	4561.56	4562.44	4557.77	4561.56	4913.0
2014-07-08 04:00:00	NQ	Futures	4561.56	4561.56	4556.6	4556.6	1828.0
2014-07-08 05:00:00	NQ	Futures	4556.31	4558.06	4555.72	4555.72	1224.0
2014-07-08 06:00:00	NQ	Futures	4555.72	4558.64	4553.97	4556.31	1738.0
2014-07-08 07:00:00	NQ	Futures	4556.01	4559.81	4555.72	4558.06	1695.0
2014-07-08 08:00:00	NQ	Futures	4558.06	4558.35	4553.09	4554.26	3432.0
2014-07-08 09:00:00	NQ	Futures	4554.26	4554.55	4526.23	4530.9	54089.0
2014-07-08 10:00:00	NQ	Futures	4530.61	4530.61	4502.87	4512.21	77401.0
2014-07-08 11:00:00	NQ	Futures	4511.92	4512.5	4486.81	4494.11	49429.0
2014-07-08 12:00:00	NQ	Futures	4494.4	4504.03	4488.56	4502.57	34799.0
2014-07-08 13:00:00	NQ	Futures	4502.57	4515.42	4496.73	4512.21	27611.0
2014-07-08 14:00:00	NQ	Futures	4512.21	4512.79	4503.45	4504.33	21457.0
2014-07-08 15:00:00	NQ	Futures	4504.62	4510.46	4497.9	4506.66	40166.0
2014-07-08 16:00:00	NQ	Futures	4506.66	4513.96	4505.79	4511.04	7299.0
2014-07-08 17:00:00	NQ	Futures	4511.04	4513.09	4511.04	4512.5	316.0
2014-07-08 18:00:00	NQ	Futures	4512.79	4513.96	4512.5	4512.79	362.0
2014-07-08 19:00:00	NQ	Futures	4513.09	4513.67	4511.92	4511.92	388.0
2014-07-08 20:00:00	NQ	Futures	4511.92	4514.84	4511.92	4513.67	546.0
2014-07-08 21:00:00	NQ	Futures	4513.96	4514.84	4512.21	4512.5	443.0
2014-07-08 22:00:00	NQ	Futures	4512.5	4514.55	4511.33	4513.67	875.0
2014-07-08 23:00:00	NQ	Futures	4513.09	4513.67	4511.33	4512.5	330.0
2014-07-08 00:00:00	YM	Futures	17521.4	17522.5	17519.4	17519.4	150.0
2014-07-08 01:00:00	YM	Futures	17519.4	17536.9	17515.2	17526.6	1065.0

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

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