PREVIEW / futures_1hour / 2011-11-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-21.parquet
  size:    47 KB
  rows:    1,422

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-21 00:00:00	ES	Futures	1209.91	1210.41	1207.4	1208.65	3665.0
2011-11-21 01:00:00	ES	Futures	1208.65	1210.66	1206.65	1209.91	4519.0
2011-11-21 02:00:00	ES	Futures	1209.91	1212.16	1208.4	1209.91	15463.0
2011-11-21 03:00:00	ES	Futures	1209.91	1210.41	1195.61	1198.12	95898.0
2011-11-21 04:00:00	ES	Futures	1198.37	1201.38	1196.62	1198.87	41355.0
2011-11-21 05:00:00	ES	Futures	1198.87	1199.88	1197.12	1199.38	24805.0
2011-11-21 06:00:00	ES	Futures	1199.38	1200.38	1195.61	1197.62	36011.0
2011-11-21 07:00:00	ES	Futures	1197.37	1199.88	1196.12	1198.12	45547.0
2011-11-21 08:00:00	ES	Futures	1198.37	1203.39	1197.62	1201.63	51878.0
2011-11-21 09:00:00	ES	Futures	1201.38	1202.89	1192.35	1194.11	279818.0
2011-11-21 10:00:00	ES	Futures	1194.36	1195.61	1186.59	1187.34	388046.0
2011-11-21 11:00:00	ES	Futures	1187.09	1190.6	1184.08	1189.35	346637.0
2011-11-21 12:00:00	ES	Futures	1189.09	1190.35	1186.09	1188.09	147884.0
2011-11-21 13:00:00	ES	Futures	1187.84	1192.61	1186.59	1186.84	128976.0
2011-11-21 14:00:00	ES	Futures	1187.09	1197.12	1186.09	1192.86	235931.0
2011-11-21 15:00:00	ES	Futures	1192.86	1200.38	1190.35	1194.11	378786.0
2011-11-21 16:00:00	ES	Futures	1194.11	1195.61	1189.85	1191.6	111514.0
2011-11-21 17:00:00	ES	Futures	1191.6	1192.1	1188.84	1191.35	6426.0
2011-11-21 18:00:00	ES	Futures	1192.61	1193.61	1190.85	1193.36	10491.0
2011-11-21 19:00:00	ES	Futures	1193.36	1197.37	1193.36	1197.12	13557.0
2011-11-21 20:00:00	ES	Futures	1197.12	1199.88	1196.87	1198.87	12463.0
2011-11-21 21:00:00	ES	Futures	1198.62	1201.13	1197.12	1200.88	8794.0
2011-11-21 22:00:00	ES	Futures	1200.88	1200.88	1196.37	1197.12	8751.0
2011-11-21 23:00:00	ES	Futures	1197.12	1199.38	1195.11	1199.38	5918.0
2011-11-21 00:00:00	NQ	Futures	2581.06	2581.35	2577.03	2579.04	383.0
2011-11-21 01:00:00	NQ	Futures	2579.33	2583.66	2576.45	2582.5	387.0
2011-11-21 02:00:00	NQ	Futures	2582.22	2586.25	2579.33	2582.22	1154.0
2011-11-21 03:00:00	NQ	Futures	2582.22	2582.79	2558.0	2564.05	8823.0
2011-11-21 04:00:00	NQ	Futures	2563.76	2570.11	2559.73	2566.36	3018.0
2011-11-21 05:00:00	NQ	Futures	2566.07	2568.66	2562.9	2566.65	1852.0
2011-11-21 06:00:00	NQ	Futures	2566.93	2572.99	2563.19	2567.22	3829.0
2011-11-21 07:00:00	NQ	Futures	2567.22	2571.26	2563.19	2566.93	2773.0
2011-11-21 08:00:00	NQ	Futures	2566.93	2573.57	2565.49	2570.39	4882.0
2011-11-21 09:00:00	NQ	Futures	2570.39	2572.12	2539.54	2542.72	47925.0
2011-11-21 10:00:00	NQ	Futures	2543.0	2544.73	2527.15	2528.01	50237.0
2011-11-21 11:00:00	NQ	Futures	2528.01	2536.37	2522.24	2532.05	39364.0
2011-11-21 12:00:00	NQ	Futures	2531.47	2537.81	2528.01	2534.07	22407.0
2011-11-21 13:00:00	NQ	Futures	2534.07	2545.31	2530.89	2531.47	21362.0
2011-11-21 14:00:00	NQ	Futures	2531.47	2553.1	2529.74	2545.31	31634.0
2011-11-21 15:00:00	NQ	Futures	2545.6	2564.05	2540.41	2548.19	45708.0
2011-11-21 16:00:00	NQ	Futures	2548.19	2556.56	2540.99	2549.92	11556.0
2011-11-21 17:00:00	NQ	Futures	2549.64	2550.79	2544.16	2548.19	300.0
2011-11-21 18:00:00	NQ	Futures	2551.37	2553.1	2549.06	2552.52	679.0
2011-11-21 19:00:00	NQ	Futures	2553.1	2559.73	2553.1	2559.15	826.0
2011-11-21 20:00:00	NQ	Futures	2559.15	2565.49	2558.86	2562.61	1248.0
2011-11-21 21:00:00	NQ	Futures	2563.76	2566.65	2560.02	2565.49	633.0
2011-11-21 22:00:00	NQ	Futures	2565.49	2568.09	2557.42	2558.86	792.0
2011-11-21 23:00:00	NQ	Futures	2558.86	2563.48	2555.4	2563.48	620.0
2011-11-21 00:00:00	YM	Futures	11524.3	11530.2	11504.6	11513.4	349.0
2011-11-21 01:00:00	YM	Futures	11514.4	11530.2	11500.6	11524.3	497.0

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

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