PREVIEW / futures_30min / 2018-07-15

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-07-15.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-07-15 18:00:00	ES	Futures	3056.8	3061.43	3056.8	3060.07	4413.0
2018-07-15 18:30:00	ES	Futures	3060.07	3060.89	3059.25	3060.34	1138.0
2018-07-15 19:00:00	ES	Futures	3060.61	3061.16	3059.52	3059.8	725.0
2018-07-15 19:30:00	ES	Futures	3059.8	3060.34	3058.98	3059.25	758.0
2018-07-15 20:00:00	ES	Futures	3059.52	3059.8	3058.98	3059.25	750.0
2018-07-15 20:30:00	ES	Futures	3059.25	3060.61	3059.25	3059.52	1781.0
2018-07-15 21:00:00	ES	Futures	3059.52	3060.34	3059.25	3059.52	1735.0
2018-07-15 21:30:00	ES	Futures	3059.25	3061.43	3057.62	3057.62	4662.0
2018-07-15 22:00:00	ES	Futures	3057.62	3058.98	3057.07	3057.62	2592.0
2018-07-15 22:30:00	ES	Futures	3057.62	3057.62	3055.71	3056.53	2447.0
2018-07-15 23:00:00	ES	Futures	3056.53	3058.71	3056.25	3058.43	1899.0
2018-07-15 23:30:00	ES	Futures	3058.43	3058.71	3057.34	3057.89	689.0
2018-07-15 18:00:00	NQ	Futures	8714.19	8730.97	8713.01	8724.49	1575.0
2018-07-15 18:30:00	NQ	Futures	8724.79	8727.73	8722.73	8726.85	561.0
2018-07-15 19:00:00	NQ	Futures	8726.55	8728.91	8723.9	8725.97	465.0
2018-07-15 19:30:00	NQ	Futures	8725.97	8726.85	8721.84	8723.61	571.0
2018-07-15 20:00:00	NQ	Futures	8723.9	8725.97	8722.43	8725.97	429.0
2018-07-15 20:30:00	NQ	Futures	8725.97	8729.5	8725.38	8725.67	872.0
2018-07-15 21:00:00	NQ	Futures	8725.67	8728.61	8724.79	8725.08	1063.0
2018-07-15 21:30:00	NQ	Futures	8725.08	8730.68	8715.66	8715.66	2627.0
2018-07-15 22:00:00	NQ	Futures	8715.66	8720.37	8713.01	8714.19	1522.0
2018-07-15 22:30:00	NQ	Futures	8713.89	8714.19	8706.83	8711.24	1132.0
2018-07-15 23:00:00	NQ	Futures	8711.24	8720.08	8710.95	8718.02	860.0
2018-07-15 23:30:00	NQ	Futures	8718.31	8718.9	8715.37	8716.54	249.0
2018-07-15 18:00:00	YM	Futures	27205.7	27262.2	27205.7	27245.9	1146.0
2018-07-15 18:30:00	YM	Futures	27244.8	27258.9	27241.5	27257.8	244.0
2018-07-15 19:00:00	YM	Futures	27256.8	27263.3	27248.1	27252.4	343.0
2018-07-15 19:30:00	YM	Futures	27252.4	27256.8	27237.2	27243.7	325.0
2018-07-15 20:00:00	YM	Futures	27245.9	27249.1	27239.4	27244.8	251.0
2018-07-15 20:30:00	YM	Futures	27244.8	27258.9	27244.8	27251.3	419.0
2018-07-15 21:00:00	YM	Futures	27251.3	27257.8	27247.0	27247.0	491.0
2018-07-15 21:30:00	YM	Futures	27248.1	27276.3	27237.2	27237.2	988.0
2018-07-15 22:00:00	YM	Futures	27236.1	27251.3	27229.6	27235.0	586.0
2018-07-15 22:30:00	YM	Futures	27233.9	27233.9	27214.4	27222.0	646.0
2018-07-15 23:00:00	YM	Futures	27222.0	27247.0	27222.0	27242.6	504.0
2018-07-15 23:30:00	YM	Futures	27242.6	27242.6	27233.9	27236.1	150.0
2018-07-15 18:00:00	CL	Futures	63.19	63.42	63.04	63.35	602.0
2018-07-15 18:30:00	CL	Futures	63.37	63.4	63.3	63.33	119.0
2018-07-15 19:00:00	CL	Futures	63.33	63.38	63.29	63.29	128.0
2018-07-15 19:30:00	CL	Futures	63.3	63.32	63.27	63.29	74.0
2018-07-15 20:00:00	CL	Futures	63.28	63.28	63.21	63.24	229.0
2018-07-15 20:30:00	CL	Futures	63.25	63.35	63.24	63.32	398.0
2018-07-15 21:00:00	CL	Futures	63.33	63.42	63.31	63.32	615.0
2018-07-15 21:30:00	CL	Futures	63.33	63.41	63.17	63.23	1077.0
2018-07-15 22:00:00	CL	Futures	63.23	63.27	63.2	63.22	481.0
2018-07-15 22:30:00	CL	Futures	63.21	63.21	63.11	63.18	515.0
2018-07-15 23:00:00	CL	Futures	63.19	63.26	63.17	63.23	362.0
2018-07-15 23:30:00	CL	Futures	63.23	63.25	63.19	63.2	177.0
2018-07-15 18:00:00	GC	Futures	1629.4	1630.5	1628.8	1630.2	605.0
2018-07-15 18:30:00	GC	Futures	1630.4	1631.0	1630.0	1630.6	659.0

> showing 50 of 548 rows — these rows as CSV

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