PREVIEW / futures_1hour / 2017-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-28.parquet
  size:    53 KB
  rows:    1,641

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
2017-11-28 00:00:00	ES	Futures	2843.92	2844.46	2843.37	2844.19	2956.0
2017-11-28 01:00:00	ES	Futures	2844.19	2845.01	2843.92	2844.74	3708.0
2017-11-28 02:00:00	ES	Futures	2845.01	2847.47	2844.74	2846.92	8108.0
2017-11-28 03:00:00	ES	Futures	2846.65	2849.39	2846.1	2848.57	32577.0
2017-11-28 04:00:00	ES	Futures	2848.84	2849.39	2847.47	2848.84	17846.0
2017-11-28 05:00:00	ES	Futures	2848.84	2849.93	2847.2	2849.66	16969.0
2017-11-28 06:00:00	ES	Futures	2849.66	2850.75	2848.57	2850.21	16043.0
2017-11-28 07:00:00	ES	Futures	2849.93	2850.48	2849.11	2849.39	13673.0
2017-11-28 08:00:00	ES	Futures	2849.39	2851.03	2849.11	2850.75	15682.0
2017-11-28 09:00:00	ES	Futures	2850.75	2853.49	2849.66	2851.03	118247.0
2017-11-28 10:00:00	ES	Futures	2851.3	2855.68	2851.3	2854.58	140398.0
2017-11-28 11:00:00	ES	Futures	2854.58	2860.06	2854.31	2859.78	150516.0
2017-11-28 12:00:00	ES	Futures	2859.78	2864.98	2859.51	2864.71	116802.0
2017-11-28 13:00:00	ES	Futures	2864.71	2867.44	2857.59	2858.41	196289.0
2017-11-28 14:00:00	ES	Futures	2858.41	2870.18	2855.68	2869.36	219978.0
2017-11-28 15:00:00	ES	Futures	2869.08	2874.55	2868.54	2874.28	302590.0
2017-11-28 16:00:00	ES	Futures	2874.01	2874.28	2872.37	2873.19	100519.0
2017-11-28 18:00:00	ES	Futures	2872.91	2873.19	2871.27	2872.09	6534.0
2017-11-28 19:00:00	ES	Futures	2872.09	2873.19	2871.0	2872.09	7634.0
2017-11-28 20:00:00	ES	Futures	2872.37	2873.19	2871.82	2871.82	5807.0
2017-11-28 21:00:00	ES	Futures	2872.09	2872.64	2870.45	2870.72	6605.0
2017-11-28 22:00:00	ES	Futures	2870.72	2872.37	2870.45	2871.27	5153.0
2017-11-28 23:00:00	ES	Futures	2871.0	2871.82	2871.0	2871.27	2441.0
2017-11-28 00:00:00	NQ	Futures	7616.84	7619.81	7615.05	7619.21	997.0
2017-11-28 01:00:00	NQ	Futures	7619.21	7621.0	7616.24	7619.81	755.0
2017-11-28 02:00:00	NQ	Futures	7619.81	7629.03	7619.81	7627.84	2226.0
2017-11-28 03:00:00	NQ	Futures	7627.84	7632.6	7622.49	7629.03	3380.0
2017-11-28 04:00:00	NQ	Futures	7629.33	7631.41	7626.65	7630.52	1305.0
2017-11-28 05:00:00	NQ	Futures	7631.11	7634.09	7626.35	7633.49	1894.0
2017-11-28 06:00:00	NQ	Futures	7633.49	7635.87	7630.81	7635.27	2060.0
2017-11-28 07:00:00	NQ	Futures	7635.27	7637.36	7634.38	7636.17	2137.0
2017-11-28 08:00:00	NQ	Futures	7635.87	7640.03	7635.57	7639.44	3699.0
2017-11-28 09:00:00	NQ	Futures	7639.44	7644.49	7626.06	7629.62	41125.0
2017-11-28 10:00:00	NQ	Futures	7629.62	7638.84	7624.27	7627.54	34914.0
2017-11-28 11:00:00	NQ	Futures	7627.54	7642.71	7627.24	7638.84	26791.0
2017-11-28 12:00:00	NQ	Futures	7638.55	7646.58	7634.68	7638.25	20286.0
2017-11-28 13:00:00	NQ	Futures	7638.55	7646.58	7610.29	7612.08	44449.0
2017-11-28 14:00:00	NQ	Futures	7612.37	7646.58	7600.48	7639.14	55622.0
2017-11-28 15:00:00	NQ	Futures	7639.14	7648.96	7633.49	7644.49	42847.0
2017-11-28 16:00:00	NQ	Futures	7644.49	7644.49	7636.46	7640.93	7157.0
2017-11-28 18:00:00	NQ	Futures	7641.82	7641.82	7632.6	7638.55	1249.0
2017-11-28 19:00:00	NQ	Futures	7638.55	7641.52	7634.68	7637.36	1135.0
2017-11-28 20:00:00	NQ	Futures	7637.36	7641.22	7633.79	7634.38	1560.0
2017-11-28 21:00:00	NQ	Futures	7634.09	7636.76	7631.41	7631.41	1297.0
2017-11-28 22:00:00	NQ	Futures	7632.0	7635.87	7631.11	7633.79	938.0
2017-11-28 23:00:00	NQ	Futures	7633.19	7635.87	7633.19	7635.27	386.0
2017-11-28 00:00:00	YM	Futures	25606.3	25613.9	25601.9	25612.8	770.0
2017-11-28 01:00:00	YM	Futures	25612.8	25629.1	25612.8	25622.6	1444.0
2017-11-28 02:00:00	YM	Futures	25622.6	25648.7	25621.5	25643.2	1947.0
2017-11-28 03:00:00	YM	Futures	25643.2	25663.9	25634.5	25656.3	4065.0

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

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