PREVIEW / futures_1hour / 2017-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-08.parquet
  size:    53 KB
  rows:    1,638

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-05-08 00:00:00	ES	Futures	2619.17	2619.44	2618.35	2618.35	1790.0
2017-05-08 01:00:00	ES	Futures	2618.35	2619.44	2617.8	2619.17	6084.0
2017-05-08 02:00:00	ES	Futures	2618.89	2619.17	2615.89	2617.26	16955.0
2017-05-08 03:00:00	ES	Futures	2617.26	2617.26	2613.71	2615.34	29843.0
2017-05-08 04:00:00	ES	Futures	2615.34	2617.53	2615.07	2615.62	15495.0
2017-05-08 05:00:00	ES	Futures	2615.34	2616.44	2613.98	2615.62	15811.0
2017-05-08 06:00:00	ES	Futures	2615.62	2619.17	2615.34	2618.08	19112.0
2017-05-08 07:00:00	ES	Futures	2617.8	2619.17	2617.26	2617.26	12305.0
2017-05-08 08:00:00	ES	Futures	2617.26	2617.8	2615.07	2615.62	24108.0
2017-05-08 09:00:00	ES	Futures	2615.89	2619.71	2613.71	2614.25	147995.0
2017-05-08 10:00:00	ES	Futures	2614.25	2616.16	2612.61	2613.43	134076.0
2017-05-08 11:00:00	ES	Futures	2613.43	2614.8	2610.97	2613.98	110807.0
2017-05-08 12:00:00	ES	Futures	2613.98	2616.44	2612.89	2615.62	61098.0
2017-05-08 13:00:00	ES	Futures	2615.62	2616.98	2615.07	2616.71	38819.0
2017-05-08 14:00:00	ES	Futures	2616.98	2616.98	2614.52	2615.89	59102.0
2017-05-08 15:00:00	ES	Futures	2615.89	2616.98	2613.43	2616.71	129292.0
2017-05-08 16:00:00	ES	Futures	2616.71	2617.26	2615.34	2616.44	70685.0
2017-05-08 18:00:00	ES	Futures	2616.16	2617.53	2615.89	2617.26	3169.0
2017-05-08 19:00:00	ES	Futures	2617.26	2617.53	2616.16	2616.16	1801.0
2017-05-08 20:00:00	ES	Futures	2616.44	2616.44	2614.52	2615.34	5300.0
2017-05-08 21:00:00	ES	Futures	2615.34	2616.71	2615.34	2615.62	2873.0
2017-05-08 22:00:00	ES	Futures	2615.62	2616.16	2614.8	2616.16	2972.0
2017-05-08 23:00:00	ES	Futures	2616.16	2616.44	2615.34	2615.62	2496.0
2017-05-08 00:00:00	NQ	Futures	6732.01	6733.79	6731.41	6731.71	415.0
2017-05-08 01:00:00	NQ	Futures	6731.41	6734.09	6730.51	6733.5	1245.0
2017-05-08 02:00:00	NQ	Futures	6733.2	6734.09	6726.94	6728.73	2533.0
2017-05-08 03:00:00	NQ	Futures	6728.73	6729.02	6719.78	6724.25	3238.0
2017-05-08 04:00:00	NQ	Futures	6724.25	6730.51	6723.96	6725.74	2095.0
2017-05-08 05:00:00	NQ	Futures	6725.74	6729.02	6722.76	6726.64	1828.0
2017-05-08 06:00:00	NQ	Futures	6726.64	6735.58	6726.64	6732.6	2202.0
2017-05-08 07:00:00	NQ	Futures	6732.6	6735.58	6730.81	6733.2	1956.0
2017-05-08 08:00:00	NQ	Futures	6733.5	6734.69	6726.94	6729.32	5562.0
2017-05-08 09:00:00	NQ	Futures	6729.62	6740.35	6725.15	6725.15	26468.0
2017-05-08 10:00:00	NQ	Futures	6725.15	6736.18	6723.36	6726.94	24606.0
2017-05-08 11:00:00	NQ	Futures	6726.94	6732.01	6719.48	6729.92	19180.0
2017-05-08 12:00:00	NQ	Futures	6730.22	6740.35	6728.43	6736.18	12998.0
2017-05-08 13:00:00	NQ	Futures	6736.18	6740.65	6732.6	6740.65	10806.0
2017-05-08 14:00:00	NQ	Futures	6740.35	6741.55	6734.09	6740.35	12369.0
2017-05-08 15:00:00	NQ	Futures	6740.35	6744.53	6731.41	6743.93	19139.0
2017-05-08 16:00:00	NQ	Futures	6743.93	6745.12	6741.84	6744.23	4299.0
2017-05-08 18:00:00	NQ	Futures	6743.04	6745.12	6742.14	6744.53	807.0
2017-05-08 19:00:00	NQ	Futures	6744.23	6745.42	6742.74	6743.04	415.0
2017-05-08 20:00:00	NQ	Futures	6743.04	6743.33	6738.86	6740.95	1210.0
2017-05-08 21:00:00	NQ	Futures	6740.95	6744.53	6740.65	6741.25	900.0
2017-05-08 22:00:00	NQ	Futures	6741.25	6743.33	6739.46	6742.14	828.0
2017-05-08 23:00:00	NQ	Futures	6742.14	6743.04	6740.95	6741.55	508.0
2017-05-08 00:00:00	YM	Futures	22778.1	22780.2	22774.8	22774.8	346.0
2017-05-08 01:00:00	YM	Futures	22774.8	22780.2	22769.4	22778.1	920.0
2017-05-08 02:00:00	YM	Futures	22777.0	22779.1	22737.8	22748.7	2859.0
2017-05-08 03:00:00	YM	Futures	22748.7	22748.7	22722.6	22733.5	3860.0

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

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