PREVIEW / futures_1hour / 2015-01-13

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-01-13.parquet
  size:    53 KB
  rows:    1,562

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
2015-01-13 00:00:00	ES	Futures	2131.27	2133.64	2130.74	2133.37	4068.0
2015-01-13 01:00:00	ES	Futures	2133.64	2134.16	2130.48	2131.27	3846.0
2015-01-13 02:00:00	ES	Futures	2131.0	2133.9	2127.58	2127.58	13839.0
2015-01-13 03:00:00	ES	Futures	2127.85	2133.9	2126.27	2130.74	29097.0
2015-01-13 04:00:00	ES	Futures	2130.74	2139.16	2129.95	2137.32	25106.0
2015-01-13 05:00:00	ES	Futures	2137.32	2138.37	2133.37	2135.48	14309.0
2015-01-13 06:00:00	ES	Futures	2135.48	2142.58	2134.42	2142.32	23762.0
2015-01-13 07:00:00	ES	Futures	2142.32	2142.85	2137.58	2137.85	26860.0
2015-01-13 08:00:00	ES	Futures	2137.58	2139.95	2135.21	2138.9	29855.0
2015-01-13 09:00:00	ES	Futures	2138.9	2158.63	2138.64	2158.11	312264.0
2015-01-13 10:00:00	ES	Futures	2158.11	2159.69	2152.85	2156.0	247818.0
2015-01-13 11:00:00	ES	Futures	2155.74	2156.27	2148.37	2149.16	240862.0
2015-01-13 12:00:00	ES	Futures	2149.42	2150.21	2137.58	2142.06	230331.0
2015-01-13 13:00:00	ES	Futures	2142.06	2143.64	2112.06	2117.58	370234.0
2015-01-13 14:00:00	ES	Futures	2117.85	2119.95	2106.27	2110.48	418215.0
2015-01-13 15:00:00	ES	Futures	2110.48	2129.16	2108.37	2123.11	397171.0
2015-01-13 16:00:00	ES	Futures	2123.11	2126.0	2121.27	2124.95	73525.0
2015-01-13 17:00:00	ES	Futures	2124.95	2125.21	2123.37	2123.64	1664.0
2015-01-13 18:00:00	ES	Futures	2123.37	2125.48	2120.21	2122.58	6327.0
2015-01-13 19:00:00	ES	Futures	2122.85	2125.74	2121.0	2121.53	7033.0
2015-01-13 20:00:00	ES	Futures	2121.79	2121.79	2112.06	2117.06	17763.0
2015-01-13 21:00:00	ES	Futures	2117.32	2119.69	2115.48	2117.06	9338.0
2015-01-13 22:00:00	ES	Futures	2117.06	2117.32	2111.27	2114.69	7012.0
2015-01-13 23:00:00	ES	Futures	2114.69	2116.53	2113.64	2115.21	4237.0
2015-01-13 00:00:00	NQ	Futures	4901.37	4906.65	4899.6	4906.06	558.0
2015-01-13 01:00:00	NQ	Futures	4906.06	4907.53	4898.43	4901.07	354.0
2015-01-13 02:00:00	NQ	Futures	4901.07	4906.65	4891.38	4892.26	1407.0
2015-01-13 03:00:00	NQ	Futures	4892.26	4906.06	4887.86	4896.96	4901.0
2015-01-13 04:00:00	NQ	Futures	4897.25	4920.46	4896.37	4915.17	4954.0
2015-01-13 05:00:00	NQ	Futures	4915.17	4918.11	4906.36	4911.64	2373.0
2015-01-13 06:00:00	NQ	Futures	4911.35	4929.85	4908.71	4927.5	4842.0
2015-01-13 07:00:00	NQ	Futures	4927.5	4928.68	4918.69	4919.28	3763.0
2015-01-13 08:00:00	NQ	Futures	4918.99	4926.04	4913.41	4924.27	4861.0
2015-01-13 09:00:00	NQ	Futures	4923.98	4985.36	4923.69	4983.89	66311.0
2015-01-13 10:00:00	NQ	Futures	4983.6	4990.06	4976.84	4984.19	45527.0
2015-01-13 11:00:00	NQ	Futures	4983.89	4985.07	4968.62	4970.97	33582.0
2015-01-13 12:00:00	NQ	Futures	4971.56	4973.61	4939.25	4947.18	44522.0
2015-01-13 13:00:00	NQ	Futures	4947.18	4953.05	4870.82	4883.16	82580.0
2015-01-13 14:00:00	NQ	Futures	4883.16	4891.67	4847.91	4862.01	85592.0
2015-01-13 15:00:00	NQ	Futures	4862.31	4906.06	4854.38	4887.27	77905.0
2015-01-13 16:00:00	NQ	Futures	4887.56	4894.32	4884.33	4892.85	8635.0
2015-01-13 17:00:00	NQ	Futures	4892.85	4893.44	4887.56	4887.56	204.0
2015-01-13 18:00:00	NQ	Futures	4884.63	4893.14	4881.69	4887.56	909.0
2015-01-13 19:00:00	NQ	Futures	4887.86	4895.49	4884.33	4885.8	2104.0
2015-01-13 20:00:00	NQ	Futures	4886.09	4886.97	4863.48	4876.11	4404.0
2015-01-13 21:00:00	NQ	Futures	4875.81	4880.81	4869.94	4875.52	2774.0
2015-01-13 22:00:00	NQ	Futures	4874.93	4876.7	4862.01	4870.82	1979.0
2015-01-13 23:00:00	NQ	Futures	4870.23	4874.35	4867.0	4870.82	514.0
2015-01-13 00:00:00	YM	Futures	18367.0	18388.9	18360.8	18386.9	625.0
2015-01-13 01:00:00	YM	Futures	18384.8	18388.9	18359.7	18366.0	611.0

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

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