PREVIEW / futures_1hour / 2017-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-11-24.parquet
  size:    37 KB
  rows:    1,068

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-24 00:00:00	ES	Futures	2842.82	2842.82	2841.18	2841.45	2555.0
2017-11-24 01:00:00	ES	Futures	2841.45	2842.0	2840.36	2840.91	2973.0
2017-11-24 02:00:00	ES	Futures	2840.91	2843.37	2840.63	2842.0	5793.0
2017-11-24 03:00:00	ES	Futures	2842.0	2843.09	2840.63	2842.0	19176.0
2017-11-24 04:00:00	ES	Futures	2841.73	2843.09	2841.45	2842.27	15028.0
2017-11-24 05:00:00	ES	Futures	2842.27	2844.19	2841.73	2843.92	11515.0
2017-11-24 06:00:00	ES	Futures	2843.64	2846.92	2843.64	2846.1	20201.0
2017-11-24 07:00:00	ES	Futures	2845.83	2847.47	2845.28	2845.83	15037.0
2017-11-24 08:00:00	ES	Futures	2846.1	2847.75	2845.56	2846.1	20112.0
2017-11-24 09:00:00	ES	Futures	2846.1	2846.92	2844.46	2845.83	63611.0
2017-11-24 10:00:00	ES	Futures	2845.56	2846.65	2844.19	2846.38	51013.0
2017-11-24 11:00:00	ES	Futures	2846.1	2848.02	2846.1	2846.92	52285.0
2017-11-24 12:00:00	ES	Futures	2847.2	2848.29	2845.83	2846.65	63768.0
2017-11-24 13:00:00	ES	Futures	2846.38	2848.02	2845.01	2846.65	50663.0
2017-11-24 00:00:00	NQ	Futures	7605.53	7605.53	7602.56	7602.86	675.0
2017-11-24 01:00:00	NQ	Futures	7602.86	7604.94	7600.77	7601.67	833.0
2017-11-24 02:00:00	NQ	Futures	7601.37	7607.32	7601.37	7605.53	1380.0
2017-11-24 03:00:00	NQ	Futures	7605.24	7607.91	7599.88	7602.86	2600.0
2017-11-24 04:00:00	NQ	Futures	7602.26	7606.43	7602.26	7606.13	1447.0
2017-11-24 05:00:00	NQ	Futures	7606.13	7609.4	7604.34	7608.51	2117.0
2017-11-24 06:00:00	NQ	Futures	7608.8	7612.08	7606.43	7609.4	3770.0
2017-11-24 07:00:00	NQ	Futures	7609.1	7612.67	7608.51	7611.18	3240.0
2017-11-24 08:00:00	NQ	Futures	7611.18	7616.24	7610.59	7611.78	4524.0
2017-11-24 09:00:00	NQ	Futures	7611.78	7616.24	7604.94	7614.16	17012.0
2017-11-24 10:00:00	NQ	Futures	7613.86	7622.78	7607.32	7620.7	15261.0
2017-11-24 11:00:00	NQ	Futures	7620.7	7631.11	7620.7	7625.46	14196.0
2017-11-24 12:00:00	NQ	Futures	7625.76	7630.81	7625.46	7628.43	10768.0
2017-11-24 13:00:00	NQ	Futures	7628.73	7632.9	7626.35	7631.11	3614.0
2017-11-24 00:00:00	YM	Futures	25584.5	25584.5	25572.5	25575.8	597.0
2017-11-24 01:00:00	YM	Futures	25575.8	25582.3	25568.2	25569.3	702.0
2017-11-24 02:00:00	YM	Futures	25568.2	25584.5	25568.2	25569.3	1222.0
2017-11-24 03:00:00	YM	Futures	25570.4	25580.2	25546.4	25554.1	2728.0
2017-11-24 04:00:00	YM	Futures	25554.1	25566.0	25542.1	25549.7	2230.0
2017-11-24 05:00:00	YM	Futures	25549.7	25573.6	25544.3	25573.6	1542.0
2017-11-24 06:00:00	YM	Futures	25573.6	25613.9	25572.5	25610.6	2918.0
2017-11-24 07:00:00	YM	Futures	25610.6	25624.8	25608.4	25620.4	3179.0
2017-11-24 08:00:00	YM	Futures	25620.4	25623.7	25582.3	25588.9	3719.0
2017-11-24 09:00:00	YM	Futures	25587.8	25608.4	25582.3	25600.8	6835.0
2017-11-24 10:00:00	YM	Futures	25601.9	25617.1	25592.1	25613.9	5536.0
2017-11-24 11:00:00	YM	Futures	25612.8	25635.6	25609.5	25613.9	5823.0
2017-11-24 12:00:00	YM	Futures	25613.9	25622.6	25585.6	25591.0	4558.0
2017-11-24 13:00:00	YM	Futures	25592.1	25600.8	25573.6	25581.2	2267.0
2017-11-24 00:00:00	CL	Futures	51.83	51.85	51.8	51.83	1803.0
2017-11-24 01:00:00	CL	Futures	51.82	51.85	51.81	51.83	1604.0
2017-11-24 02:00:00	CL	Futures	51.83	51.96	51.82	51.94	9567.0
2017-11-24 03:00:00	CL	Futures	51.93	52.06	51.92	52.0	18135.0
2017-11-24 04:00:00	CL	Futures	52.0	52.03	51.82	51.95	19210.0
2017-11-24 05:00:00	CL	Futures	51.96	52.03	51.91	52.01	12027.0
2017-11-24 06:00:00	CL	Futures	52.01	52.14	51.99	52.09	16364.0
2017-11-24 07:00:00	CL	Futures	52.08	52.24	52.04	52.18	25571.0

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

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