PREVIEW / futures_1hour / 2011-05-23

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-23.parquet
  size:    46 KB
  rows:    1,412

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-05-23 00:00:00	ES	Futures	1312.71	1313.7	1311.96	1312.21	4585.0
2011-05-23 01:00:00	ES	Futures	1312.21	1313.45	1311.96	1312.96	6718.0
2011-05-23 02:00:00	ES	Futures	1313.2	1313.2	1311.46	1311.46	22031.0
2011-05-23 03:00:00	ES	Futures	1311.71	1313.45	1308.73	1310.47	59654.0
2011-05-23 04:00:00	ES	Futures	1310.47	1310.72	1306.99	1309.48	37671.0
2011-05-23 05:00:00	ES	Futures	1309.48	1309.48	1304.01	1306.74	44707.0
2011-05-23 06:00:00	ES	Futures	1306.74	1308.48	1306.5	1306.74	26885.0
2011-05-23 07:00:00	ES	Futures	1306.74	1310.22	1306.25	1308.48	42005.0
2011-05-23 08:00:00	ES	Futures	1308.24	1309.23	1306.25	1308.48	49234.0
2011-05-23 09:00:00	ES	Futures	1308.73	1309.23	1304.01	1307.49	267492.0
2011-05-23 10:00:00	ES	Futures	1307.49	1309.73	1305.25	1306.74	301900.0
2011-05-23 11:00:00	ES	Futures	1306.74	1308.73	1303.02	1305.01	268004.0
2011-05-23 12:00:00	ES	Futures	1305.01	1306.99	1302.52	1306.25	180598.0
2011-05-23 13:00:00	ES	Futures	1306.25	1307.74	1304.26	1306.99	96701.0
2011-05-23 14:00:00	ES	Futures	1307.24	1311.46	1306.74	1309.48	170316.0
2011-05-23 15:00:00	ES	Futures	1309.73	1311.22	1306.5	1307.24	315026.0
2011-05-23 16:00:00	ES	Futures	1307.24	1307.49	1305.5	1306.25	102015.0
2011-05-23 17:00:00	ES	Futures	1306.25	1306.25	1305.5	1305.75	2925.0
2011-05-23 18:00:00	ES	Futures	1306.0	1306.25	1305.01	1305.25	6113.0
2011-05-23 19:00:00	ES	Futures	1305.25	1306.0	1304.01	1305.75	5245.0
2011-05-23 20:00:00	ES	Futures	1305.75	1308.73	1305.75	1308.24	11530.0
2011-05-23 21:00:00	ES	Futures	1308.24	1309.48	1307.49	1307.49	8109.0
2011-05-23 22:00:00	ES	Futures	1307.74	1308.48	1306.25	1306.99	4630.0
2011-05-23 23:00:00	ES	Futures	1306.99	1309.73	1306.74	1308.98	6118.0
2011-05-23 00:00:00	NQ	Futures	2678.64	2680.65	2678.06	2678.06	129.0
2011-05-23 01:00:00	NQ	Futures	2678.06	2680.07	2678.06	2678.64	399.0
2011-05-23 02:00:00	NQ	Futures	2679.5	2680.07	2675.76	2676.05	906.0
2011-05-23 03:00:00	NQ	Futures	2676.34	2679.21	2670.59	2674.9	4284.0
2011-05-23 04:00:00	NQ	Futures	2674.61	2675.48	2667.43	2672.31	2556.0
2011-05-23 05:00:00	NQ	Futures	2672.03	2672.31	2662.26	2666.28	3830.0
2011-05-23 06:00:00	NQ	Futures	2666.57	2669.73	2665.42	2665.71	1787.0
2011-05-23 07:00:00	NQ	Futures	2665.71	2671.45	2665.13	2668.29	2518.0
2011-05-23 08:00:00	NQ	Futures	2668.58	2670.02	2664.56	2669.44	4652.0
2011-05-23 09:00:00	NQ	Futures	2669.15	2669.44	2648.76	2653.35	48352.0
2011-05-23 10:00:00	NQ	Futures	2653.35	2659.39	2648.18	2654.79	41227.0
2011-05-23 11:00:00	NQ	Futures	2654.5	2658.81	2649.04	2654.21	25478.0
2011-05-23 12:00:00	NQ	Futures	2654.21	2658.52	2649.62	2657.95	19130.0
2011-05-23 13:00:00	NQ	Futures	2658.24	2659.96	2653.64	2658.52	12587.0
2011-05-23 14:00:00	NQ	Futures	2658.81	2669.44	2658.52	2665.71	24889.0
2011-05-23 15:00:00	NQ	Futures	2665.71	2671.74	2658.52	2661.97	40680.0
2011-05-23 16:00:00	NQ	Futures	2661.97	2664.56	2658.24	2660.53	10213.0
2011-05-23 17:00:00	NQ	Futures	2660.53	2660.53	2659.39	2659.96	74.0
2011-05-23 18:00:00	NQ	Futures	2660.25	2661.11	2658.81	2658.81	258.0
2011-05-23 19:00:00	NQ	Futures	2658.81	2660.53	2657.66	2659.96	380.0
2011-05-23 20:00:00	NQ	Futures	2660.53	2666.28	2659.96	2664.56	831.0
2011-05-23 21:00:00	NQ	Futures	2664.56	2666.57	2663.12	2663.7	286.0
2011-05-23 22:00:00	NQ	Futures	2663.7	2664.84	2660.53	2661.68	257.0
2011-05-23 23:00:00	NQ	Futures	2661.68	2665.99	2661.68	2665.13	532.0
2011-05-23 00:00:00	YM	Futures	11951.2	11958.0	11945.5	11945.5	245.0
2011-05-23 01:00:00	YM	Futures	11946.4	11953.2	11945.5	11950.3	249.0

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

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