PREVIEW / futures_30min / 2018-04-13

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-04-13.parquet
  size:    71 KB
  rows:    2,567

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-04-13 00:00:00	ES	Futures	2899.65	2900.19	2899.1	2899.92	790.0
2018-04-13 00:30:00	ES	Futures	2899.92	2901.83	2899.65	2901.01	895.0
2018-04-13 01:00:00	ES	Futures	2901.29	2903.74	2900.74	2902.92	2194.0
2018-04-13 01:30:00	ES	Futures	2902.65	2904.83	2902.65	2904.56	2242.0
2018-04-13 02:00:00	ES	Futures	2904.56	2908.38	2904.56	2908.11	5000.0
2018-04-13 02:30:00	ES	Futures	2908.11	2912.47	2906.74	2911.93	6198.0
2018-04-13 03:00:00	ES	Futures	2912.2	2912.2	2906.74	2907.29	5551.0
2018-04-13 03:30:00	ES	Futures	2907.02	2910.84	2905.92	2910.84	5891.0
2018-04-13 04:00:00	ES	Futures	2910.56	2910.84	2908.65	2909.75	3904.0
2018-04-13 04:30:00	ES	Futures	2909.47	2911.11	2908.38	2910.84	3399.0
2018-04-13 05:00:00	ES	Futures	2910.84	2911.11	2910.02	2910.56	2978.0
2018-04-13 05:30:00	ES	Futures	2910.56	2914.66	2909.75	2914.11	4540.0
2018-04-13 06:00:00	ES	Futures	2914.11	2915.75	2912.75	2913.02	6520.0
2018-04-13 06:30:00	ES	Futures	2913.29	2917.66	2911.38	2916.57	8193.0
2018-04-13 07:00:00	ES	Futures	2916.84	2918.21	2913.84	2914.66	8423.0
2018-04-13 07:30:00	ES	Futures	2914.66	2918.21	2913.57	2916.84	10011.0
2018-04-13 08:00:00	ES	Futures	2917.11	2922.3	2915.75	2922.3	21745.0
2018-04-13 08:30:00	ES	Futures	2922.3	2925.57	2922.03	2923.94	20732.0
2018-04-13 09:00:00	ES	Futures	2924.21	2925.57	2923.12	2924.21	18855.0
2018-04-13 09:30:00	ES	Futures	2924.21	2926.12	2914.66	2915.2	141965.0
2018-04-13 10:00:00	ES	Futures	2915.2	2917.39	2899.92	2902.38	175497.0
2018-04-13 10:30:00	ES	Futures	2902.38	2907.02	2898.28	2898.56	133315.0
2018-04-13 11:00:00	ES	Futures	2898.56	2907.02	2893.92	2905.65	117036.0
2018-04-13 11:30:00	ES	Futures	2905.65	2907.84	2900.74	2907.02	78610.0
2018-04-13 12:00:00	ES	Futures	2907.02	2910.02	2901.56	2908.65	70034.0
2018-04-13 12:30:00	ES	Futures	2908.65	2908.93	2901.01	2904.83	60438.0
2018-04-13 13:00:00	ES	Futures	2904.56	2912.47	2904.56	2911.93	49494.0
2018-04-13 13:30:00	ES	Futures	2911.93	2912.47	2908.11	2909.47	55659.0
2018-04-13 14:00:00	ES	Futures	2909.47	2911.11	2904.83	2906.74	61647.0
2018-04-13 14:30:00	ES	Futures	2906.47	2910.29	2900.74	2901.83	83313.0
2018-04-13 15:00:00	ES	Futures	2901.56	2901.83	2887.09	2890.91	159792.0
2018-04-13 15:30:00	ES	Futures	2890.91	2902.65	2888.46	2899.65	205240.0
2018-04-13 16:00:00	ES	Futures	2899.65	2902.1	2898.28	2900.74	57864.0
2018-04-13 16:30:00	ES	Futures	2899.38	2902.92	2898.56	2902.92	8253.0
2018-04-13 00:00:00	NQ	Futures	7861.45	7862.93	7858.79	7859.68	501.0
2018-04-13 00:30:00	NQ	Futures	7859.38	7866.47	7859.38	7865.88	759.0
2018-04-13 01:00:00	NQ	Futures	7866.18	7871.79	7863.81	7867.66	901.0
2018-04-13 01:30:00	NQ	Futures	7867.36	7872.98	7867.36	7870.91	996.0
2018-04-13 02:00:00	NQ	Futures	7870.61	7878.89	7870.32	7877.7	1955.0
2018-04-13 02:30:00	NQ	Futures	7877.41	7886.57	7875.04	7880.66	3447.0
2018-04-13 03:00:00	NQ	Futures	7880.96	7881.25	7863.22	7866.77	2755.0
2018-04-13 03:30:00	NQ	Futures	7866.47	7875.34	7860.27	7874.45	2286.0
2018-04-13 04:00:00	NQ	Futures	7874.16	7874.45	7867.95	7872.68	1139.0
2018-04-13 04:30:00	NQ	Futures	7872.68	7876.82	7868.25	7876.52	1153.0
2018-04-13 05:00:00	NQ	Futures	7875.93	7877.41	7873.27	7875.34	971.0
2018-04-13 05:30:00	NQ	Futures	7875.34	7885.98	7873.57	7885.39	1313.0
2018-04-13 06:00:00	NQ	Futures	7885.39	7889.23	7881.25	7883.02	1339.0
2018-04-13 06:30:00	NQ	Futures	7883.02	7899.87	7878.89	7896.62	2428.0
2018-04-13 07:00:00	NQ	Futures	7896.91	7897.8	7887.16	7892.19	2308.0
2018-04-13 07:30:00	NQ	Futures	7892.19	7899.87	7887.46	7898.39	3320.0

> showing 50 of 2,567 rows — these rows as CSV

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