PREVIEW / futures_1hour / 2011-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-28.parquet
  size:    50 KB
  rows:    1,476

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-28 00:00:00	ES	Futures	1274.71	1274.96	1273.46	1273.46	3713.0
2011-06-28 01:00:00	ES	Futures	1273.46	1274.71	1272.22	1272.47	6823.0
2011-06-28 02:00:00	ES	Futures	1272.72	1274.21	1272.22	1272.47	8051.0
2011-06-28 03:00:00	ES	Futures	1272.47	1275.71	1271.22	1274.46	31204.0
2011-06-28 04:00:00	ES	Futures	1274.46	1275.21	1270.72	1271.47	24687.0
2011-06-28 05:00:00	ES	Futures	1271.22	1271.97	1269.47	1270.47	24408.0
2011-06-28 06:00:00	ES	Futures	1270.47	1272.47	1269.97	1270.72	17383.0
2011-06-28 07:00:00	ES	Futures	1270.72	1273.22	1268.48	1271.72	46283.0
2011-06-28 08:00:00	ES	Futures	1271.72	1279.45	1271.22	1278.45	121113.0
2011-06-28 09:00:00	ES	Futures	1278.45	1280.7	1274.96	1279.7	251668.0
2011-06-28 10:00:00	ES	Futures	1279.7	1284.94	1278.95	1282.44	334574.0
2011-06-28 11:00:00	ES	Futures	1282.44	1284.19	1281.45	1283.19	172961.0
2011-06-28 12:00:00	ES	Futures	1283.44	1285.44	1283.19	1284.94	111691.0
2011-06-28 13:00:00	ES	Futures	1284.94	1286.43	1284.19	1285.69	137363.0
2011-06-28 14:00:00	ES	Futures	1285.93	1288.68	1284.94	1287.43	181775.0
2011-06-28 15:00:00	ES	Futures	1287.43	1288.93	1285.19	1288.68	276093.0
2011-06-28 16:00:00	ES	Futures	1288.68	1291.92	1288.43	1291.17	137473.0
2011-06-28 17:00:00	ES	Futures	1291.17	1291.92	1290.67	1291.92	5313.0
2011-06-28 18:00:00	ES	Futures	1291.42	1291.42	1289.68	1289.93	7540.0
2011-06-28 19:00:00	ES	Futures	1289.93	1290.92	1289.68	1290.92	3646.0
2011-06-28 20:00:00	ES	Futures	1290.67	1290.92	1289.18	1289.68	6214.0
2011-06-28 21:00:00	ES	Futures	1289.68	1290.17	1288.68	1289.68	6562.0
2011-06-28 22:00:00	ES	Futures	1289.68	1290.17	1289.18	1289.43	3988.0
2011-06-28 23:00:00	ES	Futures	1289.43	1290.17	1288.43	1288.93	3446.0
2011-06-28 00:00:00	NQ	Futures	2593.92	2594.78	2588.74	2589.6	930.0
2011-06-28 01:00:00	NQ	Futures	2589.89	2591.9	2585.86	2587.3	822.0
2011-06-28 02:00:00	NQ	Futures	2587.3	2590.18	2587.3	2587.87	1489.0
2011-06-28 03:00:00	NQ	Futures	2587.87	2593.34	2584.71	2591.33	3364.0
2011-06-28 04:00:00	NQ	Futures	2591.04	2592.19	2583.56	2585.0	3323.0
2011-06-28 05:00:00	NQ	Futures	2584.42	2585.0	2580.1	2582.41	2861.0
2011-06-28 06:00:00	NQ	Futures	2582.69	2588.74	2581.54	2584.71	2489.0
2011-06-28 07:00:00	NQ	Futures	2584.71	2589.31	2580.97	2586.43	3355.0
2011-06-28 08:00:00	NQ	Futures	2586.43	2600.25	2584.71	2598.23	8867.0
2011-06-28 09:00:00	NQ	Futures	2597.94	2606.0	2589.6	2603.12	44217.0
2011-06-28 10:00:00	NQ	Futures	2602.84	2615.21	2601.69	2612.05	37378.0
2011-06-28 11:00:00	NQ	Futures	2611.76	2616.94	2609.74	2615.21	25687.0
2011-06-28 12:00:00	NQ	Futures	2615.21	2618.66	2614.35	2617.51	15042.0
2011-06-28 13:00:00	NQ	Futures	2617.23	2622.12	2616.07	2620.97	22884.0
2011-06-28 14:00:00	NQ	Futures	2620.97	2627.3	2618.95	2622.69	18532.0
2011-06-28 15:00:00	NQ	Futures	2622.69	2627.01	2618.09	2626.72	32294.0
2011-06-28 16:00:00	NQ	Futures	2626.72	2630.17	2626.15	2629.89	9706.0
2011-06-28 17:00:00	NQ	Futures	2629.6	2631.04	2628.74	2630.46	153.0
2011-06-28 18:00:00	NQ	Futures	2630.46	2630.46	2627.01	2627.01	316.0
2011-06-28 19:00:00	NQ	Futures	2627.3	2628.45	2626.72	2627.87	224.0
2011-06-28 20:00:00	NQ	Futures	2627.87	2627.87	2625.86	2627.01	635.0
2011-06-28 21:00:00	NQ	Futures	2626.72	2627.3	2625.28	2626.72	215.0
2011-06-28 22:00:00	NQ	Futures	2626.72	2627.3	2625.86	2626.43	151.0
2011-06-28 23:00:00	NQ	Futures	2627.3	2627.87	2624.71	2625.57	221.0
2011-06-28 00:00:00	YM	Futures	11618.9	11622.7	11611.1	11611.1	174.0
2011-06-28 01:00:00	YM	Futures	11611.1	11621.8	11602.4	11602.4	256.0

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

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