PREVIEW / futures_1hour / 2014-01-08

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-08.parquet
  size:    50 KB
  rows:    1,571

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-01-08 00:00:00	ES	Futures	1895.41	1896.19	1895.41	1896.19	2339.0
2014-01-08 01:00:00	ES	Futures	1895.93	1896.19	1895.41	1895.67	1331.0
2014-01-08 02:00:00	ES	Futures	1895.67	1896.7	1895.15	1896.19	7366.0
2014-01-08 03:00:00	ES	Futures	1896.45	1896.45	1892.82	1894.89	16442.0
2014-01-08 04:00:00	ES	Futures	1894.64	1895.41	1892.82	1892.82	7355.0
2014-01-08 05:00:00	ES	Futures	1892.82	1893.34	1891.01	1891.79	10530.0
2014-01-08 06:00:00	ES	Futures	1892.05	1892.82	1891.01	1891.27	6075.0
2014-01-08 07:00:00	ES	Futures	1891.01	1893.34	1891.01	1892.31	6984.0
2014-01-08 08:00:00	ES	Futures	1892.31	1894.38	1890.5	1893.08	45703.0
2014-01-08 09:00:00	ES	Futures	1893.08	1895.93	1888.69	1892.31	184084.0
2014-01-08 10:00:00	ES	Futures	1892.31	1898.26	1890.76	1895.93	201875.0
2014-01-08 11:00:00	ES	Futures	1895.93	1897.74	1893.6	1896.96	116315.0
2014-01-08 12:00:00	ES	Futures	1897.22	1897.74	1894.12	1894.89	74270.0
2014-01-08 13:00:00	ES	Futures	1894.64	1896.7	1893.08	1895.67	120593.0
2014-01-08 14:00:00	ES	Futures	1895.67	1897.48	1892.05	1893.86	227404.0
2014-01-08 15:00:00	ES	Futures	1893.6	1895.93	1889.46	1895.15	214885.0
2014-01-08 16:00:00	ES	Futures	1895.15	1896.96	1894.38	1895.41	68692.0
2014-01-08 17:00:00	ES	Futures	1895.67	1895.67	1895.15	1895.67	1616.0
2014-01-08 18:00:00	ES	Futures	1895.15	1895.41	1893.86	1893.86	5412.0
2014-01-08 19:00:00	ES	Futures	1894.12	1894.64	1893.86	1894.38	3465.0
2014-01-08 20:00:00	ES	Futures	1894.12	1896.19	1894.12	1895.15	3965.0
2014-01-08 21:00:00	ES	Futures	1895.15	1896.19	1895.15	1896.19	2003.0
2014-01-08 22:00:00	ES	Futures	1895.93	1896.19	1895.15	1895.67	2430.0
2014-01-08 23:00:00	ES	Futures	1895.41	1897.22	1894.89	1896.19	3932.0
2014-01-08 00:00:00	NQ	Futures	4129.18	4131.21	4128.89	4130.63	455.0
2014-01-08 01:00:00	NQ	Futures	4130.34	4130.92	4130.05	4130.34	79.0
2014-01-08 02:00:00	NQ	Futures	4130.34	4131.21	4129.18	4130.63	462.0
2014-01-08 03:00:00	NQ	Futures	4130.34	4130.34	4123.07	4127.43	1772.0
2014-01-08 04:00:00	NQ	Futures	4127.14	4128.89	4124.24	4124.82	993.0
2014-01-08 05:00:00	NQ	Futures	4124.53	4125.98	4120.75	4122.78	1269.0
2014-01-08 06:00:00	NQ	Futures	4122.49	4124.53	4121.04	4121.04	871.0
2014-01-08 07:00:00	NQ	Futures	4121.04	4127.43	4121.04	4126.27	980.0
2014-01-08 08:00:00	NQ	Futures	4126.27	4130.05	4122.78	4127.72	5381.0
2014-01-08 09:00:00	NQ	Futures	4127.72	4134.12	4121.91	4132.66	32610.0
2014-01-08 10:00:00	NQ	Futures	4132.66	4150.4	4130.05	4141.09	35490.0
2014-01-08 11:00:00	NQ	Futures	4141.09	4149.23	4138.48	4148.36	18141.0
2014-01-08 12:00:00	NQ	Futures	4148.36	4149.82	4141.39	4143.42	13333.0
2014-01-08 13:00:00	NQ	Futures	4143.42	4146.62	4139.35	4144.29	19248.0
2014-01-08 14:00:00	NQ	Futures	4144.58	4148.65	4138.48	4140.51	37546.0
2014-01-08 15:00:00	NQ	Futures	4140.22	4142.26	4127.14	4140.51	30851.0
2014-01-08 16:00:00	NQ	Futures	4140.51	4146.62	4139.06	4143.42	5680.0
2014-01-08 17:00:00	NQ	Futures	4143.42	4144.0	4142.84	4143.71	178.0
2014-01-08 18:00:00	NQ	Futures	4142.55	4142.84	4139.35	4139.35	383.0
2014-01-08 19:00:00	NQ	Futures	4139.64	4141.39	4139.35	4140.22	252.0
2014-01-08 20:00:00	NQ	Futures	4140.51	4144.29	4139.93	4142.26	667.0
2014-01-08 21:00:00	NQ	Futures	4142.55	4144.58	4142.55	4144.58	157.0
2014-01-08 22:00:00	NQ	Futures	4144.58	4144.58	4142.84	4143.71	318.0
2014-01-08 23:00:00	NQ	Futures	4144.0	4147.2	4142.55	4145.46	409.0
2014-01-08 00:00:00	YM	Futures	16891.5	16897.6	16890.4	16897.6	506.0
2014-01-08 01:00:00	YM	Futures	16897.6	16897.6	16892.5	16892.5	277.0

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

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