PREVIEW / futures_1hour / 2011-10-19

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-19.parquet
  size:    50 KB
  rows:    1,481

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-10-19 00:00:00	ES	Futures	1221.94	1221.94	1219.44	1220.94	4966.0
2011-10-19 01:00:00	ES	Futures	1220.94	1222.95	1219.94	1220.94	7633.0
2011-10-19 02:00:00	ES	Futures	1220.69	1223.95	1220.44	1222.19	17509.0
2011-10-19 03:00:00	ES	Futures	1222.45	1222.7	1218.18	1220.19	36096.0
2011-10-19 04:00:00	ES	Futures	1220.44	1222.95	1217.93	1222.95	23619.0
2011-10-19 05:00:00	ES	Futures	1222.95	1229.22	1222.45	1228.46	37592.0
2011-10-19 06:00:00	ES	Futures	1228.46	1230.97	1225.96	1230.22	24817.0
2011-10-19 07:00:00	ES	Futures	1230.22	1230.47	1222.7	1223.2	46852.0
2011-10-19 08:00:00	ES	Futures	1222.95	1227.46	1221.19	1226.71	68684.0
2011-10-19 09:00:00	ES	Futures	1226.71	1226.71	1219.19	1222.95	274841.0
2011-10-19 10:00:00	ES	Futures	1222.7	1228.97	1218.93	1226.21	344737.0
2011-10-19 11:00:00	ES	Futures	1226.46	1228.46	1222.45	1222.7	218862.0
2011-10-19 12:00:00	ES	Futures	1222.95	1226.21	1221.19	1224.2	158391.0
2011-10-19 13:00:00	ES	Futures	1224.2	1226.71	1218.93	1220.94	172967.0
2011-10-19 14:00:00	ES	Futures	1220.94	1222.19	1208.9	1209.66	428818.0
2011-10-19 15:00:00	ES	Futures	1209.66	1212.42	1205.14	1208.9	414618.0
2011-10-19 16:00:00	ES	Futures	1208.9	1211.66	1208.65	1211.16	66209.0
2011-10-19 17:00:00	ES	Futures	1211.41	1212.42	1211.41	1211.91	1672.0
2011-10-19 18:00:00	ES	Futures	1212.16	1213.42	1211.66	1211.66	6008.0
2011-10-19 19:00:00	ES	Futures	1211.66	1213.92	1211.16	1213.17	6079.0
2011-10-19 20:00:00	ES	Futures	1213.17	1214.67	1212.42	1213.42	8541.0
2011-10-19 21:00:00	ES	Futures	1213.42	1213.67	1210.41	1211.91	8935.0
2011-10-19 22:00:00	ES	Futures	1211.91	1212.67	1208.9	1209.66	6876.0
2011-10-19 23:00:00	ES	Futures	1209.41	1210.41	1207.9	1209.91	6033.0
2011-10-19 00:00:00	NQ	Futures	2699.56	2702.16	2697.55	2701.87	471.0
2011-10-19 01:00:00	NQ	Futures	2701.87	2703.6	2699.56	2701.29	738.0
2011-10-19 02:00:00	NQ	Futures	2701.0	2704.46	2698.7	2701.58	1759.0
2011-10-19 03:00:00	NQ	Futures	2701.87	2707.64	2695.82	2701.87	3488.0
2011-10-19 04:00:00	NQ	Futures	2702.73	2705.62	2696.68	2705.62	1454.0
2011-10-19 05:00:00	NQ	Futures	2705.62	2714.84	2704.75	2714.27	2482.0
2011-10-19 06:00:00	NQ	Futures	2714.56	2717.44	2709.65	2715.13	2339.0
2011-10-19 07:00:00	NQ	Futures	2715.42	2716.57	2701.87	2702.73	4596.0
2011-10-19 08:00:00	NQ	Futures	2703.02	2712.83	2700.72	2711.67	6065.0
2011-10-19 09:00:00	NQ	Futures	2711.67	2712.25	2697.83	2701.58	38860.0
2011-10-19 10:00:00	NQ	Futures	2701.29	2713.98	2690.63	2709.65	57887.0
2011-10-19 11:00:00	NQ	Futures	2709.94	2713.4	2700.14	2700.43	27706.0
2011-10-19 12:00:00	NQ	Futures	2700.43	2711.1	2699.27	2706.48	21776.0
2011-10-19 13:00:00	NQ	Futures	2706.19	2709.37	2690.05	2694.66	26170.0
2011-10-19 14:00:00	NQ	Futures	2694.95	2696.39	2665.25	2670.44	55693.0
2011-10-19 15:00:00	NQ	Futures	2670.15	2672.75	2659.2	2667.56	56579.0
2011-10-19 16:00:00	NQ	Futures	2667.56	2675.63	2667.27	2673.33	10075.0
2011-10-19 17:00:00	NQ	Futures	2673.33	2675.34	2673.33	2675.34	440.0
2011-10-19 18:00:00	NQ	Futures	2674.77	2677.65	2673.9	2675.06	428.0
2011-10-19 19:00:00	NQ	Futures	2674.77	2677.94	2674.48	2676.79	270.0
2011-10-19 20:00:00	NQ	Futures	2676.21	2678.8	2675.92	2677.36	660.0
2011-10-19 21:00:00	NQ	Futures	2677.36	2677.94	2671.6	2675.06	660.0
2011-10-19 22:00:00	NQ	Futures	2673.9	2675.92	2669.29	2670.73	620.0
2011-10-19 23:00:00	NQ	Futures	2670.44	2672.17	2667.56	2671.88	530.0
2011-10-19 00:00:00	YM	Futures	11319.5	11319.5	11300.8	11308.7	320.0
2011-10-19 01:00:00	YM	Futures	11314.6	11329.3	11304.7	11310.6	613.0

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

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