PREVIEW / futures_1hour / 2018-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-08-23.parquet
  size:    53 KB
  rows:    1,660

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-23 00:00:00	ES	Futures	3115.92	3117.56	3115.65	3115.92	2524.0
2018-08-23 01:00:00	ES	Futures	3115.65	3117.56	3114.83	3117.01	6065.0
2018-08-23 02:00:00	ES	Futures	3117.01	3118.92	3116.2	3118.65	5854.0
2018-08-23 03:00:00	ES	Futures	3118.65	3120.01	3117.29	3118.92	12573.0
2018-08-23 04:00:00	ES	Futures	3118.92	3121.1	3115.65	3120.83	18183.0
2018-08-23 05:00:00	ES	Futures	3120.83	3121.1	3118.1	3118.65	11041.0
2018-08-23 06:00:00	ES	Futures	3118.65	3120.01	3117.29	3119.19	8656.0
2018-08-23 07:00:00	ES	Futures	3118.92	3119.19	3116.2	3118.92	9044.0
2018-08-23 08:00:00	ES	Futures	3118.65	3120.01	3117.29	3119.19	9526.0
2018-08-23 09:00:00	ES	Futures	3118.92	3125.46	3115.11	3122.46	123311.0
2018-08-23 10:00:00	ES	Futures	3122.19	3127.64	3121.37	3121.37	151044.0
2018-08-23 11:00:00	ES	Futures	3121.65	3122.46	3111.29	3113.74	244669.0
2018-08-23 12:00:00	ES	Futures	3113.47	3118.92	3113.47	3115.92	90052.0
2018-08-23 13:00:00	ES	Futures	3115.65	3116.74	3113.2	3114.83	59936.0
2018-08-23 14:00:00	ES	Futures	3114.56	3118.65	3114.56	3117.56	53426.0
2018-08-23 15:00:00	ES	Futures	3117.29	3118.92	3111.57	3114.83	151150.0
2018-08-23 16:00:00	ES	Futures	3114.83	3116.47	3114.56	3115.11	40128.0
2018-08-23 18:00:00	ES	Futures	3115.11	3115.38	3114.29	3114.56	2585.0
2018-08-23 19:00:00	ES	Futures	3114.83	3116.2	3113.47	3114.29	3309.0
2018-08-23 20:00:00	ES	Futures	3114.02	3117.01	3112.93	3116.47	6460.0
2018-08-23 21:00:00	ES	Futures	3116.74	3118.65	3115.11	3116.74	9470.0
2018-08-23 22:00:00	ES	Futures	3116.74	3119.47	3115.65	3118.38	5924.0
2018-08-23 23:00:00	ES	Futures	3118.65	3120.28	3117.56	3119.19	4209.0
2018-08-23 00:00:00	NQ	Futures	8741.86	8748.93	8739.8	8741.27	1235.0
2018-08-23 01:00:00	NQ	Futures	8742.16	8750.99	8733.91	8748.05	2542.0
2018-08-23 02:00:00	NQ	Futures	8748.34	8754.82	8745.69	8752.76	1784.0
2018-08-23 03:00:00	NQ	Futures	8752.76	8758.06	8746.87	8754.52	2867.0
2018-08-23 04:00:00	NQ	Futures	8754.52	8759.82	8740.98	8758.06	3736.0
2018-08-23 05:00:00	NQ	Futures	8758.06	8758.65	8748.34	8752.46	2331.0
2018-08-23 06:00:00	NQ	Futures	8751.58	8755.41	8744.81	8750.4	3169.0
2018-08-23 07:00:00	NQ	Futures	8750.4	8752.17	8741.57	8747.46	2870.0
2018-08-23 08:00:00	NQ	Futures	8747.16	8751.58	8743.04	8748.64	3100.0
2018-08-23 09:00:00	NQ	Futures	8748.64	8796.04	8735.98	8790.44	56915.0
2018-08-23 10:00:00	NQ	Futures	8790.44	8803.1	8778.67	8779.55	56992.0
2018-08-23 11:00:00	NQ	Futures	8779.55	8783.67	8728.03	8743.04	81371.0
2018-08-23 12:00:00	NQ	Futures	8743.04	8768.66	8742.16	8758.06	36750.0
2018-08-23 13:00:00	NQ	Futures	8758.06	8765.42	8750.4	8760.12	22008.0
2018-08-23 14:00:00	NQ	Futures	8760.12	8773.07	8759.53	8765.71	19704.0
2018-08-23 15:00:00	NQ	Futures	8766.3	8768.95	8735.39	8741.57	37263.0
2018-08-23 16:00:00	NQ	Futures	8741.57	8748.93	8740.98	8744.81	6927.0
2018-08-23 18:00:00	NQ	Futures	8746.57	8747.75	8741.57	8747.16	1155.0
2018-08-23 19:00:00	NQ	Futures	8746.87	8753.35	8745.4	8747.46	1322.0
2018-08-23 20:00:00	NQ	Futures	8747.16	8757.76	8743.63	8755.41	1967.0
2018-08-23 21:00:00	NQ	Futures	8756.0	8761.88	8746.87	8753.05	3036.0
2018-08-23 22:00:00	NQ	Futures	8752.17	8764.83	8748.93	8761.59	2353.0
2018-08-23 23:00:00	NQ	Futures	8761.59	8767.48	8757.47	8763.95	1630.0
2018-08-23 00:00:00	YM	Futures	27939.5	27961.2	27936.2	27939.5	1078.0
2018-08-23 01:00:00	YM	Futures	27939.5	27960.1	27928.6	27944.9	1810.0
2018-08-23 02:00:00	YM	Futures	27946.0	27972.1	27939.5	27961.2	2028.0
2018-08-23 03:00:00	YM	Futures	27961.2	27972.1	27949.3	27961.2	1879.0

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

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