PREVIEW / futures_1hour / 2017-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-11.parquet
  size:    52 KB
  rows:    1,623

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-07-11 00:00:00	ES	Futures	2652.76	2653.3	2652.21	2652.76	1434.0
2017-07-11 01:00:00	ES	Futures	2652.76	2654.12	2652.76	2653.58	4113.0
2017-07-11 02:00:00	ES	Futures	2653.58	2654.4	2652.76	2653.03	4349.0
2017-07-11 03:00:00	ES	Futures	2652.76	2654.4	2650.3	2650.57	22665.0
2017-07-11 04:00:00	ES	Futures	2650.57	2651.12	2648.93	2649.75	16100.0
2017-07-11 05:00:00	ES	Futures	2649.75	2651.12	2648.93	2649.2	11085.0
2017-07-11 06:00:00	ES	Futures	2648.93	2649.48	2648.11	2648.93	8422.0
2017-07-11 07:00:00	ES	Futures	2649.2	2649.2	2647.29	2647.84	11978.0
2017-07-11 08:00:00	ES	Futures	2647.56	2649.48	2647.56	2648.93	12641.0
2017-07-11 09:00:00	ES	Futures	2648.93	2650.84	2646.47	2648.11	111487.0
2017-07-11 10:00:00	ES	Futures	2648.11	2652.48	2647.29	2652.21	119988.0
2017-07-11 11:00:00	ES	Futures	2651.94	2652.48	2635.26	2645.65	312243.0
2017-07-11 12:00:00	ES	Futures	2645.65	2647.29	2641.82	2645.65	95368.0
2017-07-11 13:00:00	ES	Futures	2645.65	2650.84	2643.74	2650.3	91799.0
2017-07-11 14:00:00	ES	Futures	2650.3	2651.94	2648.66	2649.75	86671.0
2017-07-11 15:00:00	ES	Futures	2649.75	2653.85	2648.11	2649.48	154448.0
2017-07-11 16:00:00	ES	Futures	2649.48	2651.66	2649.48	2651.39	43458.0
2017-07-11 18:00:00	ES	Futures	2651.39	2652.48	2650.84	2652.21	3713.0
2017-07-11 19:00:00	ES	Futures	2652.48	2653.03	2651.12	2651.39	2452.0
2017-07-11 20:00:00	ES	Futures	2651.12	2651.94	2649.75	2650.02	5816.0
2017-07-11 21:00:00	ES	Futures	2650.02	2650.84	2648.66	2650.3	6469.0
2017-07-11 22:00:00	ES	Futures	2650.02	2650.57	2649.48	2649.75	2670.0
2017-07-11 23:00:00	ES	Futures	2650.02	2650.3	2648.66	2649.2	3301.0
2017-07-11 00:00:00	NQ	Futures	6787.84	6789.92	6781.88	6788.73	952.0
2017-07-11 01:00:00	NQ	Futures	6789.03	6792.0	6788.13	6791.71	1158.0
2017-07-11 02:00:00	NQ	Futures	6791.71	6792.3	6784.26	6787.54	1174.0
2017-07-11 03:00:00	NQ	Futures	6787.54	6791.71	6779.5	6779.8	2535.0
2017-07-11 04:00:00	NQ	Futures	6779.8	6782.48	6774.44	6776.22	2532.0
2017-07-11 05:00:00	NQ	Futures	6776.22	6781.28	6775.63	6775.63	1043.0
2017-07-11 06:00:00	NQ	Futures	6775.63	6780.39	6772.05	6780.09	3120.0
2017-07-11 07:00:00	NQ	Futures	6779.5	6780.39	6768.48	6770.86	3156.0
2017-07-11 08:00:00	NQ	Futures	6770.86	6773.84	6766.69	6769.37	5755.0
2017-07-11 09:00:00	NQ	Futures	6769.67	6787.54	6764.61	6786.64	36771.0
2017-07-11 10:00:00	NQ	Futures	6786.64	6809.87	6780.99	6799.75	41599.0
2017-07-11 11:00:00	NQ	Futures	6799.45	6804.81	6750.02	6783.67	69424.0
2017-07-11 12:00:00	NQ	Futures	6783.67	6787.24	6765.8	6782.77	27255.0
2017-07-11 13:00:00	NQ	Futures	6782.48	6800.64	6778.31	6799.75	21973.0
2017-07-11 14:00:00	NQ	Futures	6799.75	6807.78	6796.17	6798.26	17718.0
2017-07-11 15:00:00	NQ	Futures	6798.26	6813.44	6796.47	6803.91	30507.0
2017-07-11 16:00:00	NQ	Futures	6804.21	6815.53	6803.02	6811.95	7390.0
2017-07-11 18:00:00	NQ	Futures	6811.95	6816.12	6809.57	6814.33	773.0
2017-07-11 19:00:00	NQ	Futures	6814.63	6817.01	6810.76	6811.06	595.0
2017-07-11 20:00:00	NQ	Futures	6811.36	6813.74	6806.0	6806.3	1181.0
2017-07-11 21:00:00	NQ	Futures	6806.59	6811.95	6803.91	6808.98	1204.0
2017-07-11 22:00:00	NQ	Futures	6808.98	6810.76	6807.19	6808.08	550.0
2017-07-11 23:00:00	NQ	Futures	6807.78	6810.17	6805.7	6807.49	697.0
2017-07-11 00:00:00	YM	Futures	23272.8	23275.0	23268.5	23273.9	404.0
2017-07-11 01:00:00	YM	Futures	23273.9	23281.5	23273.9	23276.1	565.0
2017-07-11 02:00:00	YM	Futures	23277.2	23281.5	23270.7	23271.7	1034.0
2017-07-11 03:00:00	YM	Futures	23271.7	23281.5	23252.1	23253.2	2475.0

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

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