PREVIEW / futures_1hour / 2017-09-08

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-09-08.parquet
  size:    45 KB
  rows:    1,318

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-09-08 00:00:00	ES	Futures	2692.66	2694.58	2692.39	2693.76	2524.0
2017-09-08 01:00:00	ES	Futures	2694.03	2694.03	2690.2	2690.2	7138.0
2017-09-08 02:00:00	ES	Futures	2690.2	2692.12	2688.56	2689.66	8314.0
2017-09-08 03:00:00	ES	Futures	2689.66	2691.3	2688.02	2689.93	12828.0
2017-09-08 04:00:00	ES	Futures	2690.2	2690.2	2687.2	2687.74	10249.0
2017-09-08 05:00:00	ES	Futures	2687.74	2692.39	2687.74	2689.66	11201.0
2017-09-08 06:00:00	ES	Futures	2689.66	2690.75	2686.1	2686.92	13093.0
2017-09-08 07:00:00	ES	Futures	2686.92	2689.66	2686.65	2689.11	9089.0
2017-09-08 08:00:00	ES	Futures	2689.38	2691.3	2688.29	2690.75	11817.0
2017-09-08 09:00:00	ES	Futures	2690.48	2692.66	2688.02	2692.39	61309.0
2017-09-08 10:00:00	ES	Futures	2692.39	2694.3	2690.75	2693.76	91561.0
2017-09-08 11:00:00	ES	Futures	2693.76	2696.76	2692.66	2693.21	50126.0
2017-09-08 12:00:00	ES	Futures	2693.21	2694.58	2691.02	2693.76	32255.0
2017-09-08 13:00:00	ES	Futures	2693.76	2694.03	2691.57	2692.66	26362.0
2017-09-08 14:00:00	ES	Futures	2692.66	2694.85	2691.3	2692.94	43558.0
2017-09-08 15:00:00	ES	Futures	2692.66	2693.48	2688.56	2690.75	104641.0
2017-09-08 16:00:00	ES	Futures	2691.02	2692.94	2690.48	2692.39	36030.0
2017-09-08 00:00:00	NQ	Futures	7100.18	7106.43	7099.58	7102.86	388.0
2017-09-08 01:00:00	NQ	Futures	7103.15	7103.45	7091.24	7094.22	1148.0
2017-09-08 02:00:00	NQ	Futures	7093.92	7097.2	7087.67	7091.24	1645.0
2017-09-08 03:00:00	NQ	Futures	7091.24	7094.52	7084.69	7092.14	3190.0
2017-09-08 04:00:00	NQ	Futures	7091.54	7093.03	7087.67	7088.56	1222.0
2017-09-08 05:00:00	NQ	Futures	7088.56	7103.75	7087.67	7096.01	2646.0
2017-09-08 06:00:00	NQ	Futures	7095.41	7098.69	7085.59	7087.08	2349.0
2017-09-08 07:00:00	NQ	Futures	7087.37	7094.82	7086.48	7094.52	2020.0
2017-09-08 08:00:00	NQ	Futures	7094.52	7100.47	7091.24	7098.09	2976.0
2017-09-08 09:00:00	NQ	Futures	7098.09	7100.18	7078.44	7086.78	17854.0
2017-09-08 10:00:00	NQ	Futures	7086.48	7089.16	7068.61	7076.65	24272.0
2017-09-08 11:00:00	NQ	Futures	7076.36	7086.48	7063.26	7067.42	13440.0
2017-09-08 12:00:00	NQ	Futures	7067.42	7070.1	7058.19	7064.45	9171.0
2017-09-08 13:00:00	NQ	Futures	7064.74	7070.7	7056.7	7057.6	6744.0
2017-09-08 14:00:00	NQ	Futures	7057.9	7059.38	7043.9	7047.77	9533.0
2017-09-08 15:00:00	NQ	Futures	7048.07	7051.64	7035.86	7043.31	19315.0
2017-09-08 16:00:00	NQ	Futures	7043.6	7049.26	7041.82	7049.26	3361.0
2017-09-08 00:00:00	YM	Futures	23690.8	23724.6	23687.5	23719.1	1763.0
2017-09-08 01:00:00	YM	Futures	23719.1	23719.1	23674.5	23679.9	4140.0
2017-09-08 02:00:00	YM	Futures	23678.8	23694.1	23653.8	23660.3	1739.0
2017-09-08 03:00:00	YM	Futures	23661.4	23669.0	23646.2	23664.7	1671.0
2017-09-08 04:00:00	YM	Futures	23661.4	23665.8	23647.3	23649.4	1037.0
2017-09-08 05:00:00	YM	Futures	23649.4	23682.1	23649.4	23659.2	1103.0
2017-09-08 06:00:00	YM	Futures	23659.2	23665.8	23635.3	23638.6	1229.0
2017-09-08 07:00:00	YM	Futures	23636.4	23659.2	23634.2	23658.2	930.0
2017-09-08 08:00:00	YM	Futures	23657.1	23677.7	23648.4	23671.2	1872.0
2017-09-08 09:00:00	YM	Futures	23671.2	23727.8	23651.6	23727.8	8287.0
2017-09-08 10:00:00	YM	Futures	23726.7	23759.4	23715.8	23749.6	8809.0
2017-09-08 11:00:00	YM	Futures	23750.7	23776.8	23731.1	23749.6	6092.0
2017-09-08 12:00:00	YM	Futures	23749.6	23772.4	23739.8	23764.8	2336.0
2017-09-08 13:00:00	YM	Futures	23764.8	23765.9	23736.5	23748.5	2797.0
2017-09-08 14:00:00	YM	Futures	23747.4	23759.4	23728.9	23742.0	3875.0
2017-09-08 15:00:00	YM	Futures	23742.0	23748.5	23709.3	23724.6	5302.0

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

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