PREVIEW / futures_1hour / 2014-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-11-19.parquet
  size:    50 KB
  rows:    1,546

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-11-19 00:00:00	ES	Futures	2144.73	2144.73	2143.68	2143.94	3248.0
2014-11-19 01:00:00	ES	Futures	2143.94	2145.77	2143.68	2144.99	2565.0
2014-11-19 02:00:00	ES	Futures	2144.99	2145.25	2143.42	2143.68	6546.0
2014-11-19 03:00:00	ES	Futures	2143.42	2143.94	2142.37	2143.42	15849.0
2014-11-19 04:00:00	ES	Futures	2143.16	2145.25	2143.16	2144.73	11338.0
2014-11-19 05:00:00	ES	Futures	2144.99	2145.51	2143.94	2144.46	6825.0
2014-11-19 06:00:00	ES	Futures	2144.46	2146.3	2144.2	2145.25	12474.0
2014-11-19 07:00:00	ES	Futures	2145.25	2147.61	2144.2	2144.73	24536.0
2014-11-19 08:00:00	ES	Futures	2144.46	2144.99	2143.16	2144.46	25933.0
2014-11-19 09:00:00	ES	Futures	2144.2	2146.3	2139.75	2141.32	201978.0
2014-11-19 10:00:00	ES	Futures	2141.32	2141.58	2136.08	2136.87	200277.0
2014-11-19 11:00:00	ES	Futures	2136.87	2142.11	2135.3	2141.32	129915.0
2014-11-19 12:00:00	ES	Futures	2141.32	2143.94	2140.8	2143.94	63432.0
2014-11-19 13:00:00	ES	Futures	2143.94	2144.73	2142.37	2143.16	53788.0
2014-11-19 14:00:00	ES	Futures	2143.16	2148.66	2139.23	2142.37	188601.0
2014-11-19 15:00:00	ES	Futures	2142.37	2146.04	2141.06	2144.99	159493.0
2014-11-19 16:00:00	ES	Futures	2144.73	2146.56	2144.73	2144.99	49112.0
2014-11-19 17:00:00	ES	Futures	2145.25	2145.25	2144.46	2144.46	1034.0
2014-11-19 18:00:00	ES	Futures	2144.99	2145.77	2143.68	2145.51	3076.0
2014-11-19 19:00:00	ES	Futures	2145.77	2146.3	2144.46	2144.73	3284.0
2014-11-19 20:00:00	ES	Futures	2144.73	2144.99	2140.54	2141.58	6390.0
2014-11-19 21:00:00	ES	Futures	2141.85	2142.89	2141.85	2142.89	2620.0
2014-11-19 22:00:00	ES	Futures	2142.63	2143.94	2142.11	2142.63	2723.0
2014-11-19 23:00:00	ES	Futures	2142.63	2142.63	2140.8	2141.32	1901.0
2014-11-19 00:00:00	NQ	Futures	4964.69	4964.98	4962.64	4962.64	475.0
2014-11-19 01:00:00	NQ	Futures	4962.93	4968.5	4962.93	4965.86	374.0
2014-11-19 02:00:00	NQ	Futures	4965.86	4967.33	4963.81	4964.4	964.0
2014-11-19 03:00:00	NQ	Futures	4964.4	4964.69	4961.47	4963.22	1446.0
2014-11-19 04:00:00	NQ	Futures	4963.52	4967.91	4962.34	4967.33	1280.0
2014-11-19 05:00:00	NQ	Futures	4967.33	4967.91	4964.98	4965.27	758.0
2014-11-19 06:00:00	NQ	Futures	4965.86	4970.26	4964.98	4968.2	1548.0
2014-11-19 07:00:00	NQ	Futures	4968.5	4972.31	4964.69	4964.98	2802.0
2014-11-19 08:00:00	NQ	Futures	4965.27	4966.74	4962.64	4965.86	3945.0
2014-11-19 09:00:00	NQ	Futures	4965.86	4968.79	4940.66	4944.47	44916.0
2014-11-19 10:00:00	NQ	Futures	4944.18	4945.35	4931.87	4933.34	45378.0
2014-11-19 11:00:00	NQ	Futures	4933.34	4946.82	4927.48	4944.18	26252.0
2014-11-19 12:00:00	NQ	Futures	4944.47	4955.02	4944.47	4954.73	10655.0
2014-11-19 13:00:00	NQ	Futures	4954.73	4957.66	4950.92	4950.92	10369.0
2014-11-19 14:00:00	NQ	Futures	4951.5	4964.69	4940.08	4948.87	42597.0
2014-11-19 15:00:00	NQ	Futures	4949.16	4955.31	4942.71	4950.62	33036.0
2014-11-19 16:00:00	NQ	Futures	4950.62	4954.43	4950.04	4952.09	4394.0
2014-11-19 17:00:00	NQ	Futures	4952.09	4952.09	4947.99	4948.28	529.0
2014-11-19 18:00:00	NQ	Futures	4950.33	4954.43	4948.28	4953.55	609.0
2014-11-19 19:00:00	NQ	Futures	4953.85	4955.02	4950.62	4950.62	705.0
2014-11-19 20:00:00	NQ	Futures	4950.92	4951.5	4944.47	4945.35	1504.0
2014-11-19 21:00:00	NQ	Futures	4945.64	4949.16	4945.64	4949.16	455.0
2014-11-19 22:00:00	NQ	Futures	4949.16	4951.5	4947.4	4947.99	456.0
2014-11-19 23:00:00	NQ	Futures	4948.28	4948.57	4944.47	4944.76	639.0
2014-11-19 00:00:00	YM	Futures	18339.3	18340.4	18332.1	18332.1	844.0
2014-11-19 01:00:00	YM	Futures	18334.1	18347.7	18333.1	18342.5	594.0

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

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