PREVIEW / futures_1hour / 2011-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-27.parquet
  size:    48 KB
  rows:    1,436

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-06-27 00:00:00	ES	Futures	1259.0	1259.0	1257.75	1257.75	4944.0
2011-06-27 01:00:00	ES	Futures	1257.75	1260.5	1257.25	1259.0	8232.0
2011-06-27 02:00:00	ES	Futures	1259.0	1259.25	1256.26	1258.5	12870.0
2011-06-27 03:00:00	ES	Futures	1258.75	1264.74	1258.5	1259.5	48925.0
2011-06-27 04:00:00	ES	Futures	1259.25	1264.74	1259.0	1264.24	19623.0
2011-06-27 05:00:00	ES	Futures	1264.49	1265.73	1263.24	1263.99	18263.0
2011-06-27 06:00:00	ES	Futures	1263.99	1266.48	1263.49	1263.99	22283.0
2011-06-27 07:00:00	ES	Futures	1263.99	1264.98	1263.24	1263.24	15409.0
2011-06-27 08:00:00	ES	Futures	1263.24	1263.99	1260.99	1261.49	42859.0
2011-06-27 09:00:00	ES	Futures	1261.74	1266.23	1258.75	1264.24	286158.0
2011-06-27 10:00:00	ES	Futures	1264.24	1270.47	1263.74	1269.22	302364.0
2011-06-27 11:00:00	ES	Futures	1269.22	1271.22	1266.23	1270.97	233559.0
2011-06-27 12:00:00	ES	Futures	1270.97	1271.72	1269.47	1269.72	117239.0
2011-06-27 13:00:00	ES	Futures	1269.72	1271.72	1268.23	1270.22	162035.0
2011-06-27 14:00:00	ES	Futures	1269.97	1276.96	1269.97	1275.21	275562.0
2011-06-27 15:00:00	ES	Futures	1274.96	1276.46	1271.47	1271.72	263211.0
2011-06-27 16:00:00	ES	Futures	1271.97	1274.96	1270.97	1274.71	105050.0
2011-06-27 17:00:00	ES	Futures	1274.46	1275.21	1273.71	1274.71	2982.0
2011-06-27 18:00:00	ES	Futures	1274.96	1275.96	1274.46	1274.96	2772.0
2011-06-27 19:00:00	ES	Futures	1274.96	1275.96	1274.96	1275.71	2523.0
2011-06-27 20:00:00	ES	Futures	1275.96	1275.96	1273.96	1275.21	5283.0
2011-06-27 21:00:00	ES	Futures	1275.21	1276.96	1274.96	1275.46	6394.0
2011-06-27 22:00:00	ES	Futures	1275.46	1275.96	1274.96	1275.21	2429.0
2011-06-27 23:00:00	ES	Futures	1275.21	1275.21	1273.96	1274.46	2683.0
2011-06-27 00:00:00	NQ	Futures	2536.36	2536.65	2533.77	2533.77	739.0
2011-06-27 01:00:00	NQ	Futures	2534.06	2538.38	2533.2	2536.94	597.0
2011-06-27 02:00:00	NQ	Futures	2537.23	2538.67	2532.91	2537.8	1332.0
2011-06-27 03:00:00	NQ	Futures	2537.8	2549.31	2537.8	2538.95	4674.0
2011-06-27 04:00:00	NQ	Futures	2538.95	2550.75	2538.09	2550.18	2965.0
2011-06-27 05:00:00	NQ	Futures	2550.18	2553.63	2548.16	2549.31	2237.0
2011-06-27 06:00:00	NQ	Futures	2549.6	2554.78	2548.45	2549.6	2725.0
2011-06-27 07:00:00	NQ	Futures	2549.31	2551.9	2548.45	2548.74	2081.0
2011-06-27 08:00:00	NQ	Futures	2548.74	2549.89	2543.56	2545.0	6978.0
2011-06-27 09:00:00	NQ	Futures	2545.0	2561.4	2541.26	2558.52	52067.0
2011-06-27 10:00:00	NQ	Futures	2558.52	2578.95	2557.66	2574.64	53379.0
2011-06-27 11:00:00	NQ	Futures	2574.64	2583.56	2572.33	2582.98	33310.0
2011-06-27 12:00:00	NQ	Futures	2583.27	2587.01	2582.12	2584.71	18166.0
2011-06-27 13:00:00	NQ	Futures	2584.71	2588.74	2580.39	2585.57	20064.0
2011-06-27 14:00:00	NQ	Futures	2585.57	2601.4	2585.28	2597.37	29610.0
2011-06-27 15:00:00	NQ	Futures	2597.08	2599.96	2586.72	2587.3	36697.0
2011-06-27 16:00:00	NQ	Futures	2587.59	2594.2	2584.71	2593.05	11656.0
2011-06-27 17:00:00	NQ	Futures	2593.05	2594.49	2591.61	2592.48	301.0
2011-06-27 18:00:00	NQ	Futures	2593.34	2597.37	2593.34	2596.22	575.0
2011-06-27 19:00:00	NQ	Futures	2595.93	2597.94	2595.93	2597.94	323.0
2011-06-27 20:00:00	NQ	Futures	2597.94	2598.23	2594.78	2596.51	827.0
2011-06-27 21:00:00	NQ	Futures	2596.51	2600.53	2596.51	2597.66	804.0
2011-06-27 22:00:00	NQ	Futures	2597.66	2597.94	2596.79	2597.08	158.0
2011-06-27 23:00:00	NQ	Futures	2597.37	2597.37	2591.61	2593.63	901.0
2011-06-27 00:00:00	YM	Futures	11486.2	11487.2	11473.6	11473.6	258.0
2011-06-27 01:00:00	YM	Futures	11475.5	11495.9	11472.6	11490.1	521.0

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

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