PREVIEW / futures_1hour / 2015-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-12-02.parquet
  size:    51 KB
  rows:    1,602

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
2015-12-02 00:00:00	ES	Futures	2248.45	2248.71	2247.38	2247.38	2000.0
2015-12-02 01:00:00	ES	Futures	2247.38	2252.46	2247.38	2251.39	6537.0
2015-12-02 02:00:00	ES	Futures	2251.39	2251.92	2250.05	2250.32	7826.0
2015-12-02 03:00:00	ES	Futures	2250.32	2253.0	2248.71	2250.32	20592.0
2015-12-02 04:00:00	ES	Futures	2250.32	2251.66	2247.91	2249.78	11323.0
2015-12-02 05:00:00	ES	Futures	2249.78	2252.19	2249.52	2250.85	13276.0
2015-12-02 06:00:00	ES	Futures	2250.59	2252.19	2248.45	2249.25	10027.0
2015-12-02 07:00:00	ES	Futures	2249.25	2249.52	2245.5	2248.71	23341.0
2015-12-02 08:00:00	ES	Futures	2248.45	2249.52	2244.97	2246.31	34741.0
2015-12-02 09:00:00	ES	Futures	2246.31	2250.59	2244.97	2249.78	156216.0
2015-12-02 10:00:00	ES	Futures	2249.78	2251.12	2245.5	2246.84	218379.0
2015-12-02 11:00:00	ES	Futures	2246.57	2246.84	2239.62	2240.95	179081.0
2015-12-02 12:00:00	ES	Futures	2240.95	2243.9	2238.55	2241.22	124268.0
2015-12-02 13:00:00	ES	Futures	2240.95	2242.56	2236.41	2236.94	111468.0
2015-12-02 14:00:00	ES	Futures	2237.21	2237.21	2221.69	2222.76	303566.0
2015-12-02 15:00:00	ES	Futures	2222.76	2229.98	2220.89	2224.1	332906.0
2015-12-02 16:00:00	ES	Futures	2224.1	2230.79	2223.29	2229.98	108674.0
2015-12-02 18:00:00	ES	Futures	2229.72	2229.98	2223.83	2228.38	8818.0
2015-12-02 19:00:00	ES	Futures	2228.38	2229.45	2226.51	2228.91	3686.0
2015-12-02 20:00:00	ES	Futures	2228.91	2231.32	2228.38	2231.05	4682.0
2015-12-02 21:00:00	ES	Futures	2231.05	2231.32	2229.45	2229.98	2771.0
2015-12-02 22:00:00	ES	Futures	2229.98	2229.98	2225.97	2228.38	4446.0
2015-12-02 23:00:00	ES	Futures	2228.38	2232.12	2227.58	2231.59	7317.0
2015-12-02 00:00:00	NQ	Futures	5596.56	5597.75	5595.08	5595.38	456.0
2015-12-02 01:00:00	NQ	Futures	5595.08	5608.13	5594.79	5605.46	1009.0
2015-12-02 02:00:00	NQ	Futures	5605.46	5607.24	5601.01	5601.31	923.0
2015-12-02 03:00:00	NQ	Futures	5601.6	5607.83	5596.56	5602.49	2653.0
2015-12-02 04:00:00	NQ	Futures	5602.2	5605.16	5597.75	5601.6	1403.0
2015-12-02 05:00:00	NQ	Futures	5601.9	5608.13	5600.42	5601.9	1709.0
2015-12-02 06:00:00	NQ	Futures	5602.2	5604.87	5598.34	5599.83	1361.0
2015-12-02 07:00:00	NQ	Futures	5599.83	5600.42	5590.93	5599.53	3750.0
2015-12-02 08:00:00	NQ	Futures	5599.53	5601.31	5591.23	5593.9	7566.0
2015-12-02 09:00:00	NQ	Futures	5593.9	5617.62	5593.01	5616.73	28767.0
2015-12-02 10:00:00	NQ	Futures	5616.73	5620.88	5606.94	5613.46	31926.0
2015-12-02 11:00:00	NQ	Futures	5613.17	5614.06	5599.83	5606.65	22652.0
2015-12-02 12:00:00	NQ	Futures	5606.65	5614.65	5601.6	5611.69	15456.0
2015-12-02 13:00:00	NQ	Futures	5611.39	5612.87	5590.93	5592.71	14131.0
2015-12-02 14:00:00	NQ	Futures	5593.01	5593.01	5549.72	5552.98	41335.0
2015-12-02 15:00:00	NQ	Futures	5552.68	5572.25	5548.53	5558.61	43546.0
2015-12-02 16:00:00	NQ	Futures	5558.61	5574.03	5557.43	5571.66	9042.0
2015-12-02 18:00:00	NQ	Futures	5572.55	5572.85	5559.8	5569.88	1723.0
2015-12-02 19:00:00	NQ	Futures	5569.58	5572.55	5565.43	5571.36	868.0
2015-12-02 20:00:00	NQ	Futures	5571.36	5577.0	5570.18	5576.7	715.0
2015-12-02 21:00:00	NQ	Futures	5576.4	5577.89	5572.55	5573.73	421.0
2015-12-02 22:00:00	NQ	Futures	5574.33	5574.33	5564.84	5571.36	1143.0
2015-12-02 23:00:00	NQ	Futures	5571.66	5580.85	5571.36	5579.96	1419.0
2015-12-02 00:00:00	YM	Futures	18925.7	18927.8	18916.1	18916.1	338.0
2015-12-02 01:00:00	YM	Futures	18916.1	18956.4	18914.0	18950.0	1222.0
2015-12-02 02:00:00	YM	Futures	18949.0	18957.5	18944.7	18944.7	1063.0
2015-12-02 03:00:00	YM	Futures	18945.8	18965.9	18927.8	18947.9	2513.0

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

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