PREVIEW / futures_1hour / 2011-10-10

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-10.parquet
  size:    48 KB
  rows:    1,413

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-10 00:00:00	ES	Futures	1172.04	1173.05	1171.29	1172.54	4486.0
2011-10-10 01:00:00	ES	Futures	1172.54	1173.05	1170.29	1171.04	5393.0
2011-10-10 02:00:00	ES	Futures	1170.79	1173.55	1168.53	1170.29	13633.0
2011-10-10 03:00:00	ES	Futures	1170.04	1173.05	1166.28	1171.79	49917.0
2011-10-10 04:00:00	ES	Futures	1171.79	1172.54	1167.53	1171.79	31379.0
2011-10-10 05:00:00	ES	Futures	1171.54	1173.05	1169.28	1171.79	24003.0
2011-10-10 06:00:00	ES	Futures	1171.79	1175.8	1171.54	1172.54	24680.0
2011-10-10 07:00:00	ES	Futures	1172.54	1175.05	1171.29	1172.29	25188.0
2011-10-10 08:00:00	ES	Futures	1172.54	1174.05	1171.79	1172.54	39021.0
2011-10-10 09:00:00	ES	Futures	1172.54	1181.57	1172.29	1181.07	228983.0
2011-10-10 10:00:00	ES	Futures	1181.07	1189.09	1180.07	1186.34	339033.0
2011-10-10 11:00:00	ES	Futures	1186.34	1188.34	1184.58	1187.59	158160.0
2011-10-10 12:00:00	ES	Futures	1187.59	1188.34	1185.33	1186.34	99156.0
2011-10-10 13:00:00	ES	Futures	1186.34	1190.6	1185.83	1187.59	103187.0
2011-10-10 14:00:00	ES	Futures	1187.59	1188.84	1185.58	1185.83	83416.0
2011-10-10 15:00:00	ES	Futures	1185.58	1194.11	1180.32	1193.86	351619.0
2011-10-10 16:00:00	ES	Futures	1193.86	1195.87	1192.86	1193.36	136890.0
2011-10-10 17:00:00	ES	Futures	1193.61	1193.86	1192.1	1192.86	4352.0
2011-10-10 18:00:00	ES	Futures	1192.61	1193.61	1191.1	1192.86	5606.0
2011-10-10 19:00:00	ES	Futures	1192.61	1193.61	1191.85	1192.61	3696.0
2011-10-10 20:00:00	ES	Futures	1192.86	1193.86	1191.85	1192.61	9384.0
2011-10-10 21:00:00	ES	Futures	1192.61	1193.86	1191.85	1192.35	7187.0
2011-10-10 22:00:00	ES	Futures	1192.1	1193.36	1190.1	1190.1	5521.0
2011-10-10 23:00:00	ES	Futures	1190.1	1191.6	1189.85	1191.1	3613.0
2011-10-10 00:00:00	NQ	Futures	2571.26	2573.28	2569.82	2571.84	323.0
2011-10-10 01:00:00	NQ	Futures	2571.84	2573.28	2568.66	2569.53	370.0
2011-10-10 02:00:00	NQ	Futures	2569.24	2574.72	2563.76	2566.36	2052.0
2011-10-10 03:00:00	NQ	Futures	2566.36	2572.99	2560.88	2572.12	5196.0
2011-10-10 04:00:00	NQ	Futures	2571.84	2571.84	2563.19	2569.24	3253.0
2011-10-10 05:00:00	NQ	Futures	2568.95	2572.12	2564.92	2567.51	1923.0
2011-10-10 06:00:00	NQ	Futures	2567.8	2576.16	2567.22	2570.97	2443.0
2011-10-10 07:00:00	NQ	Futures	2570.68	2575.3	2568.38	2571.55	3007.0
2011-10-10 08:00:00	NQ	Futures	2571.84	2575.87	2570.97	2572.41	4923.0
2011-10-10 09:00:00	NQ	Futures	2572.99	2597.21	2572.7	2596.34	35521.0
2011-10-10 10:00:00	NQ	Futures	2596.06	2617.68	2592.6	2611.62	44997.0
2011-10-10 11:00:00	NQ	Futures	2611.34	2615.37	2606.72	2613.35	18576.0
2011-10-10 12:00:00	NQ	Futures	2613.64	2614.8	2605.57	2608.17	12836.0
2011-10-10 13:00:00	NQ	Futures	2607.88	2616.24	2606.72	2612.78	13824.0
2011-10-10 14:00:00	NQ	Futures	2612.78	2614.8	2603.84	2604.42	13402.0
2011-10-10 15:00:00	NQ	Futures	2604.13	2622.0	2590.58	2622.0	42748.0
2011-10-10 16:00:00	NQ	Futures	2621.72	2627.48	2620.85	2623.73	12710.0
2011-10-10 17:00:00	NQ	Futures	2623.45	2624.6	2621.72	2622.29	365.0
2011-10-10 18:00:00	NQ	Futures	2622.0	2624.02	2619.99	2622.58	817.0
2011-10-10 19:00:00	NQ	Futures	2622.0	2623.45	2621.43	2622.87	293.0
2011-10-10 20:00:00	NQ	Futures	2623.16	2624.02	2619.99	2621.43	699.0
2011-10-10 21:00:00	NQ	Futures	2621.43	2623.73	2619.7	2620.27	626.0
2011-10-10 22:00:00	NQ	Futures	2620.27	2622.0	2617.1	2617.1	688.0
2011-10-10 23:00:00	NQ	Futures	2616.81	2620.27	2615.95	2618.26	325.0
2011-10-10 00:00:00	YM	Futures	11011.3	11020.2	11006.4	11015.3	329.0
2011-10-10 01:00:00	YM	Futures	11014.3	11021.2	10995.6	11002.5	655.0

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

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