PREVIEW / futures_1hour / 2011-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-15.parquet
  size:    41 KB
  rows:    1,202

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-07-15 00:00:00	ES	Futures	1304.64	1304.89	1302.65	1303.14	3098.0
2011-07-15 01:00:00	ES	Futures	1303.14	1305.14	1302.65	1304.39	4853.0
2011-07-15 02:00:00	ES	Futures	1304.39	1304.89	1301.4	1302.15	11737.0
2011-07-15 03:00:00	ES	Futures	1302.15	1304.39	1299.4	1301.65	44577.0
2011-07-15 04:00:00	ES	Futures	1301.9	1304.39	1299.9	1302.89	20653.0
2011-07-15 05:00:00	ES	Futures	1303.14	1306.39	1302.4	1305.14	22419.0
2011-07-15 06:00:00	ES	Futures	1305.39	1305.89	1303.64	1304.39	15208.0
2011-07-15 07:00:00	ES	Futures	1304.39	1307.63	1303.89	1306.64	22170.0
2011-07-15 08:00:00	ES	Futures	1306.89	1309.13	1304.64	1307.88	109161.0
2011-07-15 09:00:00	ES	Futures	1307.88	1310.88	1303.14	1305.14	364121.0
2011-07-15 10:00:00	ES	Futures	1304.89	1309.88	1299.9	1302.65	464357.0
2011-07-15 11:00:00	ES	Futures	1302.65	1306.64	1301.15	1304.64	209784.0
2011-07-15 12:00:00	ES	Futures	1304.39	1309.38	1303.14	1304.64	244909.0
2011-07-15 13:00:00	ES	Futures	1304.39	1305.89	1301.65	1301.9	95153.0
2011-07-15 14:00:00	ES	Futures	1301.9	1304.39	1300.4	1302.15	156311.0
2011-07-15 15:00:00	ES	Futures	1302.4	1309.38	1301.4	1309.13	291965.0
2011-07-15 16:00:00	ES	Futures	1309.13	1312.37	1309.13	1311.37	149600.0
2011-07-15 00:00:00	NQ	Futures	2700.1	2700.39	2694.35	2696.36	418.0
2011-07-15 01:00:00	NQ	Futures	2696.36	2701.54	2694.35	2696.94	642.0
2011-07-15 02:00:00	NQ	Futures	2696.65	2696.94	2690.03	2691.18	1386.0
2011-07-15 03:00:00	NQ	Futures	2691.47	2695.5	2683.7	2688.59	4723.0
2011-07-15 04:00:00	NQ	Futures	2688.59	2692.62	2685.43	2688.02	2969.0
2011-07-15 05:00:00	NQ	Futures	2688.3	2694.63	2686.29	2692.62	1875.0
2011-07-15 06:00:00	NQ	Futures	2692.91	2694.92	2690.89	2691.76	1841.0
2011-07-15 07:00:00	NQ	Futures	2691.76	2698.38	2691.18	2696.94	2488.0
2011-07-15 08:00:00	NQ	Futures	2696.94	2702.69	2693.77	2702.4	9120.0
2011-07-15 09:00:00	NQ	Futures	2702.4	2709.31	2689.74	2692.91	48601.0
2011-07-15 10:00:00	NQ	Futures	2693.2	2703.55	2685.14	2691.76	45489.0
2011-07-15 11:00:00	NQ	Futures	2691.47	2700.1	2689.74	2694.35	22881.0
2011-07-15 12:00:00	NQ	Futures	2694.35	2704.13	2694.06	2700.1	25182.0
2011-07-15 13:00:00	NQ	Futures	2700.1	2702.98	2693.77	2694.06	12316.0
2011-07-15 14:00:00	NQ	Futures	2694.06	2697.8	2689.74	2692.62	17740.0
2011-07-15 15:00:00	NQ	Futures	2692.33	2709.89	2691.76	2709.89	37930.0
2011-07-15 16:00:00	NQ	Futures	2709.89	2715.07	2709.31	2711.32	11534.0
2011-07-15 00:00:00	YM	Futures	12006.2	12006.2	11984.9	11989.8	246.0
2011-07-15 01:00:00	YM	Futures	11990.7	12007.2	11987.8	12004.3	808.0
2011-07-15 02:00:00	YM	Futures	12004.3	12008.2	11983.9	11990.7	1216.0
2011-07-15 03:00:00	YM	Futures	11992.7	12013.0	11976.2	11996.5	3034.0
2011-07-15 04:00:00	YM	Futures	11996.5	12018.8	11981.0	12005.2	1502.0
2011-07-15 05:00:00	YM	Futures	12006.2	12032.4	11999.4	12023.6	1807.0
2011-07-15 06:00:00	YM	Futures	12023.6	12029.5	12007.2	12013.0	1262.0
2011-07-15 07:00:00	YM	Futures	12011.1	12030.4	12001.4	12021.7	1899.0
2011-07-15 08:00:00	YM	Futures	12020.7	12039.1	12003.3	12031.4	5320.0
2011-07-15 09:00:00	YM	Futures	12032.4	12055.6	11990.7	12006.2	22777.0
2011-07-15 10:00:00	YM	Futures	12006.2	12045.0	11958.8	11983.9	25143.0
2011-07-15 11:00:00	YM	Futures	11984.9	12016.9	11973.3	11994.6	11853.0
2011-07-15 12:00:00	YM	Futures	11995.6	12036.2	11982.0	11991.7	12560.0
2011-07-15 13:00:00	YM	Futures	11989.8	12003.3	11972.3	11973.3	5513.0
2011-07-15 14:00:00	YM	Futures	11973.3	11997.5	11965.5	11979.1	9983.0
2011-07-15 15:00:00	YM	Futures	11979.1	12034.3	11971.4	12033.3	12230.0

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

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