PREVIEW / futures_1hour / 2011-10-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	1202.38	1203.39	1201.63	1202.38	3347.0
2011-10-13 01:00:00	ES	Futures	1202.38	1203.14	1199.12	1199.88	7152.0
2011-10-13 02:00:00	ES	Futures	1200.13	1201.38	1197.87	1199.88	14130.0
2011-10-13 03:00:00	ES	Futures	1199.88	1207.9	1199.63	1206.4	44557.0
2011-10-13 04:00:00	ES	Futures	1206.4	1206.65	1196.87	1197.87	54939.0
2011-10-13 05:00:00	ES	Futures	1198.12	1200.63	1195.11	1196.87	46244.0
2011-10-13 06:00:00	ES	Futures	1196.87	1200.13	1194.36	1199.12	70160.0
2011-10-13 07:00:00	ES	Futures	1199.38	1199.38	1193.86	1195.61	46909.0
2011-10-13 08:00:00	ES	Futures	1195.87	1198.37	1193.61	1197.37	65691.0
2011-10-13 09:00:00	ES	Futures	1197.37	1199.12	1192.1	1193.36	263996.0
2011-10-13 10:00:00	ES	Futures	1193.11	1197.37	1189.6	1189.85	405989.0
2011-10-13 11:00:00	ES	Futures	1189.85	1196.62	1188.84	1194.36	321553.0
2011-10-13 12:00:00	ES	Futures	1194.36	1196.12	1190.85	1194.36	125394.0
2011-10-13 13:00:00	ES	Futures	1194.36	1201.38	1192.1	1199.12	210458.0
2011-10-13 14:00:00	ES	Futures	1199.38	1204.39	1196.87	1202.89	173376.0
2011-10-13 15:00:00	ES	Futures	1202.89	1206.65	1197.87	1202.89	327043.0
2011-10-13 16:00:00	ES	Futures	1202.89	1205.39	1200.38	1201.88	92643.0
2011-10-13 17:00:00	ES	Futures	1201.63	1203.14	1201.63	1202.89	3047.0
2011-10-13 18:00:00	ES	Futures	1202.64	1203.14	1198.87	1199.12	8027.0
2011-10-13 19:00:00	ES	Futures	1199.12	1200.88	1198.87	1200.13	4903.0
2011-10-13 20:00:00	ES	Futures	1200.13	1202.13	1196.87	1197.12	8079.0
2011-10-13 21:00:00	ES	Futures	1196.87	1203.64	1196.62	1200.63	12661.0
2011-10-13 22:00:00	ES	Futures	1200.63	1201.13	1197.12	1198.37	7180.0
2011-10-13 23:00:00	ES	Futures	1198.12	1200.13	1197.62	1199.38	4702.0
2011-10-13 00:00:00	NQ	Futures	2652.28	2653.43	2649.97	2651.99	305.0
2011-10-13 01:00:00	NQ	Futures	2651.99	2652.86	2645.65	2646.51	496.0
2011-10-13 02:00:00	NQ	Futures	2646.8	2649.97	2643.05	2646.8	1336.0
2011-10-13 03:00:00	NQ	Futures	2646.22	2665.25	2645.94	2662.37	3991.0
2011-10-13 04:00:00	NQ	Futures	2662.08	2662.08	2642.48	2645.65	4451.0
2011-10-13 05:00:00	NQ	Futures	2645.94	2651.99	2639.88	2643.63	3831.0
2011-10-13 06:00:00	NQ	Futures	2643.92	2651.41	2640.75	2649.68	4191.0
2011-10-13 07:00:00	NQ	Futures	2649.4	2649.68	2641.03	2643.34	5159.0
2011-10-13 08:00:00	NQ	Futures	2643.05	2649.97	2640.17	2647.95	6178.0
2011-10-13 09:00:00	NQ	Futures	2647.67	2658.62	2646.8	2652.28	43752.0
2011-10-13 10:00:00	NQ	Futures	2652.28	2663.81	2648.82	2649.97	68137.0
2011-10-13 11:00:00	NQ	Futures	2650.26	2668.71	2648.53	2663.81	41510.0
2011-10-13 12:00:00	NQ	Futures	2663.81	2667.27	2656.31	2660.93	25041.0
2011-10-13 13:00:00	NQ	Futures	2660.64	2672.17	2655.16	2665.54	24730.0
2011-10-13 14:00:00	NQ	Futures	2665.83	2677.65	2662.08	2675.06	20838.0
2011-10-13 15:00:00	NQ	Futures	2675.06	2682.84	2666.69	2679.09	41896.0
2011-10-13 16:00:00	NQ	Futures	2678.8	2694.37	2678.23	2684.86	16291.0
2011-10-13 17:00:00	NQ	Futures	2685.15	2688.03	2685.15	2687.17	576.0
2011-10-13 18:00:00	NQ	Futures	2686.59	2689.76	2680.82	2682.55	791.0
2011-10-13 19:00:00	NQ	Futures	2682.55	2684.57	2681.4	2684.57	748.0
2011-10-13 20:00:00	NQ	Futures	2684.28	2687.17	2676.79	2676.79	706.0
2011-10-13 21:00:00	NQ	Futures	2676.21	2688.9	2675.92	2683.71	1356.0
2011-10-13 22:00:00	NQ	Futures	2683.99	2684.57	2678.23	2680.53	889.0
2011-10-13 23:00:00	NQ	Futures	2680.53	2686.3	2679.96	2684.86	538.0
2011-10-13 00:00:00	YM	Futures	11249.6	11257.5	11242.7	11252.5	198.0
2011-10-13 01:00:00	YM	Futures	11253.5	11254.5	11226.9	11230.9	769.0

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

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