PREVIEW / futures_30min / 2018-08-23

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-23.parquet
  size:    81 KB
  rows:    3,103

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	3116.74	1857.0
2018-08-23 00:30:00	ES	Futures	3116.47	3116.74	3115.65	3115.92	667.0
2018-08-23 01:00:00	ES	Futures	3115.65	3116.74	3114.83	3116.47	2061.0
2018-08-23 01:30:00	ES	Futures	3116.74	3117.56	3115.92	3117.01	4004.0
2018-08-23 02:00:00	ES	Futures	3117.01	3118.92	3116.2	3117.83	3288.0
2018-08-23 02:30:00	ES	Futures	3117.83	3118.92	3117.29	3118.65	2566.0
2018-08-23 03:00:00	ES	Futures	3118.65	3119.47	3117.29	3117.56	6041.0
2018-08-23 03:30:00	ES	Futures	3117.83	3120.01	3117.29	3118.92	6532.0
2018-08-23 04:00:00	ES	Futures	3118.92	3118.92	3115.65	3118.38	11046.0
2018-08-23 04:30:00	ES	Futures	3118.65	3121.1	3118.1	3120.83	7137.0
2018-08-23 05:00:00	ES	Futures	3120.83	3121.1	3118.92	3119.19	7169.0
2018-08-23 05:30:00	ES	Futures	3119.19	3119.47	3118.1	3118.65	3872.0
2018-08-23 06:00:00	ES	Futures	3118.65	3118.92	3118.1	3118.1	2323.0
2018-08-23 06:30:00	ES	Futures	3118.1	3120.01	3117.29	3119.19	6333.0
2018-08-23 07:00:00	ES	Futures	3118.92	3119.19	3116.2	3117.01	4461.0
2018-08-23 07:30:00	ES	Futures	3117.01	3119.19	3116.74	3118.92	4583.0
2018-08-23 08:00:00	ES	Futures	3118.65	3120.01	3117.83	3118.65	4489.0
2018-08-23 08:30:00	ES	Futures	3118.65	3119.19	3117.29	3119.19	5037.0
2018-08-23 09:00:00	ES	Futures	3118.92	3119.19	3115.11	3116.74	13409.0
2018-08-23 09:30:00	ES	Futures	3116.74	3125.46	3115.92	3122.46	109902.0
2018-08-23 10:00:00	ES	Futures	3122.19	3126.82	3121.65	3126.82	77023.0
2018-08-23 10:30:00	ES	Futures	3126.55	3127.64	3121.37	3121.37	74021.0
2018-08-23 11:00:00	ES	Futures	3121.65	3122.46	3111.84	3114.56	140793.0
2018-08-23 11:30:00	ES	Futures	3114.56	3115.65	3111.29	3113.74	103876.0
2018-08-23 12:00:00	ES	Futures	3113.47	3118.1	3113.47	3117.83	53748.0
2018-08-23 12:30:00	ES	Futures	3118.1	3118.92	3115.11	3115.92	36304.0
2018-08-23 13:00:00	ES	Futures	3115.65	3116.47	3113.2	3116.2	32429.0
2018-08-23 13:30:00	ES	Futures	3116.47	3116.74	3113.74	3114.83	27507.0
2018-08-23 14:00:00	ES	Futures	3114.56	3117.56	3114.56	3117.29	24226.0
2018-08-23 14:30:00	ES	Futures	3117.01	3118.65	3115.38	3117.56	29200.0
2018-08-23 15:00:00	ES	Futures	3117.29	3118.92	3116.2	3117.56	28731.0
2018-08-23 15:30:00	ES	Futures	3117.56	3117.83	3111.57	3114.83	122419.0
2018-08-23 16:00:00	ES	Futures	3114.83	3116.47	3114.56	3114.56	36298.0
2018-08-23 16:30:00	ES	Futures	3115.11	3115.65	3114.56	3115.11	3830.0
2018-08-23 18:00:00	ES	Futures	3115.11	3115.38	3114.29	3114.83	1958.0
2018-08-23 18:30:00	ES	Futures	3114.56	3115.11	3114.29	3114.56	627.0
2018-08-23 19:00:00	ES	Futures	3114.83	3115.38	3114.29	3114.56	916.0
2018-08-23 19:30:00	ES	Futures	3114.83	3116.2	3113.47	3114.29	2393.0
2018-08-23 20:00:00	ES	Futures	3114.02	3114.56	3112.93	3114.29	3021.0
2018-08-23 20:30:00	ES	Futures	3114.29	3117.01	3113.47	3116.47	3439.0
2018-08-23 21:00:00	ES	Futures	3116.74	3118.65	3115.92	3116.74	5569.0
2018-08-23 21:30:00	ES	Futures	3116.74	3117.29	3115.11	3116.74	3901.0
2018-08-23 22:00:00	ES	Futures	3116.74	3117.56	3115.65	3117.56	2553.0
2018-08-23 22:30:00	ES	Futures	3117.29	3119.47	3115.65	3118.38	3371.0
2018-08-23 23:00:00	ES	Futures	3118.65	3118.92	3117.56	3118.65	1993.0
2018-08-23 23:30:00	ES	Futures	3118.92	3120.28	3118.1	3119.19	2216.0
2018-08-23 00:00:00	NQ	Futures	8741.86	8748.93	8740.98	8743.04	842.0
2018-08-23 00:30:00	NQ	Futures	8743.04	8743.63	8739.8	8741.27	393.0
2018-08-23 01:00:00	NQ	Futures	8742.16	8745.1	8733.91	8744.22	1108.0
2018-08-23 01:30:00	NQ	Futures	8744.22	8750.99	8741.86	8748.05	1434.0

> showing 50 of 3,103 rows — these rows as CSV

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