PREVIEW / futures_1hour / 2017-03-23

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-23.parquet
  size:    52 KB
  rows:    1,627

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-03-23 00:00:00	ES	Futures	2565.63	2565.63	2564.81	2564.81	1890.0
2017-03-23 01:00:00	ES	Futures	2565.09	2566.18	2564.54	2565.63	3288.0
2017-03-23 02:00:00	ES	Futures	2565.36	2565.36	2563.17	2563.45	4294.0
2017-03-23 03:00:00	ES	Futures	2563.17	2563.72	2561.26	2563.45	9489.0
2017-03-23 04:00:00	ES	Futures	2563.45	2563.45	2559.9	2560.44	15362.0
2017-03-23 05:00:00	ES	Futures	2560.17	2563.99	2560.17	2562.08	12539.0
2017-03-23 06:00:00	ES	Futures	2561.81	2565.09	2560.72	2564.54	13683.0
2017-03-23 07:00:00	ES	Futures	2564.81	2565.91	2563.17	2564.27	16736.0
2017-03-23 08:00:00	ES	Futures	2563.99	2565.63	2560.72	2561.26	36514.0
2017-03-23 09:00:00	ES	Futures	2561.53	2564.54	2556.35	2560.99	199076.0
2017-03-23 10:00:00	ES	Futures	2561.26	2570.0	2559.9	2567.54	181924.0
2017-03-23 11:00:00	ES	Futures	2567.54	2574.1	2567.54	2571.09	167345.0
2017-03-23 12:00:00	ES	Futures	2571.09	2573.83	2570.55	2573.28	89945.0
2017-03-23 13:00:00	ES	Futures	2573.55	2573.55	2562.35	2566.72	253630.0
2017-03-23 14:00:00	ES	Futures	2567.0	2569.73	2565.09	2565.91	98197.0
2017-03-23 15:00:00	ES	Futures	2566.18	2566.45	2554.71	2559.35	384348.0
2017-03-23 16:00:00	ES	Futures	2559.08	2559.62	2555.53	2557.98	90963.0
2017-03-23 18:00:00	ES	Futures	2557.71	2562.08	2557.71	2559.35	7326.0
2017-03-23 19:00:00	ES	Futures	2559.35	2562.35	2559.35	2560.17	4218.0
2017-03-23 20:00:00	ES	Futures	2560.17	2567.0	2559.9	2565.63	16330.0
2017-03-23 21:00:00	ES	Futures	2565.36	2566.18	2563.45	2563.45	7831.0
2017-03-23 22:00:00	ES	Futures	2563.45	2565.09	2563.45	2563.72	5139.0
2017-03-23 23:00:00	ES	Futures	2563.72	2563.99	2561.53	2562.35	4523.0
2017-03-23 00:00:00	NQ	Futures	6408.52	6408.82	6407.03	6407.63	448.0
2017-03-23 01:00:00	NQ	Futures	6407.93	6410.31	6406.73	6407.93	528.0
2017-03-23 02:00:00	NQ	Futures	6408.52	6408.52	6401.96	6402.86	755.0
2017-03-23 03:00:00	NQ	Futures	6402.56	6403.46	6398.09	6402.86	1634.0
2017-03-23 04:00:00	NQ	Futures	6402.86	6403.46	6394.21	6395.7	2446.0
2017-03-23 05:00:00	NQ	Futures	6395.7	6403.75	6394.81	6399.28	2080.0
2017-03-23 06:00:00	NQ	Futures	6398.98	6405.84	6395.7	6405.24	2141.0
2017-03-23 07:00:00	NQ	Futures	6405.24	6408.52	6404.05	6405.54	3146.0
2017-03-23 08:00:00	NQ	Futures	6405.84	6409.72	6398.68	6399.88	5601.0
2017-03-23 09:00:00	NQ	Futures	6399.88	6402.56	6381.69	6388.25	43463.0
2017-03-23 10:00:00	NQ	Futures	6387.95	6407.33	6378.41	6401.07	39302.0
2017-03-23 11:00:00	NQ	Futures	6401.07	6413.0	6399.88	6409.12	26412.0
2017-03-23 12:00:00	NQ	Futures	6408.82	6412.7	6404.95	6410.91	16000.0
2017-03-23 13:00:00	NQ	Futures	6410.91	6411.21	6386.46	6395.7	45000.0
2017-03-23 14:00:00	NQ	Futures	6396.0	6409.42	6394.21	6401.37	17293.0
2017-03-23 15:00:00	NQ	Futures	6401.37	6401.67	6376.92	6389.14	48348.0
2017-03-23 16:00:00	NQ	Futures	6388.85	6390.64	6380.2	6389.14	8099.0
2017-03-23 18:00:00	NQ	Futures	6388.55	6400.77	6387.65	6393.62	1560.0
2017-03-23 19:00:00	NQ	Futures	6393.91	6399.88	6393.91	6394.81	977.0
2017-03-23 20:00:00	NQ	Futures	6394.81	6409.42	6393.62	6407.93	3099.0
2017-03-23 21:00:00	NQ	Futures	6407.93	6409.42	6402.56	6402.86	1375.0
2017-03-23 22:00:00	NQ	Futures	6402.86	6406.14	6402.86	6403.46	815.0
2017-03-23 23:00:00	NQ	Futures	6403.75	6404.05	6398.68	6400.18	574.0
2017-03-23 00:00:00	YM	Futures	22416.2	22418.3	22406.4	22407.5	1051.0
2017-03-23 01:00:00	YM	Futures	22407.5	22416.2	22405.3	22411.8	637.0
2017-03-23 02:00:00	YM	Futures	22411.8	22411.8	22392.2	22393.3	900.0
2017-03-23 03:00:00	YM	Futures	22393.3	22394.4	22374.9	22390.1	2378.0

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

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