PREVIEW / futures_1hour / 2011-09-08

all futures 1-hour files

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

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
2011-09-08 00:00:00	ES	Futures	1191.91	1194.9	1191.66	1193.65	3533.0
2011-09-08 01:00:00	ES	Futures	1193.65	1193.9	1190.41	1191.41	6005.0
2011-09-08 02:00:00	ES	Futures	1191.16	1193.16	1189.91	1190.91	12082.0
2011-09-08 03:00:00	ES	Futures	1190.91	1194.4	1188.42	1191.41	41836.0
2011-09-08 04:00:00	ES	Futures	1191.16	1196.15	1190.41	1195.65	28126.0
2011-09-08 05:00:00	ES	Futures	1195.65	1199.64	1195.4	1199.39	25874.0
2011-09-08 06:00:00	ES	Futures	1199.39	1199.39	1194.65	1197.4	19726.0
2011-09-08 07:00:00	ES	Futures	1197.65	1198.14	1190.16	1191.41	44734.0
2011-09-08 08:00:00	ES	Futures	1191.41	1191.91	1183.18	1186.92	114220.0
2011-09-08 09:00:00	ES	Futures	1186.67	1195.15	1185.42	1189.42	238392.0
2011-09-08 10:00:00	ES	Futures	1189.17	1199.39	1185.42	1198.64	249769.0
2011-09-08 11:00:00	ES	Futures	1198.89	1200.89	1190.66	1191.91	197288.0
2011-09-08 12:00:00	ES	Futures	1191.91	1195.15	1189.42	1194.9	95237.0
2011-09-08 13:00:00	ES	Futures	1194.65	1195.65	1182.43	1185.67	154088.0
2011-09-08 14:00:00	ES	Futures	1185.67	1188.67	1181.68	1184.68	122235.0
2011-09-08 15:00:00	ES	Futures	1184.93	1187.67	1179.19	1181.93	172705.0
2011-09-08 16:00:00	ES	Futures	1181.93	1183.93	1180.44	1182.68	55627.0
2011-09-08 17:00:00	ES	Futures	1182.68	1183.93	1182.18	1182.18	1481.0
2011-09-08 18:00:00	ES	Futures	1182.43	1185.67	1181.93	1185.18	4519.0
2011-09-08 19:00:00	ES	Futures	1185.18	1186.67	1175.45	1179.94	19130.0
2011-09-08 20:00:00	ES	Futures	1180.19	1186.92	1179.19	1183.68	9142.0
2011-09-08 21:00:00	ES	Futures	1183.68	1190.41	1183.68	1190.41	8664.0
2011-09-08 22:00:00	ES	Futures	1190.41	1191.16	1188.67	1190.16	5361.0
2011-09-08 23:00:00	ES	Futures	1190.16	1190.41	1187.17	1187.92	3148.0
2011-09-08 00:00:00	NQ	Futures	2551.61	2557.95	2551.61	2554.2	317.0
2011-09-08 01:00:00	NQ	Futures	2554.2	2554.49	2548.74	2549.89	866.0
2011-09-08 02:00:00	NQ	Futures	2550.18	2554.2	2548.16	2552.19	1195.0
2011-09-08 03:00:00	NQ	Futures	2551.9	2557.37	2545.57	2552.19	3446.0
2011-09-08 04:00:00	NQ	Futures	2551.61	2562.26	2550.18	2560.82	1631.0
2011-09-08 05:00:00	NQ	Futures	2561.97	2571.18	2561.4	2569.74	1697.0
2011-09-08 06:00:00	NQ	Futures	2569.74	2570.61	2561.11	2565.72	1136.0
2011-09-08 07:00:00	NQ	Futures	2566.87	2567.44	2552.48	2554.2	3444.0
2011-09-08 08:00:00	NQ	Futures	2554.2	2555.07	2538.38	2546.44	11075.0
2011-09-08 09:00:00	NQ	Futures	2546.44	2563.7	2543.27	2552.77	34431.0
2011-09-08 10:00:00	NQ	Futures	2552.77	2579.82	2543.85	2578.95	34210.0
2011-09-08 11:00:00	NQ	Futures	2578.95	2582.98	2559.67	2561.97	28285.0
2011-09-08 12:00:00	NQ	Futures	2561.69	2568.31	2554.78	2566.0	15820.0
2011-09-08 13:00:00	NQ	Futures	2566.29	2568.59	2544.13	2551.9	25693.0
2011-09-08 14:00:00	NQ	Futures	2551.9	2558.52	2544.13	2552.19	17936.0
2011-09-08 15:00:00	NQ	Futures	2552.48	2557.95	2538.67	2546.72	25393.0
2011-09-08 16:00:00	NQ	Futures	2546.72	2553.05	2545.28	2547.87	6330.0
2011-09-08 17:00:00	NQ	Futures	2547.87	2550.18	2547.01	2549.02	135.0
2011-09-08 18:00:00	NQ	Futures	2548.45	2553.92	2546.44	2552.77	164.0
2011-09-08 19:00:00	NQ	Futures	2552.77	2555.07	2536.08	2544.42	393.0
2011-09-08 20:00:00	NQ	Futures	2544.71	2558.23	2543.56	2551.04	461.0
2011-09-08 21:00:00	NQ	Futures	2551.33	2563.13	2551.04	2562.84	706.0
2011-09-08 22:00:00	NQ	Futures	2562.55	2564.28	2559.38	2562.84	385.0
2011-09-08 23:00:00	NQ	Futures	2562.55	2562.55	2556.79	2559.1	222.0
2011-09-08 00:00:00	YM	Futures	11016.5	11036.8	11015.5	11030.1	263.0
2011-09-08 01:00:00	YM	Futures	11029.1	11030.1	11005.9	11010.7	353.0

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

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