PREVIEW / futures_1hour / 2017-02-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-16.parquet
  size:    52 KB
  rows:    1,626

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-02-16 00:00:00	ES	Futures	2563.21	2563.21	2562.12	2562.66	2599.0
2017-02-16 01:00:00	ES	Futures	2562.94	2563.21	2561.03	2561.57	7048.0
2017-02-16 02:00:00	ES	Futures	2561.57	2562.12	2561.3	2561.57	7769.0
2017-02-16 03:00:00	ES	Futures	2561.85	2563.76	2561.03	2561.03	21549.0
2017-02-16 04:00:00	ES	Futures	2561.03	2561.85	2559.94	2560.48	14597.0
2017-02-16 05:00:00	ES	Futures	2560.75	2560.75	2559.39	2560.48	11136.0
2017-02-16 06:00:00	ES	Futures	2560.75	2561.3	2559.66	2560.21	13297.0
2017-02-16 07:00:00	ES	Futures	2560.48	2560.75	2559.12	2559.39	12357.0
2017-02-16 08:00:00	ES	Futures	2559.39	2561.03	2558.03	2560.48	27994.0
2017-02-16 09:00:00	ES	Futures	2560.48	2563.76	2556.66	2558.3	226977.0
2017-02-16 10:00:00	ES	Futures	2558.3	2561.57	2550.66	2554.48	400488.0
2017-02-16 11:00:00	ES	Futures	2554.48	2556.94	2549.57	2556.94	288233.0
2017-02-16 12:00:00	ES	Futures	2556.94	2558.85	2553.66	2555.84	124161.0
2017-02-16 13:00:00	ES	Futures	2555.84	2556.12	2552.84	2554.75	131382.0
2017-02-16 14:00:00	ES	Futures	2555.03	2556.12	2552.03	2555.3	131208.0
2017-02-16 15:00:00	ES	Futures	2555.3	2559.39	2554.75	2559.39	191659.0
2017-02-16 16:00:00	ES	Futures	2559.12	2561.03	2558.85	2559.66	83852.0
2017-02-16 18:00:00	ES	Futures	2558.57	2559.12	2556.94	2557.21	3480.0
2017-02-16 19:00:00	ES	Futures	2557.21	2558.57	2556.39	2558.3	7051.0
2017-02-16 20:00:00	ES	Futures	2558.57	2560.48	2557.75	2559.39	5650.0
2017-02-16 21:00:00	ES	Futures	2559.39	2561.3	2559.12	2559.94	3779.0
2017-02-16 22:00:00	ES	Futures	2559.66	2560.21	2558.57	2558.85	2166.0
2017-02-16 23:00:00	ES	Futures	2558.57	2559.39	2557.75	2558.3	1715.0
2017-02-16 00:00:00	NQ	Futures	6339.3	6339.59	6336.91	6338.1	676.0
2017-02-16 01:00:00	NQ	Futures	6338.1	6338.7	6334.22	6336.31	1094.0
2017-02-16 02:00:00	NQ	Futures	6336.01	6337.21	6334.22	6336.01	1420.0
2017-02-16 03:00:00	NQ	Futures	6335.72	6340.49	6335.42	6335.72	2652.0
2017-02-16 04:00:00	NQ	Futures	6335.42	6336.61	6332.73	6334.52	1774.0
2017-02-16 05:00:00	NQ	Futures	6334.52	6335.72	6331.84	6335.72	1398.0
2017-02-16 06:00:00	NQ	Futures	6335.42	6336.91	6332.73	6334.22	1652.0
2017-02-16 07:00:00	NQ	Futures	6334.52	6336.01	6331.54	6332.43	1922.0
2017-02-16 08:00:00	NQ	Futures	6332.43	6333.93	6329.75	6332.73	3350.0
2017-02-16 09:00:00	NQ	Futures	6332.73	6344.67	6323.78	6328.86	30807.0
2017-02-16 10:00:00	NQ	Futures	6329.15	6340.49	6311.85	6321.4	43852.0
2017-02-16 11:00:00	NQ	Futures	6321.4	6324.38	6310.66	6321.4	29933.0
2017-02-16 12:00:00	NQ	Futures	6321.4	6325.57	6314.83	6317.52	14181.0
2017-02-16 13:00:00	NQ	Futures	6317.52	6319.91	6312.15	6318.12	16466.0
2017-02-16 14:00:00	NQ	Futures	6318.12	6322.29	6312.45	6319.61	18523.0
2017-02-16 15:00:00	NQ	Futures	6319.91	6326.77	6318.12	6326.17	23775.0
2017-02-16 16:00:00	NQ	Futures	6326.17	6329.45	6324.08	6326.17	4348.0
2017-02-16 18:00:00	NQ	Futures	6324.68	6325.28	6320.8	6321.4	593.0
2017-02-16 19:00:00	NQ	Futures	6321.1	6322.89	6317.52	6322.59	1500.0
2017-02-16 20:00:00	NQ	Futures	6322.89	6327.07	6320.8	6324.68	1287.0
2017-02-16 21:00:00	NQ	Futures	6324.38	6328.26	6324.08	6325.87	751.0
2017-02-16 22:00:00	NQ	Futures	6325.28	6326.77	6322.89	6323.19	602.0
2017-02-16 23:00:00	NQ	Futures	6323.19	6324.98	6321.7	6322.29	501.0
2017-02-16 00:00:00	YM	Futures	22364.6	22364.6	22355.9	22361.4	690.0
2017-02-16 01:00:00	YM	Futures	22362.4	22364.6	22349.4	22355.9	965.0
2017-02-16 02:00:00	YM	Futures	22354.9	22358.1	22349.4	22353.8	1382.0
2017-02-16 03:00:00	YM	Futures	22352.7	22364.6	22349.4	22349.4	2840.0

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

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