PREVIEW / futures_1hour / 2017-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-08.parquet
  size:    52 KB
  rows:    1,632

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
2017-11-08 00:00:00	ES	Futures	2827.23	2827.78	2826.68	2826.95	6502.0
2017-11-08 01:00:00	ES	Futures	2827.23	2827.5	2826.41	2826.95	2143.0
2017-11-08 02:00:00	ES	Futures	2827.23	2829.14	2827.23	2828.87	7885.0
2017-11-08 03:00:00	ES	Futures	2828.87	2831.33	2827.78	2828.87	26750.0
2017-11-08 04:00:00	ES	Futures	2829.14	2831.06	2828.87	2829.69	15074.0
2017-11-08 05:00:00	ES	Futures	2829.69	2830.24	2828.32	2828.87	11801.0
2017-11-08 06:00:00	ES	Futures	2828.6	2829.69	2826.68	2827.78	14854.0
2017-11-08 07:00:00	ES	Futures	2827.5	2828.87	2825.86	2826.95	12193.0
2017-11-08 08:00:00	ES	Futures	2827.23	2829.42	2826.95	2828.6	19415.0
2017-11-08 09:00:00	ES	Futures	2828.6	2829.42	2824.77	2825.86	120081.0
2017-11-08 10:00:00	ES	Futures	2826.13	2829.69	2825.59	2829.14	137461.0
2017-11-08 11:00:00	ES	Futures	2829.14	2830.78	2827.5	2829.69	91792.0
2017-11-08 12:00:00	ES	Futures	2829.69	2833.79	2829.14	2832.97	93483.0
2017-11-08 13:00:00	ES	Futures	2833.25	2835.16	2832.97	2834.34	100661.0
2017-11-08 14:00:00	ES	Futures	2834.34	2835.98	2833.25	2835.16	77673.0
2017-11-08 15:00:00	ES	Futures	2834.89	2836.8	2832.97	2835.71	161230.0
2017-11-08 16:00:00	ES	Futures	2835.98	2835.98	2833.79	2834.61	83889.0
2017-11-08 18:00:00	ES	Futures	2835.43	2835.98	2834.61	2835.16	9245.0
2017-11-08 19:00:00	ES	Futures	2835.16	2838.72	2834.61	2837.35	14928.0
2017-11-08 20:00:00	ES	Futures	2837.35	2838.99	2835.71	2837.35	8767.0
2017-11-08 21:00:00	ES	Futures	2837.62	2838.99	2837.35	2837.9	7653.0
2017-11-08 22:00:00	ES	Futures	2838.17	2838.17	2835.71	2837.08	8071.0
2017-11-08 23:00:00	ES	Futures	2836.8	2837.08	2834.07	2834.89	8723.0
2017-11-08 00:00:00	NQ	Futures	7513.04	7513.33	7510.36	7511.25	618.0
2017-11-08 01:00:00	NQ	Futures	7511.25	7512.44	7507.68	7511.55	537.0
2017-11-08 02:00:00	NQ	Futures	7511.25	7517.2	7511.25	7516.31	1360.0
2017-11-08 03:00:00	NQ	Futures	7516.61	7526.12	7514.82	7518.09	3804.0
2017-11-08 04:00:00	NQ	Futures	7518.39	7522.85	7516.9	7518.09	1922.0
2017-11-08 05:00:00	NQ	Futures	7518.69	7520.77	7512.44	7514.82	1908.0
2017-11-08 06:00:00	NQ	Futures	7515.42	7517.2	7508.87	7513.63	2408.0
2017-11-08 07:00:00	NQ	Futures	7513.63	7516.61	7507.68	7512.44	3765.0
2017-11-08 08:00:00	NQ	Futures	7512.74	7517.2	7512.44	7515.42	4575.0
2017-11-08 09:00:00	NQ	Futures	7515.12	7521.96	7504.11	7508.28	40081.0
2017-11-08 10:00:00	NQ	Futures	7508.58	7525.83	7508.58	7523.15	34891.0
2017-11-08 11:00:00	NQ	Futures	7523.15	7532.07	7521.36	7525.23	26901.0
2017-11-08 12:00:00	NQ	Futures	7524.93	7534.45	7524.04	7532.96	17915.0
2017-11-08 13:00:00	NQ	Futures	7532.96	7542.18	7532.37	7541.89	18269.0
2017-11-08 14:00:00	NQ	Futures	7541.89	7546.94	7537.13	7544.27	17046.0
2017-11-08 15:00:00	NQ	Futures	7544.56	7549.02	7539.8	7547.54	25882.0
2017-11-08 16:00:00	NQ	Futures	7547.54	7547.83	7542.48	7543.08	6061.0
2017-11-08 18:00:00	NQ	Futures	7545.16	7546.05	7542.48	7543.67	892.0
2017-11-08 19:00:00	NQ	Futures	7543.67	7552.89	7542.48	7549.02	2578.0
2017-11-08 20:00:00	NQ	Futures	7548.73	7556.16	7544.56	7551.11	1823.0
2017-11-08 21:00:00	NQ	Futures	7551.7	7555.57	7551.4	7554.08	1330.0
2017-11-08 22:00:00	NQ	Futures	7554.08	7554.08	7546.05	7548.13	1772.0
2017-11-08 23:00:00	NQ	Futures	7547.83	7548.43	7538.32	7542.48	2060.0
2017-11-08 00:00:00	YM	Futures	25529.0	25534.5	25525.8	25530.1	944.0
2017-11-08 01:00:00	YM	Futures	25531.2	25534.5	25520.3	25525.8	665.0
2017-11-08 02:00:00	YM	Futures	25526.9	25539.9	25526.9	25537.7	1928.0
2017-11-08 03:00:00	YM	Futures	25537.7	25559.5	25531.2	25541.0	3916.0

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

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