PREVIEW / futures_30min / 2018-08-20

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-20.parquet
  size:    82 KB
  rows:    3,095

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-20 00:00:00	ES	Futures	3109.11	3109.66	3108.57	3109.39	526.0
2018-08-20 00:30:00	ES	Futures	3109.66	3109.66	3107.48	3107.75	2178.0
2018-08-20 01:00:00	ES	Futures	3108.02	3108.3	3106.93	3107.75	1751.0
2018-08-20 01:30:00	ES	Futures	3107.75	3108.02	3106.66	3107.75	3008.0
2018-08-20 02:00:00	ES	Futures	3108.02	3111.02	3107.75	3111.02	4495.0
2018-08-20 02:30:00	ES	Futures	3110.75	3114.02	3110.75	3112.93	5587.0
2018-08-20 03:00:00	ES	Futures	3112.93	3115.65	3112.65	3114.56	9279.0
2018-08-20 03:30:00	ES	Futures	3114.56	3116.2	3114.56	3115.92	6601.0
2018-08-20 04:00:00	ES	Futures	3116.2	3117.01	3115.11	3115.92	5812.0
2018-08-20 04:30:00	ES	Futures	3115.65	3116.2	3114.02	3114.56	4927.0
2018-08-20 05:00:00	ES	Futures	3114.56	3115.38	3113.74	3114.29	5304.0
2018-08-20 05:30:00	ES	Futures	3114.29	3115.65	3114.02	3115.11	3551.0
2018-08-20 06:00:00	ES	Futures	3115.11	3115.38	3112.93	3112.93	4024.0
2018-08-20 06:30:00	ES	Futures	3112.93	3114.56	3112.65	3113.47	2585.0
2018-08-20 07:00:00	ES	Futures	3113.74	3116.2	3113.2	3114.02	5147.0
2018-08-20 07:30:00	ES	Futures	3114.02	3114.02	3111.29	3112.11	5307.0
2018-08-20 08:00:00	ES	Futures	3112.38	3113.74	3111.84	3113.47	5684.0
2018-08-20 08:30:00	ES	Futures	3113.74	3114.02	3111.29	3111.84	7965.0
2018-08-20 09:00:00	ES	Futures	3111.84	3114.02	3111.29	3113.74	10319.0
2018-08-20 09:30:00	ES	Futures	3113.47	3115.38	3109.93	3111.02	121385.0
2018-08-20 10:00:00	ES	Futures	3111.29	3114.83	3108.84	3112.11	66467.0
2018-08-20 10:30:00	ES	Futures	3112.11	3112.65	3107.75	3109.11	70186.0
2018-08-20 11:00:00	ES	Futures	3109.11	3111.84	3108.3	3111.57	44599.0
2018-08-20 11:30:00	ES	Futures	3111.84	3115.11	3110.75	3112.93	37704.0
2018-08-20 12:00:00	ES	Futures	3112.93	3115.92	3112.11	3115.38	30359.0
2018-08-20 12:30:00	ES	Futures	3115.11	3116.2	3114.02	3115.65	23327.0
2018-08-20 13:00:00	ES	Futures	3115.65	3116.2	3114.02	3115.92	16675.0
2018-08-20 13:30:00	ES	Futures	3116.2	3116.47	3115.11	3116.47	15689.0
2018-08-20 14:00:00	ES	Futures	3116.47	3117.01	3115.38	3116.74	23460.0
2018-08-20 14:30:00	ES	Futures	3117.01	3117.29	3114.29	3115.38	31037.0
2018-08-20 15:00:00	ES	Futures	3115.65	3117.01	3114.56	3116.2	21491.0
2018-08-20 15:30:00	ES	Futures	3116.47	3117.83	3114.02	3114.83	95612.0
2018-08-20 16:00:00	ES	Futures	3114.83	3116.47	3114.02	3115.65	46060.0
2018-08-20 16:30:00	ES	Futures	3115.11	3115.38	3113.47	3114.02	6176.0
2018-08-20 18:00:00	ES	Futures	3113.47	3114.29	3112.65	3113.47	2911.0
2018-08-20 18:30:00	ES	Futures	3113.47	3114.02	3113.2	3113.74	886.0
2018-08-20 19:00:00	ES	Futures	3113.74	3114.02	3113.47	3114.02	351.0
2018-08-20 19:30:00	ES	Futures	3113.74	3114.02	3112.11	3112.65	1626.0
2018-08-20 20:00:00	ES	Futures	3112.65	3112.93	3110.2	3110.75	4490.0
2018-08-20 20:30:00	ES	Futures	3111.02	3112.93	3110.48	3112.11	4059.0
2018-08-20 21:00:00	ES	Futures	3112.11	3113.74	3111.84	3113.47	2878.0
2018-08-20 21:30:00	ES	Futures	3113.47	3114.56	3112.65	3113.47	4137.0
2018-08-20 22:00:00	ES	Futures	3113.47	3114.56	3112.65	3114.56	2567.0
2018-08-20 22:30:00	ES	Futures	3114.56	3115.38	3113.74	3115.11	2824.0
2018-08-20 23:00:00	ES	Futures	3114.83	3115.38	3114.29	3114.83	1607.0
2018-08-20 23:30:00	ES	Futures	3114.83	3115.92	3114.56	3115.38	1936.0
2018-08-20 00:00:00	NQ	Futures	8712.42	8714.48	8710.07	8713.31	297.0
2018-08-20 00:30:00	NQ	Futures	8713.89	8714.48	8708.59	8709.18	533.0
2018-08-20 01:00:00	NQ	Futures	8709.18	8710.36	8705.65	8708.59	525.0
2018-08-20 01:30:00	NQ	Futures	8708.3	8710.95	8704.47	8709.48	613.0

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

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