PREVIEW / futures_1hour / 2012-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-09.parquet
  size:    48 KB
  rows:    1,471

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-08-09 00:00:00	ES	Futures	1426.02	1427.04	1425.26	1426.78	5209.0
2012-08-09 01:00:00	ES	Futures	1426.78	1427.8	1425.0	1425.77	9707.0
2012-08-09 02:00:00	ES	Futures	1425.77	1427.8	1425.26	1426.53	8828.0
2012-08-09 03:00:00	ES	Futures	1426.53	1426.78	1422.97	1423.48	25457.0
2012-08-09 04:00:00	ES	Futures	1423.22	1423.73	1420.68	1422.21	22714.0
2012-08-09 05:00:00	ES	Futures	1422.46	1424.75	1421.7	1424.24	14180.0
2012-08-09 06:00:00	ES	Futures	1424.5	1424.5	1419.92	1420.68	23817.0
2012-08-09 07:00:00	ES	Futures	1420.68	1421.95	1417.63	1419.92	32781.0
2012-08-09 08:00:00	ES	Futures	1419.92	1421.95	1418.65	1420.94	47910.0
2012-08-09 09:00:00	ES	Futures	1420.94	1425.51	1419.16	1422.46	165700.0
2012-08-09 10:00:00	ES	Futures	1422.21	1426.78	1422.21	1426.02	178446.0
2012-08-09 11:00:00	ES	Futures	1425.77	1426.28	1419.16	1420.43	204183.0
2012-08-09 12:00:00	ES	Futures	1420.43	1424.5	1419.66	1424.5	100138.0
2012-08-09 13:00:00	ES	Futures	1424.5	1425.0	1422.97	1423.22	70232.0
2012-08-09 14:00:00	ES	Futures	1423.48	1425.77	1422.97	1424.75	49868.0
2012-08-09 15:00:00	ES	Futures	1424.75	1425.26	1422.21	1423.73	138615.0
2012-08-09 16:00:00	ES	Futures	1423.73	1425.0	1423.48	1424.24	54302.0
2012-08-09 17:00:00	ES	Futures	1424.24	1424.24	1422.97	1423.22	2100.0
2012-08-09 18:00:00	ES	Futures	1423.22	1424.75	1423.22	1424.5	2090.0
2012-08-09 19:00:00	ES	Futures	1424.5	1424.75	1422.46	1422.97	2220.0
2012-08-09 20:00:00	ES	Futures	1422.72	1422.97	1420.68	1421.44	7264.0
2012-08-09 21:00:00	ES	Futures	1421.44	1421.44	1420.17	1420.43	4501.0
2012-08-09 22:00:00	ES	Futures	1420.43	1420.68	1419.41	1420.43	4219.0
2012-08-09 23:00:00	ES	Futures	1420.43	1420.43	1418.14	1419.41	8695.0
2012-08-09 00:00:00	NQ	Futures	3153.08	3155.98	3151.63	3154.82	1018.0
2012-08-09 01:00:00	NQ	Futures	3155.11	3157.72	3151.92	3152.79	1596.0
2012-08-09 02:00:00	NQ	Futures	3152.79	3157.14	3152.5	3154.82	1287.0
2012-08-09 03:00:00	NQ	Futures	3154.24	3154.53	3146.7	3146.99	2623.0
2012-08-09 04:00:00	NQ	Futures	3146.7	3148.73	3142.35	3145.54	2027.0
2012-08-09 05:00:00	NQ	Futures	3145.54	3150.18	3144.96	3149.6	1306.0
2012-08-09 06:00:00	NQ	Futures	3149.89	3149.89	3140.9	3142.06	2388.0
2012-08-09 07:00:00	NQ	Futures	3142.06	3144.09	3134.82	3140.61	3921.0
2012-08-09 08:00:00	NQ	Futures	3140.61	3145.83	3138.29	3144.67	6200.0
2012-08-09 09:00:00	NQ	Futures	3144.96	3155.69	3140.32	3150.18	23281.0
2012-08-09 10:00:00	NQ	Futures	3150.47	3156.85	3149.6	3153.95	21836.0
2012-08-09 11:00:00	NQ	Futures	3153.95	3154.82	3136.85	3140.03	23660.0
2012-08-09 12:00:00	NQ	Futures	3140.32	3148.15	3138.29	3147.86	15167.0
2012-08-09 13:00:00	NQ	Futures	3148.15	3149.89	3145.83	3148.73	10046.0
2012-08-09 14:00:00	NQ	Futures	3148.44	3152.79	3146.7	3150.47	8355.0
2012-08-09 15:00:00	NQ	Futures	3150.47	3152.5	3146.99	3151.92	18539.0
2012-08-09 16:00:00	NQ	Futures	3151.92	3153.66	3150.76	3152.5	4828.0
2012-08-09 17:00:00	NQ	Futures	3151.34	3151.63	3149.31	3149.6	175.0
2012-08-09 18:00:00	NQ	Futures	3149.89	3151.92	3149.6	3151.92	199.0
2012-08-09 19:00:00	NQ	Futures	3151.92	3152.21	3147.57	3148.44	292.0
2012-08-09 20:00:00	NQ	Futures	3148.44	3148.44	3145.54	3146.12	585.0
2012-08-09 21:00:00	NQ	Futures	3146.12	3146.41	3144.96	3145.54	313.0
2012-08-09 22:00:00	NQ	Futures	3145.83	3146.41	3143.8	3145.25	504.0
2012-08-09 23:00:00	NQ	Futures	3145.25	3145.25	3140.9	3142.93	1717.0
2012-08-09 00:00:00	YM	Futures	13088.3	13099.3	13081.4	13096.3	927.0
2012-08-09 01:00:00	YM	Futures	13097.3	13111.2	13085.3	13089.3	2170.0

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

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