PREVIEW / futures_1hour / 2016-11-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-23.parquet
  size:    54 KB
  rows:    1,596

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-23 00:00:00	ES	Futures	2394.84	2396.47	2394.84	2395.93	2246.0
2016-11-23 01:00:00	ES	Futures	2395.66	2396.2	2395.11	2395.66	1752.0
2016-11-23 02:00:00	ES	Futures	2395.93	2395.93	2394.57	2395.66	4186.0
2016-11-23 03:00:00	ES	Futures	2395.38	2397.29	2394.57	2396.2	15209.0
2016-11-23 04:00:00	ES	Futures	2396.2	2398.1	2395.11	2395.11	13746.0
2016-11-23 05:00:00	ES	Futures	2394.84	2395.11	2391.85	2393.48	15457.0
2016-11-23 06:00:00	ES	Futures	2393.48	2394.84	2392.12	2392.93	10405.0
2016-11-23 07:00:00	ES	Futures	2392.93	2395.38	2392.93	2394.84	9529.0
2016-11-23 08:00:00	ES	Futures	2394.84	2395.38	2389.67	2390.76	43689.0
2016-11-23 09:00:00	ES	Futures	2390.76	2391.57	2385.59	2387.22	240024.0
2016-11-23 10:00:00	ES	Futures	2387.49	2393.48	2387.22	2391.85	193165.0
2016-11-23 11:00:00	ES	Futures	2391.85	2392.66	2388.04	2392.39	116188.0
2016-11-23 12:00:00	ES	Futures	2392.12	2395.38	2391.57	2393.48	93267.0
2016-11-23 13:00:00	ES	Futures	2393.75	2394.57	2392.12	2392.39	54603.0
2016-11-23 14:00:00	ES	Futures	2392.12	2395.11	2392.12	2393.48	79750.0
2016-11-23 15:00:00	ES	Futures	2393.48	2396.74	2393.21	2396.2	115734.0
2016-11-23 16:00:00	ES	Futures	2396.2	2396.47	2394.57	2395.38	57195.0
2016-11-23 18:00:00	ES	Futures	2395.38	2396.47	2393.21	2393.48	3085.0
2016-11-23 19:00:00	ES	Futures	2393.48	2394.3	2392.66	2394.02	2903.0
2016-11-23 20:00:00	ES	Futures	2394.02	2394.3	2391.57	2393.75	3345.0
2016-11-23 21:00:00	ES	Futures	2393.75	2395.11	2392.93	2394.3	4323.0
2016-11-23 22:00:00	ES	Futures	2394.57	2395.11	2393.21	2393.21	2003.0
2016-11-23 23:00:00	ES	Futures	2393.21	2393.75	2392.93	2393.75	1062.0
2016-11-23 00:00:00	NQ	Futures	5820.81	5824.09	5820.22	5822.01	403.0
2016-11-23 01:00:00	NQ	Futures	5822.3	5824.09	5819.92	5821.71	360.0
2016-11-23 02:00:00	NQ	Futures	5821.71	5822.01	5817.53	5821.41	660.0
2016-11-23 03:00:00	NQ	Futures	5820.51	5825.29	5818.13	5821.41	1338.0
2016-11-23 04:00:00	NQ	Futures	5821.71	5826.48	5819.02	5819.02	1110.0
2016-11-23 05:00:00	NQ	Futures	5819.02	5819.62	5810.37	5813.65	1828.0
2016-11-23 06:00:00	NQ	Futures	5813.95	5815.14	5808.58	5812.16	1639.0
2016-11-23 07:00:00	NQ	Futures	5811.86	5816.93	5811.56	5816.34	1476.0
2016-11-23 08:00:00	NQ	Futures	5816.04	5817.83	5799.93	5801.42	6945.0
2016-11-23 09:00:00	NQ	Futures	5801.12	5802.91	5771.59	5778.45	44804.0
2016-11-23 10:00:00	NQ	Futures	5778.45	5788.29	5773.08	5777.85	31063.0
2016-11-23 11:00:00	NQ	Futures	5777.85	5779.94	5764.13	5779.64	18024.0
2016-11-23 12:00:00	NQ	Futures	5779.34	5785.91	5777.55	5781.43	9488.0
2016-11-23 13:00:00	NQ	Futures	5781.73	5783.82	5772.48	5773.38	7156.0
2016-11-23 14:00:00	NQ	Futures	5773.97	5786.21	5773.68	5778.45	10932.0
2016-11-23 15:00:00	NQ	Futures	5778.45	5790.38	5778.45	5790.38	12837.0
2016-11-23 16:00:00	NQ	Futures	5790.38	5790.98	5785.61	5789.79	4069.0
2016-11-23 18:00:00	NQ	Futures	5788.29	5791.87	5785.31	5785.31	453.0
2016-11-23 19:00:00	NQ	Futures	5785.61	5785.61	5781.43	5782.33	637.0
2016-11-23 20:00:00	NQ	Futures	5782.63	5782.63	5775.17	5780.84	851.0
2016-11-23 21:00:00	NQ	Futures	5780.84	5786.8	5780.84	5783.52	944.0
2016-11-23 22:00:00	NQ	Futures	5783.82	5787.4	5780.84	5781.13	496.0
2016-11-23 23:00:00	NQ	Futures	5781.13	5784.71	5779.94	5784.71	148.0
2016-11-23 00:00:00	YM	Futures	20543.1	20550.7	20542.1	20545.3	495.0
2016-11-23 01:00:00	YM	Futures	20546.4	20550.7	20541.0	20543.1	554.0
2016-11-23 02:00:00	YM	Futures	20543.1	20544.2	20532.3	20536.7	1293.0
2016-11-23 03:00:00	YM	Futures	20535.6	20550.7	20529.1	20535.6	3433.0

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

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