PREVIEW / futures_1hour / 2017-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-22.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-03-22 00:00:00	ES	Futures	2552.79	2553.34	2551.97	2552.79	3028.0
2017-03-22 01:00:00	ES	Futures	2553.07	2553.34	2549.24	2550.06	8755.0
2017-03-22 02:00:00	ES	Futures	2550.06	2552.25	2548.15	2551.7	9666.0
2017-03-22 03:00:00	ES	Futures	2551.7	2554.43	2549.52	2552.25	18439.0
2017-03-22 04:00:00	ES	Futures	2552.52	2556.89	2549.24	2552.52	43346.0
2017-03-22 05:00:00	ES	Futures	2552.52	2558.26	2549.52	2557.44	35002.0
2017-03-22 06:00:00	ES	Futures	2557.16	2557.98	2555.25	2557.16	12136.0
2017-03-22 07:00:00	ES	Futures	2557.16	2558.26	2553.89	2556.35	21305.0
2017-03-22 08:00:00	ES	Futures	2556.35	2558.8	2555.25	2557.16	34786.0
2017-03-22 09:00:00	ES	Futures	2556.89	2558.8	2550.88	2551.16	246096.0
2017-03-22 10:00:00	ES	Futures	2551.16	2558.8	2548.7	2558.26	347127.0
2017-03-22 11:00:00	ES	Futures	2558.53	2565.36	2554.98	2562.08	225323.0
2017-03-22 12:00:00	ES	Futures	2562.08	2563.45	2555.8	2557.98	141533.0
2017-03-22 13:00:00	ES	Futures	2557.98	2561.81	2552.79	2555.53	185874.0
2017-03-22 14:00:00	ES	Futures	2555.53	2562.35	2555.25	2561.26	113358.0
2017-03-22 15:00:00	ES	Futures	2561.53	2566.18	2560.17	2562.35	261602.0
2017-03-22 16:00:00	ES	Futures	2562.35	2562.35	2557.98	2559.08	81694.0
2017-03-22 18:00:00	ES	Futures	2559.08	2564.27	2558.8	2563.72	11856.0
2017-03-22 19:00:00	ES	Futures	2563.72	2565.63	2563.45	2565.36	5790.0
2017-03-22 20:00:00	ES	Futures	2565.36	2565.36	2563.17	2564.81	7235.0
2017-03-22 21:00:00	ES	Futures	2564.54	2567.0	2564.27	2566.18	11413.0
2017-03-22 22:00:00	ES	Futures	2565.91	2567.0	2565.36	2565.91	4022.0
2017-03-22 23:00:00	ES	Futures	2566.18	2566.18	2564.81	2565.63	3401.0
2017-03-22 00:00:00	NQ	Futures	6350.39	6352.77	6349.79	6352.47	861.0
2017-03-22 01:00:00	NQ	Futures	6352.77	6353.07	6345.91	6346.51	2223.0
2017-03-22 02:00:00	NQ	Futures	6347.11	6351.88	6341.74	6351.58	1934.0
2017-03-22 03:00:00	NQ	Futures	6351.28	6356.35	6348.0	6351.58	3285.0
2017-03-22 04:00:00	NQ	Futures	6351.58	6360.52	6344.72	6350.98	7500.0
2017-03-22 05:00:00	NQ	Futures	6350.68	6362.31	6344.13	6359.93	5387.0
2017-03-22 06:00:00	NQ	Futures	6359.63	6363.8	6356.05	6362.01	2294.0
2017-03-22 07:00:00	NQ	Futures	6362.31	6364.4	6356.65	6360.22	3425.0
2017-03-22 08:00:00	NQ	Futures	6360.22	6364.4	6358.14	6363.5	4638.0
2017-03-22 09:00:00	NQ	Futures	6363.21	6384.37	6359.63	6365.0	51961.0
2017-03-22 10:00:00	NQ	Futures	6365.0	6385.86	6354.26	6385.57	60151.0
2017-03-22 11:00:00	NQ	Futures	6385.27	6405.54	6376.92	6398.09	43657.0
2017-03-22 12:00:00	NQ	Futures	6398.09	6400.77	6383.78	6390.34	25852.0
2017-03-22 13:00:00	NQ	Futures	6390.04	6398.68	6377.52	6383.48	37661.0
2017-03-22 14:00:00	NQ	Futures	6383.18	6402.86	6383.18	6401.07	25508.0
2017-03-22 15:00:00	NQ	Futures	6400.77	6411.5	6396.6	6404.05	35549.0
2017-03-22 16:00:00	NQ	Futures	6404.05	6404.65	6396.6	6398.09	6207.0
2017-03-22 18:00:00	NQ	Futures	6398.68	6410.01	6397.79	6408.82	1742.0
2017-03-22 19:00:00	NQ	Futures	6408.82	6411.21	6407.33	6411.21	929.0
2017-03-22 20:00:00	NQ	Futures	6410.91	6412.4	6405.54	6409.12	1305.0
2017-03-22 21:00:00	NQ	Futures	6408.52	6414.19	6407.33	6411.21	1692.0
2017-03-22 22:00:00	NQ	Futures	6411.21	6413.59	6409.12	6409.12	721.0
2017-03-22 23:00:00	NQ	Futures	6409.12	6410.31	6407.33	6408.23	675.0
2017-03-22 00:00:00	YM	Futures	22367.2	22373.8	22360.7	22370.5	733.0
2017-03-22 01:00:00	YM	Futures	22371.6	22372.7	22347.7	22353.1	1648.0
2017-03-22 02:00:00	YM	Futures	22352.0	22370.5	22339.0	22367.2	2043.0
2017-03-22 03:00:00	YM	Futures	22367.2	22383.6	22353.1	22362.9	3442.0

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

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