PREVIEW / futures_1hour / 2012-05-14

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-14.parquet
  size:    48 KB
  rows:    1,468

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-05-14 00:00:00	ES	Futures	1363.84	1364.09	1362.07	1362.07	2011.0
2012-05-14 01:00:00	ES	Futures	1362.32	1363.59	1361.56	1362.32	4970.0
2012-05-14 02:00:00	ES	Futures	1362.07	1364.09	1360.55	1361.06	10602.0
2012-05-14 03:00:00	ES	Futures	1361.06	1362.07	1356.5	1357.51	57949.0
2012-05-14 04:00:00	ES	Futures	1357.51	1357.77	1352.45	1353.47	66480.0
2012-05-14 05:00:00	ES	Futures	1353.21	1357.01	1352.71	1354.98	32601.0
2012-05-14 06:00:00	ES	Futures	1354.98	1356.25	1352.71	1352.71	26172.0
2012-05-14 07:00:00	ES	Futures	1352.71	1356.25	1351.7	1355.74	31618.0
2012-05-14 08:00:00	ES	Futures	1355.74	1356.5	1352.71	1354.48	43879.0
2012-05-14 09:00:00	ES	Futures	1354.48	1356.5	1350.43	1353.21	275261.0
2012-05-14 10:00:00	ES	Futures	1352.96	1355.49	1349.17	1353.72	334456.0
2012-05-14 11:00:00	ES	Futures	1353.72	1359.79	1352.71	1357.01	297672.0
2012-05-14 12:00:00	ES	Futures	1357.01	1358.78	1356.0	1357.51	80221.0
2012-05-14 13:00:00	ES	Futures	1357.77	1360.8	1354.98	1359.28	134891.0
2012-05-14 14:00:00	ES	Futures	1359.54	1360.55	1353.72	1354.48	113488.0
2012-05-14 15:00:00	ES	Futures	1354.73	1355.24	1350.94	1351.95	242952.0
2012-05-14 16:00:00	ES	Futures	1351.95	1351.95	1348.15	1349.67	107648.0
2012-05-14 17:00:00	ES	Futures	1349.67	1351.44	1349.67	1350.18	3598.0
2012-05-14 18:00:00	ES	Futures	1350.43	1352.96	1350.18	1352.45	6111.0
2012-05-14 19:00:00	ES	Futures	1352.45	1353.97	1352.45	1353.21	5613.0
2012-05-14 20:00:00	ES	Futures	1353.21	1354.23	1352.71	1352.96	7419.0
2012-05-14 21:00:00	ES	Futures	1353.21	1353.21	1349.92	1352.2	10121.0
2012-05-14 22:00:00	ES	Futures	1352.45	1353.97	1351.7	1353.47	7225.0
2012-05-14 23:00:00	ES	Futures	1353.47	1354.23	1352.45	1353.72	4221.0
2012-05-14 00:00:00	NQ	Futures	3016.94	3017.23	3013.18	3013.18	221.0
2012-05-14 01:00:00	NQ	Futures	3013.47	3016.94	3012.31	3013.76	440.0
2012-05-14 02:00:00	NQ	Futures	3013.18	3017.52	3011.16	3012.89	1153.0
2012-05-14 03:00:00	NQ	Futures	3012.6	3014.63	3000.46	3003.06	5734.0
2012-05-14 04:00:00	NQ	Futures	3003.06	3003.06	2990.33	2992.36	4771.0
2012-05-14 05:00:00	NQ	Futures	2991.78	3000.46	2990.91	2995.83	3301.0
2012-05-14 06:00:00	NQ	Futures	2995.83	2999.01	2992.36	2992.36	1854.0
2012-05-14 07:00:00	NQ	Futures	2992.36	3000.17	2990.04	2998.43	3176.0
2012-05-14 08:00:00	NQ	Futures	2998.72	3001.32	2993.23	2996.7	5149.0
2012-05-14 09:00:00	NQ	Futures	2996.99	3004.79	2993.23	2999.59	41806.0
2012-05-14 10:00:00	NQ	Futures	2999.59	3005.08	2988.6	3001.03	56084.0
2012-05-14 11:00:00	NQ	Futures	3001.03	3016.65	2996.41	3010.87	31835.0
2012-05-14 12:00:00	NQ	Futures	3010.87	3014.63	3007.4	3009.13	13152.0
2012-05-14 13:00:00	NQ	Futures	3009.42	3016.94	3000.46	3012.89	18073.0
2012-05-14 14:00:00	NQ	Futures	3013.18	3017.23	2998.72	3000.74	16184.0
2012-05-14 15:00:00	NQ	Futures	3000.74	3002.48	2990.91	2992.94	30721.0
2012-05-14 16:00:00	NQ	Futures	2993.23	2994.96	2986.28	2990.04	6523.0
2012-05-14 17:00:00	NQ	Futures	2990.33	2993.8	2990.33	2992.07	141.0
2012-05-14 18:00:00	NQ	Futures	2991.78	2997.56	2991.2	2996.7	475.0
2012-05-14 19:00:00	NQ	Futures	2996.7	2998.43	2996.12	2997.85	254.0
2012-05-14 20:00:00	NQ	Futures	2997.85	2999.3	2996.12	2996.41	366.0
2012-05-14 21:00:00	NQ	Futures	2996.99	2996.99	2989.76	2994.38	1043.0
2012-05-14 22:00:00	NQ	Futures	2994.67	2997.56	2992.36	2996.41	578.0
2012-05-14 23:00:00	NQ	Futures	2996.12	2997.85	2994.96	2997.27	299.0
2012-05-14 00:00:00	YM	Futures	12721.7	12721.7	12708.8	12708.8	233.0
2012-05-14 01:00:00	YM	Futures	12708.8	12718.8	12702.8	12706.8	403.0

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

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