PREVIEW / futures_1hour / 2018-08-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	3115.38	3115.65	3114.56	3115.65	1853.0
2018-08-21 01:00:00	ES	Futures	3115.65	3116.2	3114.83	3115.65	4022.0
2018-08-21 02:00:00	ES	Futures	3115.65	3116.47	3114.83	3115.65	4672.0
2018-08-21 03:00:00	ES	Futures	3115.65	3117.01	3115.11	3116.74	12216.0
2018-08-21 04:00:00	ES	Futures	3117.01	3118.65	3116.2	3118.38	11660.0
2018-08-21 05:00:00	ES	Futures	3118.65	3122.19	3118.38	3121.37	12421.0
2018-08-21 06:00:00	ES	Futures	3121.65	3121.65	3120.01	3120.83	7586.0
2018-08-21 07:00:00	ES	Futures	3121.1	3121.65	3119.74	3121.37	8294.0
2018-08-21 08:00:00	ES	Futures	3121.65	3121.65	3118.92	3119.19	10907.0
2018-08-21 09:00:00	ES	Futures	3119.47	3127.64	3118.1	3127.1	135024.0
2018-08-21 10:00:00	ES	Futures	3127.1	3127.64	3124.1	3125.19	111900.0
2018-08-21 11:00:00	ES	Futures	3124.92	3129.0	3121.1	3128.73	118578.0
2018-08-21 12:00:00	ES	Futures	3128.73	3132.27	3128.46	3131.46	79711.0
2018-08-21 13:00:00	ES	Futures	3131.46	3132.0	3128.73	3130.37	74053.0
2018-08-21 14:00:00	ES	Futures	3130.09	3130.37	3123.28	3125.46	100654.0
2018-08-21 15:00:00	ES	Futures	3125.46	3127.1	3119.19	3120.83	217887.0
2018-08-21 16:00:00	ES	Futures	3120.56	3121.1	3108.3	3111.57	85288.0
2018-08-21 18:00:00	ES	Futures	3109.39	3111.57	3105.3	3106.12	21937.0
2018-08-21 19:00:00	ES	Futures	3105.84	3106.39	3102.57	3103.12	19778.0
2018-08-21 20:00:00	ES	Futures	3103.12	3105.84	3102.03	3105.3	17114.0
2018-08-21 21:00:00	ES	Futures	3105.57	3107.75	3105.03	3106.39	12461.0
2018-08-21 22:00:00	ES	Futures	3106.39	3112.65	3106.12	3111.29	12104.0
2018-08-21 23:00:00	ES	Futures	3111.29	3114.29	3110.75	3113.2	6301.0
2018-08-21 00:00:00	NQ	Futures	8702.41	8703.88	8698.0	8699.76	699.0
2018-08-21 01:00:00	NQ	Futures	8700.35	8705.65	8698.0	8701.82	1009.0
2018-08-21 02:00:00	NQ	Futures	8702.12	8705.36	8697.7	8699.76	1231.0
2018-08-21 03:00:00	NQ	Futures	8700.06	8711.54	8698.58	8708.01	3165.0
2018-08-21 04:00:00	NQ	Futures	8708.3	8713.31	8705.36	8712.42	2776.0
2018-08-21 05:00:00	NQ	Futures	8712.72	8724.49	8712.42	8722.14	3428.0
2018-08-21 06:00:00	NQ	Futures	8722.14	8726.85	8718.6	8723.02	3126.0
2018-08-21 07:00:00	NQ	Futures	8723.32	8723.61	8715.66	8722.43	2916.0
2018-08-21 08:00:00	NQ	Futures	8722.43	8722.43	8713.01	8715.95	4016.0
2018-08-21 09:00:00	NQ	Futures	8715.95	8748.93	8712.72	8745.69	49989.0
2018-08-21 10:00:00	NQ	Futures	8745.4	8751.58	8735.09	8743.04	49936.0
2018-08-21 11:00:00	NQ	Futures	8743.34	8759.82	8725.08	8758.06	41309.0
2018-08-21 12:00:00	NQ	Futures	8758.06	8776.31	8757.47	8771.6	27438.0
2018-08-21 13:00:00	NQ	Futures	8771.6	8773.37	8757.47	8758.06	23846.0
2018-08-21 14:00:00	NQ	Futures	8757.76	8758.94	8721.25	8729.2	30913.0
2018-08-21 15:00:00	NQ	Futures	8729.5	8736.27	8713.31	8723.02	45414.0
2018-08-21 16:00:00	NQ	Futures	8723.02	8724.2	8679.45	8687.69	15586.0
2018-08-21 18:00:00	NQ	Futures	8684.45	8691.22	8669.44	8671.2	3754.0
2018-08-21 19:00:00	NQ	Futures	8671.2	8673.56	8658.25	8667.96	4994.0
2018-08-21 20:00:00	NQ	Futures	8667.67	8675.03	8661.78	8674.15	3250.0
2018-08-21 21:00:00	NQ	Futures	8673.85	8678.86	8670.32	8673.85	2795.0
2018-08-21 22:00:00	NQ	Futures	8674.15	8691.22	8673.26	8687.1	2854.0
2018-08-21 23:00:00	NQ	Futures	8687.1	8701.82	8684.75	8698.0	3115.0
2018-08-21 00:00:00	YM	Futures	28023.2	28027.5	28014.5	28025.4	506.0
2018-08-21 01:00:00	YM	Futures	28024.3	28027.5	28014.5	28016.7	837.0
2018-08-21 02:00:00	YM	Futures	28017.8	28024.3	28010.1	28015.6	799.0
2018-08-21 03:00:00	YM	Futures	28015.6	28036.2	28010.1	28024.3	1827.0

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

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