PREVIEW / futures_1hour / 2016-11-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-25.parquet
  size:    36 KB
  rows:    1,049

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-25 00:00:00	ES	Futures	2397.83	2398.92	2397.29	2398.38	3147.0
2016-11-25 01:00:00	ES	Futures	2398.38	2399.46	2397.56	2398.92	3803.0
2016-11-25 02:00:00	ES	Futures	2399.19	2400.01	2397.56	2398.92	4523.0
2016-11-25 03:00:00	ES	Futures	2398.92	2400.55	2397.29	2397.56	12190.0
2016-11-25 04:00:00	ES	Futures	2397.83	2400.28	2397.02	2399.46	6942.0
2016-11-25 05:00:00	ES	Futures	2399.46	2400.28	2398.1	2398.38	4571.0
2016-11-25 06:00:00	ES	Futures	2398.38	2399.46	2397.83	2399.46	5034.0
2016-11-25 07:00:00	ES	Futures	2399.46	2400.55	2398.92	2400.28	5786.0
2016-11-25 08:00:00	ES	Futures	2400.28	2401.1	2399.46	2400.01	11166.0
2016-11-25 09:00:00	ES	Futures	2400.01	2402.46	2399.46	2402.19	93842.0
2016-11-25 10:00:00	ES	Futures	2402.46	2403.0	2401.1	2401.91	85717.0
2016-11-25 11:00:00	ES	Futures	2402.19	2403.27	2401.64	2402.73	76292.0
2016-11-25 12:00:00	ES	Futures	2402.46	2405.72	2402.19	2405.72	79114.0
2016-11-25 13:00:00	ES	Futures	2405.72	2407.08	2404.36	2406.81	32571.0
2016-11-25 00:00:00	NQ	Futures	5795.75	5799.63	5794.86	5798.14	638.0
2016-11-25 01:00:00	NQ	Futures	5798.74	5801.72	5796.35	5799.63	774.0
2016-11-25 02:00:00	NQ	Futures	5799.63	5802.02	5794.26	5797.24	555.0
2016-11-25 03:00:00	NQ	Futures	5797.54	5802.02	5792.47	5792.47	1557.0
2016-11-25 04:00:00	NQ	Futures	5792.77	5800.82	5791.58	5795.75	1007.0
2016-11-25 05:00:00	NQ	Futures	5795.75	5798.14	5793.66	5794.56	548.0
2016-11-25 06:00:00	NQ	Futures	5794.56	5795.75	5792.77	5795.16	471.0
2016-11-25 07:00:00	NQ	Futures	5795.45	5799.93	5794.86	5797.84	1031.0
2016-11-25 08:00:00	NQ	Futures	5797.84	5799.93	5793.66	5795.45	2045.0
2016-11-25 09:00:00	NQ	Futures	5795.16	5803.81	5790.08	5802.61	15707.0
2016-11-25 10:00:00	NQ	Futures	5802.61	5803.81	5794.56	5798.74	11408.0
2016-11-25 11:00:00	NQ	Futures	5799.03	5808.58	5797.54	5807.98	9327.0
2016-11-25 12:00:00	NQ	Futures	5807.69	5811.56	5803.51	5808.88	8403.0
2016-11-25 13:00:00	NQ	Futures	5808.88	5811.56	5807.09	5811.56	3440.0
2016-11-25 00:00:00	YM	Futures	20633.9	20644.7	20632.8	20643.6	756.0
2016-11-25 01:00:00	YM	Futures	20643.6	20652.3	20637.2	20648.0	1172.0
2016-11-25 02:00:00	YM	Futures	20648.0	20652.3	20635.0	20642.6	1268.0
2016-11-25 03:00:00	YM	Futures	20641.5	20652.3	20631.8	20636.1	2839.0
2016-11-25 04:00:00	YM	Futures	20633.9	20657.7	20632.8	20649.1	1708.0
2016-11-25 05:00:00	YM	Futures	20650.1	20655.5	20640.4	20641.5	1102.0
2016-11-25 06:00:00	YM	Futures	20642.6	20648.0	20638.2	20645.8	920.0
2016-11-25 07:00:00	YM	Futures	20648.0	20656.6	20644.7	20655.5	1068.0
2016-11-25 08:00:00	YM	Futures	20655.5	20657.7	20644.7	20649.1	1655.0
2016-11-25 09:00:00	YM	Futures	20650.1	20655.5	20633.9	20653.4	14525.0
2016-11-25 10:00:00	YM	Futures	20653.4	20662.0	20644.7	20648.0	10597.0
2016-11-25 11:00:00	YM	Futures	20649.1	20656.6	20643.6	20648.0	7791.0
2016-11-25 12:00:00	YM	Futures	20648.0	20668.5	20638.2	20668.5	6777.0
2016-11-25 13:00:00	YM	Futures	20667.4	20694.4	20662.0	20693.4	2358.0
2016-11-25 00:00:00	CL	Futures	46.63	46.67	46.56	46.66	2986.0
2016-11-25 01:00:00	CL	Futures	46.66	46.7	46.24	46.38	10472.0
2016-11-25 02:00:00	CL	Futures	46.38	46.54	46.3	46.46	9591.0
2016-11-25 03:00:00	CL	Futures	46.47	46.67	46.42	46.49	16927.0
2016-11-25 04:00:00	CL	Futures	46.5	46.74	46.45	46.61	12284.0
2016-11-25 05:00:00	CL	Futures	46.6	46.68	46.53	46.56	5844.0
2016-11-25 06:00:00	CL	Futures	46.56	46.56	46.3	46.36	9079.0
2016-11-25 07:00:00	CL	Futures	46.36	46.59	46.34	46.53	7732.0

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

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