PREVIEW / futures_1hour / 2017-10-31

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-31.parquet
  size:    51 KB
  rows:    1,592

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-31 00:00:00	ES	Futures	2811.91	2812.46	2811.64	2812.46	3043.0
2017-10-31 01:00:00	ES	Futures	2812.18	2812.18	2810.81	2811.64	3748.0
2017-10-31 02:00:00	ES	Futures	2811.64	2812.46	2810.54	2811.64	2683.0
2017-10-31 03:00:00	ES	Futures	2811.36	2812.46	2811.36	2811.91	2454.0
2017-10-31 04:00:00	ES	Futures	2811.91	2814.92	2811.36	2814.64	12924.0
2017-10-31 05:00:00	ES	Futures	2814.37	2815.74	2814.1	2814.92	8070.0
2017-10-31 06:00:00	ES	Futures	2814.92	2815.74	2814.1	2814.37	5158.0
2017-10-31 07:00:00	ES	Futures	2814.64	2816.29	2813.55	2816.01	9983.0
2017-10-31 08:00:00	ES	Futures	2815.74	2816.01	2814.92	2815.47	10678.0
2017-10-31 09:00:00	ES	Futures	2815.47	2816.29	2812.18	2812.73	96360.0
2017-10-31 10:00:00	ES	Futures	2812.46	2815.19	2811.09	2814.64	90447.0
2017-10-31 11:00:00	ES	Futures	2814.64	2817.38	2814.37	2816.56	84835.0
2017-10-31 12:00:00	ES	Futures	2816.56	2816.83	2814.64	2815.47	77065.0
2017-10-31 13:00:00	ES	Futures	2815.47	2816.56	2814.92	2816.29	38913.0
2017-10-31 14:00:00	ES	Futures	2816.01	2817.38	2815.19	2816.83	66513.0
2017-10-31 15:00:00	ES	Futures	2816.56	2818.2	2813.28	2814.37	381327.0
2017-10-31 16:00:00	ES	Futures	2814.37	2815.74	2814.1	2815.19	101388.0
2017-10-31 18:00:00	ES	Futures	2815.19	2816.56	2813.28	2814.1	7715.0
2017-10-31 19:00:00	ES	Futures	2814.1	2815.74	2814.1	2815.19	3640.0
2017-10-31 20:00:00	ES	Futures	2815.47	2817.93	2814.64	2817.93	12154.0
2017-10-31 21:00:00	ES	Futures	2817.65	2820.39	2817.65	2819.57	9805.0
2017-10-31 22:00:00	ES	Futures	2819.57	2819.84	2818.47	2819.29	4869.0
2017-10-31 23:00:00	ES	Futures	2819.02	2820.12	2818.75	2819.02	4362.0
2017-10-31 00:00:00	NQ	Futures	7414.0	7417.86	7412.81	7416.97	680.0
2017-10-31 01:00:00	NQ	Futures	7416.97	7417.27	7413.1	7415.78	608.0
2017-10-31 02:00:00	NQ	Futures	7415.78	7416.67	7410.13	7414.0	765.0
2017-10-31 03:00:00	NQ	Futures	7414.29	7419.65	7414.29	7417.86	928.0
2017-10-31 04:00:00	NQ	Futures	7417.57	7422.92	7415.48	7422.32	2082.0
2017-10-31 05:00:00	NQ	Futures	7422.32	7425.3	7421.14	7424.41	1526.0
2017-10-31 06:00:00	NQ	Futures	7424.11	7425.0	7419.95	7421.73	1338.0
2017-10-31 07:00:00	NQ	Futures	7421.73	7430.06	7419.65	7429.17	2238.0
2017-10-31 08:00:00	NQ	Futures	7428.87	7434.82	7427.38	7431.54	5300.0
2017-10-31 09:00:00	NQ	Futures	7431.84	7434.82	7409.83	7416.08	41667.0
2017-10-31 10:00:00	NQ	Futures	7416.08	7430.06	7411.92	7425.89	42382.0
2017-10-31 11:00:00	NQ	Futures	7425.89	7436.01	7425.0	7434.82	22478.0
2017-10-31 12:00:00	NQ	Futures	7434.82	7435.11	7422.32	7432.14	19703.0
2017-10-31 13:00:00	NQ	Futures	7432.14	7435.11	7427.68	7434.52	13695.0
2017-10-31 14:00:00	NQ	Futures	7434.82	7445.82	7434.22	7436.6	24526.0
2017-10-31 15:00:00	NQ	Futures	7436.6	7440.17	7427.08	7434.52	42645.0
2017-10-31 16:00:00	NQ	Futures	7434.52	7438.98	7433.92	7436.9	9101.0
2017-10-31 18:00:00	NQ	Futures	7435.11	7441.66	7431.54	7436.9	1747.0
2017-10-31 19:00:00	NQ	Futures	7436.9	7440.47	7436.01	7439.28	754.0
2017-10-31 20:00:00	NQ	Futures	7439.57	7452.07	7437.79	7450.88	2781.0
2017-10-31 21:00:00	NQ	Futures	7450.88	7458.31	7449.69	7454.74	3302.0
2017-10-31 22:00:00	NQ	Futures	7454.45	7455.04	7452.36	7453.55	956.0
2017-10-31 23:00:00	NQ	Futures	7453.55	7456.23	7452.96	7453.55	831.0
2017-10-31 00:00:00	YM	Futures	25346.3	25348.5	25342.0	25347.4	451.0
2017-10-31 01:00:00	YM	Futures	25346.3	25347.4	25338.7	25344.1	565.0
2017-10-31 02:00:00	YM	Futures	25344.1	25345.2	25331.1	25335.4	728.0
2017-10-31 03:00:00	YM	Futures	25336.5	25348.5	25335.4	25339.8	783.0

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

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