PREVIEW / futures_1hour / 2016-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-08-23.parquet
  size:    51 KB
  rows:    1,583

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-08-23 00:00:00	ES	Futures	2367.46	2368.27	2366.92	2366.92	3449.0
2016-08-23 01:00:00	ES	Futures	2366.92	2367.19	2366.37	2366.92	2745.0
2016-08-23 02:00:00	ES	Futures	2366.64	2368.0	2366.1	2367.46	5882.0
2016-08-23 03:00:00	ES	Futures	2367.46	2369.36	2366.92	2368.54	27479.0
2016-08-23 04:00:00	ES	Futures	2368.81	2372.61	2368.54	2371.25	31828.0
2016-08-23 05:00:00	ES	Futures	2371.25	2372.61	2369.63	2372.07	14076.0
2016-08-23 06:00:00	ES	Futures	2372.07	2373.42	2370.71	2371.25	14420.0
2016-08-23 07:00:00	ES	Futures	2370.98	2372.88	2370.98	2371.53	15886.0
2016-08-23 08:00:00	ES	Futures	2371.8	2372.61	2370.44	2372.61	20252.0
2016-08-23 09:00:00	ES	Futures	2372.61	2376.95	2372.34	2376.41	226267.0
2016-08-23 10:00:00	ES	Futures	2376.14	2377.22	2373.97	2375.59	179136.0
2016-08-23 11:00:00	ES	Futures	2375.86	2375.86	2372.88	2373.69	123952.0
2016-08-23 12:00:00	ES	Futures	2373.42	2373.97	2370.71	2372.07	97718.0
2016-08-23 13:00:00	ES	Futures	2372.07	2373.97	2371.25	2372.88	67654.0
2016-08-23 14:00:00	ES	Futures	2372.61	2373.42	2371.25	2372.07	68127.0
2016-08-23 15:00:00	ES	Futures	2371.8	2373.15	2369.63	2370.17	141814.0
2016-08-23 16:00:00	ES	Futures	2370.17	2371.25	2369.63	2370.71	55033.0
2016-08-23 18:00:00	ES	Futures	2370.98	2371.53	2369.9	2370.44	2954.0
2016-08-23 19:00:00	ES	Futures	2370.44	2371.8	2370.44	2371.25	1472.0
2016-08-23 20:00:00	ES	Futures	2370.98	2372.34	2370.98	2371.53	3634.0
2016-08-23 21:00:00	ES	Futures	2371.53	2371.53	2368.81	2369.36	6564.0
2016-08-23 22:00:00	ES	Futures	2369.36	2369.63	2367.46	2368.0	6251.0
2016-08-23 23:00:00	ES	Futures	2368.0	2369.63	2367.73	2369.36	3088.0
2016-08-23 00:00:00	NQ	Futures	5740.77	5742.26	5739.28	5739.58	524.0
2016-08-23 01:00:00	NQ	Futures	5739.28	5740.18	5737.79	5738.68	257.0
2016-08-23 02:00:00	NQ	Futures	5738.39	5741.07	5736.9	5741.07	850.0
2016-08-23 03:00:00	NQ	Futures	5740.18	5746.14	5738.68	5743.45	3240.0
2016-08-23 04:00:00	NQ	Futures	5743.75	5756.27	5743.75	5752.4	4920.0
2016-08-23 05:00:00	NQ	Futures	5752.1	5756.57	5748.22	5755.67	2035.0
2016-08-23 06:00:00	NQ	Futures	5755.67	5758.06	5749.41	5750.31	2141.0
2016-08-23 07:00:00	NQ	Futures	5750.31	5753.29	5750.01	5752.4	1835.0
2016-08-23 08:00:00	NQ	Futures	5752.1	5752.69	5748.82	5752.69	2322.0
2016-08-23 09:00:00	NQ	Futures	5752.69	5766.4	5752.1	5763.42	32951.0
2016-08-23 10:00:00	NQ	Futures	5763.72	5765.81	5754.48	5758.06	25648.0
2016-08-23 11:00:00	NQ	Futures	5758.06	5758.36	5748.82	5752.4	20034.0
2016-08-23 12:00:00	NQ	Futures	5752.4	5754.18	5741.07	5744.94	15266.0
2016-08-23 13:00:00	NQ	Futures	5744.94	5751.5	5743.45	5749.12	9678.0
2016-08-23 14:00:00	NQ	Futures	5749.12	5753.89	5744.65	5748.82	13445.0
2016-08-23 15:00:00	NQ	Futures	5748.52	5751.5	5743.16	5743.75	15498.0
2016-08-23 16:00:00	NQ	Futures	5743.75	5746.14	5741.37	5745.24	5325.0
2016-08-23 18:00:00	NQ	Futures	5744.65	5746.14	5742.86	5744.05	477.0
2016-08-23 19:00:00	NQ	Futures	5744.05	5747.92	5744.05	5746.43	329.0
2016-08-23 20:00:00	NQ	Futures	5746.73	5749.71	5745.84	5747.33	534.0
2016-08-23 21:00:00	NQ	Futures	5747.63	5747.63	5738.68	5739.88	1132.0
2016-08-23 22:00:00	NQ	Futures	5739.88	5740.47	5732.72	5734.81	1447.0
2016-08-23 23:00:00	NQ	Futures	5735.11	5738.98	5734.21	5738.09	624.0
2016-08-23 00:00:00	YM	Futures	19941.0	19945.3	19933.5	19933.5	416.0
2016-08-23 01:00:00	YM	Futures	19934.5	19937.8	19929.2	19933.5	380.0
2016-08-23 02:00:00	YM	Futures	19933.5	19944.2	19928.1	19942.1	729.0
2016-08-23 03:00:00	YM	Futures	19941.0	19957.1	19936.7	19950.7	2836.0

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

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