PREVIEW / futures_1hour / 2017-05-10

all futures 1-hour files

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

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-10 00:00:00	ES	Futures	2611.25	2611.52	2610.7	2610.97	1877.0
2017-05-10 01:00:00	ES	Futures	2611.25	2611.52	2610.7	2611.25	2851.0
2017-05-10 02:00:00	ES	Futures	2611.52	2611.52	2610.15	2610.7	8501.0
2017-05-10 03:00:00	ES	Futures	2610.7	2613.43	2610.15	2610.43	20916.0
2017-05-10 04:00:00	ES	Futures	2610.15	2610.7	2608.52	2610.15	13181.0
2017-05-10 05:00:00	ES	Futures	2609.88	2611.25	2609.61	2610.43	10733.0
2017-05-10 06:00:00	ES	Futures	2610.7	2611.52	2609.61	2609.88	7408.0
2017-05-10 07:00:00	ES	Futures	2609.88	2612.61	2609.88	2611.79	15897.0
2017-05-10 08:00:00	ES	Futures	2611.79	2613.98	2611.25	2612.61	16495.0
2017-05-10 09:00:00	ES	Futures	2612.61	2614.25	2611.25	2613.43	121710.0
2017-05-10 10:00:00	ES	Futures	2613.43	2614.8	2610.43	2613.43	185883.0
2017-05-10 11:00:00	ES	Futures	2613.43	2617.53	2612.61	2615.89	132248.0
2017-05-10 12:00:00	ES	Futures	2615.89	2617.26	2615.62	2616.98	55376.0
2017-05-10 13:00:00	ES	Futures	2617.26	2618.35	2615.89	2616.71	71447.0
2017-05-10 14:00:00	ES	Futures	2616.71	2617.8	2615.07	2617.26	75804.0
2017-05-10 15:00:00	ES	Futures	2617.26	2618.62	2615.07	2618.35	139194.0
2017-05-10 16:00:00	ES	Futures	2618.35	2618.89	2616.16	2616.44	58135.0
2017-05-10 18:00:00	ES	Futures	2616.71	2616.98	2616.16	2616.71	2730.0
2017-05-10 19:00:00	ES	Futures	2616.71	2616.98	2615.89	2616.71	1605.0
2017-05-10 20:00:00	ES	Futures	2616.71	2616.98	2615.34	2616.16	4960.0
2017-05-10 21:00:00	ES	Futures	2616.44	2616.98	2615.62	2616.16	3339.0
2017-05-10 22:00:00	ES	Futures	2616.16	2616.71	2615.62	2615.89	3540.0
2017-05-10 23:00:00	ES	Futures	2616.16	2616.16	2615.34	2615.34	2546.0
2017-05-10 00:00:00	NQ	Futures	6765.99	6766.59	6765.1	6765.4	276.0
2017-05-10 01:00:00	NQ	Futures	6765.4	6767.48	6765.4	6766.59	544.0
2017-05-10 02:00:00	NQ	Futures	6766.59	6767.48	6763.01	6763.91	1761.0
2017-05-10 03:00:00	NQ	Futures	6763.61	6770.17	6763.61	6764.2	2595.0
2017-05-10 04:00:00	NQ	Futures	6764.2	6764.5	6759.14	6762.71	2382.0
2017-05-10 05:00:00	NQ	Futures	6763.01	6764.5	6761.22	6763.61	1200.0
2017-05-10 06:00:00	NQ	Futures	6763.61	6767.48	6763.61	6764.2	1296.0
2017-05-10 07:00:00	NQ	Futures	6764.5	6771.36	6763.91	6769.57	2946.0
2017-05-10 08:00:00	NQ	Futures	6769.57	6771.36	6767.78	6768.38	2925.0
2017-05-10 09:00:00	NQ	Futures	6768.08	6772.85	6752.58	6757.35	28798.0
2017-05-10 10:00:00	NQ	Futures	6757.05	6759.73	6747.81	6749.89	36970.0
2017-05-10 11:00:00	NQ	Futures	6749.89	6765.99	6748.7	6761.22	20153.0
2017-05-10 12:00:00	NQ	Futures	6761.22	6768.68	6758.84	6768.68	12011.0
2017-05-10 13:00:00	NQ	Futures	6768.38	6771.66	6763.61	6769.87	11340.0
2017-05-10 14:00:00	NQ	Futures	6769.87	6771.66	6765.7	6769.57	10460.0
2017-05-10 15:00:00	NQ	Futures	6769.57	6773.45	6757.65	6770.76	25118.0
2017-05-10 16:00:00	NQ	Futures	6771.06	6772.25	6767.19	6768.38	4412.0
2017-05-10 18:00:00	NQ	Futures	6767.48	6769.27	6764.8	6766.89	899.0
2017-05-10 19:00:00	NQ	Futures	6767.19	6767.19	6763.31	6766.89	429.0
2017-05-10 20:00:00	NQ	Futures	6766.89	6768.08	6764.2	6765.1	741.0
2017-05-10 21:00:00	NQ	Futures	6765.1	6768.08	6765.1	6766.29	686.0
2017-05-10 22:00:00	NQ	Futures	6766.29	6767.48	6765.4	6765.7	595.0
2017-05-10 23:00:00	NQ	Futures	6765.99	6766.59	6764.2	6765.4	681.0
2017-05-10 00:00:00	YM	Futures	22680.2	22683.5	22675.9	22680.2	289.0
2017-05-10 01:00:00	YM	Futures	22681.3	22686.8	22680.2	22681.3	484.0
2017-05-10 02:00:00	YM	Futures	22681.3	22686.8	22677.0	22680.2	1616.0
2017-05-10 03:00:00	YM	Futures	22680.2	22699.8	22670.5	22672.6	2491.0

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

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