PREVIEW / futures_1hour / 2018-08-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-22.parquet
  size:    54 KB
  rows:    1,673

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-22 00:00:00	ES	Futures	3113.2	3113.47	3110.75	3111.02	4143.0
2018-08-22 01:00:00	ES	Futures	3111.29	3112.65	3109.93	3110.75	5648.0
2018-08-22 02:00:00	ES	Futures	3111.02	3112.65	3107.48	3111.57	13067.0
2018-08-22 03:00:00	ES	Futures	3111.57	3114.29	3110.75	3112.11	15457.0
2018-08-22 04:00:00	ES	Futures	3111.84	3113.2	3109.93	3113.2	12549.0
2018-08-22 05:00:00	ES	Futures	3113.2	3113.47	3110.75	3112.11	8423.0
2018-08-22 06:00:00	ES	Futures	3111.84	3117.01	3111.84	3116.74	15746.0
2018-08-22 07:00:00	ES	Futures	3116.74	3118.38	3112.65	3114.02	22018.0
2018-08-22 08:00:00	ES	Futures	3114.02	3114.56	3109.39	3113.74	28795.0
2018-08-22 09:00:00	ES	Futures	3113.74	3121.1	3112.65	3115.38	149411.0
2018-08-22 10:00:00	ES	Futures	3115.38	3123.55	3112.93	3122.19	164455.0
2018-08-22 11:00:00	ES	Futures	3121.92	3126.01	3121.37	3124.92	102428.0
2018-08-22 12:00:00	ES	Futures	3124.92	3125.73	3120.56	3122.46	53432.0
2018-08-22 13:00:00	ES	Futures	3122.19	3123.55	3120.28	3122.74	36991.0
2018-08-22 14:00:00	ES	Futures	3122.74	3125.73	3117.56	3120.83	90598.0
2018-08-22 15:00:00	ES	Futures	3120.83	3123.55	3119.74	3120.01	103311.0
2018-08-22 16:00:00	ES	Futures	3119.74	3120.56	3117.29	3119.19	55425.0
2018-08-22 18:00:00	ES	Futures	3118.92	3121.65	3118.92	3120.83	4364.0
2018-08-22 19:00:00	ES	Futures	3121.1	3121.1	3119.47	3119.74	1709.0
2018-08-22 20:00:00	ES	Futures	3119.47	3120.01	3118.38	3118.92	4571.0
2018-08-22 21:00:00	ES	Futures	3118.92	3120.28	3115.11	3116.2	12325.0
2018-08-22 22:00:00	ES	Futures	3116.47	3117.83	3115.11	3115.11	6363.0
2018-08-22 23:00:00	ES	Futures	3115.38	3116.47	3114.29	3115.65	4325.0
2018-08-22 00:00:00	NQ	Futures	8698.0	8698.58	8689.46	8691.52	1694.0
2018-08-22 01:00:00	NQ	Futures	8691.81	8694.17	8685.92	8687.99	1698.0
2018-08-22 02:00:00	NQ	Futures	8687.69	8694.76	8679.45	8691.22	3818.0
2018-08-22 03:00:00	NQ	Futures	8691.22	8700.94	8689.46	8693.28	3571.0
2018-08-22 04:00:00	NQ	Futures	8694.17	8702.41	8690.05	8701.53	3361.0
2018-08-22 05:00:00	NQ	Futures	8701.53	8701.53	8694.17	8698.29	2164.0
2018-08-22 06:00:00	NQ	Futures	8698.0	8717.13	8697.7	8715.95	4744.0
2018-08-22 07:00:00	NQ	Futures	8715.95	8721.25	8704.18	8708.89	5568.0
2018-08-22 08:00:00	NQ	Futures	8708.59	8710.07	8689.75	8700.65	8059.0
2018-08-22 09:00:00	NQ	Futures	8700.65	8733.91	8696.52	8707.71	49855.0
2018-08-22 10:00:00	NQ	Futures	8708.01	8749.81	8692.7	8747.16	62852.0
2018-08-22 11:00:00	NQ	Futures	8747.16	8763.95	8743.63	8762.47	33428.0
2018-08-22 12:00:00	NQ	Futures	8762.47	8763.95	8741.27	8745.69	23288.0
2018-08-22 13:00:00	NQ	Futures	8745.4	8757.17	8740.98	8751.58	15147.0
2018-08-22 14:00:00	NQ	Futures	8751.58	8761.88	8738.63	8753.05	28475.0
2018-08-22 15:00:00	NQ	Futures	8753.35	8767.48	8752.17	8756.58	31334.0
2018-08-22 16:00:00	NQ	Futures	8756.58	8759.23	8750.4	8755.11	9085.0
2018-08-22 18:00:00	NQ	Futures	8754.23	8763.65	8753.93	8761.88	1439.0
2018-08-22 19:00:00	NQ	Futures	8762.47	8763.36	8757.17	8757.76	697.0
2018-08-22 20:00:00	NQ	Futures	8758.06	8758.35	8752.17	8753.05	1362.0
2018-08-22 21:00:00	NQ	Futures	8752.76	8758.06	8737.74	8739.21	3779.0
2018-08-22 22:00:00	NQ	Futures	8738.92	8747.46	8738.33	8738.63	2361.0
2018-08-22 23:00:00	NQ	Futures	8738.63	8743.63	8734.8	8741.57	1810.0
2018-08-22 00:00:00	YM	Futures	28008.0	28008.0	27986.2	27988.4	799.0
2018-08-22 01:00:00	YM	Futures	27987.3	27998.2	27973.2	27984.1	1224.0
2018-08-22 02:00:00	YM	Futures	27984.1	28006.9	27960.1	27996.0	3004.0
2018-08-22 03:00:00	YM	Futures	27997.1	28016.7	27988.4	27997.1	2640.0

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

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