PREVIEW / futures_1hour / 2012-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-27.parquet
  size:    48 KB
  rows:    1,453

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
2012-02-27 00:00:00	ES	Futures	1372.07	1373.08	1371.57	1371.82	3988.0
2012-02-27 01:00:00	ES	Futures	1372.07	1372.58	1369.81	1370.06	4741.0
2012-02-27 02:00:00	ES	Futures	1370.06	1372.83	1369.55	1371.82	12473.0
2012-02-27 03:00:00	ES	Futures	1372.07	1372.07	1366.28	1367.54	41046.0
2012-02-27 04:00:00	ES	Futures	1367.54	1368.55	1366.53	1367.54	25886.0
2012-02-27 05:00:00	ES	Futures	1367.54	1368.8	1366.28	1366.53	20941.0
2012-02-27 06:00:00	ES	Futures	1366.53	1368.04	1366.03	1367.29	16163.0
2012-02-27 07:00:00	ES	Futures	1367.03	1368.8	1367.03	1368.04	21606.0
2012-02-27 08:00:00	ES	Futures	1368.29	1368.55	1367.03	1367.79	34176.0
2012-02-27 09:00:00	ES	Futures	1368.04	1368.04	1363.76	1366.78	214802.0
2012-02-27 10:00:00	ES	Futures	1366.78	1374.09	1366.53	1372.83	376268.0
2012-02-27 11:00:00	ES	Futures	1372.83	1378.63	1372.83	1377.11	274073.0
2012-02-27 12:00:00	ES	Futures	1376.86	1380.64	1375.85	1378.88	153704.0
2012-02-27 13:00:00	ES	Futures	1378.88	1379.13	1376.86	1377.37	60055.0
2012-02-27 14:00:00	ES	Futures	1377.37	1379.13	1377.11	1378.88	56990.0
2012-02-27 15:00:00	ES	Futures	1378.88	1381.65	1376.86	1377.37	264541.0
2012-02-27 16:00:00	ES	Futures	1377.37	1378.63	1376.36	1377.62	57137.0
2012-02-27 17:00:00	ES	Futures	1377.87	1378.12	1377.37	1377.62	1734.0
2012-02-27 18:00:00	ES	Futures	1377.87	1378.88	1377.37	1378.12	7801.0
2012-02-27 19:00:00	ES	Futures	1378.12	1379.38	1377.37	1377.87	5074.0
2012-02-27 20:00:00	ES	Futures	1377.87	1379.38	1377.37	1378.63	3533.0
2012-02-27 21:00:00	ES	Futures	1378.88	1379.13	1378.12	1378.63	1917.0
2012-02-27 22:00:00	ES	Futures	1378.63	1378.88	1377.62	1378.63	2221.0
2012-02-27 23:00:00	ES	Futures	1378.37	1380.39	1377.37	1379.89	6563.0
2012-02-27 00:00:00	NQ	Futures	3002.35	3003.5	3001.48	3001.77	124.0
2012-02-27 01:00:00	NQ	Futures	3002.35	3002.64	2997.15	2997.15	513.0
2012-02-27 02:00:00	NQ	Futures	2997.15	3002.93	2996.86	3000.61	833.0
2012-02-27 03:00:00	NQ	Futures	3001.19	3001.48	2989.35	2992.53	2996.0
2012-02-27 04:00:00	NQ	Futures	2992.24	2994.26	2988.49	2991.66	1307.0
2012-02-27 05:00:00	NQ	Futures	2991.66	2993.68	2987.91	2989.06	2018.0
2012-02-27 06:00:00	NQ	Futures	2988.49	2994.26	2988.2	2992.24	2943.0
2012-02-27 07:00:00	NQ	Futures	2991.95	2994.84	2991.95	2993.97	1329.0
2012-02-27 08:00:00	NQ	Futures	2993.68	2995.99	2992.24	2993.68	2848.0
2012-02-27 09:00:00	NQ	Futures	2993.97	2994.26	2978.95	2987.04	34941.0
2012-02-27 10:00:00	NQ	Futures	2987.33	3008.99	2986.75	3005.24	44130.0
2012-02-27 11:00:00	NQ	Futures	3004.95	3019.1	3004.37	3013.9	39516.0
2012-02-27 12:00:00	NQ	Futures	3013.61	3020.54	3011.59	3017.94	17471.0
2012-02-27 13:00:00	NQ	Futures	3017.94	3018.23	3009.86	3010.43	9400.0
2012-02-27 14:00:00	NQ	Futures	3010.72	3018.52	3010.43	3017.94	10261.0
2012-02-27 15:00:00	NQ	Futures	3017.94	3022.85	3011.59	3012.74	31490.0
2012-02-27 16:00:00	NQ	Futures	3013.03	3016.5	3012.17	3013.9	5197.0
2012-02-27 17:00:00	NQ	Futures	3013.9	3014.19	3013.32	3013.32	62.0
2012-02-27 18:00:00	NQ	Futures	3013.03	3014.77	3012.74	3013.9	329.0
2012-02-27 19:00:00	NQ	Futures	3013.9	3015.63	3012.74	3013.03	287.0
2012-02-27 20:00:00	NQ	Futures	3013.03	3015.63	3013.03	3015.05	166.0
2012-02-27 21:00:00	NQ	Futures	3014.77	3015.63	3014.48	3014.77	129.0
2012-02-27 22:00:00	NQ	Futures	3014.48	3015.34	3013.32	3015.34	141.0
2012-02-27 23:00:00	NQ	Futures	3014.77	3017.65	3013.32	3017.08	342.0
2012-02-27 00:00:00	YM	Futures	12833.2	12837.2	12827.3	12829.3	171.0
2012-02-27 01:00:00	YM	Futures	12831.2	12833.2	12814.4	12814.4	230.0

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

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