PREVIEW / futures_1hour / 2012-07-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-13.parquet
  size:    41 KB
  rows:    1,212

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
2012-07-13 00:00:00	ES	Futures	1356.86	1357.62	1355.59	1356.6	3179.0
2012-07-13 01:00:00	ES	Futures	1356.6	1357.62	1356.09	1356.09	3267.0
2012-07-13 02:00:00	ES	Futures	1356.09	1356.6	1354.57	1355.59	5370.0
2012-07-13 03:00:00	ES	Futures	1355.59	1356.35	1353.3	1355.33	25762.0
2012-07-13 04:00:00	ES	Futures	1355.33	1355.84	1353.55	1355.33	17661.0
2012-07-13 05:00:00	ES	Futures	1355.08	1357.87	1355.08	1357.37	17943.0
2012-07-13 06:00:00	ES	Futures	1357.62	1359.65	1356.35	1357.87	32304.0
2012-07-13 07:00:00	ES	Futures	1358.13	1358.38	1354.57	1355.59	35385.0
2012-07-13 08:00:00	ES	Futures	1355.33	1356.86	1354.31	1355.08	34364.0
2012-07-13 09:00:00	ES	Futures	1355.08	1365.76	1353.3	1365.25	328648.0
2012-07-13 10:00:00	ES	Futures	1365.5	1370.84	1364.74	1369.06	371647.0
2012-07-13 11:00:00	ES	Futures	1368.81	1372.11	1367.28	1371.35	212640.0
2012-07-13 12:00:00	ES	Futures	1371.1	1372.88	1370.59	1371.6	91497.0
2012-07-13 13:00:00	ES	Futures	1371.6	1372.88	1370.59	1371.86	62082.0
2012-07-13 14:00:00	ES	Futures	1371.6	1372.62	1370.84	1372.62	57759.0
2012-07-13 15:00:00	ES	Futures	1372.62	1376.44	1372.37	1374.15	305334.0
2012-07-13 16:00:00	ES	Futures	1374.15	1376.18	1373.89	1375.16	100578.0
2012-07-13 00:00:00	NQ	Futures	2956.25	2957.41	2953.93	2954.51	338.0
2012-07-13 01:00:00	NQ	Futures	2954.8	2955.96	2953.06	2953.35	617.0
2012-07-13 02:00:00	NQ	Futures	2953.64	2953.93	2949.87	2950.45	760.0
2012-07-13 03:00:00	NQ	Futures	2950.45	2953.93	2946.68	2951.61	2316.0
2012-07-13 04:00:00	NQ	Futures	2951.61	2951.61	2946.39	2949.58	1596.0
2012-07-13 05:00:00	NQ	Futures	2949.58	2955.38	2949.29	2954.51	1491.0
2012-07-13 06:00:00	NQ	Futures	2954.51	2962.04	2952.19	2958.28	3532.0
2012-07-13 07:00:00	NQ	Futures	2958.86	2958.86	2949.58	2951.32	4606.0
2012-07-13 08:00:00	NQ	Futures	2951.32	2955.67	2949.29	2951.32	3434.0
2012-07-13 09:00:00	NQ	Futures	2951.03	2967.55	2947.84	2965.23	33560.0
2012-07-13 10:00:00	NQ	Futures	2965.52	2979.44	2962.91	2974.51	34454.0
2012-07-13 11:00:00	NQ	Futures	2974.51	2981.76	2970.74	2981.47	19635.0
2012-07-13 12:00:00	NQ	Futures	2981.18	2986.1	2980.6	2983.21	13214.0
2012-07-13 13:00:00	NQ	Futures	2983.21	2988.71	2982.05	2986.1	10863.0
2012-07-13 14:00:00	NQ	Futures	2986.1	2988.71	2984.66	2988.71	7832.0
2012-07-13 15:00:00	NQ	Futures	2988.71	2997.12	2988.42	2989.58	36087.0
2012-07-13 16:00:00	NQ	Futures	2989.87	2990.74	2988.42	2989.58	7235.0
2012-07-13 00:00:00	YM	Futures	12468.8	12475.8	12459.9	12473.8	755.0
2012-07-13 01:00:00	YM	Futures	12474.8	12485.7	12470.8	12474.8	765.0
2012-07-13 02:00:00	YM	Futures	12470.8	12474.8	12458.9	12466.8	383.0
2012-07-13 03:00:00	YM	Futures	12466.8	12477.8	12452.9	12468.8	2252.0
2012-07-13 04:00:00	YM	Futures	12469.8	12471.8	12454.9	12464.8	1449.0
2012-07-13 05:00:00	YM	Futures	12465.8	12483.7	12463.8	12481.7	1384.0
2012-07-13 06:00:00	YM	Futures	12479.8	12498.6	12473.8	12487.7	2369.0
2012-07-13 07:00:00	YM	Futures	12488.7	12489.7	12465.8	12470.8	1952.0
2012-07-13 08:00:00	YM	Futures	12470.8	12475.8	12459.9	12466.8	2116.0
2012-07-13 09:00:00	YM	Futures	12466.8	12566.3	12452.9	12561.3	23244.0
2012-07-13 10:00:00	YM	Futures	12561.3	12606.0	12551.4	12599.1	25294.0
2012-07-13 11:00:00	YM	Futures	12601.1	12626.9	12577.2	12621.0	15825.0
2012-07-13 12:00:00	YM	Futures	12621.0	12628.9	12606.0	12611.0	5855.0
2012-07-13 13:00:00	YM	Futures	12610.0	12622.0	12603.1	12611.0	4431.0
2012-07-13 14:00:00	YM	Futures	12611.0	12614.0	12601.1	12611.0	4267.0
2012-07-13 15:00:00	YM	Futures	12611.0	12651.8	12611.0	12639.9	18598.0

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

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