PREVIEW / futures_1hour / 2014-02-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-02-19.parquet
  size:    51 KB
  rows:    1,560

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-02-19 00:00:00	ES	Futures	1898.77	1899.55	1898.0	1898.26	3642.0
2014-02-19 01:00:00	ES	Futures	1898.26	1899.03	1898.0	1898.52	1761.0
2014-02-19 02:00:00	ES	Futures	1898.77	1900.07	1897.74	1898.0	6401.0
2014-02-19 03:00:00	ES	Futures	1898.0	1900.84	1897.48	1898.52	21866.0
2014-02-19 04:00:00	ES	Futures	1898.52	1899.55	1898.0	1898.77	12898.0
2014-02-19 05:00:00	ES	Futures	1898.52	1899.55	1896.19	1896.45	17544.0
2014-02-19 06:00:00	ES	Futures	1896.45	1897.22	1893.34	1894.38	27002.0
2014-02-19 07:00:00	ES	Futures	1894.64	1895.15	1893.34	1894.64	21068.0
2014-02-19 08:00:00	ES	Futures	1894.64	1897.48	1893.6	1896.19	43831.0
2014-02-19 09:00:00	ES	Futures	1896.19	1903.17	1894.38	1903.17	210375.0
2014-02-19 10:00:00	ES	Futures	1903.17	1908.34	1900.84	1905.5	282254.0
2014-02-19 11:00:00	ES	Futures	1905.5	1906.02	1899.55	1899.55	153129.0
2014-02-19 12:00:00	ES	Futures	1899.55	1900.33	1893.86	1897.22	212549.0
2014-02-19 13:00:00	ES	Futures	1897.22	1901.1	1896.7	1898.52	81995.0
2014-02-19 14:00:00	ES	Futures	1898.52	1902.65	1894.64	1896.96	232008.0
2014-02-19 15:00:00	ES	Futures	1896.96	1898.0	1886.36	1888.17	314494.0
2014-02-19 16:00:00	ES	Futures	1888.43	1891.01	1887.65	1889.2	92487.0
2014-02-19 17:00:00	ES	Futures	1889.46	1889.98	1889.2	1889.46	1704.0
2014-02-19 18:00:00	ES	Futures	1889.2	1892.05	1888.94	1890.5	7441.0
2014-02-19 19:00:00	ES	Futures	1890.5	1891.79	1890.24	1891.27	4896.0
2014-02-19 20:00:00	ES	Futures	1891.01	1892.57	1880.15	1882.74	32078.0
2014-02-19 21:00:00	ES	Futures	1883.0	1884.29	1880.67	1882.74	14470.0
2014-02-19 22:00:00	ES	Futures	1882.48	1883.77	1880.93	1881.44	7876.0
2014-02-19 23:00:00	ES	Futures	1881.44	1882.74	1880.67	1882.74	7245.0
2014-02-19 00:00:00	NQ	Futures	4270.45	4272.77	4269.87	4270.16	473.0
2014-02-19 01:00:00	NQ	Futures	4270.45	4271.61	4270.16	4270.74	201.0
2014-02-19 02:00:00	NQ	Futures	4270.45	4274.81	4269.58	4270.16	821.0
2014-02-19 03:00:00	NQ	Futures	4270.45	4278.3	4269.87	4273.36	2702.0
2014-02-19 04:00:00	NQ	Futures	4273.07	4275.97	4271.9	4274.52	1817.0
2014-02-19 05:00:00	NQ	Futures	4274.23	4276.26	4268.41	4268.71	1403.0
2014-02-19 06:00:00	NQ	Futures	4268.71	4270.74	4261.73	4264.05	2990.0
2014-02-19 07:00:00	NQ	Futures	4264.05	4266.38	4260.28	4265.51	3568.0
2014-02-19 08:00:00	NQ	Futures	4265.51	4270.16	4262.89	4268.12	5637.0
2014-02-19 09:00:00	NQ	Futures	4268.12	4276.84	4260.86	4269.58	44365.0
2014-02-19 10:00:00	NQ	Futures	4269.58	4277.72	4258.24	4270.74	47714.0
2014-02-19 11:00:00	NQ	Futures	4271.03	4274.52	4259.4	4259.98	23322.0
2014-02-19 12:00:00	NQ	Futures	4260.28	4261.15	4248.36	4257.95	32813.0
2014-02-19 13:00:00	NQ	Futures	4257.95	4265.22	4257.08	4257.66	14261.0
2014-02-19 14:00:00	NQ	Futures	4258.24	4269.0	4251.55	4255.92	36162.0
2014-02-19 15:00:00	NQ	Futures	4255.92	4257.95	4238.47	4246.9	46935.0
2014-02-19 16:00:00	NQ	Futures	4246.9	4255.04	4246.61	4251.55	7551.0
2014-02-19 17:00:00	NQ	Futures	4251.26	4251.55	4247.78	4248.94	515.0
2014-02-19 18:00:00	NQ	Futures	4249.23	4255.04	4249.23	4251.55	837.0
2014-02-19 19:00:00	NQ	Futures	4251.26	4254.75	4250.68	4253.59	530.0
2014-02-19 20:00:00	NQ	Futures	4253.88	4255.92	4231.79	4236.73	5400.0
2014-02-19 21:00:00	NQ	Futures	4236.44	4240.22	4232.37	4236.15	2272.0
2014-02-19 22:00:00	NQ	Futures	4236.15	4238.76	4233.24	4233.53	1359.0
2014-02-19 23:00:00	NQ	Futures	4233.53	4237.02	4232.66	4237.02	804.0
2014-02-19 00:00:00	YM	Futures	16500.8	16509.0	16497.7	16498.7	511.0
2014-02-19 01:00:00	YM	Futures	16499.8	16504.9	16497.7	16499.8	154.0

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

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