PREVIEW / futures_1hour / 2017-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-14.parquet
  size:    53 KB
  rows:    1,625

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-08-14 00:00:00	ES	Futures	2677.9	2678.18	2676.81	2677.08	2668.0
2017-08-14 01:00:00	ES	Futures	2676.81	2677.36	2676.26	2676.54	4209.0
2017-08-14 02:00:00	ES	Futures	2676.54	2678.45	2676.54	2677.9	11030.0
2017-08-14 03:00:00	ES	Futures	2677.63	2684.74	2677.08	2684.19	48119.0
2017-08-14 04:00:00	ES	Futures	2684.46	2684.46	2681.46	2683.37	22349.0
2017-08-14 05:00:00	ES	Futures	2683.1	2684.19	2682.28	2682.55	12973.0
2017-08-14 06:00:00	ES	Futures	2682.28	2683.64	2681.73	2683.64	13922.0
2017-08-14 07:00:00	ES	Futures	2683.37	2683.64	2680.64	2682.28	20784.0
2017-08-14 08:00:00	ES	Futures	2682.28	2683.64	2681.46	2683.1	21074.0
2017-08-14 09:00:00	ES	Futures	2682.82	2690.75	2680.64	2689.93	224237.0
2017-08-14 10:00:00	ES	Futures	2689.93	2696.76	2689.66	2694.85	217135.0
2017-08-14 11:00:00	ES	Futures	2695.12	2695.94	2693.21	2695.12	126060.0
2017-08-14 12:00:00	ES	Futures	2694.85	2696.22	2692.94	2693.76	90925.0
2017-08-14 13:00:00	ES	Futures	2693.76	2695.67	2693.21	2695.12	70167.0
2017-08-14 14:00:00	ES	Futures	2695.12	2695.67	2690.75	2691.84	124638.0
2017-08-14 15:00:00	ES	Futures	2691.84	2696.49	2691.02	2693.48	303104.0
2017-08-14 16:00:00	ES	Futures	2693.48	2695.67	2691.84	2695.12	96422.0
2017-08-14 18:00:00	ES	Futures	2694.58	2696.22	2692.39	2695.4	9127.0
2017-08-14 19:00:00	ES	Futures	2695.4	2698.95	2694.85	2697.86	6268.0
2017-08-14 20:00:00	ES	Futures	2698.13	2702.23	2697.58	2701.96	23379.0
2017-08-14 21:00:00	ES	Futures	2701.69	2704.15	2701.69	2702.23	12189.0
2017-08-14 22:00:00	ES	Futures	2702.23	2702.78	2701.69	2701.69	4937.0
2017-08-14 23:00:00	ES	Futures	2701.69	2702.51	2700.87	2701.69	6083.0
2017-08-14 00:00:00	NQ	Futures	6991.5	6994.47	6986.73	6987.63	970.0
2017-08-14 01:00:00	NQ	Futures	6987.63	6990.01	6984.65	6987.03	910.0
2017-08-14 02:00:00	NQ	Futures	6987.03	6992.39	6986.73	6987.63	1229.0
2017-08-14 03:00:00	NQ	Futures	6987.92	7000.73	6985.54	6998.64	5485.0
2017-08-14 04:00:00	NQ	Futures	6998.64	6998.94	6993.88	6997.15	2739.0
2017-08-14 05:00:00	NQ	Futures	6996.56	6998.94	6990.9	6992.69	1486.0
2017-08-14 06:00:00	NQ	Futures	6992.39	6995.37	6988.52	6994.77	1603.0
2017-08-14 07:00:00	NQ	Futures	6994.77	6994.77	6984.95	6987.92	2730.0
2017-08-14 08:00:00	NQ	Futures	6988.22	6997.45	6986.73	6996.86	4636.0
2017-08-14 09:00:00	NQ	Futures	6996.56	7018.0	6990.6	7014.13	47648.0
2017-08-14 10:00:00	NQ	Futures	7013.83	7040.63	7013.83	7030.5	48853.0
2017-08-14 11:00:00	NQ	Futures	7030.5	7031.69	7021.87	7027.82	22969.0
2017-08-14 12:00:00	NQ	Futures	7027.82	7033.18	7022.76	7029.61	15261.0
2017-08-14 13:00:00	NQ	Futures	7029.91	7038.24	7029.91	7035.56	15181.0
2017-08-14 14:00:00	NQ	Futures	7035.56	7038.24	7023.95	7028.72	22355.0
2017-08-14 15:00:00	NQ	Futures	7029.01	7046.88	7024.25	7036.16	44263.0
2017-08-14 16:00:00	NQ	Futures	7035.86	7045.39	7033.78	7043.01	7660.0
2017-08-14 18:00:00	NQ	Futures	7043.01	7046.28	7039.14	7044.2	1842.0
2017-08-14 19:00:00	NQ	Futures	7044.5	7054.02	7043.01	7052.54	1856.0
2017-08-14 20:00:00	NQ	Futures	7052.83	7073.08	7052.54	7070.4	5102.0
2017-08-14 21:00:00	NQ	Futures	7070.1	7080.52	7068.91	7072.49	2486.0
2017-08-14 22:00:00	NQ	Futures	7072.78	7075.46	7071.59	7072.49	847.0
2017-08-14 23:00:00	NQ	Futures	7072.49	7074.27	7070.4	7071.59	800.0
2017-08-14 00:00:00	YM	Futures	23858.4	23862.8	23850.8	23850.8	603.0
2017-08-14 01:00:00	YM	Futures	23850.8	23853.0	23841.0	23843.2	939.0
2017-08-14 02:00:00	YM	Futures	23843.2	23858.4	23843.2	23856.3	2092.0
2017-08-14 03:00:00	YM	Futures	23857.3	23896.5	23850.8	23890.0	4028.0

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

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