PREVIEW / futures_1hour / 2014-12-17

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-12-17.parquet
  size:    52 KB
  rows:    1,558

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
2014-12-17 00:00:00	ES	Futures	2072.32	2074.16	2071.27	2073.9	2981.0
2014-12-17 01:00:00	ES	Futures	2073.9	2075.74	2072.58	2075.74	3674.0
2014-12-17 02:00:00	ES	Futures	2075.48	2078.37	2073.9	2076.0	18080.0
2014-12-17 03:00:00	ES	Futures	2076.0	2079.95	2073.64	2078.11	44469.0
2014-12-17 04:00:00	ES	Futures	2077.85	2081.53	2075.22	2079.69	26769.0
2014-12-17 05:00:00	ES	Futures	2079.69	2083.11	2078.9	2079.43	19486.0
2014-12-17 06:00:00	ES	Futures	2079.43	2081.79	2076.27	2081.27	18606.0
2014-12-17 07:00:00	ES	Futures	2081.53	2085.48	2077.06	2078.9	37862.0
2014-12-17 08:00:00	ES	Futures	2078.9	2082.06	2076.27	2076.79	50224.0
2014-12-17 09:00:00	ES	Futures	2076.79	2086.79	2071.79	2085.22	280743.0
2014-12-17 10:00:00	ES	Futures	2085.22	2086.0	2076.0	2081.79	287577.0
2014-12-17 11:00:00	ES	Futures	2082.06	2099.43	2081.27	2098.11	239447.0
2014-12-17 12:00:00	ES	Futures	2098.11	2098.37	2087.32	2091.79	168504.0
2014-12-17 13:00:00	ES	Futures	2091.53	2096.79	2089.43	2096.27	109336.0
2014-12-17 14:00:00	ES	Futures	2096.27	2113.37	2094.16	2096.53	486706.0
2014-12-17 15:00:00	ES	Futures	2096.79	2116.79	2089.69	2112.06	422517.0
2014-12-17 16:00:00	ES	Futures	2112.32	2114.95	2110.48	2113.11	85702.0
2014-12-17 17:00:00	ES	Futures	2113.11	2114.16	2113.11	2113.64	2706.0
2014-12-17 18:00:00	ES	Futures	2113.64	2114.95	2112.06	2112.32	6006.0
2014-12-17 19:00:00	ES	Futures	2112.32	2114.95	2112.06	2113.37	6051.0
2014-12-17 20:00:00	ES	Futures	2113.37	2115.48	2113.11	2115.21	5020.0
2014-12-17 21:00:00	ES	Futures	2115.21	2115.48	2113.11	2113.9	3549.0
2014-12-17 22:00:00	ES	Futures	2113.64	2115.21	2113.64	2114.43	2542.0
2014-12-17 23:00:00	ES	Futures	2114.43	2114.43	2112.06	2112.06	1833.0
2014-12-17 00:00:00	NQ	Futures	4808.27	4813.55	4806.21	4812.08	724.0
2014-12-17 01:00:00	NQ	Futures	4811.5	4815.9	4808.56	4815.61	477.0
2014-12-17 02:00:00	NQ	Futures	4815.31	4818.84	4810.32	4814.43	2420.0
2014-12-17 03:00:00	NQ	Futures	4814.43	4820.31	4807.68	4815.61	6641.0
2014-12-17 04:00:00	NQ	Futures	4815.31	4823.54	4810.91	4819.13	3757.0
2014-12-17 05:00:00	NQ	Futures	4819.13	4827.65	4817.66	4820.31	3461.0
2014-12-17 06:00:00	NQ	Futures	4820.6	4828.82	4813.55	4827.06	3378.0
2014-12-17 07:00:00	NQ	Futures	4827.36	4836.17	4818.25	4822.36	8039.0
2014-12-17 08:00:00	NQ	Futures	4822.07	4829.12	4812.38	4812.67	10707.0
2014-12-17 09:00:00	NQ	Futures	4812.97	4828.82	4798.28	4827.36	63205.0
2014-12-17 10:00:00	NQ	Futures	4827.06	4832.06	4806.5	4810.32	55490.0
2014-12-17 11:00:00	NQ	Futures	4810.32	4854.67	4810.03	4852.32	42290.0
2014-12-17 12:00:00	NQ	Futures	4852.32	4853.2	4822.95	4832.94	34883.0
2014-12-17 13:00:00	NQ	Futures	4832.35	4847.62	4826.48	4847.03	19129.0
2014-12-17 14:00:00	NQ	Futures	4847.03	4884.33	4842.04	4857.9	106710.0
2014-12-17 15:00:00	NQ	Futures	4857.9	4902.25	4840.28	4887.27	80509.0
2014-12-17 16:00:00	NQ	Futures	4887.27	4892.26	4881.39	4886.97	17683.0
2014-12-17 17:00:00	NQ	Futures	4886.68	4888.74	4885.51	4887.27	379.0
2014-12-17 18:00:00	NQ	Futures	4886.39	4890.79	4883.45	4884.33	586.0
2014-12-17 19:00:00	NQ	Futures	4884.92	4890.21	4883.74	4886.39	816.0
2014-12-17 20:00:00	NQ	Futures	4886.39	4891.97	4886.09	4889.32	1600.0
2014-12-17 21:00:00	NQ	Futures	4889.32	4889.91	4882.86	4885.51	1315.0
2014-12-17 22:00:00	NQ	Futures	4885.21	4888.15	4884.04	4884.92	779.0
2014-12-17 23:00:00	NQ	Futures	4884.92	4885.21	4880.22	4880.22	471.0
2014-12-17 00:00:00	YM	Futures	17786.6	17802.3	17776.2	17798.1	1095.0
2014-12-17 01:00:00	YM	Futures	17797.1	17814.8	17788.7	17813.8	531.0

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

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