PREVIEW / futures_1hour / 2017-10-30

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-30.parquet
  size:    52 KB
  rows:    1,632

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-10-30 00:00:00	ES	Futures	2815.47	2816.29	2814.92	2815.47	1962.0
2017-10-30 01:00:00	ES	Futures	2815.47	2816.01	2814.64	2815.19	5749.0
2017-10-30 02:00:00	ES	Futures	2815.47	2816.56	2814.92	2816.29	3311.0
2017-10-30 03:00:00	ES	Futures	2816.01	2817.65	2815.19	2817.11	8760.0
2017-10-30 04:00:00	ES	Futures	2817.11	2817.65	2815.74	2816.29	18175.0
2017-10-30 05:00:00	ES	Futures	2816.56	2817.65	2815.74	2816.01	12814.0
2017-10-30 06:00:00	ES	Futures	2816.01	2816.56	2814.1	2814.37	12820.0
2017-10-30 07:00:00	ES	Futures	2814.37	2816.29	2814.1	2816.29	12995.0
2017-10-30 08:00:00	ES	Futures	2816.29	2816.56	2814.37	2815.19	17119.0
2017-10-30 09:00:00	ES	Futures	2814.92	2817.93	2813.55	2816.83	147830.0
2017-10-30 10:00:00	ES	Futures	2816.56	2820.39	2815.74	2818.75	124859.0
2017-10-30 11:00:00	ES	Futures	2818.47	2819.29	2809.45	2812.46	194979.0
2017-10-30 12:00:00	ES	Futures	2812.46	2812.73	2807.26	2811.36	120727.0
2017-10-30 13:00:00	ES	Futures	2811.36	2813.82	2809.72	2810.54	94535.0
2017-10-30 14:00:00	ES	Futures	2810.54	2813.28	2809.72	2811.91	72336.0
2017-10-30 15:00:00	ES	Futures	2811.91	2814.1	2808.63	2811.09	188728.0
2017-10-30 16:00:00	ES	Futures	2811.36	2812.46	2809.17	2810.54	98987.0
2017-10-30 18:00:00	ES	Futures	2809.99	2810.81	2808.9	2809.45	4129.0
2017-10-30 19:00:00	ES	Futures	2809.45	2810.54	2808.9	2809.17	3050.0
2017-10-30 20:00:00	ES	Futures	2809.17	2811.09	2808.63	2810.54	6559.0
2017-10-30 21:00:00	ES	Futures	2810.81	2811.64	2809.99	2811.36	4749.0
2017-10-30 22:00:00	ES	Futures	2811.36	2811.91	2811.09	2811.64	3275.0
2017-10-30 23:00:00	ES	Futures	2811.64	2812.18	2811.36	2811.91	1938.0
2017-10-30 00:00:00	NQ	Futures	7387.53	7390.5	7385.74	7387.23	501.0
2017-10-30 01:00:00	NQ	Futures	7387.82	7390.8	7386.04	7389.61	1010.0
2017-10-30 02:00:00	NQ	Futures	7389.91	7395.26	7388.12	7394.37	1861.0
2017-10-30 03:00:00	NQ	Futures	7394.67	7400.61	7391.1	7397.64	1755.0
2017-10-30 04:00:00	NQ	Futures	7397.64	7399.13	7389.31	7394.37	1921.0
2017-10-30 05:00:00	NQ	Futures	7393.77	7397.34	7391.99	7395.85	2091.0
2017-10-30 06:00:00	NQ	Futures	7396.15	7397.04	7387.23	7388.42	1883.0
2017-10-30 07:00:00	NQ	Futures	7388.42	7393.48	7387.53	7391.69	2151.0
2017-10-30 08:00:00	NQ	Futures	7391.69	7397.34	7388.12	7391.99	5277.0
2017-10-30 09:00:00	NQ	Futures	7391.99	7416.67	7383.07	7414.89	51892.0
2017-10-30 10:00:00	NQ	Futures	7414.59	7437.2	7411.62	7425.89	53893.0
2017-10-30 11:00:00	NQ	Futures	7425.6	7426.49	7393.18	7405.97	58112.0
2017-10-30 12:00:00	NQ	Futures	7405.67	7406.26	7378.6	7400.61	44346.0
2017-10-30 13:00:00	NQ	Futures	7400.32	7407.16	7389.31	7391.99	32091.0
2017-10-30 14:00:00	NQ	Futures	7391.99	7406.56	7391.1	7402.99	33420.0
2017-10-30 15:00:00	NQ	Futures	7402.7	7414.59	7389.61	7407.75	39283.0
2017-10-30 16:00:00	NQ	Futures	7407.75	7411.62	7399.72	7401.8	8229.0
2017-10-30 18:00:00	NQ	Futures	7401.8	7404.48	7398.83	7400.91	995.0
2017-10-30 19:00:00	NQ	Futures	7400.61	7404.78	7400.32	7401.21	692.0
2017-10-30 20:00:00	NQ	Futures	7401.21	7409.24	7400.02	7408.05	1403.0
2017-10-30 21:00:00	NQ	Futures	7408.05	7414.0	7404.78	7413.4	1980.0
2017-10-30 22:00:00	NQ	Futures	7413.7	7415.19	7410.73	7413.4	1100.0
2017-10-30 23:00:00	NQ	Futures	7413.7	7416.08	7412.21	7414.29	731.0
2017-10-30 00:00:00	YM	Futures	25389.8	25398.5	25386.6	25392.0	675.0
2017-10-30 01:00:00	YM	Futures	25393.1	25401.8	25388.7	25393.1	987.0
2017-10-30 02:00:00	YM	Futures	25393.1	25404.0	25393.1	25402.9	642.0
2017-10-30 03:00:00	YM	Futures	25404.0	25410.5	25388.7	25405.0	1435.0

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

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