PREVIEW / futures_1hour / 2014-12-18

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-18.parquet
  size:    53 KB
  rows:    1,578

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-12-18 00:00:00	ES	Futures	2112.32	2112.58	2109.95	2110.74	5644.0
2014-12-18 01:00:00	ES	Futures	2110.74	2113.9	2110.74	2113.9	3036.0
2014-12-18 02:00:00	ES	Futures	2113.9	2128.11	2111.53	2124.42	37304.0
2014-12-18 03:00:00	ES	Futures	2124.16	2128.37	2120.21	2127.85	42815.0
2014-12-18 04:00:00	ES	Futures	2128.11	2135.48	2127.06	2132.32	43212.0
2014-12-18 05:00:00	ES	Futures	2132.06	2143.11	2131.53	2140.21	42598.0
2014-12-18 06:00:00	ES	Futures	2140.48	2140.74	2134.95	2135.48	26828.0
2014-12-18 07:00:00	ES	Futures	2135.48	2139.95	2135.21	2138.9	25158.0
2014-12-18 08:00:00	ES	Futures	2138.9	2142.32	2134.42	2142.06	50631.0
2014-12-18 09:00:00	ES	Futures	2142.06	2145.21	2136.27	2145.21	240619.0
2014-12-18 10:00:00	ES	Futures	2145.21	2148.63	2139.69	2139.95	275540.0
2014-12-18 11:00:00	ES	Futures	2140.21	2144.95	2133.37	2144.42	262206.0
2014-12-18 12:00:00	ES	Futures	2144.42	2150.21	2142.85	2150.21	141275.0
2014-12-18 13:00:00	ES	Futures	2150.21	2151.79	2146.79	2150.48	109119.0
2014-12-18 14:00:00	ES	Futures	2150.48	2151.0	2144.69	2149.95	189440.0
2014-12-18 15:00:00	ES	Futures	2149.69	2164.95	2148.9	2164.42	368371.0
2014-12-18 16:00:00	ES	Futures	2164.69	2170.74	2163.63	2169.95	173280.0
2014-12-18 17:00:00	ES	Futures	2170.21	2171.27	2169.16	2169.69	6305.0
2014-12-18 18:00:00	ES	Futures	2168.63	2169.69	2167.32	2167.58	12319.0
2014-12-18 19:00:00	ES	Futures	2167.58	2168.63	2167.06	2167.84	5481.0
2014-12-18 20:00:00	ES	Futures	2167.58	2167.84	2166.53	2167.58	4866.0
2014-12-18 21:00:00	ES	Futures	2167.84	2169.16	2167.58	2168.63	4320.0
2014-12-18 22:00:00	ES	Futures	2168.37	2168.9	2167.58	2168.37	3935.0
2014-12-18 23:00:00	ES	Futures	2168.11	2169.69	2168.11	2169.69	2600.0
2014-12-18 00:00:00	NQ	Futures	4880.22	4880.51	4875.52	4878.75	1327.0
2014-12-18 01:00:00	NQ	Futures	4878.46	4884.92	4878.16	4883.74	318.0
2014-12-18 02:00:00	NQ	Futures	4883.74	4915.17	4879.63	4909.59	5658.0
2014-12-18 03:00:00	NQ	Futures	4909.59	4925.74	4901.95	4924.86	9570.0
2014-12-18 04:00:00	NQ	Futures	4924.57	4941.01	4922.51	4933.97	6772.0
2014-12-18 05:00:00	NQ	Futures	4933.38	4963.33	4931.91	4956.29	9714.0
2014-12-18 06:00:00	NQ	Futures	4956.58	4957.17	4943.95	4945.71	4760.0
2014-12-18 07:00:00	NQ	Futures	4945.71	4956.87	4945.42	4952.17	4724.0
2014-12-18 08:00:00	NQ	Futures	4952.47	4958.63	4943.36	4957.46	7319.0
2014-12-18 09:00:00	NQ	Futures	4958.05	4969.21	4944.24	4968.62	52999.0
2014-12-18 10:00:00	NQ	Futures	4968.91	4983.3	4961.28	4966.86	51332.0
2014-12-18 11:00:00	NQ	Futures	4966.86	4976.55	4950.71	4975.67	38092.0
2014-12-18 12:00:00	NQ	Futures	4975.67	4983.01	4965.1	4983.01	22078.0
2014-12-18 13:00:00	NQ	Futures	4982.72	4993.0	4976.26	4991.53	20417.0
2014-12-18 14:00:00	NQ	Futures	4991.53	4992.7	4970.97	4981.84	27588.0
2014-12-18 15:00:00	NQ	Futures	4981.54	5007.09	4978.61	5006.51	58793.0
2014-12-18 16:00:00	NQ	Futures	5006.51	5018.25	5002.39	5017.08	25106.0
2014-12-18 17:00:00	NQ	Futures	5016.79	5019.13	5015.61	5016.2	542.0
2014-12-18 18:00:00	NQ	Futures	5014.44	5016.49	5011.79	5012.09	1212.0
2014-12-18 19:00:00	NQ	Futures	5011.79	5014.14	5011.79	5012.67	796.0
2014-12-18 20:00:00	NQ	Futures	5012.38	5012.67	5009.44	5012.67	760.0
2014-12-18 21:00:00	NQ	Futures	5012.97	5015.9	5012.09	5014.44	668.0
2014-12-18 22:00:00	NQ	Futures	5014.14	5015.61	5012.97	5015.61	737.0
2014-12-18 23:00:00	NQ	Futures	5015.61	5020.02	5015.32	5019.72	649.0
2014-12-18 00:00:00	YM	Futures	18043.4	18044.5	18025.7	18035.1	1175.0
2014-12-18 01:00:00	YM	Futures	18035.1	18055.9	18034.0	18051.8	521.0

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

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