PREVIEW / futures_1hour / 2011-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-28.parquet
  size:    48 KB
  rows:    1,447

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-11-28 00:00:00	ES	Futures	1178.31	1180.57	1176.81	1180.57	7428.0
2011-11-28 01:00:00	ES	Futures	1180.57	1182.32	1178.81	1180.07	10010.0
2011-11-28 02:00:00	ES	Futures	1180.32	1182.07	1176.56	1178.56	16741.0
2011-11-28 03:00:00	ES	Futures	1178.56	1187.59	1176.81	1187.34	55456.0
2011-11-28 04:00:00	ES	Futures	1187.34	1191.1	1185.08	1190.6	54603.0
2011-11-28 05:00:00	ES	Futures	1190.85	1192.61	1187.84	1189.6	33061.0
2011-11-28 06:00:00	ES	Futures	1189.6	1190.35	1187.59	1189.6	20922.0
2011-11-28 07:00:00	ES	Futures	1189.85	1190.35	1187.09	1188.84	39678.0
2011-11-28 08:00:00	ES	Futures	1189.09	1192.1	1187.84	1191.35	61355.0
2011-11-28 09:00:00	ES	Futures	1191.35	1198.12	1190.85	1197.12	313265.0
2011-11-28 10:00:00	ES	Futures	1197.37	1199.88	1195.36	1196.12	330900.0
2011-11-28 11:00:00	ES	Futures	1196.12	1199.38	1195.61	1196.62	237499.0
2011-11-28 12:00:00	ES	Futures	1196.62	1197.37	1192.35	1193.11	187347.0
2011-11-28 13:00:00	ES	Futures	1193.11	1197.62	1192.1	1193.11	186939.0
2011-11-28 14:00:00	ES	Futures	1193.11	1196.87	1190.35	1191.6	174026.0
2011-11-28 15:00:00	ES	Futures	1191.6	1195.36	1186.09	1194.86	390875.0
2011-11-28 16:00:00	ES	Futures	1195.11	1196.37	1193.61	1194.61	125134.0
2011-11-28 17:00:00	ES	Futures	1194.61	1195.61	1194.61	1195.61	2177.0
2011-11-28 18:00:00	ES	Futures	1194.86	1195.36	1193.11	1193.61	9097.0
2011-11-28 19:00:00	ES	Futures	1193.61	1194.11	1190.35	1191.85	12527.0
2011-11-28 20:00:00	ES	Futures	1191.85	1193.36	1190.1	1190.35	8846.0
2011-11-28 21:00:00	ES	Futures	1190.35	1191.6	1189.85	1190.85	5357.0
2011-11-28 22:00:00	ES	Futures	1190.85	1194.61	1190.6	1193.86	5526.0
2011-11-28 23:00:00	ES	Futures	1193.86	1195.36	1192.86	1194.61	7554.0
2011-11-28 00:00:00	NQ	Futures	2521.96	2523.69	2517.92	2523.4	516.0
2011-11-28 01:00:00	NQ	Futures	2523.69	2526.86	2521.96	2523.97	737.0
2011-11-28 02:00:00	NQ	Futures	2523.69	2526.28	2517.06	2519.07	1311.0
2011-11-28 03:00:00	NQ	Futures	2519.94	2535.8	2514.75	2535.22	3739.0
2011-11-28 04:00:00	NQ	Futures	2535.51	2540.7	2530.89	2539.26	3684.0
2011-11-28 05:00:00	NQ	Futures	2539.83	2542.72	2534.93	2537.81	1554.0
2011-11-28 06:00:00	NQ	Futures	2537.81	2540.41	2535.51	2537.81	1952.0
2011-11-28 07:00:00	NQ	Futures	2538.1	2538.97	2533.78	2535.51	1366.0
2011-11-28 08:00:00	NQ	Futures	2535.51	2542.14	2534.07	2540.12	3060.0
2011-11-28 09:00:00	NQ	Futures	2540.41	2564.05	2538.39	2561.46	47847.0
2011-11-28 10:00:00	NQ	Futures	2561.46	2568.66	2558.57	2562.61	35386.0
2011-11-28 11:00:00	NQ	Futures	2562.32	2569.53	2560.59	2564.92	24211.0
2011-11-28 12:00:00	NQ	Futures	2564.92	2568.66	2557.42	2558.57	24348.0
2011-11-28 13:00:00	NQ	Futures	2558.0	2568.38	2555.98	2559.15	23995.0
2011-11-28 14:00:00	NQ	Futures	2558.86	2566.93	2554.54	2557.71	34355.0
2011-11-28 15:00:00	NQ	Futures	2557.42	2566.07	2546.18	2565.78	61651.0
2011-11-28 16:00:00	NQ	Futures	2565.49	2566.93	2561.17	2562.03	10755.0
2011-11-28 17:00:00	NQ	Futures	2562.32	2563.19	2561.46	2562.9	154.0
2011-11-28 18:00:00	NQ	Futures	2562.61	2563.76	2559.73	2560.88	425.0
2011-11-28 19:00:00	NQ	Futures	2560.88	2560.88	2555.11	2558.86	788.0
2011-11-28 20:00:00	NQ	Futures	2558.57	2560.3	2555.69	2555.98	657.0
2011-11-28 21:00:00	NQ	Futures	2555.98	2556.84	2553.96	2554.54	597.0
2011-11-28 22:00:00	NQ	Futures	2554.25	2560.88	2553.96	2560.02	527.0
2011-11-28 23:00:00	NQ	Futures	2560.02	2563.19	2558.57	2562.03	462.0
2011-11-28 00:00:00	YM	Futures	11173.8	11189.5	11165.9	11189.5	350.0
2011-11-28 01:00:00	YM	Futures	11189.5	11203.3	11179.7	11187.6	504.0

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

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