PREVIEW / futures_1hour / 2015-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-03-23.parquet
  size:    51 KB
  rows:    1,551

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-03-23 00:00:00	ES	Futures	2221.49	2221.76	2221.23	2221.49	1661.0
2015-03-23 01:00:00	ES	Futures	2221.49	2221.76	2220.17	2220.17	1694.0
2015-03-23 02:00:00	ES	Futures	2220.17	2220.44	2219.38	2219.65	1467.0
2015-03-23 03:00:00	ES	Futures	2219.65	2220.44	2218.85	2219.65	4454.0
2015-03-23 04:00:00	ES	Futures	2219.65	2219.65	2213.31	2214.89	21800.0
2015-03-23 05:00:00	ES	Futures	2214.89	2216.21	2212.51	2213.04	13834.0
2015-03-23 06:00:00	ES	Futures	2212.78	2213.57	2211.46	2213.31	13396.0
2015-03-23 07:00:00	ES	Futures	2213.31	2217.8	2212.78	2217.8	18601.0
2015-03-23 08:00:00	ES	Futures	2217.53	2218.33	2215.68	2217.27	16267.0
2015-03-23 09:00:00	ES	Futures	2217.27	2224.93	2216.74	2222.29	151653.0
2015-03-23 10:00:00	ES	Futures	2222.29	2225.98	2221.23	2222.82	135628.0
2015-03-23 11:00:00	ES	Futures	2223.08	2224.14	2220.17	2222.29	101457.0
2015-03-23 12:00:00	ES	Futures	2222.29	2223.87	2219.38	2222.02	77586.0
2015-03-23 13:00:00	ES	Futures	2222.02	2222.82	2220.17	2221.49	50708.0
2015-03-23 14:00:00	ES	Futures	2221.23	2224.93	2220.7	2222.29	67371.0
2015-03-23 15:00:00	ES	Futures	2222.29	2222.82	2214.36	2214.89	166694.0
2015-03-23 16:00:00	ES	Futures	2214.89	2215.16	2212.51	2213.31	89635.0
2015-03-23 17:00:00	ES	Futures	2213.31	2213.57	2212.51	2212.78	2241.0
2015-03-23 18:00:00	ES	Futures	2212.25	2214.1	2212.25	2214.1	3718.0
2015-03-23 19:00:00	ES	Futures	2214.1	2214.63	2213.57	2214.36	2542.0
2015-03-23 20:00:00	ES	Futures	2214.1	2214.63	2213.84	2214.1	2821.0
2015-03-23 21:00:00	ES	Futures	2214.1	2214.89	2212.25	2213.57	5882.0
2015-03-23 22:00:00	ES	Futures	2213.31	2214.36	2213.31	2213.57	2122.0
2015-03-23 23:00:00	ES	Futures	2213.57	2215.68	2212.78	2215.68	3381.0
2015-03-23 00:00:00	NQ	Futures	5239.92	5241.09	5238.45	5240.51	319.0
2015-03-23 01:00:00	NQ	Futures	5239.92	5240.21	5236.1	5236.98	411.0
2015-03-23 02:00:00	NQ	Futures	5236.98	5237.86	5235.8	5236.39	262.0
2015-03-23 03:00:00	NQ	Futures	5236.68	5238.45	5234.33	5236.68	773.0
2015-03-23 04:00:00	NQ	Futures	5236.68	5236.98	5223.74	5229.04	4416.0
2015-03-23 05:00:00	NQ	Futures	5228.74	5232.27	5225.8	5225.8	2050.0
2015-03-23 06:00:00	NQ	Futures	5226.1	5230.21	5221.39	5222.57	3293.0
2015-03-23 07:00:00	NQ	Futures	5222.86	5233.15	5221.98	5231.98	3120.0
2015-03-23 08:00:00	NQ	Futures	5232.27	5233.15	5226.98	5230.21	2591.0
2015-03-23 09:00:00	NQ	Futures	5229.92	5238.15	5223.16	5227.86	26223.0
2015-03-23 10:00:00	NQ	Futures	5227.86	5243.45	5225.8	5234.62	21716.0
2015-03-23 11:00:00	NQ	Futures	5234.62	5238.45	5226.98	5234.92	15639.0
2015-03-23 12:00:00	NQ	Futures	5234.92	5237.86	5229.33	5233.74	12936.0
2015-03-23 13:00:00	NQ	Futures	5233.45	5237.86	5230.8	5235.21	8518.0
2015-03-23 14:00:00	NQ	Futures	5234.92	5244.92	5233.45	5237.57	13443.0
2015-03-23 15:00:00	NQ	Futures	5237.86	5239.04	5221.39	5221.98	22715.0
2015-03-23 16:00:00	NQ	Futures	5222.27	5223.45	5217.86	5219.63	7357.0
2015-03-23 17:00:00	NQ	Futures	5219.92	5220.22	5218.16	5218.45	115.0
2015-03-23 18:00:00	NQ	Futures	5218.45	5221.69	5216.39	5221.69	567.0
2015-03-23 19:00:00	NQ	Futures	5221.98	5223.45	5221.39	5222.86	349.0
2015-03-23 20:00:00	NQ	Futures	5222.86	5224.33	5222.27	5223.16	689.0
2015-03-23 21:00:00	NQ	Futures	5223.16	5225.8	5219.92	5222.27	1331.0
2015-03-23 22:00:00	NQ	Futures	5222.27	5223.74	5221.39	5222.57	375.0
2015-03-23 23:00:00	NQ	Futures	5222.27	5226.69	5219.33	5226.39	903.0
2015-03-23 00:00:00	YM	Futures	18953.6	18954.6	18949.4	18952.6	191.0
2015-03-23 01:00:00	YM	Futures	18951.5	18951.5	18937.9	18938.9	361.0

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

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