PREVIEW / futures_1hour / 2014-01-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1896.96	1897.48	1896.45	1896.7	1727.0
2014-01-13 01:00:00	ES	Futures	1896.96	1897.74	1895.93	1896.45	2598.0
2014-01-13 02:00:00	ES	Futures	1896.19	1898.52	1896.19	1898.26	4446.0
2014-01-13 03:00:00	ES	Futures	1898.52	1898.77	1895.93	1896.19	18252.0
2014-01-13 04:00:00	ES	Futures	1895.93	1898.26	1895.67	1898.26	9769.0
2014-01-13 05:00:00	ES	Futures	1898.0	1898.26	1895.67	1896.7	8113.0
2014-01-13 06:00:00	ES	Futures	1896.7	1896.7	1893.86	1895.15	12251.0
2014-01-13 07:00:00	ES	Futures	1895.15	1897.74	1894.64	1897.22	12208.0
2014-01-13 08:00:00	ES	Futures	1897.22	1897.48	1895.67	1895.93	17916.0
2014-01-13 09:00:00	ES	Futures	1895.93	1899.81	1894.89	1897.48	163080.0
2014-01-13 10:00:00	ES	Futures	1897.74	1901.88	1897.48	1900.07	158918.0
2014-01-13 11:00:00	ES	Futures	1899.81	1900.07	1897.74	1899.03	116120.0
2014-01-13 12:00:00	ES	Futures	1899.03	1899.29	1888.94	1888.94	195772.0
2014-01-13 13:00:00	ES	Futures	1889.2	1889.72	1884.55	1887.13	202797.0
2014-01-13 14:00:00	ES	Futures	1886.88	1887.65	1878.6	1879.89	271247.0
2014-01-13 15:00:00	ES	Futures	1880.15	1880.15	1872.13	1876.27	371358.0
2014-01-13 16:00:00	ES	Futures	1876.27	1878.34	1875.24	1877.56	106069.0
2014-01-13 17:00:00	ES	Futures	1877.82	1878.6	1877.56	1877.82	3522.0
2014-01-13 18:00:00	ES	Futures	1878.6	1879.12	1877.82	1878.86	8458.0
2014-01-13 19:00:00	ES	Futures	1878.6	1879.12	1878.08	1878.6	5465.0
2014-01-13 20:00:00	ES	Futures	1878.34	1879.63	1878.34	1879.63	3837.0
2014-01-13 21:00:00	ES	Futures	1879.63	1879.89	1878.34	1878.86	3619.0
2014-01-13 22:00:00	ES	Futures	1879.12	1879.89	1878.6	1879.12	4821.0
2014-01-13 23:00:00	ES	Futures	1879.37	1879.63	1877.82	1877.82	4828.0
2014-01-13 00:00:00	NQ	Futures	4131.79	4133.54	4131.79	4131.79	133.0
2014-01-13 01:00:00	NQ	Futures	4132.37	4133.54	4130.92	4131.21	186.0
2014-01-13 02:00:00	NQ	Futures	4131.79	4136.44	4131.21	4135.57	298.0
2014-01-13 03:00:00	NQ	Futures	4135.57	4137.03	4130.63	4130.63	2685.0
2014-01-13 04:00:00	NQ	Futures	4130.63	4134.99	4130.05	4134.7	1260.0
2014-01-13 05:00:00	NQ	Futures	4134.7	4134.7	4128.89	4130.92	1326.0
2014-01-13 06:00:00	NQ	Futures	4130.92	4130.92	4123.65	4127.43	2014.0
2014-01-13 07:00:00	NQ	Futures	4127.72	4136.73	4127.14	4135.28	1249.0
2014-01-13 08:00:00	NQ	Futures	4135.57	4136.44	4131.21	4131.5	2469.0
2014-01-13 09:00:00	NQ	Futures	4131.5	4140.51	4127.14	4135.28	35953.0
2014-01-13 10:00:00	NQ	Futures	4135.28	4146.91	4135.28	4145.46	39981.0
2014-01-13 11:00:00	NQ	Futures	4145.46	4146.33	4140.51	4144.87	24963.0
2014-01-13 12:00:00	NQ	Futures	4144.58	4145.46	4119.87	4120.17	38336.0
2014-01-13 13:00:00	NQ	Futures	4120.17	4120.17	4105.05	4109.99	39159.0
2014-01-13 14:00:00	NQ	Futures	4110.28	4112.03	4083.25	4087.03	52042.0
2014-01-13 15:00:00	NQ	Futures	4086.74	4086.74	4060.87	4077.73	78026.0
2014-01-13 16:00:00	NQ	Futures	4077.73	4082.67	4075.98	4080.63	9527.0
2014-01-13 17:00:00	NQ	Futures	4080.63	4082.38	4080.63	4082.09	229.0
2014-01-13 18:00:00	NQ	Futures	4081.5	4083.54	4080.34	4082.09	682.0
2014-01-13 19:00:00	NQ	Futures	4082.38	4082.96	4080.63	4081.8	412.0
2014-01-13 20:00:00	NQ	Futures	4081.8	4083.83	4081.5	4083.83	446.0
2014-01-13 21:00:00	NQ	Futures	4084.12	4084.12	4081.21	4082.67	418.0
2014-01-13 22:00:00	NQ	Futures	4082.67	4083.25	4081.21	4082.38	821.0
2014-01-13 23:00:00	NQ	Futures	4082.67	4082.96	4078.31	4078.6	657.0
2014-01-13 00:00:00	YM	Futures	16759.2	16766.4	16758.2	16763.3	325.0
2014-01-13 01:00:00	YM	Futures	16762.3	16767.4	16755.1	16758.2	324.0

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

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