PREVIEW / futures_1hour / 2014-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-01-07.parquet
  size:    49 KB
  rows:    1,569

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-07 00:00:00	ES	Futures	1886.88	1888.17	1886.1	1887.39	2845.0
2014-01-07 01:00:00	ES	Futures	1887.13	1887.39	1885.58	1885.84	2597.0
2014-01-07 02:00:00	ES	Futures	1885.58	1887.91	1885.58	1886.88	4864.0
2014-01-07 03:00:00	ES	Futures	1886.62	1888.17	1885.07	1888.17	15267.0
2014-01-07 04:00:00	ES	Futures	1887.91	1889.2	1887.91	1889.2	13645.0
2014-01-07 05:00:00	ES	Futures	1889.2	1891.53	1888.69	1891.27	14695.0
2014-01-07 06:00:00	ES	Futures	1891.01	1891.27	1889.2	1889.46	10329.0
2014-01-07 07:00:00	ES	Futures	1889.46	1892.05	1889.2	1889.98	15817.0
2014-01-07 08:00:00	ES	Futures	1889.98	1891.27	1889.46	1891.27	17957.0
2014-01-07 09:00:00	ES	Futures	1891.27	1895.41	1889.46	1895.15	202276.0
2014-01-07 10:00:00	ES	Futures	1895.41	1898.26	1894.64	1896.7	181606.0
2014-01-07 11:00:00	ES	Futures	1896.7	1896.96	1893.6	1894.38	86274.0
2014-01-07 12:00:00	ES	Futures	1894.12	1896.19	1893.34	1895.93	70912.0
2014-01-07 13:00:00	ES	Futures	1896.19	1896.7	1893.34	1893.6	63731.0
2014-01-07 14:00:00	ES	Futures	1893.6	1895.67	1891.27	1895.15	149024.0
2014-01-07 15:00:00	ES	Futures	1895.15	1897.74	1894.38	1894.64	194779.0
2014-01-07 16:00:00	ES	Futures	1894.64	1894.89	1893.34	1893.6	72120.0
2014-01-07 17:00:00	ES	Futures	1893.6	1894.12	1893.6	1893.86	2041.0
2014-01-07 18:00:00	ES	Futures	1894.12	1894.38	1893.6	1893.86	3346.0
2014-01-07 19:00:00	ES	Futures	1893.6	1893.86	1892.57	1893.08	3465.0
2014-01-07 20:00:00	ES	Futures	1893.08	1894.12	1892.82	1893.34	2641.0
2014-01-07 21:00:00	ES	Futures	1893.34	1894.38	1893.08	1893.86	1172.0
2014-01-07 22:00:00	ES	Futures	1893.86	1895.15	1893.6	1894.64	2806.0
2014-01-07 23:00:00	ES	Futures	1894.38	1895.93	1894.38	1895.67	2283.0
2014-01-07 00:00:00	NQ	Futures	4097.2	4099.53	4096.33	4098.36	420.0
2014-01-07 01:00:00	NQ	Futures	4098.36	4098.36	4095.46	4096.04	308.0
2014-01-07 02:00:00	NQ	Futures	4095.46	4100.11	4095.46	4097.78	430.0
2014-01-07 03:00:00	NQ	Futures	4097.2	4100.4	4093.42	4099.82	1821.0
2014-01-07 04:00:00	NQ	Futures	4100.4	4102.43	4099.53	4102.43	1154.0
2014-01-07 05:00:00	NQ	Futures	4102.14	4109.41	4101.27	4108.83	2127.0
2014-01-07 06:00:00	NQ	Futures	4108.83	4109.41	4105.34	4106.5	1336.0
2014-01-07 07:00:00	NQ	Futures	4106.5	4110.86	4105.63	4107.38	1914.0
2014-01-07 08:00:00	NQ	Futures	4107.67	4111.44	4107.08	4109.99	3338.0
2014-01-07 09:00:00	NQ	Futures	4109.7	4122.78	4103.6	4121.91	31072.0
2014-01-07 10:00:00	NQ	Futures	4121.91	4130.63	4121.33	4128.01	31254.0
2014-01-07 11:00:00	NQ	Futures	4128.3	4129.47	4120.17	4121.91	14603.0
2014-01-07 12:00:00	NQ	Futures	4121.91	4128.6	4119.29	4127.43	11930.0
2014-01-07 13:00:00	NQ	Futures	4127.14	4131.21	4123.07	4124.24	11255.0
2014-01-07 14:00:00	NQ	Futures	4123.94	4129.47	4116.97	4128.89	28115.0
2014-01-07 15:00:00	NQ	Futures	4129.18	4136.15	4128.01	4128.6	41899.0
2014-01-07 16:00:00	NQ	Futures	4128.6	4129.47	4125.98	4127.43	4898.0
2014-01-07 17:00:00	NQ	Futures	4127.43	4127.72	4126.85	4126.85	69.0
2014-01-07 18:00:00	NQ	Futures	4125.69	4125.98	4124.24	4124.53	397.0
2014-01-07 19:00:00	NQ	Futures	4124.53	4124.53	4122.2	4123.65	465.0
2014-01-07 20:00:00	NQ	Futures	4123.94	4127.72	4123.65	4125.4	628.0
2014-01-07 21:00:00	NQ	Futures	4125.4	4127.72	4125.4	4126.56	131.0
2014-01-07 22:00:00	NQ	Futures	4126.56	4128.3	4125.4	4127.72	329.0
2014-01-07 23:00:00	NQ	Futures	4127.43	4129.47	4126.85	4129.18	372.0
2014-01-07 00:00:00	YM	Futures	16807.4	16816.6	16802.3	16811.5	499.0
2014-01-07 01:00:00	YM	Futures	16810.5	16810.5	16796.1	16796.1	509.0

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

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