PREVIEW / futures_1hour / 2017-08-16

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-16.parquet
  size:    54 KB
  rows:    1,638

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-16 00:00:00	ES	Futures	2692.94	2693.48	2692.39	2692.94	1104.0
2017-08-16 01:00:00	ES	Futures	2693.21	2694.85	2692.94	2693.76	4242.0
2017-08-16 02:00:00	ES	Futures	2693.76	2697.04	2693.48	2696.76	10274.0
2017-08-16 03:00:00	ES	Futures	2696.76	2700.04	2695.94	2699.22	23879.0
2017-08-16 04:00:00	ES	Futures	2698.95	2700.59	2698.68	2700.04	13051.0
2017-08-16 05:00:00	ES	Futures	2700.32	2701.96	2698.68	2700.87	16307.0
2017-08-16 06:00:00	ES	Futures	2701.14	2701.41	2698.95	2699.22	14474.0
2017-08-16 07:00:00	ES	Futures	2699.5	2700.04	2697.86	2698.4	13749.0
2017-08-16 08:00:00	ES	Futures	2698.4	2700.04	2697.58	2699.5	18700.0
2017-08-16 09:00:00	ES	Futures	2699.5	2701.14	2697.04	2700.32	149290.0
2017-08-16 10:00:00	ES	Futures	2700.32	2703.6	2698.95	2702.78	124372.0
2017-08-16 11:00:00	ES	Futures	2702.78	2703.87	2699.5	2702.51	90689.0
2017-08-16 12:00:00	ES	Futures	2702.51	2704.97	2699.77	2700.59	97075.0
2017-08-16 13:00:00	ES	Futures	2700.87	2701.96	2695.94	2697.86	134728.0
2017-08-16 14:00:00	ES	Futures	2698.13	2701.14	2692.39	2697.31	175427.0
2017-08-16 15:00:00	ES	Futures	2697.31	2698.4	2695.12	2697.58	154138.0
2017-08-16 16:00:00	ES	Futures	2697.58	2698.4	2696.22	2696.76	60401.0
2017-08-16 18:00:00	ES	Futures	2697.04	2697.04	2693.21	2693.76	7878.0
2017-08-16 19:00:00	ES	Futures	2694.03	2694.58	2692.39	2694.03	4477.0
2017-08-16 20:00:00	ES	Futures	2693.76	2695.12	2692.94	2694.58	6005.0
2017-08-16 21:00:00	ES	Futures	2694.58	2695.12	2693.21	2693.48	4468.0
2017-08-16 22:00:00	ES	Futures	2693.48	2694.03	2692.94	2693.76	3488.0
2017-08-16 23:00:00	ES	Futures	2694.03	2695.67	2693.76	2695.4	2943.0
2017-08-16 00:00:00	NQ	Futures	7037.35	7037.65	7036.46	7037.35	410.0
2017-08-16 01:00:00	NQ	Futures	7037.35	7043.01	7037.05	7039.73	943.0
2017-08-16 02:00:00	NQ	Futures	7039.43	7048.96	7038.54	7048.67	1659.0
2017-08-16 03:00:00	NQ	Futures	7048.37	7063.55	7047.47	7059.09	4565.0
2017-08-16 04:00:00	NQ	Futures	7058.79	7065.93	7058.49	7064.15	2748.0
2017-08-16 05:00:00	NQ	Futures	7064.15	7072.78	7058.49	7067.13	2751.0
2017-08-16 06:00:00	NQ	Futures	7067.13	7067.72	7055.81	7057.6	3397.0
2017-08-16 07:00:00	NQ	Futures	7057.6	7059.98	7051.94	7053.43	5438.0
2017-08-16 08:00:00	NQ	Futures	7053.43	7062.06	7050.75	7059.98	3764.0
2017-08-16 09:00:00	NQ	Futures	7059.98	7060.87	7035.86	7044.2	39993.0
2017-08-16 10:00:00	NQ	Futures	7044.79	7068.32	7038.84	7064.74	36509.0
2017-08-16 11:00:00	NQ	Futures	7065.04	7072.19	7059.09	7070.4	27370.0
2017-08-16 12:00:00	NQ	Futures	7070.4	7085.88	7061.17	7063.55	33524.0
2017-08-16 13:00:00	NQ	Futures	7063.55	7065.64	7041.22	7048.67	37076.0
2017-08-16 14:00:00	NQ	Futures	7048.96	7062.96	7029.31	7048.67	48420.0
2017-08-16 15:00:00	NQ	Futures	7048.96	7054.02	7041.52	7051.94	25554.0
2017-08-16 16:00:00	NQ	Futures	7052.24	7056.11	7047.77	7051.05	7595.0
2017-08-16 18:00:00	NQ	Futures	7050.75	7051.05	7039.43	7040.33	1629.0
2017-08-16 19:00:00	NQ	Futures	7040.63	7042.71	7032.29	7037.65	1470.0
2017-08-16 20:00:00	NQ	Futures	7037.65	7045.99	7034.67	7043.01	1723.0
2017-08-16 21:00:00	NQ	Futures	7043.31	7045.39	7037.05	7038.84	1433.0
2017-08-16 22:00:00	NQ	Futures	7038.24	7038.84	7034.37	7038.54	1012.0
2017-08-16 23:00:00	NQ	Futures	7038.24	7044.5	7036.16	7043.01	854.0
2017-08-16 00:00:00	YM	Futures	23923.7	23924.8	23919.4	23922.7	276.0
2017-08-16 01:00:00	YM	Futures	23923.7	23933.5	23922.7	23927.0	817.0
2017-08-16 02:00:00	YM	Futures	23927.0	23953.1	23922.7	23953.1	2135.0
2017-08-16 03:00:00	YM	Futures	23953.1	23989.1	23944.4	23981.4	4054.0

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

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