PREVIEW / futures_1hour / 2016-11-15

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-15.parquet
  size:    55 KB
  rows:    1,633

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-11-15 00:00:00	ES	Futures	2356.48	2357.56	2355.39	2357.29	4110.0
2016-11-15 01:00:00	ES	Futures	2357.02	2357.29	2354.57	2355.39	3950.0
2016-11-15 02:00:00	ES	Futures	2355.12	2357.56	2354.57	2356.75	8117.0
2016-11-15 03:00:00	ES	Futures	2357.02	2360.56	2356.48	2358.92	31242.0
2016-11-15 04:00:00	ES	Futures	2358.92	2361.37	2355.39	2357.02	14333.0
2016-11-15 05:00:00	ES	Futures	2357.02	2357.56	2355.39	2355.66	9371.0
2016-11-15 06:00:00	ES	Futures	2355.93	2356.2	2353.21	2354.84	12114.0
2016-11-15 07:00:00	ES	Futures	2355.12	2355.66	2352.4	2353.76	14695.0
2016-11-15 08:00:00	ES	Futures	2353.76	2358.92	2353.48	2356.48	50539.0
2016-11-15 09:00:00	ES	Futures	2356.48	2358.92	2354.03	2355.93	199845.0
2016-11-15 10:00:00	ES	Futures	2355.66	2360.83	2355.66	2358.92	194778.0
2016-11-15 11:00:00	ES	Futures	2359.2	2361.1	2357.02	2358.65	127658.0
2016-11-15 12:00:00	ES	Futures	2358.65	2360.83	2355.93	2356.48	97709.0
2016-11-15 13:00:00	ES	Futures	2356.75	2360.83	2356.75	2360.29	78484.0
2016-11-15 14:00:00	ES	Futures	2360.56	2368.72	2359.74	2367.63	196459.0
2016-11-15 15:00:00	ES	Futures	2367.9	2370.35	2366.27	2369.81	249175.0
2016-11-15 16:00:00	ES	Futures	2369.81	2372.26	2368.99	2371.44	91941.0
2016-11-15 18:00:00	ES	Futures	2371.44	2372.53	2370.62	2371.44	6336.0
2016-11-15 19:00:00	ES	Futures	2371.71	2377.97	2370.9	2374.43	17104.0
2016-11-15 20:00:00	ES	Futures	2374.43	2376.07	2373.89	2375.25	7578.0
2016-11-15 21:00:00	ES	Futures	2375.25	2376.07	2374.71	2375.52	4335.0
2016-11-15 22:00:00	ES	Futures	2375.25	2375.79	2373.89	2374.16	3757.0
2016-11-15 23:00:00	ES	Futures	2374.16	2375.52	2373.89	2374.43	2419.0
2016-11-15 00:00:00	NQ	Futures	5608.99	5610.49	5605.41	5608.99	1029.0
2016-11-15 01:00:00	NQ	Futures	5608.99	5609.89	5604.22	5606.01	628.0
2016-11-15 02:00:00	NQ	Futures	5606.01	5611.68	5603.92	5609.29	1459.0
2016-11-15 03:00:00	NQ	Futures	5609.59	5626.3	5606.31	5620.63	5993.0
2016-11-15 04:00:00	NQ	Futures	5620.63	5626.89	5614.96	5619.73	3090.0
2016-11-15 05:00:00	NQ	Futures	5619.73	5622.42	5614.66	5615.56	1370.0
2016-11-15 06:00:00	NQ	Futures	5615.56	5617.65	5608.4	5612.57	2130.0
2016-11-15 07:00:00	NQ	Futures	5612.87	5613.17	5602.73	5606.31	2607.0
2016-11-15 08:00:00	NQ	Futures	5606.31	5646.88	5606.01	5642.41	10278.0
2016-11-15 09:00:00	NQ	Futures	5642.11	5671.94	5635.55	5671.35	41620.0
2016-11-15 10:00:00	NQ	Futures	5671.35	5700.29	5666.57	5679.4	53976.0
2016-11-15 11:00:00	NQ	Futures	5679.7	5687.46	5671.05	5675.52	23939.0
2016-11-15 12:00:00	NQ	Futures	5675.23	5680.6	5656.43	5659.12	15098.0
2016-11-15 13:00:00	NQ	Futures	5659.71	5676.72	5658.52	5675.52	13128.0
2016-11-15 14:00:00	NQ	Futures	5676.12	5698.79	5673.44	5698.79	22144.0
2016-11-15 15:00:00	NQ	Futures	5698.5	5703.27	5684.18	5684.47	23936.0
2016-11-15 16:00:00	NQ	Futures	5684.18	5688.95	5681.49	5686.26	5807.0
2016-11-15 18:00:00	NQ	Futures	5686.26	5693.42	5685.67	5690.74	760.0
2016-11-15 19:00:00	NQ	Futures	5690.44	5707.74	5689.55	5702.37	2630.0
2016-11-15 20:00:00	NQ	Futures	5702.37	5707.45	5701.18	5703.57	1531.0
2016-11-15 21:00:00	NQ	Futures	5704.16	5707.45	5701.78	5704.16	1058.0
2016-11-15 22:00:00	NQ	Futures	5703.87	5706.25	5702.37	5703.57	780.0
2016-11-15 23:00:00	NQ	Futures	5703.27	5706.55	5703.27	5704.76	468.0
2016-11-15 00:00:00	YM	Futures	20372.4	20381.0	20362.6	20373.5	995.0
2016-11-15 01:00:00	YM	Futures	20373.5	20373.5	20349.7	20352.9	986.0
2016-11-15 02:00:00	YM	Futures	20351.8	20369.1	20346.4	20363.7	1569.0
2016-11-15 03:00:00	YM	Futures	20363.7	20390.7	20360.5	20377.8	6316.0

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

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