PREVIEW / futures_1hour / 2017-12-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-12-12.parquet
  size:    50 KB
  rows:    1,575

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-12 00:00:00	ES	Futures	2913.67	2913.95	2913.13	2913.95	835.0
2017-12-12 01:00:00	ES	Futures	2913.95	2913.95	2912.85	2913.13	1239.0
2017-12-12 02:00:00	ES	Futures	2913.13	2913.13	2912.03	2912.58	1662.0
2017-12-12 03:00:00	ES	Futures	2912.85	2914.22	2911.48	2913.67	6351.0
2017-12-12 04:00:00	ES	Futures	2913.67	2915.59	2912.58	2913.4	6486.0
2017-12-12 05:00:00	ES	Futures	2913.67	2913.95	2912.03	2912.85	3033.0
2017-12-12 06:00:00	ES	Futures	2912.58	2914.22	2912.58	2913.4	2296.0
2017-12-12 07:00:00	ES	Futures	2913.13	2916.13	2913.13	2914.77	5562.0
2017-12-12 08:00:00	ES	Futures	2914.77	2915.86	2913.4	2915.31	7989.0
2017-12-12 09:00:00	ES	Futures	2915.59	2915.86	2911.21	2914.22	35602.0
2017-12-12 10:00:00	ES	Futures	2913.95	2917.23	2913.13	2916.13	28845.0
2017-12-12 11:00:00	ES	Futures	2916.13	2921.06	2915.04	2919.96	33812.0
2017-12-12 12:00:00	ES	Futures	2919.96	2921.88	2916.96	2920.24	24599.0
2017-12-12 13:00:00	ES	Futures	2920.24	2921.33	2917.78	2918.05	20022.0
2017-12-12 14:00:00	ES	Futures	2918.05	2921.61	2916.96	2920.79	20088.0
2017-12-12 15:00:00	ES	Futures	2920.51	2920.79	2915.04	2916.13	53001.0
2017-12-12 16:00:00	ES	Futures	2915.86	2917.5	2915.59	2917.23	15323.0
2017-12-12 18:00:00	ES	Futures	2916.68	2916.96	2912.85	2912.85	3752.0
2017-12-12 19:00:00	ES	Futures	2913.13	2914.22	2912.3	2913.4	2057.0
2017-12-12 20:00:00	ES	Futures	2913.4	2914.22	2911.76	2913.67	3248.0
2017-12-12 21:00:00	ES	Futures	2913.95	2914.49	2912.3	2913.4	2925.0
2017-12-12 22:00:00	ES	Futures	2913.13	2913.13	2907.11	2909.57	10647.0
2017-12-12 23:00:00	ES	Futures	2909.57	2911.76	2909.02	2911.48	1424.0
2017-12-12 00:00:00	NQ	Futures	7616.54	7620.11	7616.24	7620.11	196.0
2017-12-12 01:00:00	NQ	Futures	7620.11	7620.7	7617.73	7619.81	270.0
2017-12-12 02:00:00	NQ	Futures	7620.11	7620.11	7614.75	7615.65	429.0
2017-12-12 03:00:00	NQ	Futures	7615.65	7620.4	7610.89	7613.27	944.0
2017-12-12 04:00:00	NQ	Futures	7613.56	7617.73	7608.51	7612.97	758.0
2017-12-12 05:00:00	NQ	Futures	7612.67	7614.16	7605.83	7609.1	531.0
2017-12-12 06:00:00	NQ	Futures	7608.51	7613.27	7606.72	7608.21	422.0
2017-12-12 07:00:00	NQ	Futures	7608.51	7612.97	7608.21	7609.1	750.0
2017-12-12 08:00:00	NQ	Futures	7610.29	7610.89	7601.67	7608.21	1494.0
2017-12-12 09:00:00	NQ	Futures	7608.51	7608.8	7580.25	7602.56	14431.0
2017-12-12 10:00:00	NQ	Futures	7603.15	7607.91	7588.58	7602.86	11043.0
2017-12-12 11:00:00	NQ	Futures	7603.15	7618.32	7601.37	7614.16	7404.0
2017-12-12 12:00:00	NQ	Futures	7613.86	7618.92	7601.67	7604.34	6901.0
2017-12-12 13:00:00	NQ	Futures	7604.34	7607.02	7582.33	7587.99	5586.0
2017-12-12 14:00:00	NQ	Futures	7587.99	7608.51	7583.23	7605.83	4789.0
2017-12-12 15:00:00	NQ	Futures	7606.13	7606.43	7590.07	7597.21	7929.0
2017-12-12 16:00:00	NQ	Futures	7596.91	7598.4	7592.74	7595.12	2038.0
2017-12-12 18:00:00	NQ	Futures	7596.02	7597.8	7588.28	7588.88	250.0
2017-12-12 19:00:00	NQ	Futures	7587.69	7592.74	7585.61	7591.26	323.0
2017-12-12 20:00:00	NQ	Futures	7591.26	7595.72	7587.69	7593.04	353.0
2017-12-12 21:00:00	NQ	Futures	7593.93	7596.31	7591.26	7593.64	321.0
2017-12-12 22:00:00	NQ	Futures	7592.74	7593.04	7572.82	7580.25	1086.0
2017-12-12 23:00:00	NQ	Futures	7580.55	7586.8	7578.47	7586.2	263.0
2017-12-12 00:00:00	YM	Futures	26564.4	26569.9	26556.8	26563.4	962.0
2017-12-12 01:00:00	YM	Futures	26563.4	26566.6	26559.0	26562.3	357.0
2017-12-12 02:00:00	YM	Futures	26560.1	26561.2	26547.0	26549.2	1016.0
2017-12-12 03:00:00	YM	Futures	26551.4	26563.4	26537.3	26560.1	1853.0

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

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