PREVIEW / futures_1hour / 2018-12-11

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-11.parquet
  size:    52 KB
  rows:    1,591

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-12-11 00:00:00	ES	Futures	2866.86	2869.85	2865.5	2866.32	5690.0
2018-12-11 01:00:00	ES	Futures	2866.05	2868.77	2864.14	2868.49	3844.0
2018-12-11 02:00:00	ES	Futures	2868.49	2874.48	2867.41	2867.95	14571.0
2018-12-11 03:00:00	ES	Futures	2867.95	2873.12	2863.6	2866.05	23732.0
2018-12-11 04:00:00	ES	Futures	2866.05	2875.29	2864.96	2874.21	17389.0
2018-12-11 05:00:00	ES	Futures	2874.21	2888.08	2874.21	2886.99	33718.0
2018-12-11 06:00:00	ES	Futures	2886.99	2899.77	2886.17	2894.33	49064.0
2018-12-11 07:00:00	ES	Futures	2894.06	2904.4	2894.06	2899.5	39831.0
2018-12-11 08:00:00	ES	Futures	2899.77	2913.64	2896.51	2909.29	69767.0
2018-12-11 09:00:00	ES	Futures	2909.29	2910.92	2900.32	2902.76	236006.0
2018-12-11 10:00:00	ES	Futures	2903.04	2910.65	2890.53	2894.88	290599.0
2018-12-11 11:00:00	ES	Futures	2895.15	2895.97	2878.01	2886.45	257238.0
2018-12-11 12:00:00	ES	Futures	2886.45	2886.72	2864.41	2870.94	237260.0
2018-12-11 13:00:00	ES	Futures	2870.94	2876.38	2852.45	2854.62	205823.0
2018-12-11 14:00:00	ES	Futures	2854.62	2886.72	2851.9	2879.37	267675.0
2018-12-11 15:00:00	ES	Futures	2879.37	2895.15	2868.49	2869.85	299694.0
2018-12-11 16:00:00	ES	Futures	2869.85	2874.75	2859.52	2863.33	65914.0
2018-12-11 18:00:00	ES	Futures	2864.14	2879.37	2863.33	2870.94	22777.0
2018-12-11 19:00:00	ES	Futures	2870.94	2882.09	2866.05	2881.55	22981.0
2018-12-11 20:00:00	ES	Futures	2881.28	2890.53	2879.1	2886.17	21218.0
2018-12-11 21:00:00	ES	Futures	2885.9	2887.53	2882.91	2883.18	6474.0
2018-12-11 22:00:00	ES	Futures	2883.18	2889.17	2880.73	2887.26	6845.0
2018-12-11 23:00:00	ES	Futures	2887.53	2890.53	2886.72	2888.08	4556.0
2018-12-11 00:00:00	NQ	Futures	7830.61	7842.05	7828.55	7829.14	2359.0
2018-12-11 01:00:00	NQ	Futures	7828.55	7837.65	7821.81	7835.01	1973.0
2018-12-11 02:00:00	NQ	Futures	7835.89	7858.77	7834.71	7836.18	6283.0
2018-12-11 03:00:00	NQ	Futures	7835.89	7854.37	7823.57	7832.66	8171.0
2018-12-11 04:00:00	NQ	Futures	7832.95	7863.17	7828.55	7861.41	5998.0
2018-12-11 05:00:00	NQ	Futures	7860.82	7910.68	7860.82	7906.28	13027.0
2018-12-11 06:00:00	NQ	Futures	7906.58	7950.57	7902.47	7929.75	17058.0
2018-12-11 07:00:00	NQ	Futures	7929.16	7958.2	7928.87	7947.93	11559.0
2018-12-11 08:00:00	NQ	Futures	7948.23	7988.41	7934.73	7975.21	31165.0
2018-12-11 09:00:00	NQ	Futures	7974.92	7978.73	7935.32	7944.71	90992.0
2018-12-11 10:00:00	NQ	Futures	7945.0	7970.81	7901.3	7917.14	113188.0
2018-12-11 11:00:00	NQ	Futures	7916.26	7925.64	7884.58	7917.43	84678.0
2018-12-11 12:00:00	NQ	Futures	7917.72	7917.72	7851.43	7876.95	73791.0
2018-12-11 13:00:00	NQ	Futures	7876.95	7887.22	7809.78	7817.7	60688.0
2018-12-11 14:00:00	NQ	Futures	7817.7	7905.99	7803.62	7887.51	74568.0
2018-12-11 15:00:00	NQ	Futures	7887.8	7936.2	7865.22	7868.15	81505.0
2018-12-11 16:00:00	NQ	Futures	7868.45	7884.28	7827.67	7839.41	15537.0
2018-12-11 18:00:00	NQ	Futures	7844.98	7893.08	7841.46	7867.27	6898.0
2018-12-11 19:00:00	NQ	Futures	7867.86	7908.63	7852.9	7904.52	9548.0
2018-12-11 20:00:00	NQ	Futures	7904.52	7942.95	7897.78	7928.57	11631.0
2018-12-11 21:00:00	NQ	Futures	7928.87	7933.56	7920.95	7922.42	3351.0
2018-12-11 22:00:00	NQ	Futures	7923.0	7936.79	7912.74	7930.92	3908.0
2018-12-11 23:00:00	NQ	Futures	7930.92	7938.25	7926.81	7933.56	2388.0
2018-12-11 00:00:00	YM	Futures	26537.9	26553.1	26518.4	26530.3	35.0
2018-12-11 01:00:00	YM	Futures	26514.0	26546.6	26503.2	26545.5	40.0
2018-12-11 02:00:00	YM	Futures	26547.7	26599.8	26547.7	26552.0	67.0
2018-12-11 03:00:00	YM	Futures	26552.0	26583.5	26498.8	26517.3	59.0

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

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