PREVIEW / futures_30min / 2018-07-29

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-29.parquet
  size:    20 KB
  rows:    552

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-07-29 18:00:00	ES	Futures	3069.06	3070.97	3065.52	3067.7	4408.0
2018-07-29 18:30:00	ES	Futures	3067.97	3069.06	3067.7	3068.79	591.0
2018-07-29 19:00:00	ES	Futures	3068.52	3069.88	3067.97	3069.88	1022.0
2018-07-29 19:30:00	ES	Futures	3069.88	3069.88	3067.15	3068.24	3228.0
2018-07-29 20:00:00	ES	Futures	3067.97	3069.06	3062.25	3064.16	6625.0
2018-07-29 20:30:00	ES	Futures	3064.16	3065.52	3062.79	3064.7	3148.0
2018-07-29 21:00:00	ES	Futures	3064.7	3065.79	3063.61	3065.52	2824.0
2018-07-29 21:30:00	ES	Futures	3065.25	3066.88	3064.43	3065.79	4135.0
2018-07-29 22:00:00	ES	Futures	3066.06	3066.06	3064.43	3064.7	2247.0
2018-07-29 22:30:00	ES	Futures	3064.7	3064.7	3058.71	3060.07	5760.0
2018-07-29 23:00:00	ES	Futures	3060.34	3062.52	3059.52	3062.25	2434.0
2018-07-29 23:30:00	ES	Futures	3062.25	3063.07	3061.16	3062.25	1884.0
2018-07-29 18:00:00	NQ	Futures	8588.77	8596.72	8584.64	8589.65	1362.0
2018-07-29 18:30:00	NQ	Futures	8589.65	8590.83	8587.59	8589.36	346.0
2018-07-29 19:00:00	NQ	Futures	8588.77	8595.54	8587.29	8593.77	514.0
2018-07-29 19:30:00	NQ	Futures	8593.77	8593.77	8585.23	8587.0	1009.0
2018-07-29 20:00:00	NQ	Futures	8586.71	8589.36	8568.16	8572.87	2471.0
2018-07-29 20:30:00	NQ	Futures	8573.46	8576.4	8565.8	8569.92	1833.0
2018-07-29 21:00:00	NQ	Futures	8569.33	8573.75	8566.98	8571.98	1316.0
2018-07-29 21:30:00	NQ	Futures	8572.28	8580.52	8568.16	8576.11	1996.0
2018-07-29 22:00:00	NQ	Futures	8576.4	8578.17	8570.51	8572.28	858.0
2018-07-29 22:30:00	NQ	Futures	8572.28	8572.57	8549.9	8554.32	2548.0
2018-07-29 23:00:00	NQ	Futures	8554.02	8562.56	8551.38	8561.97	1601.0
2018-07-29 23:30:00	NQ	Futures	8562.27	8563.15	8559.03	8560.5	808.0
2018-07-29 18:00:00	YM	Futures	27637.3	27648.1	27611.2	27626.4	596.0
2018-07-29 18:30:00	YM	Futures	27626.4	27636.2	27624.2	27632.9	94.0
2018-07-29 19:00:00	YM	Futures	27631.8	27639.4	27624.2	27635.1	152.0
2018-07-29 19:30:00	YM	Futures	27635.1	27636.2	27606.8	27619.9	505.0
2018-07-29 20:00:00	YM	Futures	27616.6	27627.5	27562.2	27581.8	1252.0
2018-07-29 20:30:00	YM	Futures	27581.8	27592.7	27568.8	27584.0	762.0
2018-07-29 21:00:00	YM	Futures	27582.9	27605.7	27576.4	27600.3	716.0
2018-07-29 21:30:00	YM	Futures	27600.3	27622.0	27592.7	27612.3	976.0
2018-07-29 22:00:00	YM	Futures	27612.3	27618.8	27595.9	27599.2	474.0
2018-07-29 22:30:00	YM	Futures	27600.3	27600.3	27552.5	27563.3	1149.0
2018-07-29 23:00:00	YM	Futures	27562.2	27585.1	27559.0	27581.8	538.0
2018-07-29 23:30:00	YM	Futures	27581.8	27587.2	27574.2	27581.8	370.0
2018-07-29 18:00:00	CL	Futures	62.72	62.76	62.65	62.72	1343.0
2018-07-29 18:30:00	CL	Futures	62.72	62.73	62.63	62.68	845.0
2018-07-29 19:00:00	CL	Futures	62.68	62.7	62.66	62.68	413.0
2018-07-29 19:30:00	CL	Futures	62.69	62.7	62.65	62.67	525.0
2018-07-29 20:00:00	CL	Futures	62.66	62.71	62.59	62.61	1927.0
2018-07-29 20:30:00	CL	Futures	62.62	62.66	62.59	62.62	1662.0
2018-07-29 21:00:00	CL	Futures	62.62	62.65	62.56	62.63	2669.0
2018-07-29 21:30:00	CL	Futures	62.62	62.68	62.6	62.67	2418.0
2018-07-29 22:00:00	CL	Futures	62.67	62.67	62.59	62.6	1250.0
2018-07-29 22:30:00	CL	Futures	62.59	62.62	62.53	62.57	2097.0
2018-07-29 23:00:00	CL	Futures	62.56	62.62	62.53	62.61	8504.0
2018-07-29 23:30:00	CL	Futures	62.61	62.62	62.56	62.61	954.0
2018-07-29 18:00:00	GC	Futures	1603.9	1606.4	1603.8	1605.6	938.0
2018-07-29 18:30:00	GC	Futures	1605.6	1606.4	1605.5	1605.5	263.0

> showing 50 of 552 rows — these rows as CSV

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