PREVIEW / futures_30min / 2018-10-07

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-10-07.parquet
  size:    22 KB
  rows:    569

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-10-07 18:00:00	ES	Futures	3152.46	3153.28	3146.75	3147.56	9623.0
2018-10-07 18:30:00	ES	Futures	3147.84	3149.74	3146.75	3149.2	2176.0
2018-10-07 19:00:00	ES	Futures	3149.2	3150.56	3148.11	3148.38	3380.0
2018-10-07 19:30:00	ES	Futures	3148.65	3149.2	3142.4	3145.66	9504.0
2018-10-07 20:00:00	ES	Futures	3145.93	3150.56	3144.84	3149.2	8030.0
2018-10-07 20:30:00	ES	Futures	3149.2	3150.01	3147.56	3149.2	4971.0
2018-10-07 21:00:00	ES	Futures	3149.2	3152.73	3148.65	3151.37	5902.0
2018-10-07 21:30:00	ES	Futures	3151.37	3151.37	3148.38	3148.38	6276.0
2018-10-07 22:00:00	ES	Futures	3148.38	3150.01	3147.56	3147.84	3527.0
2018-10-07 22:30:00	ES	Futures	3147.84	3147.84	3146.2	3147.02	4407.0
2018-10-07 23:00:00	ES	Futures	3147.02	3150.83	3146.48	3149.2	3036.0
2018-10-07 23:30:00	ES	Futures	3149.2	3149.2	3147.56	3148.65	1726.0
2018-10-07 18:00:00	NQ	Futures	8732.84	8744.57	8712.31	8715.83	3602.0
2018-10-07 18:30:00	NQ	Futures	8715.83	8727.86	8714.36	8725.51	900.0
2018-10-07 19:00:00	NQ	Futures	8725.51	8729.62	8719.64	8721.4	794.0
2018-10-07 19:30:00	NQ	Futures	8721.4	8722.58	8697.06	8709.38	2446.0
2018-10-07 20:00:00	NQ	Futures	8709.08	8726.98	8704.98	8722.28	2557.0
2018-10-07 20:30:00	NQ	Futures	8723.16	8726.39	8715.24	8721.4	1782.0
2018-10-07 21:00:00	NQ	Futures	8721.99	8735.78	8719.64	8729.91	2535.0
2018-10-07 21:30:00	NQ	Futures	8730.5	8730.79	8719.06	8719.06	2770.0
2018-10-07 22:00:00	NQ	Futures	8718.76	8724.34	8712.9	8715.54	2431.0
2018-10-07 22:30:00	NQ	Futures	8715.54	8717.88	8708.5	8712.31	3577.0
2018-10-07 23:00:00	NQ	Futures	8712.31	8731.08	8709.67	8722.28	2836.0
2018-10-07 23:30:00	NQ	Futures	8721.99	8723.75	8713.78	8717.88	1584.0
2018-10-07 18:00:00	YM	Futures	28814.3	28838.2	28758.9	28774.1	1470.0
2018-10-07 18:30:00	YM	Futures	28774.1	28794.8	28767.6	28788.2	496.0
2018-10-07 19:00:00	YM	Futures	28788.2	28804.5	28786.1	28789.3	470.0
2018-10-07 19:30:00	YM	Futures	28790.4	28794.8	28728.5	28760.0	1769.0
2018-10-07 20:00:00	YM	Futures	28758.9	28811.0	28751.3	28796.9	1492.0
2018-10-07 20:30:00	YM	Futures	28798.0	28806.7	28781.7	28791.5	730.0
2018-10-07 21:00:00	YM	Futures	28792.6	28835.0	28787.1	28812.1	1677.0
2018-10-07 21:30:00	YM	Futures	28812.1	28814.3	28781.7	28783.9	1309.0
2018-10-07 22:00:00	YM	Futures	28782.8	28794.8	28768.7	28774.1	927.0
2018-10-07 22:30:00	YM	Futures	28774.1	28774.1	28755.6	28765.4	1031.0
2018-10-07 23:00:00	YM	Futures	28763.2	28803.4	28756.7	28789.3	894.0
2018-10-07 23:30:00	YM	Futures	28788.2	28789.3	28774.1	28781.7	545.0
2018-10-07 18:00:00	CL	Futures	68.54	68.7	68.17	68.22	4366.0
2018-10-07 18:30:00	CL	Futures	68.21	68.22	67.73	68.08	5118.0
2018-10-07 19:00:00	CL	Futures	68.08	68.26	67.96	68.14	2283.0
2018-10-07 19:30:00	CL	Futures	68.14	68.16	67.99	68.05	1882.0
2018-10-07 20:00:00	CL	Futures	68.04	68.17	67.98	68.1	3000.0
2018-10-07 20:30:00	CL	Futures	68.11	68.14	67.95	67.97	2519.0
2018-10-07 21:00:00	CL	Futures	67.97	68.17	67.87	68.07	5395.0
2018-10-07 21:30:00	CL	Futures	68.07	68.07	67.92	67.95	2440.0
2018-10-07 22:00:00	CL	Futures	67.95	67.97	67.89	67.93	1566.0
2018-10-07 22:30:00	CL	Futures	67.92	67.95	67.86	67.93	2055.0
2018-10-07 23:00:00	CL	Futures	67.93	67.96	67.89	67.93	1686.0
2018-10-07 23:30:00	CL	Futures	67.93	68.0	67.92	67.98	987.0
2018-10-07 18:00:00	GC	Futures	1572.2	1573.7	1571.8	1572.9	949.0
2018-10-07 18:30:00	GC	Futures	1572.8	1573.8	1572.7	1572.7	411.0

> showing 50 of 569 rows — these rows as CSV

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