PREVIEW / futures_30min / 2018-09-25

all futures 30-min files

  file:    by_date/futures_30min/2018/2018-09-25.parquet
  size:    79 KB
  rows:    3,119

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-09-25 00:00:00	ES	Futures	3182.38	3182.65	3181.84	3182.38	547.0
2018-09-25 00:30:00	ES	Futures	3182.38	3182.65	3182.11	3182.65	437.0
2018-09-25 01:00:00	ES	Futures	3182.38	3182.92	3182.11	3182.92	1117.0
2018-09-25 01:30:00	ES	Futures	3182.92	3182.92	3181.56	3182.92	1861.0
2018-09-25 02:00:00	ES	Futures	3182.65	3184.28	3181.84	3183.2	3208.0
2018-09-25 02:30:00	ES	Futures	3183.2	3183.74	3182.92	3183.47	1946.0
2018-09-25 03:00:00	ES	Futures	3183.2	3185.1	3181.56	3184.83	8984.0
2018-09-25 03:30:00	ES	Futures	3184.83	3185.92	3183.2	3183.47	5727.0
2018-09-25 04:00:00	ES	Futures	3183.74	3185.37	3183.47	3185.1	4471.0
2018-09-25 04:30:00	ES	Futures	3185.37	3186.46	3184.28	3184.83	3892.0
2018-09-25 05:00:00	ES	Futures	3184.83	3187.55	3184.83	3187.0	6087.0
2018-09-25 05:30:00	ES	Futures	3186.73	3187.82	3185.92	3187.0	4078.0
2018-09-25 06:00:00	ES	Futures	3187.0	3188.64	3186.73	3188.09	8219.0
2018-09-25 06:30:00	ES	Futures	3188.09	3191.63	3187.82	3190.81	11816.0
2018-09-25 07:00:00	ES	Futures	3190.81	3192.44	3190.27	3190.81	10865.0
2018-09-25 07:30:00	ES	Futures	3190.81	3190.81	3189.72	3190.27	4490.0
2018-09-25 08:00:00	ES	Futures	3190.27	3191.63	3188.36	3189.72	8403.0
2018-09-25 08:30:00	ES	Futures	3189.72	3189.72	3186.73	3188.09	11582.0
2018-09-25 09:00:00	ES	Futures	3187.82	3188.36	3186.19	3186.73	14061.0
2018-09-25 09:30:00	ES	Futures	3186.73	3188.09	3182.92	3183.2	120526.0
2018-09-25 10:00:00	ES	Futures	3183.2	3185.1	3181.02	3182.92	73577.0
2018-09-25 10:30:00	ES	Futures	3182.92	3184.28	3178.57	3179.12	63521.0
2018-09-25 11:00:00	ES	Futures	3178.84	3185.1	3177.21	3185.1	68897.0
2018-09-25 11:30:00	ES	Futures	3184.83	3185.92	3184.01	3184.28	32912.0
2018-09-25 12:00:00	ES	Futures	3184.56	3185.92	3184.28	3184.56	20650.0
2018-09-25 12:30:00	ES	Futures	3184.83	3184.83	3181.56	3182.38	26098.0
2018-09-25 13:00:00	ES	Futures	3182.38	3182.38	3179.66	3180.2	62626.0
2018-09-25 13:30:00	ES	Futures	3180.48	3180.48	3175.04	3178.57	81899.0
2018-09-25 14:00:00	ES	Futures	3178.3	3180.2	3177.48	3179.93	36389.0
2018-09-25 14:30:00	ES	Futures	3179.93	3179.93	3176.4	3178.57	55850.0
2018-09-25 15:00:00	ES	Futures	3178.57	3179.66	3177.21	3179.66	53932.0
2018-09-25 15:30:00	ES	Futures	3179.66	3180.75	3175.31	3177.76	135248.0
2018-09-25 16:00:00	ES	Futures	3177.48	3178.57	3177.21	3178.3	42580.0
2018-09-25 16:30:00	ES	Futures	3178.57	3179.93	3178.03	3179.39	6147.0
2018-09-25 18:00:00	ES	Futures	3179.66	3180.48	3179.12	3179.93	2246.0
2018-09-25 18:30:00	ES	Futures	3179.93	3180.48	3179.66	3179.66	618.0
2018-09-25 19:00:00	ES	Futures	3179.93	3181.29	3179.66	3181.02	1294.0
2018-09-25 19:30:00	ES	Futures	3181.29	3181.29	3180.48	3180.75	850.0
2018-09-25 20:00:00	ES	Futures	3180.48	3181.84	3180.48	3181.02	2340.0
2018-09-25 20:30:00	ES	Futures	3181.02	3181.56	3180.75	3181.56	955.0
2018-09-25 21:00:00	ES	Futures	3181.29	3182.65	3181.29	3182.65	2484.0
2018-09-25 21:30:00	ES	Futures	3182.38	3183.2	3181.56	3182.38	2878.0
2018-09-25 22:00:00	ES	Futures	3182.65	3184.01	3182.38	3183.74	2807.0
2018-09-25 22:30:00	ES	Futures	3184.01	3184.83	3183.47	3184.56	3019.0
2018-09-25 23:00:00	ES	Futures	3184.83	3184.83	3184.01	3184.83	2163.0
2018-09-25 23:30:00	ES	Futures	3184.83	3185.64	3184.83	3185.37	1701.0
2018-09-25 00:00:00	NQ	Futures	8896.22	8896.51	8893.28	8894.75	190.0
2018-09-25 00:30:00	NQ	Futures	8895.04	8895.63	8893.87	8895.04	167.0
2018-09-25 01:00:00	NQ	Futures	8894.75	8895.04	8891.23	8892.11	463.0
2018-09-25 01:30:00	NQ	Futures	8892.4	8892.4	8886.54	8892.11	749.0

> showing 50 of 3,119 rows — these rows as CSV

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