PREVIEW / futures_1hour / 2012-03-07

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-07.parquet
  size:    48 KB
  rows:    1,479

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-03-07 00:00:00	ES	Futures	1355.19	1355.95	1354.44	1355.95	6020.0
2012-03-07 01:00:00	ES	Futures	1355.95	1356.96	1355.19	1356.2	4947.0
2012-03-07 02:00:00	ES	Futures	1355.95	1357.71	1355.7	1357.46	12312.0
2012-03-07 03:00:00	ES	Futures	1357.46	1358.72	1355.19	1356.96	53462.0
2012-03-07 04:00:00	ES	Futures	1357.21	1358.97	1356.2	1357.96	33668.0
2012-03-07 05:00:00	ES	Futures	1358.22	1359.73	1357.21	1359.48	28203.0
2012-03-07 06:00:00	ES	Futures	1359.22	1359.22	1357.96	1358.97	17968.0
2012-03-07 07:00:00	ES	Futures	1358.72	1358.97	1356.96	1358.22	37945.0
2012-03-07 08:00:00	ES	Futures	1358.22	1359.98	1356.96	1359.48	68202.0
2012-03-07 09:00:00	ES	Futures	1359.48	1359.98	1354.94	1357.46	233228.0
2012-03-07 10:00:00	ES	Futures	1357.46	1358.22	1355.19	1357.21	229079.0
2012-03-07 11:00:00	ES	Futures	1357.21	1362.5	1357.21	1362.0	310530.0
2012-03-07 12:00:00	ES	Futures	1362.25	1363.26	1360.74	1362.75	131406.0
2012-03-07 13:00:00	ES	Futures	1362.75	1363.26	1360.23	1361.74	111056.0
2012-03-07 14:00:00	ES	Futures	1361.74	1363.76	1360.99	1363.26	127817.0
2012-03-07 15:00:00	ES	Futures	1363.26	1365.02	1361.24	1363.0	203230.0
2012-03-07 16:00:00	ES	Futures	1363.0	1364.01	1362.0	1362.5	72358.0
2012-03-07 17:00:00	ES	Futures	1362.25	1363.26	1362.25	1362.5	2675.0
2012-03-07 18:00:00	ES	Futures	1363.0	1363.26	1362.25	1362.5	3879.0
2012-03-07 19:00:00	ES	Futures	1362.5	1363.0	1361.24	1362.5	6295.0
2012-03-07 20:00:00	ES	Futures	1362.5	1363.26	1362.0	1362.75	3992.0
2012-03-07 21:00:00	ES	Futures	1362.5	1363.51	1362.5	1363.51	3556.0
2012-03-07 22:00:00	ES	Futures	1363.51	1366.53	1363.26	1365.52	12715.0
2012-03-07 23:00:00	ES	Futures	1365.77	1366.03	1365.02	1365.52	2679.0
2012-03-07 00:00:00	NQ	Futures	2996.86	2998.88	2995.71	2998.88	204.0
2012-03-07 01:00:00	NQ	Futures	2998.59	3000.61	2997.15	2998.02	337.0
2012-03-07 02:00:00	NQ	Futures	2997.73	3000.04	2997.15	2999.46	818.0
2012-03-07 03:00:00	NQ	Futures	2999.46	3003.21	2995.99	2999.46	3570.0
2012-03-07 04:00:00	NQ	Futures	2999.46	3003.5	2998.02	3002.06	1840.0
2012-03-07 05:00:00	NQ	Futures	3001.77	3006.97	3000.33	3006.39	2080.0
2012-03-07 06:00:00	NQ	Futures	3006.1	3006.68	3003.21	3006.39	2375.0
2012-03-07 07:00:00	NQ	Futures	3006.1	3008.41	3002.93	3004.95	7490.0
2012-03-07 08:00:00	NQ	Futures	3004.95	3008.41	3003.21	3007.26	8201.0
2012-03-07 09:00:00	NQ	Futures	3007.55	3008.99	2999.75	3006.39	32615.0
2012-03-07 10:00:00	NQ	Futures	3006.39	3008.12	3000.9	3005.24	27632.0
2012-03-07 11:00:00	NQ	Futures	3005.24	3015.34	3005.24	3015.34	27887.0
2012-03-07 12:00:00	NQ	Futures	3015.05	3020.25	3014.77	3019.1	18725.0
2012-03-07 13:00:00	NQ	Futures	3019.1	3020.25	3007.83	3012.74	32793.0
2012-03-07 14:00:00	NQ	Futures	3012.74	3018.23	3006.39	3009.86	27279.0
2012-03-07 15:00:00	NQ	Futures	3010.15	3018.81	3002.64	3014.19	33755.0
2012-03-07 16:00:00	NQ	Futures	3014.19	3015.34	3011.01	3011.59	6682.0
2012-03-07 17:00:00	NQ	Futures	3011.01	3012.17	3011.01	3011.3	65.0
2012-03-07 18:00:00	NQ	Futures	3011.3	3012.74	3010.72	3010.72	164.0
2012-03-07 19:00:00	NQ	Futures	3011.3	3012.17	3008.7	3010.72	322.0
2012-03-07 20:00:00	NQ	Futures	3010.72	3012.17	3010.15	3010.72	204.0
2012-03-07 21:00:00	NQ	Futures	3010.72	3012.74	3010.72	3012.46	102.0
2012-03-07 22:00:00	NQ	Futures	3012.46	3020.83	3012.17	3017.94	1121.0
2012-03-07 23:00:00	NQ	Futures	3017.94	3018.52	3015.05	3016.5	402.0
2012-03-07 00:00:00	YM	Futures	12654.8	12663.7	12648.9	12661.8	360.0
2012-03-07 01:00:00	YM	Futures	12661.8	12669.7	12656.8	12661.8	252.0

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

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