PREVIEW / futures_1hour / 2017-08-18

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-18.parquet
  size:    45 KB
  rows:    1,323

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-18 00:00:00	ES	Futures	2657.95	2658.22	2656.58	2657.68	4573.0
2017-08-18 01:00:00	ES	Futures	2657.68	2660.14	2657.4	2659.86	6199.0
2017-08-18 02:00:00	ES	Futures	2659.86	2660.41	2656.31	2656.31	13708.0
2017-08-18 03:00:00	ES	Futures	2656.31	2657.95	2653.3	2655.76	48445.0
2017-08-18 04:00:00	ES	Futures	2655.49	2656.86	2650.57	2652.21	33472.0
2017-08-18 05:00:00	ES	Futures	2652.21	2657.4	2651.94	2655.76	36221.0
2017-08-18 06:00:00	ES	Futures	2655.76	2658.77	2655.49	2656.58	25355.0
2017-08-18 07:00:00	ES	Futures	2656.58	2659.59	2654.4	2658.22	33172.0
2017-08-18 08:00:00	ES	Futures	2658.22	2660.68	2657.95	2657.95	38067.0
2017-08-18 09:00:00	ES	Futures	2657.95	2657.95	2645.38	2645.92	352105.0
2017-08-18 10:00:00	ES	Futures	2645.92	2654.4	2645.65	2650.84	265768.0
2017-08-18 11:00:00	ES	Futures	2650.84	2662.87	2646.47	2660.68	312196.0
2017-08-18 12:00:00	ES	Futures	2660.96	2667.24	2656.86	2663.14	236715.0
2017-08-18 13:00:00	ES	Futures	2663.14	2664.51	2655.22	2655.22	157352.0
2017-08-18 14:00:00	ES	Futures	2655.49	2659.59	2654.94	2656.31	96585.0
2017-08-18 15:00:00	ES	Futures	2656.31	2659.32	2650.02	2650.84	310174.0
2017-08-18 16:00:00	ES	Futures	2650.57	2654.67	2650.57	2651.39	136287.0
2017-08-18 00:00:00	NQ	Futures	6925.69	6928.37	6922.42	6925.1	1131.0
2017-08-18 01:00:00	NQ	Futures	6924.8	6932.24	6924.5	6927.18	1512.0
2017-08-18 02:00:00	NQ	Futures	6927.48	6930.76	6914.38	6914.68	2709.0
2017-08-18 03:00:00	NQ	Futures	6914.97	6915.87	6900.98	6908.72	7269.0
2017-08-18 04:00:00	NQ	Futures	6908.42	6910.51	6895.32	6900.39	4295.0
2017-08-18 05:00:00	NQ	Futures	6900.09	6921.53	6898.6	6914.97	5451.0
2017-08-18 06:00:00	NQ	Futures	6914.68	6928.08	6914.38	6926.29	6302.0
2017-08-18 07:00:00	NQ	Futures	6926.29	6931.35	6921.23	6928.67	6150.0
2017-08-18 08:00:00	NQ	Futures	6928.67	6938.8	6928.37	6933.44	9899.0
2017-08-18 09:00:00	NQ	Futures	6933.14	6934.03	6875.08	6875.37	83730.0
2017-08-18 10:00:00	NQ	Futures	6875.37	6921.23	6875.37	6911.7	77653.0
2017-08-18 11:00:00	NQ	Futures	6911.7	6944.15	6891.15	6938.8	65717.0
2017-08-18 12:00:00	NQ	Futures	6938.5	6949.51	6923.61	6939.99	42362.0
2017-08-18 13:00:00	NQ	Futures	6939.99	6944.45	6911.7	6912.0	35948.0
2017-08-18 14:00:00	NQ	Futures	6912.0	6928.97	6911.7	6919.44	22897.0
2017-08-18 15:00:00	NQ	Futures	6919.74	6927.78	6899.79	6901.28	43211.0
2017-08-18 16:00:00	NQ	Futures	6901.28	6912.89	6896.51	6904.26	11305.0
2017-08-18 00:00:00	YM	Futures	23661.4	23665.8	23654.9	23661.4	499.0
2017-08-18 01:00:00	YM	Futures	23661.4	23676.7	23660.3	23672.3	729.0
2017-08-18 02:00:00	YM	Futures	23672.3	23676.7	23644.0	23647.3	1839.0
2017-08-18 03:00:00	YM	Futures	23647.3	23663.6	23627.7	23647.3	4574.0
2017-08-18 04:00:00	YM	Futures	23647.3	23658.2	23619.0	23630.9	2802.0
2017-08-18 05:00:00	YM	Futures	23632.0	23659.2	23627.7	23646.2	2846.0
2017-08-18 06:00:00	YM	Futures	23646.2	23664.7	23645.1	23648.4	1913.0
2017-08-18 07:00:00	YM	Futures	23647.3	23671.2	23633.1	23658.2	2193.0
2017-08-18 08:00:00	YM	Futures	23658.2	23673.4	23654.9	23661.4	4174.0
2017-08-18 09:00:00	YM	Futures	23661.4	23662.5	23572.2	23574.3	30706.0
2017-08-18 10:00:00	YM	Futures	23575.4	23619.0	23570.0	23588.5	22115.0
2017-08-18 11:00:00	YM	Futures	23587.4	23663.6	23535.2	23647.3	29749.0
2017-08-18 12:00:00	YM	Futures	23646.2	23699.5	23625.5	23675.6	20167.0
2017-08-18 13:00:00	YM	Futures	23674.5	23685.4	23622.2	23623.3	16376.0
2017-08-18 14:00:00	YM	Futures	23623.3	23651.6	23620.1	23622.2	8770.0
2017-08-18 15:00:00	YM	Futures	23622.2	23651.6	23568.9	23574.3	17068.0

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

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