PREVIEW / futures_1hour / 2017-11-02

all futures 1-hour files

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

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-11-02 00:00:00	ES	Futures	2812.18	2812.73	2811.36	2811.91	2700.0
2017-11-02 01:00:00	ES	Futures	2811.91	2812.46	2811.64	2812.46	3764.0
2017-11-02 02:00:00	ES	Futures	2812.18	2812.73	2811.36	2811.64	2551.0
2017-11-02 03:00:00	ES	Futures	2811.64	2812.73	2811.09	2812.46	7876.0
2017-11-02 04:00:00	ES	Futures	2812.18	2816.01	2811.91	2812.73	26121.0
2017-11-02 05:00:00	ES	Futures	2813.0	2814.92	2811.64	2814.64	14061.0
2017-11-02 06:00:00	ES	Futures	2814.64	2814.92	2813.0	2814.37	7681.0
2017-11-02 07:00:00	ES	Futures	2814.37	2817.11	2814.37	2815.47	15001.0
2017-11-02 08:00:00	ES	Futures	2815.47	2818.75	2814.64	2818.47	24424.0
2017-11-02 09:00:00	ES	Futures	2818.47	2818.75	2815.47	2816.56	135456.0
2017-11-02 10:00:00	ES	Futures	2816.83	2817.11	2803.7	2811.91	319615.0
2017-11-02 11:00:00	ES	Futures	2811.91	2815.74	2808.63	2813.28	159476.0
2017-11-02 12:00:00	ES	Futures	2813.28	2817.93	2812.18	2816.56	98451.0
2017-11-02 13:00:00	ES	Futures	2816.56	2817.38	2814.1	2814.92	54256.0
2017-11-02 14:00:00	ES	Futures	2814.64	2817.65	2813.28	2813.28	65461.0
2017-11-02 15:00:00	ES	Futures	2813.28	2821.21	2813.28	2819.57	192651.0
2017-11-02 16:00:00	ES	Futures	2819.29	2821.48	2818.75	2820.39	66207.0
2017-11-02 18:00:00	ES	Futures	2820.39	2821.21	2819.29	2820.66	4667.0
2017-11-02 19:00:00	ES	Futures	2820.66	2821.76	2820.39	2821.48	3168.0
2017-11-02 20:00:00	ES	Futures	2821.48	2822.3	2820.94	2821.48	3978.0
2017-11-02 21:00:00	ES	Futures	2821.21	2821.48	2819.84	2820.94	3992.0
2017-11-02 22:00:00	ES	Futures	2820.94	2821.48	2820.39	2821.21	1975.0
2017-11-02 23:00:00	ES	Futures	2821.21	2821.48	2820.66	2820.66	1394.0
2017-11-02 00:00:00	NQ	Futures	7406.86	7408.64	7403.88	7405.97	875.0
2017-11-02 01:00:00	NQ	Futures	7406.26	7408.64	7402.4	7404.48	1004.0
2017-11-02 02:00:00	NQ	Futures	7404.48	7407.16	7399.42	7405.97	1109.0
2017-11-02 03:00:00	NQ	Futures	7405.67	7409.24	7403.59	7408.64	1197.0
2017-11-02 04:00:00	NQ	Futures	7408.35	7420.54	7408.05	7411.02	3251.0
2017-11-02 05:00:00	NQ	Futures	7411.92	7419.95	7408.64	7417.86	2004.0
2017-11-02 06:00:00	NQ	Futures	7418.16	7419.95	7412.81	7419.35	1618.0
2017-11-02 07:00:00	NQ	Futures	7419.05	7425.6	7418.16	7422.32	2808.0
2017-11-02 08:00:00	NQ	Futures	7422.62	7432.44	7420.24	7429.76	5463.0
2017-11-02 09:00:00	NQ	Futures	7430.35	7430.95	7406.56	7418.16	49496.0
2017-11-02 10:00:00	NQ	Futures	7418.16	7419.35	7385.15	7400.32	77157.0
2017-11-02 11:00:00	NQ	Futures	7400.32	7415.19	7367.01	7392.88	59740.0
2017-11-02 12:00:00	NQ	Futures	7392.58	7410.73	7389.61	7405.37	35543.0
2017-11-02 13:00:00	NQ	Futures	7405.67	7411.92	7396.15	7398.83	20718.0
2017-11-02 14:00:00	NQ	Futures	7398.83	7420.84	7397.94	7412.21	23205.0
2017-11-02 15:00:00	NQ	Futures	7412.21	7424.11	7409.24	7417.27	33324.0
2017-11-02 16:00:00	NQ	Futures	7416.97	7450.88	7414.89	7446.12	14171.0
2017-11-02 18:00:00	NQ	Futures	7438.39	7441.66	7433.63	7438.68	1773.0
2017-11-02 19:00:00	NQ	Futures	7438.39	7442.25	7437.79	7441.36	910.0
2017-11-02 20:00:00	NQ	Futures	7441.06	7442.85	7438.09	7440.17	1884.0
2017-11-02 21:00:00	NQ	Futures	7440.17	7441.66	7434.52	7438.68	1579.0
2017-11-02 22:00:00	NQ	Futures	7438.39	7440.17	7436.6	7439.87	732.0
2017-11-02 23:00:00	NQ	Futures	7439.57	7441.06	7438.98	7439.87	576.0
2017-11-02 00:00:00	YM	Futures	25389.8	25398.5	25386.6	25393.1	827.0
2017-11-02 01:00:00	YM	Futures	25394.2	25400.7	25390.9	25397.4	1019.0
2017-11-02 02:00:00	YM	Futures	25397.4	25399.6	25386.6	25390.9	742.0
2017-11-02 03:00:00	YM	Futures	25392.0	25395.3	25385.5	25390.9	974.0

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

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