PREVIEW / futures_1hour / 2018-04-05

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-05.parquet
  size:    55 KB
  rows:    1,678

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-05 00:00:00	ES	Futures	2902.1	2903.74	2901.29	2903.2	4523.0
2018-04-05 01:00:00	ES	Futures	2903.2	2903.47	2896.37	2898.83	6400.0
2018-04-05 02:00:00	ES	Futures	2898.83	2904.83	2896.37	2902.65	13658.0
2018-04-05 03:00:00	ES	Futures	2902.65	2911.38	2899.65	2907.02	35686.0
2018-04-05 04:00:00	ES	Futures	2907.02	2908.65	2900.19	2901.01	23178.0
2018-04-05 05:00:00	ES	Futures	2901.01	2902.92	2895.28	2902.65	19313.0
2018-04-05 06:00:00	ES	Futures	2902.1	2903.2	2897.74	2899.38	19075.0
2018-04-05 07:00:00	ES	Futures	2899.1	2904.56	2898.28	2902.65	21179.0
2018-04-05 08:00:00	ES	Futures	2902.65	2908.65	2900.47	2904.83	36552.0
2018-04-05 09:00:00	ES	Futures	2905.11	2906.74	2893.92	2903.47	182917.0
2018-04-05 10:00:00	ES	Futures	2903.74	2905.38	2896.1	2898.56	179540.0
2018-04-05 11:00:00	ES	Futures	2898.56	2917.11	2898.28	2916.57	188967.0
2018-04-05 12:00:00	ES	Futures	2916.57	2917.11	2905.11	2910.56	159136.0
2018-04-05 13:00:00	ES	Futures	2910.84	2914.39	2891.73	2900.74	173174.0
2018-04-05 14:00:00	ES	Futures	2901.01	2913.84	2897.46	2912.75	161274.0
2018-04-05 15:00:00	ES	Futures	2912.75	2916.84	2901.83	2906.47	226066.0
2018-04-05 16:00:00	ES	Futures	2906.47	2909.2	2904.29	2905.92	71758.0
2018-04-05 18:00:00	ES	Futures	2907.02	2908.11	2872.36	2872.63	27091.0
2018-04-05 19:00:00	ES	Futures	2872.9	2875.36	2859.8	2872.08	66338.0
2018-04-05 20:00:00	ES	Futures	2872.36	2880.27	2866.63	2870.45	38266.0
2018-04-05 21:00:00	ES	Futures	2870.45	2878.63	2862.53	2876.18	38774.0
2018-04-05 22:00:00	ES	Futures	2875.9	2879.73	2872.9	2876.45	19146.0
2018-04-05 23:00:00	ES	Futures	2876.72	2879.45	2872.08	2873.45	6428.0
2018-04-05 00:00:00	NQ	Futures	7825.4	7840.17	7823.03	7834.56	2456.0
2018-04-05 01:00:00	NQ	Futures	7834.56	7835.15	7816.23	7824.51	3155.0
2018-04-05 02:00:00	NQ	Futures	7824.21	7847.26	7816.53	7841.06	5504.0
2018-04-05 03:00:00	NQ	Futures	7840.76	7866.47	7832.78	7843.13	9614.0
2018-04-05 04:00:00	NQ	Futures	7842.54	7848.45	7822.74	7829.83	6963.0
2018-04-05 05:00:00	NQ	Futures	7830.12	7833.37	7807.66	7831.01	6658.0
2018-04-05 06:00:00	NQ	Futures	7830.42	7837.81	7814.76	7826.58	7280.0
2018-04-05 07:00:00	NQ	Futures	7827.17	7851.99	7823.92	7840.47	8369.0
2018-04-05 08:00:00	NQ	Futures	7840.47	7863.22	7833.67	7847.56	10966.0
2018-04-05 09:00:00	NQ	Futures	7847.56	7856.13	7792.59	7826.58	66628.0
2018-04-05 10:00:00	NQ	Futures	7826.87	7832.78	7789.93	7808.55	69103.0
2018-04-05 11:00:00	NQ	Futures	7808.55	7853.18	7808.55	7846.38	54829.0
2018-04-05 12:00:00	NQ	Futures	7846.38	7847.86	7801.16	7825.69	47796.0
2018-04-05 13:00:00	NQ	Futures	7825.69	7837.22	7753.58	7788.16	57590.0
2018-04-05 14:00:00	NQ	Futures	7788.16	7824.21	7779.88	7822.44	50027.0
2018-04-05 15:00:00	NQ	Futures	7822.44	7841.06	7791.41	7808.55	51388.0
2018-04-05 16:00:00	NQ	Futures	7808.55	7818.3	7798.8	7809.14	9877.0
2018-04-05 18:00:00	NQ	Futures	7811.51	7815.35	7706.59	7706.59	5583.0
2018-04-05 19:00:00	NQ	Futures	7706.59	7726.39	7672.31	7713.09	14416.0
2018-04-05 20:00:00	NQ	Futures	7713.98	7729.94	7689.45	7706.59	11806.0
2018-04-05 21:00:00	NQ	Futures	7706.59	7719.6	7666.4	7711.02	16045.0
2018-04-05 22:00:00	NQ	Futures	7711.62	7731.71	7704.52	7714.57	7812.0
2018-04-05 23:00:00	NQ	Futures	7714.87	7727.57	7702.75	7706.89	2240.0
2018-04-05 00:00:00	YM	Futures	26457.7	26482.7	26450.1	26474.0	1886.0
2018-04-05 01:00:00	YM	Futures	26472.9	26475.1	26398.0	26409.9	2976.0
2018-04-05 02:00:00	YM	Futures	26409.9	26484.8	26380.6	26459.9	5489.0
2018-04-05 03:00:00	YM	Futures	26458.8	26526.1	26431.6	26476.2	8805.0

> showing 50 of 1,678 rows — these rows as CSV

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