PREVIEW / futures_1hour / 2016-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-11-02.parquet
  size:    55 KB
  rows:    1,658

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
2016-11-02 00:00:00	ES	Futures	2280.84	2282.47	2280.02	2280.84	4497.0
2016-11-02 01:00:00	ES	Futures	2281.11	2282.74	2280.57	2281.65	4247.0
2016-11-02 02:00:00	ES	Futures	2281.93	2282.47	2280.02	2281.11	4334.0
2016-11-02 03:00:00	ES	Futures	2281.11	2285.46	2280.29	2283.83	13764.0
2016-11-02 04:00:00	ES	Futures	2283.83	2284.1	2280.29	2283.83	34221.0
2016-11-02 05:00:00	ES	Futures	2283.56	2287.37	2282.2	2286.55	23515.0
2016-11-02 06:00:00	ES	Futures	2286.55	2287.1	2283.83	2285.19	14312.0
2016-11-02 07:00:00	ES	Futures	2285.46	2290.36	2284.92	2288.18	31015.0
2016-11-02 08:00:00	ES	Futures	2288.18	2289.27	2283.56	2287.37	60448.0
2016-11-02 09:00:00	ES	Futures	2287.37	2291.72	2284.92	2290.09	232873.0
2016-11-02 10:00:00	ES	Futures	2290.09	2292.54	2281.38	2282.47	306595.0
2016-11-02 11:00:00	ES	Futures	2282.2	2288.18	2281.93	2283.83	188685.0
2016-11-02 12:00:00	ES	Futures	2283.83	2286.28	2282.2	2284.92	117337.0
2016-11-02 13:00:00	ES	Futures	2284.65	2285.74	2276.76	2280.29	167291.0
2016-11-02 14:00:00	ES	Futures	2280.29	2285.19	2271.59	2279.21	352683.0
2016-11-02 15:00:00	ES	Futures	2279.48	2284.65	2275.94	2276.76	277056.0
2016-11-02 16:00:00	ES	Futures	2276.76	2277.85	2272.95	2274.85	119649.0
2016-11-02 17:00:00	ES	Futures	2274.85	2274.85	2274.85	2274.85	1.0
2016-11-02 18:00:00	ES	Futures	2272.68	2275.12	2272.13	2274.04	8790.0
2016-11-02 19:00:00	ES	Futures	2274.04	2277.85	2273.76	2276.76	7522.0
2016-11-02 20:00:00	ES	Futures	2277.03	2279.21	2276.48	2277.85	5910.0
2016-11-02 21:00:00	ES	Futures	2278.12	2279.48	2277.85	2279.21	5367.0
2016-11-02 22:00:00	ES	Futures	2279.21	2279.75	2272.13	2272.68	12370.0
2016-11-02 23:00:00	ES	Futures	2272.4	2272.68	2268.05	2270.77	18374.0
2016-11-02 00:00:00	NQ	Futures	5655.24	5659.41	5654.04	5657.03	637.0
2016-11-02 01:00:00	NQ	Futures	5657.92	5662.1	5656.13	5659.12	908.0
2016-11-02 02:00:00	NQ	Futures	5659.12	5660.61	5654.64	5656.73	616.0
2016-11-02 03:00:00	NQ	Futures	5657.03	5667.17	5654.94	5663.59	2724.0
2016-11-02 04:00:00	NQ	Futures	5663.29	5664.78	5655.54	5664.19	3744.0
2016-11-02 05:00:00	NQ	Futures	5664.19	5671.94	5660.01	5671.05	2775.0
2016-11-02 06:00:00	NQ	Futures	5670.45	5671.65	5663.29	5667.77	2085.0
2016-11-02 07:00:00	NQ	Futures	5667.77	5680.6	5667.17	5677.31	4056.0
2016-11-02 08:00:00	NQ	Futures	5677.31	5679.7	5669.86	5678.81	7805.0
2016-11-02 09:00:00	NQ	Futures	5678.51	5687.46	5669.26	5682.39	35123.0
2016-11-02 10:00:00	NQ	Futures	5682.39	5690.44	5661.2	5663.29	39455.0
2016-11-02 11:00:00	NQ	Futures	5663.29	5681.19	5662.1	5666.28	24760.0
2016-11-02 12:00:00	NQ	Futures	5665.98	5669.86	5654.34	5658.52	23035.0
2016-11-02 13:00:00	NQ	Futures	5658.22	5661.5	5634.35	5644.8	31924.0
2016-11-02 14:00:00	NQ	Futures	5644.5	5662.1	5621.23	5639.43	50340.0
2016-11-02 15:00:00	NQ	Futures	5640.02	5651.96	5631.67	5633.76	36460.0
2016-11-02 16:00:00	NQ	Futures	5633.46	5638.23	5618.54	5631.97	20148.0
2016-11-02 17:00:00	NQ	Futures	5632.26	5632.26	5632.26	5632.26	1.0
2016-11-02 18:00:00	NQ	Futures	5608.7	5615.26	5603.62	5609.89	4596.0
2016-11-02 19:00:00	NQ	Futures	5609.89	5621.23	5608.99	5617.05	2144.0
2016-11-02 20:00:00	NQ	Futures	5617.35	5623.91	5616.45	5619.44	1322.0
2016-11-02 21:00:00	NQ	Futures	5620.03	5625.1	5620.03	5623.91	1207.0
2016-11-02 22:00:00	NQ	Futures	5624.21	5624.81	5603.92	5605.12	2092.0
2016-11-02 23:00:00	NQ	Futures	5605.12	5605.41	5596.17	5603.33	3218.0
2016-11-02 00:00:00	YM	Futures	19317.6	19328.4	19310.0	19315.4	1222.0
2016-11-02 01:00:00	YM	Futures	19316.5	19328.4	19314.3	19319.7	862.0

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

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