PREVIEW / futures_30min / 2018-08-05

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-08-05.parquet
  size:    20 KB
  rows:    548

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-05 18:00:00	ES	Futures	3096.85	3098.49	3095.49	3096.85	3685.0
2018-08-05 18:30:00	ES	Futures	3096.85	3097.12	3095.76	3096.31	801.0
2018-08-05 19:00:00	ES	Futures	3096.31	3097.12	3095.76	3097.12	944.0
2018-08-05 19:30:00	ES	Futures	3096.85	3096.85	3094.94	3095.22	1465.0
2018-08-05 20:00:00	ES	Futures	3095.22	3097.67	3094.94	3096.85	2727.0
2018-08-05 20:30:00	ES	Futures	3096.58	3096.85	3095.49	3096.31	1256.0
2018-08-05 21:00:00	ES	Futures	3096.31	3097.94	3096.03	3096.85	2627.0
2018-08-05 21:30:00	ES	Futures	3096.85	3099.58	3095.76	3099.58	5331.0
2018-08-05 22:00:00	ES	Futures	3099.58	3100.39	3099.03	3100.12	2876.0
2018-08-05 22:30:00	ES	Futures	3100.12	3100.67	3099.03	3099.3	2376.0
2018-08-05 23:00:00	ES	Futures	3099.3	3099.85	3098.49	3098.76	1544.0
2018-08-05 23:30:00	ES	Futures	3099.03	3099.3	3097.94	3098.76	1982.0
2018-08-05 18:00:00	NQ	Futures	8719.78	8733.33	8718.02	8727.14	1429.0
2018-08-05 18:30:00	NQ	Futures	8726.85	8726.85	8718.6	8720.08	450.0
2018-08-05 19:00:00	NQ	Futures	8720.37	8726.55	8720.37	8724.79	362.0
2018-08-05 19:30:00	NQ	Futures	8724.79	8724.79	8718.9	8720.08	316.0
2018-08-05 20:00:00	NQ	Futures	8720.08	8730.09	8719.49	8725.97	848.0
2018-08-05 20:30:00	NQ	Futures	8725.97	8726.26	8721.84	8723.9	467.0
2018-08-05 21:00:00	NQ	Futures	8723.61	8729.79	8723.02	8725.97	757.0
2018-08-05 21:30:00	NQ	Futures	8725.67	8742.45	8722.43	8738.04	1960.0
2018-08-05 22:00:00	NQ	Futures	8738.33	8742.16	8734.8	8740.69	1080.0
2018-08-05 22:30:00	NQ	Futures	8740.1	8743.34	8735.39	8736.86	855.0
2018-08-05 23:00:00	NQ	Futures	8736.56	8738.33	8731.85	8733.03	481.0
2018-08-05 23:30:00	NQ	Futures	8733.03	8733.91	8730.09	8732.44	535.0
2018-08-05 18:00:00	YM	Futures	27639.4	27665.5	27631.8	27639.4	587.0
2018-08-05 18:30:00	YM	Futures	27640.5	27644.9	27632.9	27640.5	240.0
2018-08-05 19:00:00	YM	Futures	27640.5	27651.4	27640.5	27649.2	276.0
2018-08-05 19:30:00	YM	Futures	27649.2	27649.2	27635.1	27638.3	294.0
2018-08-05 20:00:00	YM	Futures	27636.2	27661.2	27635.1	27653.6	563.0
2018-08-05 20:30:00	YM	Futures	27653.6	27654.6	27642.7	27649.2	279.0
2018-08-05 21:00:00	YM	Futures	27648.1	27663.3	27648.1	27656.8	437.0
2018-08-05 21:30:00	YM	Futures	27654.6	27688.4	27644.9	27686.2	943.0
2018-08-05 22:00:00	YM	Futures	27687.3	27700.3	27684.0	27699.2	829.0
2018-08-05 22:30:00	YM	Futures	27698.1	27703.6	27688.4	27692.7	498.0
2018-08-05 23:00:00	YM	Futures	27691.6	27698.1	27680.7	27682.9	363.0
2018-08-05 23:30:00	YM	Futures	27682.9	27685.1	27673.1	27681.8	494.0
2018-08-05 18:00:00	CL	Futures	62.4	62.41	62.31	62.32	1262.0
2018-08-05 18:30:00	CL	Futures	62.32	62.33	62.26	62.31	812.0
2018-08-05 19:00:00	CL	Futures	62.31	62.39	62.31	62.37	704.0
2018-08-05 19:30:00	CL	Futures	62.37	62.38	62.31	62.31	446.0
2018-08-05 20:00:00	CL	Futures	62.32	62.38	62.31	62.32	1069.0
2018-08-05 20:30:00	CL	Futures	62.33	62.39	62.29	62.36	1733.0
2018-08-05 21:00:00	CL	Futures	62.36	62.45	62.34	62.38	2165.0
2018-08-05 21:30:00	CL	Futures	62.38	62.62	62.36	62.58	4221.0
2018-08-05 22:00:00	CL	Futures	62.58	62.61	62.53	62.56	2727.0
2018-08-05 22:30:00	CL	Futures	62.56	62.57	62.49	62.51	1308.0
2018-08-05 23:00:00	CL	Futures	62.51	62.55	62.49	62.51	1076.0
2018-08-05 23:30:00	CL	Futures	62.51	62.51	62.47	62.5	667.0
2018-08-05 18:00:00	GC	Futures	1592.1	1592.9	1591.6	1592.0	1152.0
2018-08-05 18:30:00	GC	Futures	1592.0	1592.7	1591.8	1592.1	361.0

> showing 50 of 548 rows — these rows as CSV

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