PREVIEW / futures_1hour / 2012-05-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-15.parquet
  size:    50 KB
  rows:    1,528

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-15 00:00:00	ES	Futures	1353.47	1354.23	1352.71	1353.47	2333.0
2012-05-15 01:00:00	ES	Futures	1353.47	1355.74	1353.47	1355.74	5770.0
2012-05-15 02:00:00	ES	Futures	1355.74	1358.02	1354.98	1357.77	15677.0
2012-05-15 03:00:00	ES	Futures	1357.51	1363.08	1357.26	1361.81	53446.0
2012-05-15 04:00:00	ES	Futures	1361.81	1361.81	1355.49	1356.76	39475.0
2012-05-15 05:00:00	ES	Futures	1356.76	1359.28	1356.25	1358.78	24051.0
2012-05-15 06:00:00	ES	Futures	1358.78	1359.79	1356.5	1356.76	24524.0
2012-05-15 07:00:00	ES	Futures	1356.76	1358.02	1355.49	1358.02	31861.0
2012-05-15 08:00:00	ES	Futures	1358.02	1360.3	1352.71	1352.71	100972.0
2012-05-15 09:00:00	ES	Futures	1352.96	1355.24	1346.38	1352.96	410839.0
2012-05-15 10:00:00	ES	Futures	1353.21	1357.51	1351.19	1353.72	315082.0
2012-05-15 11:00:00	ES	Futures	1353.72	1357.51	1348.66	1356.5	291839.0
2012-05-15 12:00:00	ES	Futures	1356.5	1358.53	1353.72	1354.23	146572.0
2012-05-15 13:00:00	ES	Futures	1354.23	1355.74	1349.42	1350.43	141150.0
2012-05-15 14:00:00	ES	Futures	1350.43	1354.23	1348.91	1349.42	156165.0
2012-05-15 15:00:00	ES	Futures	1349.42	1349.67	1341.32	1343.6	482596.0
2012-05-15 16:00:00	ES	Futures	1343.6	1346.64	1343.35	1345.12	103553.0
2012-05-15 17:00:00	ES	Futures	1345.37	1346.38	1344.86	1346.38	2289.0
2012-05-15 18:00:00	ES	Futures	1346.38	1347.65	1345.37	1346.38	6375.0
2012-05-15 19:00:00	ES	Futures	1346.38	1347.9	1346.38	1347.39	4181.0
2012-05-15 20:00:00	ES	Futures	1347.14	1348.41	1345.37	1346.89	8219.0
2012-05-15 21:00:00	ES	Futures	1346.64	1347.14	1344.86	1345.37	6259.0
2012-05-15 22:00:00	ES	Futures	1345.62	1345.88	1344.11	1345.37	5259.0
2012-05-15 23:00:00	ES	Futures	1345.12	1345.37	1341.83	1342.33	12020.0
2012-05-15 00:00:00	NQ	Futures	2996.99	2997.56	2994.96	2994.96	461.0
2012-05-15 01:00:00	NQ	Futures	2995.83	3000.46	2995.83	3000.46	345.0
2012-05-15 02:00:00	NQ	Futures	3000.46	3006.24	3000.17	3006.24	1172.0
2012-05-15 03:00:00	NQ	Futures	3005.66	3020.41	3005.37	3018.1	6787.0
2012-05-15 04:00:00	NQ	Futures	3017.81	3017.81	3005.08	3007.69	3804.0
2012-05-15 05:00:00	NQ	Futures	3008.26	3013.47	3006.53	3012.6	2439.0
2012-05-15 06:00:00	NQ	Futures	3012.89	3016.36	3009.42	3010.0	2658.0
2012-05-15 07:00:00	NQ	Futures	3009.71	3012.89	3006.24	3012.89	3755.0
2012-05-15 08:00:00	NQ	Futures	3012.6	3017.52	3002.48	3003.06	9141.0
2012-05-15 09:00:00	NQ	Futures	3003.06	3008.84	2993.23	3002.19	53571.0
2012-05-15 10:00:00	NQ	Futures	3002.48	3016.36	2995.54	3011.16	54661.0
2012-05-15 11:00:00	NQ	Futures	3011.16	3020.41	2997.27	3016.65	35234.0
2012-05-15 12:00:00	NQ	Futures	3016.94	3026.48	3014.92	3016.65	27079.0
2012-05-15 13:00:00	NQ	Futures	3016.94	3020.12	3002.48	3007.11	20746.0
2012-05-15 14:00:00	NQ	Futures	3007.4	3016.65	3000.74	3001.9	23282.0
2012-05-15 15:00:00	NQ	Futures	3001.9	3001.9	2978.19	2983.68	69952.0
2012-05-15 16:00:00	NQ	Futures	2983.97	2989.18	2982.24	2985.13	6941.0
2012-05-15 17:00:00	NQ	Futures	2984.84	2986.28	2984.26	2986.28	212.0
2012-05-15 18:00:00	NQ	Futures	2988.02	2990.04	2986.28	2987.73	390.0
2012-05-15 19:00:00	NQ	Futures	2988.02	2989.18	2987.44	2988.02	596.0
2012-05-15 20:00:00	NQ	Futures	2988.02	2989.76	2982.53	2986.86	1458.0
2012-05-15 21:00:00	NQ	Futures	2986.86	2988.31	2982.81	2983.68	1246.0
2012-05-15 22:00:00	NQ	Futures	2983.68	2984.55	2981.08	2983.39	469.0
2012-05-15 23:00:00	NQ	Futures	2983.39	2983.39	2975.87	2976.74	1217.0
2012-05-15 00:00:00	YM	Futures	12638.1	12643.0	12634.1	12636.1	152.0
2012-05-15 01:00:00	YM	Futures	12638.1	12656.0	12638.1	12655.0	343.0

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

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