PREVIEW / futures_1hour / 2017-12-14

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-14.parquet
  size:    52 KB
  rows:    1,629

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-12-14 00:00:00	ES	Futures	2918.6	2919.14	2917.78	2918.32	3391.0
2017-12-14 01:00:00	ES	Futures	2918.32	2919.69	2917.23	2919.14	4659.0
2017-12-14 02:00:00	ES	Futures	2919.42	2921.33	2919.14	2920.78	6654.0
2017-12-14 03:00:00	ES	Futures	2920.78	2922.42	2920.51	2921.88	10272.0
2017-12-14 04:00:00	ES	Futures	2921.88	2922.97	2921.06	2922.42	9856.0
2017-12-14 05:00:00	ES	Futures	2922.42	2922.97	2920.24	2920.51	12049.0
2017-12-14 06:00:00	ES	Futures	2920.51	2921.6	2919.69	2919.69	7494.0
2017-12-14 07:00:00	ES	Futures	2919.96	2921.06	2919.14	2919.69	11338.0
2017-12-14 08:00:00	ES	Futures	2919.96	2921.06	2919.14	2921.06	21886.0
2017-12-14 09:00:00	ES	Futures	2921.06	2921.33	2916.41	2919.42	118105.0
2017-12-14 10:00:00	ES	Futures	2919.42	2920.51	2917.5	2918.05	107615.0
2017-12-14 11:00:00	ES	Futures	2917.78	2918.87	2913.13	2916.68	153612.0
2017-12-14 12:00:00	ES	Futures	2916.68	2916.96	2911.76	2912.86	82522.0
2017-12-14 13:00:00	ES	Futures	2912.58	2913.13	2908.48	2908.76	138243.0
2017-12-14 14:00:00	ES	Futures	2909.03	2910.4	2902.47	2907.39	174892.0
2017-12-14 15:00:00	ES	Futures	2907.39	2910.12	2902.47	2903.02	196512.0
2017-12-14 16:00:00	ES	Futures	2903.29	2906.3	2899.19	2900.28	101020.0
2017-12-14 18:00:00	ES	Futures	2900.28	2902.47	2900.01	2901.92	8803.0
2017-12-14 19:00:00	ES	Futures	2901.92	2903.29	2900.56	2903.02	7046.0
2017-12-14 20:00:00	ES	Futures	2903.02	2903.29	2901.92	2903.02	5421.0
2017-12-14 21:00:00	ES	Futures	2903.02	2903.84	2901.38	2903.56	4375.0
2017-12-14 22:00:00	ES	Futures	2903.84	2904.38	2903.29	2903.84	4229.0
2017-12-14 23:00:00	ES	Futures	2904.11	2907.94	2903.56	2907.12	7971.0
2017-12-14 00:00:00	NQ	Futures	7617.43	7617.73	7613.28	7615.06	871.0
2017-12-14 01:00:00	NQ	Futures	7614.17	7618.91	7610.91	7617.73	849.0
2017-12-14 02:00:00	NQ	Futures	7617.73	7625.14	7617.13	7622.18	1264.0
2017-12-14 03:00:00	NQ	Futures	7622.47	7626.03	7620.99	7624.25	1816.0
2017-12-14 04:00:00	NQ	Futures	7623.96	7627.22	7621.58	7625.73	1746.0
2017-12-14 05:00:00	NQ	Futures	7625.73	7626.92	7620.69	7623.07	1690.0
2017-12-14 06:00:00	NQ	Futures	7622.77	7626.03	7620.99	7621.58	1891.0
2017-12-14 07:00:00	NQ	Futures	7621.88	7625.73	7617.43	7619.21	2636.0
2017-12-14 08:00:00	NQ	Futures	7619.21	7626.92	7617.43	7626.92	4316.0
2017-12-14 09:00:00	NQ	Futures	7626.92	7633.45	7615.06	7626.03	34805.0
2017-12-14 10:00:00	NQ	Futures	7626.03	7644.72	7617.43	7638.79	37235.0
2017-12-14 11:00:00	NQ	Futures	7639.08	7642.64	7622.18	7631.37	35563.0
2017-12-14 12:00:00	NQ	Futures	7631.37	7636.41	7621.29	7623.96	16821.0
2017-12-14 13:00:00	NQ	Futures	7623.96	7626.33	7601.12	7614.17	31520.0
2017-12-14 14:00:00	NQ	Futures	7613.87	7622.47	7597.56	7613.57	33431.0
2017-12-14 15:00:00	NQ	Futures	7613.57	7618.91	7601.12	7604.38	31769.0
2017-12-14 16:00:00	NQ	Futures	7604.38	7610.31	7595.78	7596.97	8309.0
2017-12-14 18:00:00	NQ	Futures	7597.26	7604.68	7597.26	7603.49	1086.0
2017-12-14 19:00:00	NQ	Futures	7603.79	7606.46	7599.63	7604.97	1299.0
2017-12-14 20:00:00	NQ	Futures	7604.97	7605.86	7597.86	7600.52	1231.0
2017-12-14 21:00:00	NQ	Futures	7599.93	7603.19	7593.7	7602.01	1426.0
2017-12-14 22:00:00	NQ	Futures	7601.71	7604.68	7600.82	7602.9	629.0
2017-12-14 23:00:00	NQ	Futures	7602.9	7617.43	7600.52	7613.28	1996.0
2017-12-14 00:00:00	YM	Futures	26800.3	26802.5	26792.7	26800.3	712.0
2017-12-14 01:00:00	YM	Futures	26799.2	26812.2	26791.6	26810.1	749.0
2017-12-14 02:00:00	YM	Futures	26810.1	26822.0	26809.0	26819.9	1354.0
2017-12-14 03:00:00	YM	Futures	26818.8	26842.7	26817.7	26835.1	2084.0

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

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