PREVIEW / futures_1hour / 2016-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-04-26.parquet
  size:    53 KB
  rows:    1,621

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
2016-04-26 00:00:00	ES	Futures	2249.2	2250.82	2248.12	2250.28	2955.0
2016-04-26 01:00:00	ES	Futures	2250.55	2251.36	2248.93	2249.74	3696.0
2016-04-26 02:00:00	ES	Futures	2249.74	2251.63	2248.93	2250.82	8632.0
2016-04-26 03:00:00	ES	Futures	2250.82	2258.38	2250.82	2257.3	45044.0
2016-04-26 04:00:00	ES	Futures	2257.3	2257.57	2254.06	2254.06	19156.0
2016-04-26 05:00:00	ES	Futures	2254.06	2256.49	2251.63	2252.98	17986.0
2016-04-26 06:00:00	ES	Futures	2252.98	2253.79	2251.36	2252.17	12584.0
2016-04-26 07:00:00	ES	Futures	2251.9	2254.87	2251.63	2254.33	16828.0
2016-04-26 08:00:00	ES	Futures	2254.33	2255.41	2252.17	2254.33	28338.0
2016-04-26 09:00:00	ES	Futures	2254.06	2257.57	2250.55	2257.57	145829.0
2016-04-26 10:00:00	ES	Futures	2257.57	2258.38	2246.77	2247.04	231997.0
2016-04-26 11:00:00	ES	Futures	2247.04	2252.71	2245.69	2251.63	138418.0
2016-04-26 12:00:00	ES	Futures	2251.63	2254.33	2250.01	2250.55	80978.0
2016-04-26 13:00:00	ES	Futures	2250.55	2251.36	2247.31	2248.93	71136.0
2016-04-26 14:00:00	ES	Futures	2248.66	2251.9	2247.58	2249.2	93345.0
2016-04-26 15:00:00	ES	Futures	2248.93	2252.71	2245.96	2252.44	174804.0
2016-04-26 16:00:00	ES	Futures	2252.71	2256.49	2250.28	2250.55	93141.0
2016-04-26 18:00:00	ES	Futures	2248.66	2250.28	2247.31	2250.01	6135.0
2016-04-26 19:00:00	ES	Futures	2250.01	2251.63	2250.01	2250.28	3507.0
2016-04-26 20:00:00	ES	Futures	2250.28	2250.82	2249.2	2249.47	5613.0
2016-04-26 21:00:00	ES	Futures	2249.47	2250.82	2248.66	2250.55	7379.0
2016-04-26 22:00:00	ES	Futures	2250.55	2251.63	2249.47	2250.55	3642.0
2016-04-26 23:00:00	ES	Futures	2250.55	2251.09	2248.93	2249.74	3586.0
2016-04-26 00:00:00	NQ	Futures	5320.13	5324.0	5316.86	5322.21	518.0
2016-04-26 01:00:00	NQ	Futures	5321.91	5324.0	5317.75	5319.83	561.0
2016-04-26 02:00:00	NQ	Futures	5319.24	5325.78	5317.75	5323.7	997.0
2016-04-26 03:00:00	NQ	Futures	5323.7	5343.34	5323.7	5340.66	6131.0
2016-04-26 04:00:00	NQ	Futures	5340.66	5341.85	5330.54	5330.84	1705.0
2016-04-26 05:00:00	NQ	Futures	5330.54	5337.98	5323.7	5326.67	1914.0
2016-04-26 06:00:00	NQ	Futures	5326.08	5327.27	5321.62	5323.4	1949.0
2016-04-26 07:00:00	NQ	Futures	5323.4	5329.95	5321.62	5328.76	2390.0
2016-04-26 08:00:00	NQ	Futures	5328.16	5331.73	5325.19	5330.54	3086.0
2016-04-26 09:00:00	NQ	Futures	5330.24	5336.79	5315.07	5332.92	31138.0
2016-04-26 10:00:00	NQ	Futures	5333.22	5335.9	5288.0	5291.27	40576.0
2016-04-26 11:00:00	NQ	Futures	5291.57	5302.87	5288.0	5299.0	21595.0
2016-04-26 12:00:00	NQ	Futures	5299.3	5306.74	5290.38	5290.97	12230.0
2016-04-26 13:00:00	NQ	Futures	5290.67	5298.11	5285.02	5290.08	14067.0
2016-04-26 14:00:00	NQ	Futures	5290.08	5293.05	5279.07	5281.75	17288.0
2016-04-26 15:00:00	NQ	Futures	5281.75	5291.86	5274.31	5291.27	30268.0
2016-04-26 16:00:00	NQ	Futures	5291.86	5302.87	5244.85	5249.91	19638.0
2016-04-26 18:00:00	NQ	Futures	5242.47	5247.23	5241.58	5246.64	2051.0
2016-04-26 19:00:00	NQ	Futures	5246.34	5252.89	5246.04	5246.34	961.0
2016-04-26 20:00:00	NQ	Futures	5246.34	5249.61	5240.39	5241.28	1469.0
2016-04-26 21:00:00	NQ	Futures	5241.28	5244.85	5238.01	5244.85	2152.0
2016-04-26 22:00:00	NQ	Futures	5245.45	5249.61	5242.77	5245.45	801.0
2016-04-26 23:00:00	NQ	Futures	5245.15	5248.13	5240.69	5242.47	813.0
2016-04-26 00:00:00	YM	Futures	19155.7	19173.9	19148.2	19169.6	429.0
2016-04-26 01:00:00	YM	Futures	19168.5	19179.2	19157.8	19160.0	652.0
2016-04-26 02:00:00	YM	Futures	19161.1	19177.1	19155.7	19170.7	908.0
2016-04-26 03:00:00	YM	Futures	19170.7	19234.9	19170.7	19223.1	5158.0

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

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