PREVIEW / futures_1hour / 2017-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-10.parquet
  size:    54 KB
  rows:    1,616

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-08-10 00:00:00	ES	Futures	2697.31	2697.58	2696.22	2697.04	5382.0
2017-08-10 01:00:00	ES	Futures	2697.31	2698.4	2696.76	2697.86	4964.0
2017-08-10 02:00:00	ES	Futures	2697.86	2699.5	2697.58	2699.22	9860.0
2017-08-10 03:00:00	ES	Futures	2698.95	2699.22	2696.22	2698.4	24958.0
2017-08-10 04:00:00	ES	Futures	2698.13	2698.4	2694.58	2694.58	22843.0
2017-08-10 05:00:00	ES	Futures	2694.85	2695.12	2692.39	2694.03	31136.0
2017-08-10 06:00:00	ES	Futures	2694.3	2695.4	2691.57	2692.66	22748.0
2017-08-10 07:00:00	ES	Futures	2692.66	2694.85	2690.75	2693.76	31084.0
2017-08-10 08:00:00	ES	Futures	2693.76	2694.58	2691.84	2692.39	34220.0
2017-08-10 09:00:00	ES	Futures	2692.12	2692.94	2685.01	2686.92	284854.0
2017-08-10 10:00:00	ES	Futures	2686.92	2687.2	2677.63	2682.0	382375.0
2017-08-10 11:00:00	ES	Futures	2682.0	2683.37	2675.72	2677.63	225220.0
2017-08-10 12:00:00	ES	Futures	2677.63	2678.45	2670.8	2675.72	240941.0
2017-08-10 13:00:00	ES	Futures	2675.72	2678.72	2673.26	2674.9	142204.0
2017-08-10 14:00:00	ES	Futures	2675.17	2682.55	2672.71	2677.08	183274.0
2017-08-10 15:00:00	ES	Futures	2677.08	2678.45	2663.14	2664.24	431781.0
2017-08-10 16:00:00	ES	Futures	2663.96	2668.34	2659.86	2661.23	173564.0
2017-08-10 18:00:00	ES	Futures	2661.78	2664.24	2659.86	2663.42	13823.0
2017-08-10 19:00:00	ES	Futures	2663.69	2664.78	2663.14	2663.96	4529.0
2017-08-10 20:00:00	ES	Futures	2663.96	2664.51	2661.23	2662.05	7767.0
2017-08-10 21:00:00	ES	Futures	2662.05	2665.06	2661.78	2662.87	11005.0
2017-08-10 22:00:00	ES	Futures	2663.14	2663.69	2660.68	2661.5	9144.0
2017-08-10 23:00:00	ES	Futures	2661.5	2662.6	2660.68	2662.6	4950.0
2017-08-10 00:00:00	NQ	Futures	7031.99	7035.27	7029.31	7033.18	1007.0
2017-08-10 01:00:00	NQ	Futures	7033.48	7039.43	7031.4	7031.69	1162.0
2017-08-10 02:00:00	NQ	Futures	7031.99	7040.33	7031.69	7039.73	1240.0
2017-08-10 03:00:00	NQ	Futures	7039.73	7040.03	7025.14	7029.91	3756.0
2017-08-10 04:00:00	NQ	Futures	7030.2	7030.5	7017.4	7019.19	3321.0
2017-08-10 05:00:00	NQ	Futures	7019.19	7019.49	7010.26	7016.21	3489.0
2017-08-10 06:00:00	NQ	Futures	7016.21	7022.46	7007.87	7009.06	5698.0
2017-08-10 07:00:00	NQ	Futures	7009.36	7012.34	7001.62	7011.15	6567.0
2017-08-10 08:00:00	NQ	Futures	7011.15	7015.32	7006.09	7007.28	7973.0
2017-08-10 09:00:00	NQ	Futures	7007.58	7010.55	6979.59	6985.54	68256.0
2017-08-10 10:00:00	NQ	Futures	6985.54	6987.92	6945.64	6971.85	94744.0
2017-08-10 11:00:00	NQ	Futures	6972.14	6977.5	6936.12	6941.47	76405.0
2017-08-10 12:00:00	NQ	Futures	6941.47	6947.73	6910.81	6931.95	78983.0
2017-08-10 13:00:00	NQ	Futures	6931.95	6947.13	6925.69	6934.33	43855.0
2017-08-10 14:00:00	NQ	Futures	6934.33	6956.06	6923.91	6941.47	39452.0
2017-08-10 15:00:00	NQ	Futures	6941.47	6947.13	6887.88	6894.73	81935.0
2017-08-10 16:00:00	NQ	Futures	6894.73	6903.96	6868.82	6873.89	15153.0
2017-08-10 18:00:00	NQ	Futures	6870.91	6881.63	6865.25	6878.95	2606.0
2017-08-10 19:00:00	NQ	Futures	6878.65	6881.03	6875.97	6877.16	772.0
2017-08-10 20:00:00	NQ	Futures	6876.86	6881.03	6866.74	6872.1	1735.0
2017-08-10 21:00:00	NQ	Futures	6872.4	6881.92	6869.72	6874.18	2203.0
2017-08-10 22:00:00	NQ	Futures	6874.48	6877.76	6862.87	6870.61	2558.0
2017-08-10 23:00:00	NQ	Futures	6870.31	6874.78	6868.82	6874.48	872.0
2017-08-10 00:00:00	YM	Futures	23928.1	23936.8	23920.5	23931.4	1791.0
2017-08-10 01:00:00	YM	Futures	23932.5	23937.9	23929.2	23931.4	799.0
2017-08-10 02:00:00	YM	Futures	23931.4	23948.8	23931.4	23948.8	1252.0
2017-08-10 03:00:00	YM	Futures	23948.8	23948.8	23923.7	23941.2	2357.0

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

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