PREVIEW / futures_1hour / 2011-10-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	1229.72	1230.97	1228.71	1229.97	5103.0
2011-10-17 01:00:00	ES	Futures	1229.97	1231.47	1227.46	1228.21	7360.0
2011-10-17 02:00:00	ES	Futures	1228.21	1229.47	1226.46	1229.22	12380.0
2011-10-17 03:00:00	ES	Futures	1229.22	1233.48	1227.71	1232.73	43976.0
2011-10-17 04:00:00	ES	Futures	1232.48	1234.48	1231.47	1232.73	33883.0
2011-10-17 05:00:00	ES	Futures	1232.98	1233.48	1227.46	1228.21	51946.0
2011-10-17 06:00:00	ES	Futures	1227.96	1229.22	1223.45	1224.45	55523.0
2011-10-17 07:00:00	ES	Futures	1224.45	1224.45	1219.69	1221.69	63440.0
2011-10-17 08:00:00	ES	Futures	1221.44	1223.2	1217.93	1218.68	70333.0
2011-10-17 09:00:00	ES	Futures	1218.93	1219.44	1213.17	1213.92	261520.0
2011-10-17 10:00:00	ES	Futures	1213.92	1214.42	1206.65	1209.91	397214.0
2011-10-17 11:00:00	ES	Futures	1209.91	1212.42	1207.65	1208.15	216198.0
2011-10-17 12:00:00	ES	Futures	1207.9	1208.65	1203.39	1204.14	193695.0
2011-10-17 13:00:00	ES	Futures	1204.39	1207.15	1201.13	1203.89	206973.0
2011-10-17 14:00:00	ES	Futures	1203.89	1204.89	1198.12	1202.13	188968.0
2011-10-17 15:00:00	ES	Futures	1202.13	1205.39	1197.12	1200.13	397565.0
2011-10-17 16:00:00	ES	Futures	1200.13	1203.14	1194.36	1195.61	123727.0
2011-10-17 17:00:00	ES	Futures	1195.87	1195.87	1190.85	1193.36	13863.0
2011-10-17 18:00:00	ES	Futures	1193.86	1196.12	1193.11	1196.12	5165.0
2011-10-17 19:00:00	ES	Futures	1196.12	1197.62	1194.61	1195.36	5196.0
2011-10-17 20:00:00	ES	Futures	1195.36	1197.87	1194.11	1196.87	8342.0
2011-10-17 21:00:00	ES	Futures	1197.12	1199.12	1196.12	1196.37	7333.0
2011-10-17 22:00:00	ES	Futures	1196.37	1198.12	1194.61	1196.12	9507.0
2011-10-17 23:00:00	ES	Futures	1196.12	1200.13	1195.11	1199.63	6430.0
2011-10-17 00:00:00	NQ	Futures	2740.79	2743.96	2739.35	2743.1	456.0
2011-10-17 01:00:00	NQ	Futures	2742.52	2745.12	2738.78	2741.66	752.0
2011-10-17 02:00:00	NQ	Futures	2741.66	2747.71	2737.05	2744.25	1637.0
2011-10-17 03:00:00	NQ	Futures	2744.25	2752.33	2741.08	2749.15	4147.0
2011-10-17 04:00:00	NQ	Futures	2748.87	2754.63	2748.58	2752.04	2484.0
2011-10-17 05:00:00	NQ	Futures	2752.33	2753.77	2741.95	2743.1	2785.0
2011-10-17 06:00:00	NQ	Futures	2742.52	2746.27	2732.72	2734.16	4624.0
2011-10-17 07:00:00	NQ	Futures	2733.87	2734.16	2720.61	2723.49	5769.0
2011-10-17 08:00:00	NQ	Futures	2723.78	2724.65	2711.38	2714.27	12313.0
2011-10-17 09:00:00	NQ	Futures	2713.98	2724.94	2708.79	2714.27	39675.0
2011-10-17 10:00:00	NQ	Futures	2714.56	2716.86	2703.6	2705.62	45339.0
2011-10-17 11:00:00	NQ	Futures	2705.62	2714.56	2699.56	2699.56	27990.0
2011-10-17 12:00:00	NQ	Futures	2699.56	2699.56	2683.99	2688.03	32691.0
2011-10-17 13:00:00	NQ	Futures	2687.74	2696.39	2681.98	2688.32	25301.0
2011-10-17 14:00:00	NQ	Futures	2688.03	2690.05	2672.17	2682.84	39096.0
2011-10-17 15:00:00	NQ	Futures	2682.84	2693.51	2678.8	2687.74	53235.0
2011-10-17 16:00:00	NQ	Futures	2687.74	2695.82	2671.88	2674.48	12670.0
2011-10-17 17:00:00	NQ	Futures	2674.48	2675.06	2666.12	2668.42	845.0
2011-10-17 18:00:00	NQ	Futures	2671.02	2676.21	2670.73	2675.63	576.0
2011-10-17 19:00:00	NQ	Futures	2675.34	2679.38	2674.77	2676.21	445.0
2011-10-17 20:00:00	NQ	Futures	2675.92	2682.26	2674.48	2681.4	946.0
2011-10-17 21:00:00	NQ	Futures	2681.11	2685.72	2679.09	2679.67	681.0
2011-10-17 22:00:00	NQ	Futures	2679.09	2680.82	2674.48	2677.36	852.0
2011-10-17 23:00:00	NQ	Futures	2677.36	2685.72	2675.92	2685.15	430.0
2011-10-17 00:00:00	YM	Futures	11441.6	11450.4	11434.7	11445.5	362.0
2011-10-17 01:00:00	YM	Futures	11443.5	11453.4	11421.9	11429.8	720.0

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

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