PREVIEW / futures_1hour / 2011-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-15.parquet
  size:    49 KB
  rows:    1,452

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-09-15 00:00:00	ES	Futures	1184.58	1184.83	1180.57	1180.82	6605.0
2011-09-15 01:00:00	ES	Futures	1180.82	1185.58	1180.32	1185.08	8825.0
2011-09-15 02:00:00	ES	Futures	1185.08	1186.09	1179.32	1181.57	19905.0
2011-09-15 03:00:00	ES	Futures	1181.57	1190.35	1179.82	1189.85	65941.0
2011-09-15 04:00:00	ES	Futures	1189.85	1191.35	1186.84	1190.6	41239.0
2011-09-15 05:00:00	ES	Futures	1190.35	1192.35	1187.84	1192.1	32853.0
2011-09-15 06:00:00	ES	Futures	1192.1	1194.36	1190.1	1194.11	36398.0
2011-09-15 07:00:00	ES	Futures	1194.11	1194.61	1191.85	1193.11	42977.0
2011-09-15 08:00:00	ES	Futures	1192.86	1193.36	1185.83	1187.09	141249.0
2011-09-15 09:00:00	ES	Futures	1187.09	1203.39	1187.09	1195.11	501431.0
2011-09-15 10:00:00	ES	Futures	1195.11	1201.88	1188.34	1189.6	476407.0
2011-09-15 11:00:00	ES	Futures	1189.85	1198.12	1187.59	1197.12	320537.0
2011-09-15 12:00:00	ES	Futures	1196.87	1200.38	1195.11	1199.63	158430.0
2011-09-15 13:00:00	ES	Futures	1199.38	1201.88	1197.87	1201.13	146191.0
2011-09-15 14:00:00	ES	Futures	1201.13	1205.64	1200.38	1204.89	230540.0
2011-09-15 15:00:00	ES	Futures	1204.89	1206.65	1200.38	1206.4	355548.0
2011-09-15 16:00:00	ES	Futures	1206.15	1209.16	1205.64	1206.4	145546.0
2011-09-15 17:00:00	ES	Futures	1206.4	1212.42	1206.15	1211.16	9975.0
2011-09-15 18:00:00	ES	Futures	1211.16	1211.41	1207.65	1208.15	7730.0
2011-09-15 19:00:00	ES	Futures	1207.9	1209.91	1206.9	1207.15	3924.0
2011-09-15 20:00:00	ES	Futures	1207.4	1207.9	1205.14	1206.15	8114.0
2011-09-15 21:00:00	ES	Futures	1206.15	1208.65	1205.9	1207.4	6308.0
2011-09-15 22:00:00	ES	Futures	1207.65	1208.9	1206.9	1208.4	3572.0
2011-09-15 23:00:00	ES	Futures	1208.15	1211.41	1208.15	1210.41	7664.0
2011-09-15 00:00:00	NQ	Futures	2587.12	2588.85	2582.5	2583.37	706.0
2011-09-15 01:00:00	NQ	Futures	2583.66	2593.75	2582.5	2593.46	1235.0
2011-09-15 02:00:00	NQ	Futures	2593.17	2596.06	2583.95	2587.41	2131.0
2011-09-15 03:00:00	NQ	Futures	2587.12	2604.13	2583.95	2603.26	4450.0
2011-09-15 04:00:00	NQ	Futures	2603.55	2608.45	2596.92	2605.86	2759.0
2011-09-15 05:00:00	NQ	Futures	2606.44	2610.47	2601.25	2610.47	1928.0
2011-09-15 06:00:00	NQ	Futures	2610.18	2615.08	2605.57	2614.8	3553.0
2011-09-15 07:00:00	NQ	Futures	2614.8	2615.95	2609.32	2611.91	4079.0
2011-09-15 08:00:00	NQ	Futures	2611.91	2612.49	2597.5	2598.94	16838.0
2011-09-15 09:00:00	NQ	Futures	2599.23	2630.08	2599.23	2611.62	61325.0
2011-09-15 10:00:00	NQ	Futures	2612.49	2623.16	2596.34	2599.52	63634.0
2011-09-15 11:00:00	NQ	Futures	2599.52	2617.68	2593.17	2615.37	45031.0
2011-09-15 12:00:00	NQ	Futures	2615.37	2623.16	2611.05	2621.72	24304.0
2011-09-15 13:00:00	NQ	Futures	2622.0	2628.06	2618.54	2626.04	27911.0
2011-09-15 14:00:00	NQ	Futures	2626.33	2633.25	2624.02	2631.23	32375.0
2011-09-15 15:00:00	NQ	Futures	2631.23	2635.27	2623.45	2631.23	49680.0
2011-09-15 16:00:00	NQ	Futures	2631.23	2637.0	2630.08	2631.23	12826.0
2011-09-15 17:00:00	NQ	Futures	2631.23	2641.03	2630.94	2639.88	469.0
2011-09-15 18:00:00	NQ	Futures	2639.02	2639.3	2633.25	2634.69	370.0
2011-09-15 19:00:00	NQ	Futures	2634.4	2636.42	2632.38	2632.96	375.0
2011-09-15 20:00:00	NQ	Futures	2632.67	2632.96	2628.64	2630.94	343.0
2011-09-15 21:00:00	NQ	Futures	2630.65	2636.13	2630.37	2633.83	507.0
2011-09-15 22:00:00	NQ	Futures	2634.11	2636.71	2632.67	2635.56	310.0
2011-09-15 23:00:00	NQ	Futures	2634.98	2640.17	2634.98	2638.73	570.0
2011-09-15 00:00:00	YM	Futures	10986.7	10990.6	10954.2	10957.2	420.0
2011-09-15 01:00:00	YM	Futures	10956.2	10997.5	10954.2	10997.5	514.0

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

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