PREVIEW / futures_1hour / 2017-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-05-23.parquet
  size:    53 KB
  rows:    1,648

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-05-23 00:00:00	ES	Futures	2612.07	2612.34	2611.79	2612.07	822.0
2017-05-23 01:00:00	ES	Futures	2612.07	2612.34	2609.88	2610.7	4760.0
2017-05-23 02:00:00	ES	Futures	2610.7	2612.34	2609.33	2609.88	14605.0
2017-05-23 03:00:00	ES	Futures	2609.61	2618.08	2609.33	2617.8	38480.0
2017-05-23 04:00:00	ES	Futures	2617.53	2619.71	2616.71	2617.53	29145.0
2017-05-23 05:00:00	ES	Futures	2617.53	2618.62	2616.16	2616.44	10636.0
2017-05-23 06:00:00	ES	Futures	2616.71	2617.8	2616.16	2617.53	10483.0
2017-05-23 07:00:00	ES	Futures	2617.53	2619.44	2617.26	2617.8	14979.0
2017-05-23 08:00:00	ES	Futures	2617.8	2618.62	2616.98	2617.53	17979.0
2017-05-23 09:00:00	ES	Futures	2617.53	2619.17	2614.25	2615.07	136307.0
2017-05-23 10:00:00	ES	Futures	2615.34	2618.35	2613.43	2617.53	157571.0
2017-05-23 11:00:00	ES	Futures	2617.53	2620.53	2617.26	2619.99	104177.0
2017-05-23 12:00:00	ES	Futures	2619.71	2621.63	2616.98	2617.26	100107.0
2017-05-23 13:00:00	ES	Futures	2617.53	2620.26	2617.26	2618.89	68395.0
2017-05-23 14:00:00	ES	Futures	2619.17	2621.08	2617.53	2620.26	71851.0
2017-05-23 15:00:00	ES	Futures	2620.26	2621.35	2616.98	2619.44	123843.0
2017-05-23 16:00:00	ES	Futures	2619.44	2620.53	2618.62	2619.44	62513.0
2017-05-23 18:00:00	ES	Futures	2618.89	2619.17	2617.8	2618.62	2341.0
2017-05-23 19:00:00	ES	Futures	2618.62	2618.89	2618.35	2618.62	1447.0
2017-05-23 20:00:00	ES	Futures	2618.62	2619.17	2616.44	2618.08	8655.0
2017-05-23 21:00:00	ES	Futures	2618.08	2618.35	2617.26	2618.08	3903.0
2017-05-23 22:00:00	ES	Futures	2618.08	2618.35	2617.26	2617.8	2958.0
2017-05-23 23:00:00	ES	Futures	2618.08	2618.35	2617.53	2617.8	2110.0
2017-05-23 00:00:00	NQ	Futures	6797.0	6797.3	6795.21	6796.4	325.0
2017-05-23 01:00:00	NQ	Futures	6796.4	6796.4	6791.63	6794.91	887.0
2017-05-23 02:00:00	NQ	Futures	6794.91	6798.49	6789.84	6791.93	2483.0
2017-05-23 03:00:00	NQ	Futures	6791.63	6815.78	6790.74	6811.91	6643.0
2017-05-23 04:00:00	NQ	Futures	6811.61	6816.68	6808.93	6812.21	4245.0
2017-05-23 05:00:00	NQ	Futures	6812.5	6814.59	6806.24	6807.44	1951.0
2017-05-23 06:00:00	NQ	Futures	6807.44	6811.31	6806.24	6810.42	1761.0
2017-05-23 07:00:00	NQ	Futures	6810.42	6817.27	6809.82	6814.29	2584.0
2017-05-23 08:00:00	NQ	Futures	6814.29	6817.57	6813.1	6813.1	3532.0
2017-05-23 09:00:00	NQ	Futures	6813.4	6819.66	6790.74	6797.6	42648.0
2017-05-23 10:00:00	NQ	Futures	6797.3	6806.54	6792.83	6800.88	38758.0
2017-05-23 11:00:00	NQ	Futures	6800.88	6809.52	6800.28	6808.93	20965.0
2017-05-23 12:00:00	NQ	Futures	6808.93	6809.82	6787.46	6791.34	21596.0
2017-05-23 13:00:00	NQ	Futures	6791.63	6798.79	6791.04	6795.51	12772.0
2017-05-23 14:00:00	NQ	Futures	6795.81	6802.66	6793.12	6799.98	15617.0
2017-05-23 15:00:00	NQ	Futures	6799.98	6804.75	6795.51	6804.75	22681.0
2017-05-23 16:00:00	NQ	Futures	6804.45	6813.1	6803.86	6810.42	7796.0
2017-05-23 18:00:00	NQ	Futures	6808.93	6809.52	6807.14	6808.33	738.0
2017-05-23 19:00:00	NQ	Futures	6808.33	6809.22	6807.73	6808.63	293.0
2017-05-23 20:00:00	NQ	Futures	6808.63	6811.01	6803.86	6807.73	1963.0
2017-05-23 21:00:00	NQ	Futures	6807.44	6807.73	6804.45	6806.24	1650.0
2017-05-23 22:00:00	NQ	Futures	6806.24	6808.03	6804.75	6807.14	577.0
2017-05-23 23:00:00	NQ	Futures	6807.44	6809.22	6807.44	6807.73	679.0
2017-05-23 00:00:00	YM	Futures	22678.1	22681.3	22675.9	22679.2	190.0
2017-05-23 01:00:00	YM	Futures	22679.2	22680.2	22663.9	22671.6	1324.0
2017-05-23 02:00:00	YM	Futures	22671.6	22682.4	22657.4	22665.0	2635.0
2017-05-23 03:00:00	YM	Futures	22665.0	22738.9	22660.7	22730.2	7863.0

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

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