PREVIEW / futures_1hour / 2017-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-02-21.parquet
  size:    53 KB
  rows:    1,645

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-21 00:00:00	ES	Futures	2566.76	2567.03	2564.57	2564.85	3680.0
2017-02-21 01:00:00	ES	Futures	2564.57	2565.66	2564.57	2565.12	1762.0
2017-02-21 02:00:00	ES	Futures	2565.12	2565.94	2563.48	2563.76	4734.0
2017-02-21 03:00:00	ES	Futures	2563.76	2565.94	2562.94	2564.57	16195.0
2017-02-21 04:00:00	ES	Futures	2564.85	2567.57	2564.57	2567.03	16659.0
2017-02-21 05:00:00	ES	Futures	2567.03	2568.12	2566.21	2567.85	9233.0
2017-02-21 06:00:00	ES	Futures	2567.85	2568.67	2567.3	2567.57	9213.0
2017-02-21 07:00:00	ES	Futures	2567.57	2568.67	2567.03	2567.3	23388.0
2017-02-21 08:00:00	ES	Futures	2567.3	2567.57	2565.94	2567.03	18907.0
2017-02-21 09:00:00	ES	Futures	2567.03	2574.67	2567.03	2573.85	197758.0
2017-02-21 10:00:00	ES	Futures	2573.85	2580.12	2573.3	2577.39	268856.0
2017-02-21 11:00:00	ES	Futures	2577.12	2577.39	2570.3	2573.85	226502.0
2017-02-21 12:00:00	ES	Futures	2573.85	2575.76	2573.3	2574.12	111515.0
2017-02-21 13:00:00	ES	Futures	2574.12	2575.21	2572.21	2573.85	97222.0
2017-02-21 14:00:00	ES	Futures	2573.85	2577.94	2572.76	2576.58	103001.0
2017-02-21 15:00:00	ES	Futures	2576.85	2580.39	2576.3	2577.67	243506.0
2017-02-21 16:00:00	ES	Futures	2577.67	2577.94	2573.03	2575.21	120672.0
2017-02-21 18:00:00	ES	Futures	2574.94	2575.48	2573.85	2574.94	4506.0
2017-02-21 19:00:00	ES	Futures	2574.67	2575.48	2573.57	2575.21	4687.0
2017-02-21 20:00:00	ES	Futures	2575.48	2575.48	2574.39	2574.94	3334.0
2017-02-21 21:00:00	ES	Futures	2574.94	2575.76	2574.67	2575.21	2411.0
2017-02-21 22:00:00	ES	Futures	2574.94	2575.48	2574.94	2575.21	1118.0
2017-02-21 23:00:00	ES	Futures	2575.21	2576.85	2574.67	2576.58	3271.0
2017-02-21 00:00:00	NQ	Futures	6371.51	6371.51	6365.55	6367.04	1011.0
2017-02-21 01:00:00	NQ	Futures	6366.74	6369.43	6365.85	6366.15	525.0
2017-02-21 02:00:00	NQ	Futures	6366.44	6368.83	6363.76	6364.06	1097.0
2017-02-21 03:00:00	NQ	Futures	6364.65	6368.83	6362.27	6367.04	3022.0
2017-02-21 04:00:00	NQ	Futures	6366.74	6371.51	6366.44	6370.62	2438.0
2017-02-21 05:00:00	NQ	Futures	6370.92	6373.3	6369.43	6373.3	2195.0
2017-02-21 06:00:00	NQ	Futures	6373.01	6373.3	6369.72	6371.51	1481.0
2017-02-21 07:00:00	NQ	Futures	6371.22	6373.01	6368.23	6368.53	2247.0
2017-02-21 08:00:00	NQ	Futures	6368.23	6368.53	6365.55	6366.74	2591.0
2017-02-21 09:00:00	NQ	Futures	6366.74	6380.46	6362.27	6376.88	26105.0
2017-02-21 10:00:00	NQ	Futures	6377.18	6387.62	6374.2	6380.76	25934.0
2017-02-21 11:00:00	NQ	Futures	6380.76	6381.66	6365.25	6371.51	21727.0
2017-02-21 12:00:00	NQ	Futures	6371.22	6373.6	6366.15	6370.02	15662.0
2017-02-21 13:00:00	NQ	Futures	6370.02	6374.5	6366.74	6370.92	9632.0
2017-02-21 14:00:00	NQ	Futures	6370.92	6379.57	6369.43	6378.08	11952.0
2017-02-21 15:00:00	NQ	Futures	6377.78	6388.52	6376.88	6384.64	19188.0
2017-02-21 16:00:00	NQ	Futures	6384.64	6384.64	6373.6	6378.38	6312.0
2017-02-21 18:00:00	NQ	Futures	6378.67	6379.27	6375.99	6377.78	777.0
2017-02-21 19:00:00	NQ	Futures	6377.48	6381.06	6375.69	6380.76	981.0
2017-02-21 20:00:00	NQ	Futures	6380.76	6380.76	6378.08	6379.87	806.0
2017-02-21 21:00:00	NQ	Futures	6379.87	6381.66	6379.27	6379.87	539.0
2017-02-21 22:00:00	NQ	Futures	6379.57	6381.06	6379.57	6380.76	415.0
2017-02-21 23:00:00	NQ	Futures	6380.76	6384.34	6380.17	6383.75	717.0
2017-02-21 00:00:00	YM	Futures	22378.7	22378.7	22353.8	22360.3	1439.0
2017-02-21 01:00:00	YM	Futures	22360.3	22369.0	22358.1	22360.3	571.0
2017-02-21 02:00:00	YM	Futures	22360.3	22370.0	22350.5	22353.8	1107.0
2017-02-21 03:00:00	YM	Futures	22353.8	22376.6	22348.3	22367.9	3395.0

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

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