PREVIEW / futures_1hour / 2012-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-29.parquet
  size:    44 KB
  rows:    1,357

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-10-29 00:00:00	ES	Futures	1434.43	1434.68	1431.87	1432.13	4763.0
2012-10-29 01:00:00	ES	Futures	1432.13	1434.17	1431.11	1433.41	4820.0
2012-10-29 02:00:00	ES	Futures	1433.41	1434.94	1433.41	1433.92	2231.0
2012-10-29 03:00:00	ES	Futures	1433.92	1434.17	1431.62	1432.64	6719.0
2012-10-29 04:00:00	ES	Futures	1432.64	1432.64	1430.09	1430.6	21261.0
2012-10-29 05:00:00	ES	Futures	1430.6	1431.87	1429.32	1429.83	16926.0
2012-10-29 06:00:00	ES	Futures	1429.57	1430.09	1428.81	1429.57	13155.0
2012-10-29 07:00:00	ES	Futures	1429.57	1429.83	1427.53	1428.81	25667.0
2012-10-29 08:00:00	ES	Futures	1428.81	1432.13	1428.04	1430.85	33201.0
2012-10-29 09:00:00	ES	Futures	1430.85	1433.92	1430.09	1433.41	17769.0
2012-10-29 18:00:00	ES	Futures	1429.83	1430.6	1427.02	1428.3	9046.0
2012-10-29 19:00:00	ES	Futures	1428.3	1432.13	1428.04	1430.34	5499.0
2012-10-29 20:00:00	ES	Futures	1430.09	1432.13	1428.81	1430.85	4474.0
2012-10-29 21:00:00	ES	Futures	1431.11	1431.11	1426.76	1427.79	7803.0
2012-10-29 22:00:00	ES	Futures	1428.04	1429.32	1426.76	1428.04	5307.0
2012-10-29 23:00:00	ES	Futures	1428.04	1428.81	1423.44	1427.02	14387.0
2012-10-29 00:00:00	NQ	Futures	3081.56	3081.56	3077.2	3077.49	549.0
2012-10-29 01:00:00	NQ	Futures	3077.49	3081.85	3075.75	3080.69	613.0
2012-10-29 02:00:00	NQ	Futures	3080.4	3081.85	3079.82	3080.4	277.0
2012-10-29 03:00:00	NQ	Futures	3080.11	3080.4	3075.17	3077.79	936.0
2012-10-29 04:00:00	NQ	Futures	3077.79	3078.37	3070.23	3071.1	2106.0
2012-10-29 05:00:00	NQ	Futures	3071.39	3073.43	3066.16	3067.32	1991.0
2012-10-29 06:00:00	NQ	Futures	3067.03	3067.91	3065.0	3067.32	1263.0
2012-10-29 07:00:00	NQ	Futures	3067.03	3067.32	3063.55	3064.71	1620.0
2012-10-29 08:00:00	NQ	Futures	3064.71	3069.07	3061.8	3067.32	3636.0
2012-10-29 09:00:00	NQ	Futures	3067.61	3073.43	3067.32	3073.43	1839.0
2012-10-29 18:00:00	NQ	Futures	3065.29	3065.58	3059.77	3061.51	1247.0
2012-10-29 19:00:00	NQ	Futures	3061.51	3070.52	3061.51	3066.45	804.0
2012-10-29 20:00:00	NQ	Futures	3066.45	3068.78	3062.97	3066.16	698.0
2012-10-29 21:00:00	NQ	Futures	3066.16	3068.2	3058.03	3059.77	1415.0
2012-10-29 22:00:00	NQ	Futures	3060.06	3062.38	3057.74	3058.9	1090.0
2012-10-29 23:00:00	NQ	Futures	3058.61	3060.35	3052.21	3059.48	1780.0
2012-10-29 00:00:00	YM	Futures	13029.7	13029.7	13010.7	13011.7	517.0
2012-10-29 01:00:00	YM	Futures	13012.7	13031.7	13003.7	13024.7	586.0
2012-10-29 02:00:00	YM	Futures	13025.7	13036.7	13023.7	13031.7	194.0
2012-10-29 03:00:00	YM	Futures	13030.7	13031.7	13007.7	13014.7	480.0
2012-10-29 04:00:00	YM	Futures	13013.7	13013.7	12990.7	12993.7	1995.0
2012-10-29 05:00:00	YM	Futures	12994.7	13004.7	12990.7	12994.7	1409.0
2012-10-29 06:00:00	YM	Futures	12994.7	12994.7	12977.7	12985.7	1208.0
2012-10-29 07:00:00	YM	Futures	12985.7	12985.7	12960.7	12973.7	1771.0
2012-10-29 08:00:00	YM	Futures	12975.7	12990.7	12964.7	12978.7	2352.0
2012-10-29 09:00:00	YM	Futures	12981.7	13000.7	12974.7	13000.7	1279.0
2012-10-29 18:00:00	YM	Futures	12979.7	12979.7	12953.7	12962.7	488.0
2012-10-29 19:00:00	YM	Futures	12963.7	12991.7	12963.7	12980.7	492.0
2012-10-29 20:00:00	YM	Futures	12980.7	12989.7	12967.7	12980.7	497.0
2012-10-29 21:00:00	YM	Futures	12981.7	12984.7	12949.7	12958.7	991.0
2012-10-29 22:00:00	YM	Futures	12958.7	12974.7	12953.7	12963.7	1049.0
2012-10-29 23:00:00	YM	Futures	12962.7	12968.7	12932.7	12958.7	2243.0
2012-10-29 00:00:00	CL	Futures	139.6	139.88	139.45	139.6	836.0
2012-10-29 01:00:00	CL	Futures	139.58	139.81	139.45	139.52	1150.0

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

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