PREVIEW / futures_1hour / 2011-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-21.parquet
  size:    35 KB
  rows:    998

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
2011-02-21 00:00:00	ES	Futures	1326.46	1326.95	1325.71	1326.95	3021.0
2011-02-21 01:00:00	ES	Futures	1326.95	1327.94	1326.7	1326.95	2275.0
2011-02-21 02:00:00	ES	Futures	1326.95	1328.19	1326.7	1327.2	7199.0
2011-02-21 03:00:00	ES	Futures	1327.2	1328.44	1325.96	1328.19	11677.0
2011-02-21 04:00:00	ES	Futures	1328.19	1328.68	1324.23	1324.48	24607.0
2011-02-21 05:00:00	ES	Futures	1324.23	1325.22	1323.73	1323.98	18204.0
2011-02-21 06:00:00	ES	Futures	1324.23	1325.47	1323.73	1325.22	7103.0
2011-02-21 07:00:00	ES	Futures	1325.22	1325.96	1324.72	1325.71	6816.0
2011-02-21 08:00:00	ES	Futures	1325.71	1325.71	1324.23	1324.97	7997.0
2011-02-21 09:00:00	ES	Futures	1324.97	1325.22	1322.75	1323.24	17987.0
2011-02-21 10:00:00	ES	Futures	1322.99	1323.24	1317.05	1318.04	67637.0
2011-02-21 11:00:00	ES	Futures	1318.04	1318.04	1315.32	1316.31	34928.0
2011-02-21 18:00:00	ES	Futures	1314.83	1316.56	1313.1	1313.1	30417.0
2011-02-21 19:00:00	ES	Futures	1313.1	1314.33	1312.35	1313.59	21108.0
2011-02-21 20:00:00	ES	Futures	1313.84	1314.83	1313.34	1313.59	8648.0
2011-02-21 21:00:00	ES	Futures	1313.84	1314.33	1313.59	1314.09	6190.0
2011-02-21 22:00:00	ES	Futures	1314.09	1314.83	1313.1	1313.34	5582.0
2011-02-21 23:00:00	ES	Futures	1313.34	1313.84	1312.35	1313.34	4075.0
2011-02-21 00:00:00	NQ	Futures	2741.45	2742.31	2740.01	2742.31	253.0
2011-02-21 01:00:00	NQ	Futures	2742.31	2744.89	2741.45	2743.46	142.0
2011-02-21 02:00:00	NQ	Futures	2743.17	2746.33	2743.17	2744.89	688.0
2011-02-21 03:00:00	NQ	Futures	2744.6	2746.04	2741.45	2745.75	868.0
2011-02-21 04:00:00	NQ	Futures	2746.04	2747.47	2737.14	2737.43	1411.0
2011-02-21 05:00:00	NQ	Futures	2737.43	2740.3	2736.57	2737.14	939.0
2011-02-21 06:00:00	NQ	Futures	2737.14	2740.01	2736.85	2739.72	576.0
2011-02-21 07:00:00	NQ	Futures	2739.72	2740.87	2738.29	2740.87	277.0
2011-02-21 08:00:00	NQ	Futures	2741.16	2741.16	2736.57	2737.43	1290.0
2011-02-21 09:00:00	NQ	Futures	2737.43	2737.43	2731.69	2733.98	4856.0
2011-02-21 10:00:00	NQ	Futures	2733.98	2734.27	2713.89	2719.92	6420.0
2011-02-21 11:00:00	NQ	Futures	2720.21	2720.21	2716.19	2719.35	3697.0
2011-02-21 18:00:00	NQ	Futures	2719.06	2720.21	2712.17	2712.17	1798.0
2011-02-21 19:00:00	NQ	Futures	2712.17	2715.9	2709.3	2712.17	2365.0
2011-02-21 20:00:00	NQ	Futures	2712.46	2715.04	2711.31	2712.17	1232.0
2011-02-21 21:00:00	NQ	Futures	2712.17	2713.89	2711.6	2712.46	447.0
2011-02-21 22:00:00	NQ	Futures	2712.74	2714.18	2711.6	2712.74	290.0
2011-02-21 23:00:00	NQ	Futures	2712.46	2713.32	2710.45	2712.46	274.0
2011-02-21 00:00:00	YM	Futures	11835.3	11838.2	11831.5	11838.2	115.0
2011-02-21 01:00:00	YM	Futures	11839.1	11844.9	11837.2	11840.1	119.0
2011-02-21 02:00:00	YM	Futures	11840.1	11851.6	11839.1	11843.9	918.0
2011-02-21 03:00:00	YM	Futures	11844.9	11847.8	11833.4	11845.9	909.0
2011-02-21 04:00:00	YM	Futures	11847.8	11850.6	11825.7	11827.7	1642.0
2011-02-21 05:00:00	YM	Futures	11825.7	11833.4	11821.9	11825.7	1549.0
2011-02-21 06:00:00	YM	Futures	11825.7	11834.4	11823.8	11834.4	454.0
2011-02-21 07:00:00	YM	Futures	11834.4	11837.2	11831.5	11835.3	276.0
2011-02-21 08:00:00	YM	Futures	11835.3	11835.3	11827.7	11831.5	368.0
2011-02-21 09:00:00	YM	Futures	11830.5	11833.4	11816.2	11819.0	1293.0
2011-02-21 10:00:00	YM	Futures	11819.0	11819.0	11781.7	11790.3	5365.0
2011-02-21 11:00:00	YM	Futures	11789.3	11789.3	11775.9	11782.6	1350.0
2011-02-21 18:00:00	YM	Futures	11772.1	11779.8	11759.7	11762.5	2070.0
2011-02-21 19:00:00	YM	Futures	11762.5	11769.2	11755.8	11765.4	715.0

> showing 50 of 998 rows — these rows as CSV

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