PREVIEW / futures_1hour / 2017-04-11

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-04-11.parquet
  size:    53 KB
  rows:    1,629

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-04-11 00:00:00	ES	Futures	2567.82	2568.09	2566.72	2567.82	3175.0
2017-04-11 01:00:00	ES	Futures	2567.82	2568.36	2566.72	2568.09	3820.0
2017-04-11 02:00:00	ES	Futures	2568.09	2568.36	2565.63	2566.18	8991.0
2017-04-11 03:00:00	ES	Futures	2566.18	2569.46	2565.09	2568.64	24712.0
2017-04-11 04:00:00	ES	Futures	2568.91	2570.82	2566.18	2567.0	18827.0
2017-04-11 05:00:00	ES	Futures	2567.0	2569.73	2566.18	2569.46	13537.0
2017-04-11 06:00:00	ES	Futures	2569.73	2571.37	2568.91	2570.0	11590.0
2017-04-11 07:00:00	ES	Futures	2570.0	2570.82	2567.0	2567.27	12926.0
2017-04-11 08:00:00	ES	Futures	2567.27	2569.46	2566.72	2568.36	19309.0
2017-04-11 09:00:00	ES	Futures	2568.36	2569.46	2557.44	2561.81	281664.0
2017-04-11 10:00:00	ES	Futures	2561.81	2564.54	2549.24	2552.79	415408.0
2017-04-11 11:00:00	ES	Futures	2553.07	2556.89	2550.88	2555.8	224549.0
2017-04-11 12:00:00	ES	Futures	2555.8	2563.99	2553.61	2562.9	176963.0
2017-04-11 13:00:00	ES	Futures	2562.9	2567.0	2561.26	2563.72	149675.0
2017-04-11 14:00:00	ES	Futures	2563.45	2567.82	2559.9	2565.36	116940.0
2017-04-11 15:00:00	ES	Futures	2565.09	2568.36	2559.08	2567.82	236467.0
2017-04-11 16:00:00	ES	Futures	2568.09	2569.73	2566.72	2569.46	86009.0
2017-04-11 18:00:00	ES	Futures	2569.46	2570.0	2567.27	2568.09	6573.0
2017-04-11 19:00:00	ES	Futures	2568.09	2568.64	2567.0	2567.0	5160.0
2017-04-11 20:00:00	ES	Futures	2567.0	2567.54	2563.45	2563.45	13664.0
2017-04-11 21:00:00	ES	Futures	2563.45	2566.18	2562.63	2564.81	10914.0
2017-04-11 22:00:00	ES	Futures	2565.09	2565.36	2562.63	2564.27	4831.0
2017-04-11 23:00:00	ES	Futures	2564.27	2565.63	2563.72	2564.54	3348.0
2017-04-11 00:00:00	NQ	Futures	6459.8	6460.4	6455.93	6458.91	845.0
2017-04-11 01:00:00	NQ	Futures	6458.61	6461.89	6456.23	6460.7	835.0
2017-04-11 02:00:00	NQ	Futures	6460.4	6461.0	6454.44	6456.52	1308.0
2017-04-11 03:00:00	NQ	Futures	6456.23	6462.79	6453.54	6462.19	3404.0
2017-04-11 04:00:00	NQ	Futures	6462.19	6467.56	6456.23	6458.61	2672.0
2017-04-11 05:00:00	NQ	Futures	6458.31	6465.77	6457.12	6465.47	1654.0
2017-04-11 06:00:00	NQ	Futures	6465.47	6469.05	6463.38	6466.66	1756.0
2017-04-11 07:00:00	NQ	Futures	6466.66	6468.15	6459.8	6460.1	1926.0
2017-04-11 08:00:00	NQ	Futures	6459.8	6465.17	6458.01	6462.19	5057.0
2017-04-11 09:00:00	NQ	Futures	6462.19	6469.05	6418.06	6429.39	55787.0
2017-04-11 10:00:00	NQ	Futures	6429.39	6436.55	6389.74	6402.26	78966.0
2017-04-11 11:00:00	NQ	Futures	6401.96	6415.38	6393.02	6409.72	39998.0
2017-04-11 12:00:00	NQ	Futures	6409.72	6437.74	6405.24	6432.67	35963.0
2017-04-11 13:00:00	NQ	Futures	6432.97	6445.19	6426.41	6430.59	25621.0
2017-04-11 14:00:00	NQ	Futures	6430.29	6439.23	6422.54	6434.46	22309.0
2017-04-11 15:00:00	NQ	Futures	6434.46	6438.93	6415.38	6438.93	32599.0
2017-04-11 16:00:00	NQ	Futures	6438.93	6445.49	6434.76	6445.49	6521.0
2017-04-11 18:00:00	NQ	Futures	6443.11	6445.19	6437.44	6439.83	1208.0
2017-04-11 19:00:00	NQ	Futures	6440.13	6441.02	6435.95	6436.55	704.0
2017-04-11 20:00:00	NQ	Futures	6436.25	6438.64	6427.6	6428.2	2775.0
2017-04-11 21:00:00	NQ	Futures	6428.2	6431.78	6425.22	6428.8	2665.0
2017-04-11 22:00:00	NQ	Futures	6428.5	6429.39	6423.43	6427.31	1358.0
2017-04-11 23:00:00	NQ	Futures	6427.31	6429.39	6425.52	6426.41	1009.0
2017-04-11 00:00:00	YM	Futures	22362.9	22365.1	22354.2	22362.9	793.0
2017-04-11 01:00:00	YM	Futures	22362.9	22372.7	22354.2	22368.3	779.0
2017-04-11 02:00:00	YM	Futures	22367.2	22369.4	22348.8	22354.2	1716.0
2017-04-11 03:00:00	YM	Futures	22355.3	22377.0	22342.3	22371.6	3582.0

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

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