PREVIEW / futures_1hour / 2012-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-06-22.parquet
  size:    41 KB
  rows:    1,195

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-06-22 00:00:00	ES	Futures	1343.38	1345.41	1343.38	1343.89	3432.0
2012-06-22 01:00:00	ES	Futures	1343.89	1345.16	1343.13	1344.4	5901.0
2012-06-22 02:00:00	ES	Futures	1344.4	1345.16	1341.85	1342.87	12715.0
2012-06-22 03:00:00	ES	Futures	1342.87	1346.43	1340.84	1344.4	50989.0
2012-06-22 04:00:00	ES	Futures	1344.4	1346.94	1343.89	1346.18	28733.0
2012-06-22 05:00:00	ES	Futures	1345.92	1347.19	1344.65	1347.19	19550.0
2012-06-22 06:00:00	ES	Futures	1347.19	1347.7	1345.92	1346.94	21016.0
2012-06-22 07:00:00	ES	Futures	1346.94	1347.7	1341.09	1344.65	45303.0
2012-06-22 08:00:00	ES	Futures	1344.65	1346.43	1343.63	1345.67	43063.0
2012-06-22 09:00:00	ES	Futures	1345.67	1349.48	1344.91	1347.19	303021.0
2012-06-22 10:00:00	ES	Futures	1347.45	1349.99	1343.13	1345.92	345921.0
2012-06-22 11:00:00	ES	Futures	1345.67	1348.21	1344.91	1347.45	210721.0
2012-06-22 12:00:00	ES	Futures	1347.19	1347.7	1344.91	1346.18	134810.0
2012-06-22 13:00:00	ES	Futures	1346.18	1348.72	1344.91	1348.21	81029.0
2012-06-22 14:00:00	ES	Futures	1348.21	1352.53	1347.96	1352.28	113525.0
2012-06-22 15:00:00	ES	Futures	1352.28	1354.57	1349.99	1351.77	260392.0
2012-06-22 16:00:00	ES	Futures	1351.52	1352.53	1347.7	1348.21	130945.0
2012-06-22 00:00:00	NQ	Futures	2962.91	2966.68	2962.91	2963.49	473.0
2012-06-22 01:00:00	NQ	Futures	2963.78	2965.23	2962.04	2963.2	381.0
2012-06-22 02:00:00	NQ	Futures	2963.49	2965.23	2959.15	2960.31	922.0
2012-06-22 03:00:00	NQ	Futures	2960.6	2967.26	2955.96	2963.2	4496.0
2012-06-22 04:00:00	NQ	Futures	2962.91	2969.58	2962.04	2968.13	2164.0
2012-06-22 05:00:00	NQ	Futures	2968.42	2970.16	2966.1	2969.87	1124.0
2012-06-22 06:00:00	NQ	Futures	2969.87	2972.19	2968.13	2969.87	1691.0
2012-06-22 07:00:00	NQ	Futures	2969.87	2971.03	2955.09	2963.78	5036.0
2012-06-22 08:00:00	NQ	Futures	2963.49	2966.97	2961.17	2965.81	4001.0
2012-06-22 09:00:00	NQ	Futures	2965.81	2972.77	2960.6	2968.42	41169.0
2012-06-22 10:00:00	NQ	Futures	2968.71	2977.7	2961.46	2967.84	50235.0
2012-06-22 11:00:00	NQ	Futures	2967.84	2975.38	2967.26	2973.06	21258.0
2012-06-22 12:00:00	NQ	Futures	2973.06	2975.96	2968.71	2973.93	41839.0
2012-06-22 13:00:00	NQ	Futures	2974.22	2976.83	2971.61	2976.83	9744.0
2012-06-22 14:00:00	NQ	Futures	2976.83	2986.1	2976.83	2985.82	22709.0
2012-06-22 15:00:00	NQ	Futures	2986.1	2993.64	2980.89	2990.16	36092.0
2012-06-22 16:00:00	NQ	Futures	2990.16	2992.48	2985.24	2985.82	7158.0
2012-06-22 00:00:00	YM	Futures	12454.9	12467.8	12454.9	12457.9	303.0
2012-06-22 01:00:00	YM	Futures	12457.9	12464.8	12451.9	12458.9	393.0
2012-06-22 02:00:00	YM	Futures	12459.9	12465.8	12442.0	12449.9	1062.0
2012-06-22 03:00:00	YM	Futures	12450.9	12476.8	12434.0	12461.9	4196.0
2012-06-22 04:00:00	YM	Futures	12461.9	12481.7	12457.9	12477.8	2670.0
2012-06-22 05:00:00	YM	Futures	12476.8	12484.7	12465.8	12484.7	2140.0
2012-06-22 06:00:00	YM	Futures	12485.7	12488.7	12474.8	12484.7	2007.0
2012-06-22 07:00:00	YM	Futures	12485.7	12490.7	12440.0	12468.8	3621.0
2012-06-22 08:00:00	YM	Futures	12467.8	12479.8	12459.9	12477.8	3158.0
2012-06-22 09:00:00	YM	Futures	12476.8	12510.6	12474.8	12506.6	24757.0
2012-06-22 10:00:00	YM	Futures	12506.6	12521.5	12465.8	12490.7	23112.0
2012-06-22 11:00:00	YM	Futures	12489.7	12503.6	12480.7	12498.6	12025.0
2012-06-22 12:00:00	YM	Futures	12499.6	12502.6	12474.8	12479.8	7913.0
2012-06-22 13:00:00	YM	Futures	12478.8	12497.7	12467.8	12493.7	5342.0
2012-06-22 14:00:00	YM	Futures	12493.7	12516.5	12486.7	12513.6	7077.0
2012-06-22 15:00:00	YM	Futures	12514.6	12535.4	12494.7	12513.6	13029.0

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

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