PREVIEW / futures_1hour / 2011-09-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-07.parquet
  size:    47 KB
  rows:    1,416

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-07 00:00:00	ES	Futures	1167.97	1168.71	1167.72	1168.22	1591.0
2011-09-07 01:00:00	ES	Futures	1168.22	1170.21	1167.97	1168.71	6639.0
2011-09-07 02:00:00	ES	Futures	1168.96	1173.95	1168.96	1173.7	30605.0
2011-09-07 03:00:00	ES	Futures	1173.45	1175.2	1169.21	1171.71	57440.0
2011-09-07 04:00:00	ES	Futures	1171.71	1176.7	1170.71	1172.46	65003.0
2011-09-07 05:00:00	ES	Futures	1172.7	1174.95	1169.71	1170.96	28255.0
2011-09-07 06:00:00	ES	Futures	1170.96	1177.69	1169.21	1175.95	34325.0
2011-09-07 07:00:00	ES	Futures	1175.95	1176.94	1172.7	1173.45	32969.0
2011-09-07 08:00:00	ES	Futures	1173.7	1177.69	1171.46	1177.19	53104.0
2011-09-07 09:00:00	ES	Futures	1177.19	1181.93	1174.95	1181.18	330750.0
2011-09-07 10:00:00	ES	Futures	1181.18	1183.18	1178.44	1180.69	310994.0
2011-09-07 11:00:00	ES	Futures	1180.69	1186.17	1179.94	1185.18	289227.0
2011-09-07 12:00:00	ES	Futures	1185.18	1188.42	1183.93	1187.17	218895.0
2011-09-07 13:00:00	ES	Futures	1187.17	1190.16	1186.42	1189.17	179394.0
2011-09-07 14:00:00	ES	Futures	1189.17	1195.15	1188.42	1194.15	207118.0
2011-09-07 15:00:00	ES	Futures	1194.15	1194.9	1189.17	1194.15	339057.0
2011-09-07 16:00:00	ES	Futures	1194.15	1198.14	1193.9	1196.4	145061.0
2011-09-07 17:00:00	ES	Futures	1196.4	1197.65	1195.9	1197.4	3297.0
2011-09-07 18:00:00	ES	Futures	1196.9	1199.14	1196.4	1198.39	5053.0
2011-09-07 19:00:00	ES	Futures	1198.39	1199.39	1197.4	1198.64	4365.0
2011-09-07 20:00:00	ES	Futures	1198.89	1198.89	1195.65	1196.4	10206.0
2011-09-07 21:00:00	ES	Futures	1196.15	1196.65	1193.65	1194.65	9369.0
2011-09-07 22:00:00	ES	Futures	1194.65	1195.9	1192.41	1192.91	8240.0
2011-09-07 23:00:00	ES	Futures	1192.91	1193.65	1191.16	1191.91	5963.0
2011-09-07 00:00:00	NQ	Futures	2505.28	2507.01	2505.0	2505.86	95.0
2011-09-07 01:00:00	NQ	Futures	2506.15	2509.03	2505.86	2507.59	420.0
2011-09-07 02:00:00	NQ	Futures	2507.3	2519.67	2507.01	2518.81	2835.0
2011-09-07 03:00:00	NQ	Futures	2519.1	2526.58	2509.89	2514.49	4722.0
2011-09-07 04:00:00	NQ	Futures	2514.49	2524.85	2512.48	2515.64	4351.0
2011-09-07 05:00:00	NQ	Futures	2515.07	2519.96	2507.87	2510.75	1805.0
2011-09-07 06:00:00	NQ	Futures	2511.33	2523.41	2507.01	2519.67	2139.0
2011-09-07 07:00:00	NQ	Futures	2519.67	2522.26	2514.78	2516.22	2346.0
2011-09-07 08:00:00	NQ	Futures	2516.22	2526.0	2512.77	2526.0	4991.0
2011-09-07 09:00:00	NQ	Futures	2525.72	2536.94	2523.41	2533.2	43958.0
2011-09-07 10:00:00	NQ	Futures	2532.91	2534.92	2523.99	2526.87	38622.0
2011-09-07 11:00:00	NQ	Futures	2527.15	2540.97	2525.43	2538.95	31717.0
2011-09-07 12:00:00	NQ	Futures	2539.24	2543.27	2536.94	2540.39	17988.0
2011-09-07 13:00:00	NQ	Futures	2540.39	2549.02	2539.53	2545.0	22249.0
2011-09-07 14:00:00	NQ	Futures	2545.0	2558.52	2543.85	2557.37	24544.0
2011-09-07 15:00:00	NQ	Futures	2557.08	2558.81	2550.18	2558.52	33954.0
2011-09-07 16:00:00	NQ	Futures	2558.52	2562.26	2556.22	2559.96	11144.0
2011-09-07 17:00:00	NQ	Futures	2560.25	2561.97	2558.81	2561.4	220.0
2011-09-07 18:00:00	NQ	Futures	2560.54	2565.43	2560.25	2564.85	320.0
2011-09-07 19:00:00	NQ	Futures	2564.85	2565.43	2563.13	2564.85	244.0
2011-09-07 20:00:00	NQ	Futures	2565.14	2565.14	2559.1	2559.96	385.0
2011-09-07 21:00:00	NQ	Futures	2559.96	2561.11	2555.07	2557.37	514.0
2011-09-07 22:00:00	NQ	Futures	2557.08	2559.67	2553.05	2553.92	523.0
2011-09-07 23:00:00	NQ	Futures	2553.63	2555.36	2550.18	2551.61	518.0
2011-09-07 00:00:00	YM	Futures	10825.7	10832.5	10825.7	10829.6	89.0
2011-09-07 01:00:00	YM	Futures	10829.6	10844.1	10826.7	10838.3	378.0

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

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