PREVIEW / futures_1hour / 2016-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-29.parquet
  size:    53 KB
  rows:    1,623

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-29 00:00:00	ES	Futures	2393.75	2394.57	2393.48	2393.75	2515.0
2016-11-29 01:00:00	ES	Futures	2393.75	2394.84	2393.48	2394.57	1755.0
2016-11-29 02:00:00	ES	Futures	2394.84	2397.56	2394.57	2396.74	7872.0
2016-11-29 03:00:00	ES	Futures	2396.74	2399.19	2394.84	2398.92	20102.0
2016-11-29 04:00:00	ES	Futures	2399.19	2400.83	2397.56	2399.19	12339.0
2016-11-29 05:00:00	ES	Futures	2398.92	2399.46	2396.74	2397.29	10460.0
2016-11-29 06:00:00	ES	Futures	2397.56	2399.46	2397.29	2398.1	8380.0
2016-11-29 07:00:00	ES	Futures	2397.83	2400.55	2397.29	2397.83	14603.0
2016-11-29 08:00:00	ES	Futures	2397.83	2398.65	2394.57	2395.38	36622.0
2016-11-29 09:00:00	ES	Futures	2395.11	2397.02	2390.21	2391.85	222781.0
2016-11-29 10:00:00	ES	Futures	2391.85	2400.01	2391.57	2399.74	227358.0
2016-11-29 11:00:00	ES	Futures	2399.74	2403.0	2397.56	2402.46	180675.0
2016-11-29 12:00:00	ES	Futures	2402.46	2402.73	2399.46	2402.73	111385.0
2016-11-29 13:00:00	ES	Futures	2402.46	2403.55	2400.83	2403.0	67171.0
2016-11-29 14:00:00	ES	Futures	2403.27	2404.63	2401.91	2402.19	98276.0
2016-11-29 15:00:00	ES	Futures	2402.46	2402.46	2395.66	2398.38	267745.0
2016-11-29 16:00:00	ES	Futures	2398.38	2399.19	2397.56	2398.1	44303.0
2016-11-29 18:00:00	ES	Futures	2397.83	2398.65	2397.29	2397.83	3578.0
2016-11-29 19:00:00	ES	Futures	2397.83	2398.92	2397.56	2397.83	2978.0
2016-11-29 20:00:00	ES	Futures	2397.83	2399.46	2397.29	2398.38	3860.0
2016-11-29 21:00:00	ES	Futures	2398.38	2398.92	2397.56	2397.83	2086.0
2016-11-29 22:00:00	ES	Futures	2397.83	2398.1	2395.11	2395.93	5968.0
2016-11-29 23:00:00	ES	Futures	2395.93	2398.1	2395.38	2397.29	3889.0
2016-11-29 00:00:00	NQ	Futures	5799.63	5799.93	5796.35	5796.95	599.0
2016-11-29 01:00:00	NQ	Futures	5796.95	5798.74	5796.05	5797.54	622.0
2016-11-29 02:00:00	NQ	Futures	5797.84	5806.19	5797.84	5803.81	906.0
2016-11-29 03:00:00	NQ	Futures	5803.21	5810.97	5798.44	5810.37	1823.0
2016-11-29 04:00:00	NQ	Futures	5810.37	5814.25	5807.69	5810.97	1669.0
2016-11-29 05:00:00	NQ	Futures	5810.97	5812.16	5804.11	5805.6	1289.0
2016-11-29 06:00:00	NQ	Futures	5805.3	5810.97	5805.3	5807.09	997.0
2016-11-29 07:00:00	NQ	Futures	5806.79	5813.65	5805.6	5806.79	1446.0
2016-11-29 08:00:00	NQ	Futures	5806.49	5809.18	5796.35	5798.74	5863.0
2016-11-29 09:00:00	NQ	Futures	5799.03	5807.69	5784.71	5792.17	25477.0
2016-11-29 10:00:00	NQ	Futures	5792.17	5821.71	5791.58	5820.81	28707.0
2016-11-29 11:00:00	NQ	Futures	5820.81	5844.68	5813.95	5844.68	25219.0
2016-11-29 12:00:00	NQ	Futures	5844.38	5844.68	5834.24	5840.8	20879.0
2016-11-29 13:00:00	NQ	Futures	5841.1	5842.59	5832.45	5839.91	7680.0
2016-11-29 14:00:00	NQ	Futures	5840.2	5841.4	5833.04	5833.34	11611.0
2016-11-29 15:00:00	NQ	Futures	5833.64	5833.94	5809.18	5816.34	30361.0
2016-11-29 16:00:00	NQ	Futures	5816.04	5819.32	5814.25	5817.53	4421.0
2016-11-29 18:00:00	NQ	Futures	5814.55	5819.32	5814.55	5816.64	543.0
2016-11-29 19:00:00	NQ	Futures	5816.64	5819.32	5816.04	5818.13	446.0
2016-11-29 20:00:00	NQ	Futures	5817.83	5822.01	5815.44	5816.64	807.0
2016-11-29 21:00:00	NQ	Futures	5817.53	5820.22	5816.64	5816.64	226.0
2016-11-29 22:00:00	NQ	Futures	5816.93	5816.93	5809.48	5811.56	648.0
2016-11-29 23:00:00	NQ	Futures	5812.16	5816.64	5810.37	5815.44	425.0
2016-11-29 00:00:00	YM	Futures	20618.8	20622.0	20616.6	20618.8	440.0
2016-11-29 01:00:00	YM	Futures	20618.8	20624.2	20617.7	20622.0	384.0
2016-11-29 02:00:00	YM	Futures	20624.2	20644.7	20622.0	20638.2	2008.0
2016-11-29 03:00:00	YM	Futures	20638.2	20653.4	20626.4	20651.2	3723.0

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

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