PREVIEW / futures_1hour / 2018-08-24

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-24.parquet
  size:    46 KB
  rows:    1,377

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
2018-08-24 00:00:00	ES	Futures	3119.47	3119.74	3118.38	3119.19	2517.0
2018-08-24 01:00:00	ES	Futures	3119.47	3120.83	3118.92	3119.19	6424.0
2018-08-24 02:00:00	ES	Futures	3119.19	3119.74	3117.29	3117.83	6755.0
2018-08-24 03:00:00	ES	Futures	3117.56	3121.65	3117.56	3120.56	9611.0
2018-08-24 04:00:00	ES	Futures	3120.56	3122.19	3119.47	3121.37	10383.0
2018-08-24 05:00:00	ES	Futures	3121.37	3121.37	3119.19	3120.28	6700.0
2018-08-24 06:00:00	ES	Futures	3120.56	3122.46	3120.01	3122.46	8578.0
2018-08-24 07:00:00	ES	Futures	3122.46	3123.01	3120.83	3121.37	9474.0
2018-08-24 08:00:00	ES	Futures	3121.37	3122.19	3119.47	3120.83	15896.0
2018-08-24 09:00:00	ES	Futures	3120.56	3124.64	3120.56	3122.46	120749.0
2018-08-24 10:00:00	ES	Futures	3122.46	3133.09	3122.19	3130.37	217583.0
2018-08-24 11:00:00	ES	Futures	3130.64	3135.0	3128.73	3134.72	114632.0
2018-08-24 12:00:00	ES	Futures	3135.0	3135.54	3133.09	3134.45	71243.0
2018-08-24 13:00:00	ES	Futures	3134.72	3135.81	3128.73	3132.55	94317.0
2018-08-24 14:00:00	ES	Futures	3132.55	3134.72	3131.73	3132.82	58843.0
2018-08-24 15:00:00	ES	Futures	3132.82	3135.0	3131.46	3133.91	136975.0
2018-08-24 16:00:00	ES	Futures	3133.91	3136.09	3133.09	3135.0	63973.0
2018-08-24 00:00:00	NQ	Futures	8763.95	8765.42	8760.41	8763.65	749.0
2018-08-24 01:00:00	NQ	Futures	8764.24	8768.66	8763.06	8764.24	1921.0
2018-08-24 02:00:00	NQ	Futures	8764.24	8766.01	8755.11	8756.88	2654.0
2018-08-24 03:00:00	NQ	Futures	8757.17	8766.3	8756.58	8762.77	2530.0
2018-08-24 04:00:00	NQ	Futures	8762.77	8767.48	8759.82	8765.12	3070.0
2018-08-24 05:00:00	NQ	Futures	8765.42	8766.01	8759.23	8762.77	1697.0
2018-08-24 06:00:00	NQ	Futures	8763.06	8774.25	8761.88	8771.89	3106.0
2018-08-24 07:00:00	NQ	Futures	8771.89	8773.07	8763.95	8767.77	2702.0
2018-08-24 08:00:00	NQ	Futures	8767.48	8772.48	8762.18	8767.18	4144.0
2018-08-24 09:00:00	NQ	Futures	8767.48	8789.27	8766.89	8778.37	41788.0
2018-08-24 10:00:00	NQ	Futures	8778.37	8827.25	8778.37	8817.82	68891.0
2018-08-24 11:00:00	NQ	Futures	8817.82	8831.96	8808.99	8826.66	35307.0
2018-08-24 12:00:00	NQ	Futures	8826.66	8829.31	8819.59	8822.83	18486.0
2018-08-24 13:00:00	NQ	Futures	8823.12	8825.48	8805.16	8816.35	23072.0
2018-08-24 14:00:00	NQ	Futures	8816.06	8828.13	8814.88	8821.65	16277.0
2018-08-24 15:00:00	NQ	Futures	8821.65	8830.19	8816.94	8824.3	30448.0
2018-08-24 16:00:00	NQ	Futures	8824.6	8831.96	8823.42	8828.42	8403.0
2018-08-24 00:00:00	YM	Futures	27948.2	27952.5	27941.7	27946.0	552.0
2018-08-24 01:00:00	YM	Futures	27946.0	27960.1	27942.7	27951.4	1271.0
2018-08-24 02:00:00	YM	Futures	27951.4	27956.9	27931.9	27934.0	1487.0
2018-08-24 03:00:00	YM	Futures	27934.0	27965.6	27934.0	27952.5	2046.0
2018-08-24 04:00:00	YM	Futures	27953.6	27969.9	27952.5	27966.7	2448.0
2018-08-24 05:00:00	YM	Futures	27965.6	27967.7	27947.1	27962.3	1276.0
2018-08-24 06:00:00	YM	Futures	27961.2	27974.3	27951.4	27973.2	1939.0
2018-08-24 07:00:00	YM	Futures	27973.2	27994.9	27967.7	27985.1	2755.0
2018-08-24 08:00:00	YM	Futures	27985.1	27985.1	27952.5	27964.5	3825.0
2018-08-24 09:00:00	YM	Futures	27964.5	27986.2	27947.1	27961.2	14939.0
2018-08-24 10:00:00	YM	Futures	27961.2	28061.2	27953.6	28035.1	21883.0
2018-08-24 11:00:00	YM	Futures	28036.2	28073.2	28010.1	28069.9	13595.0
2018-08-24 12:00:00	YM	Futures	28068.8	28078.6	28050.4	28060.2	7568.0
2018-08-24 13:00:00	YM	Futures	28061.2	28072.1	28012.3	28037.3	9179.0
2018-08-24 14:00:00	YM	Futures	28037.3	28055.8	28034.1	28037.3	5270.0
2018-08-24 15:00:00	YM	Futures	28038.4	28050.4	28022.1	28034.1	10997.0

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

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