PREVIEW / futures_1hour / 2017-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-08-21.parquet
  size:    51 KB
  rows:    1,598

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-21 00:00:00	ES	Futures	2650.84	2651.39	2650.3	2650.84	2013.0
2017-08-21 01:00:00	ES	Futures	2651.12	2651.39	2650.02	2650.57	4800.0
2017-08-21 02:00:00	ES	Futures	2650.84	2651.12	2647.56	2648.66	14599.0
2017-08-21 03:00:00	ES	Futures	2648.66	2649.75	2645.65	2647.29	30677.0
2017-08-21 04:00:00	ES	Futures	2647.29	2648.93	2646.2	2647.84	17865.0
2017-08-21 05:00:00	ES	Futures	2647.56	2651.12	2647.56	2649.48	20065.0
2017-08-21 06:00:00	ES	Futures	2649.48	2654.94	2649.48	2652.48	26399.0
2017-08-21 07:00:00	ES	Futures	2652.76	2654.94	2652.21	2653.58	15693.0
2017-08-21 08:00:00	ES	Futures	2653.58	2653.58	2650.84	2651.94	25678.0
2017-08-21 09:00:00	ES	Futures	2651.94	2652.76	2645.92	2646.74	165157.0
2017-08-21 10:00:00	ES	Futures	2646.74	2649.75	2641.28	2648.93	260334.0
2017-08-21 11:00:00	ES	Futures	2648.93	2654.67	2646.47	2652.21	145265.0
2017-08-21 12:00:00	ES	Futures	2652.21	2656.31	2651.94	2654.12	101046.0
2017-08-21 13:00:00	ES	Futures	2653.85	2654.4	2649.48	2650.02	69173.0
2017-08-21 14:00:00	ES	Futures	2650.02	2651.94	2648.38	2650.57	85475.0
2017-08-21 15:00:00	ES	Futures	2650.84	2655.76	2647.84	2653.3	210127.0
2017-08-21 16:00:00	ES	Futures	2653.3	2655.49	2653.03	2655.49	66714.0
2017-08-21 18:00:00	ES	Futures	2654.67	2656.58	2654.12	2655.22	6824.0
2017-08-21 19:00:00	ES	Futures	2654.94	2656.31	2654.67	2656.04	3458.0
2017-08-21 20:00:00	ES	Futures	2656.31	2660.68	2656.04	2660.14	17371.0
2017-08-21 21:00:00	ES	Futures	2660.14	2661.23	2659.04	2659.86	10791.0
2017-08-21 22:00:00	ES	Futures	2660.14	2661.5	2659.59	2661.5	4616.0
2017-08-21 23:00:00	ES	Futures	2661.5	2661.78	2660.14	2660.68	3835.0
2017-08-21 00:00:00	NQ	Futures	6899.79	6902.77	6898.6	6902.17	485.0
2017-08-21 01:00:00	NQ	Futures	6902.17	6903.06	6898.3	6900.39	661.0
2017-08-21 02:00:00	NQ	Futures	6900.09	6901.58	6892.64	6896.22	1493.0
2017-08-21 03:00:00	NQ	Futures	6895.92	6900.09	6883.12	6886.69	4160.0
2017-08-21 04:00:00	NQ	Futures	6886.99	6891.45	6882.52	6888.48	2234.0
2017-08-21 05:00:00	NQ	Futures	6888.48	6896.81	6888.48	6894.73	1825.0
2017-08-21 06:00:00	NQ	Futures	6894.13	6912.59	6893.54	6903.96	5112.0
2017-08-21 07:00:00	NQ	Futures	6903.96	6912.59	6903.06	6906.94	3394.0
2017-08-21 08:00:00	NQ	Futures	6906.94	6912.3	6902.47	6910.21	7628.0
2017-08-21 09:00:00	NQ	Futures	6910.21	6916.76	6886.39	6889.96	44559.0
2017-08-21 10:00:00	NQ	Futures	6889.96	6892.35	6850.96	6869.12	80920.0
2017-08-21 11:00:00	NQ	Futures	6868.82	6900.68	6856.91	6892.35	57718.0
2017-08-21 12:00:00	NQ	Futures	6892.35	6906.04	6889.96	6895.03	31370.0
2017-08-21 13:00:00	NQ	Futures	6895.32	6897.11	6878.95	6880.73	29201.0
2017-08-21 14:00:00	NQ	Futures	6880.73	6886.69	6874.78	6881.92	22072.0
2017-08-21 15:00:00	NQ	Futures	6881.63	6899.19	6868.23	6894.73	44171.0
2017-08-21 16:00:00	NQ	Futures	6894.73	6904.26	6890.86	6903.36	8587.0
2017-08-21 18:00:00	NQ	Futures	6902.17	6907.53	6900.98	6902.47	775.0
2017-08-21 19:00:00	NQ	Futures	6902.17	6907.83	6901.58	6907.53	529.0
2017-08-21 20:00:00	NQ	Futures	6907.83	6929.27	6907.83	6926.29	4303.0
2017-08-21 21:00:00	NQ	Futures	6926.29	6931.65	6923.31	6927.18	2853.0
2017-08-21 22:00:00	NQ	Futures	6927.48	6931.35	6924.5	6930.46	1155.0
2017-08-21 23:00:00	NQ	Futures	6930.76	6931.05	6928.08	6928.67	462.0
2017-08-21 00:00:00	YM	Futures	23589.6	23593.9	23584.1	23592.8	510.0
2017-08-21 01:00:00	YM	Futures	23592.8	23595.0	23586.3	23589.6	633.0
2017-08-21 02:00:00	YM	Futures	23588.5	23591.8	23566.7	23571.1	2117.0
2017-08-21 03:00:00	YM	Futures	23571.1	23578.7	23545.0	23558.0	4060.0

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

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