PREVIEW / futures_1hour / 2011-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-05.parquet
  size:    44 KB
  rows:    1,217

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-08-05 00:00:00	ES	Futures	1194.15	1195.9	1193.16	1193.9	5882.0
2011-08-05 01:00:00	ES	Futures	1193.9	1196.15	1192.41	1194.65	7533.0
2011-08-05 02:00:00	ES	Futures	1194.65	1195.9	1180.69	1181.68	64852.0
2011-08-05 03:00:00	ES	Futures	1181.93	1199.14	1181.93	1198.14	147883.0
2011-08-05 04:00:00	ES	Futures	1197.89	1198.14	1185.92	1191.16	96871.0
2011-08-05 05:00:00	ES	Futures	1190.91	1194.4	1187.17	1187.17	51467.0
2011-08-05 06:00:00	ES	Futures	1187.17	1196.9	1185.67	1193.65	66636.0
2011-08-05 07:00:00	ES	Futures	1193.41	1197.89	1189.66	1197.65	82582.0
2011-08-05 08:00:00	ES	Futures	1197.4	1216.1	1188.92	1205.88	428015.0
2011-08-05 09:00:00	ES	Futures	1205.88	1214.11	1182.18	1182.93	831179.0
2011-08-05 10:00:00	ES	Futures	1182.93	1200.39	1180.19	1191.41	911676.0
2011-08-05 11:00:00	ES	Futures	1191.16	1191.41	1160.48	1164.23	807795.0
2011-08-05 12:00:00	ES	Futures	1164.23	1207.37	1162.73	1201.64	994320.0
2011-08-05 13:00:00	ES	Futures	1201.39	1209.62	1191.16	1205.38	526187.0
2011-08-05 14:00:00	ES	Futures	1205.13	1206.13	1192.16	1195.65	320339.0
2011-08-05 15:00:00	ES	Futures	1195.65	1197.65	1181.93	1192.16	594439.0
2011-08-05 16:00:00	ES	Futures	1192.16	1196.4	1189.42	1194.65	124994.0
2011-08-05 00:00:00	NQ	Futures	2537.23	2542.12	2536.08	2537.8	238.0
2011-08-05 01:00:00	NQ	Futures	2538.38	2541.26	2534.06	2538.09	360.0
2011-08-05 02:00:00	NQ	Futures	2538.67	2540.39	2508.45	2511.9	5708.0
2011-08-05 03:00:00	NQ	Futures	2511.9	2548.16	2511.62	2546.44	12365.0
2011-08-05 04:00:00	NQ	Futures	2546.44	2546.44	2522.84	2532.62	6708.0
2011-08-05 05:00:00	NQ	Futures	2532.91	2537.8	2520.54	2520.82	3963.0
2011-08-05 06:00:00	NQ	Futures	2520.82	2539.82	2518.23	2534.35	5029.0
2011-08-05 07:00:00	NQ	Futures	2534.35	2542.98	2527.15	2542.12	5854.0
2011-08-05 08:00:00	NQ	Futures	2542.12	2577.51	2528.02	2558.81	30077.0
2011-08-05 09:00:00	NQ	Futures	2558.52	2577.23	2498.95	2505.86	99684.0
2011-08-05 10:00:00	NQ	Futures	2505.86	2550.75	2496.36	2528.59	112519.0
2011-08-05 11:00:00	NQ	Futures	2528.59	2528.59	2450.32	2460.39	105338.0
2011-08-05 12:00:00	NQ	Futures	2460.11	2557.95	2456.08	2543.85	120214.0
2011-08-05 13:00:00	NQ	Futures	2543.85	2559.96	2519.96	2549.89	52904.0
2011-08-05 14:00:00	NQ	Futures	2549.89	2552.48	2516.51	2523.99	33624.0
2011-08-05 15:00:00	NQ	Futures	2524.28	2532.33	2497.8	2520.82	69005.0
2011-08-05 16:00:00	NQ	Futures	2521.11	2524.85	2513.63	2521.11	12903.0
2011-08-05 00:00:00	YM	Futures	10983.6	10998.1	10978.7	10981.6	469.0
2011-08-05 01:00:00	YM	Futures	10982.6	11003.9	10978.7	10995.2	726.0
2011-08-05 02:00:00	YM	Futures	10993.3	11001.0	10866.4	10874.2	6485.0
2011-08-05 03:00:00	YM	Futures	10875.1	11026.2	10875.1	11017.5	6297.0
2011-08-05 04:00:00	YM	Futures	11017.5	11018.4	10914.8	10958.4	3844.0
2011-08-05 05:00:00	YM	Futures	10959.4	10986.5	10927.4	10928.4	1680.0
2011-08-05 06:00:00	YM	Futures	10927.4	10997.1	10916.8	10974.9	1943.0
2011-08-05 07:00:00	YM	Futures	10972.9	11001.0	10941.9	11001.0	2972.0
2011-08-05 08:00:00	YM	Futures	10999.1	11181.1	10905.1	11080.4	17894.0
2011-08-05 09:00:00	YM	Futures	11081.4	11156.9	10908.1	10919.7	42364.0
2011-08-05 10:00:00	YM	Futures	10919.7	11033.0	10889.7	10960.3	49173.0
2011-08-05 11:00:00	YM	Futures	10959.4	10959.4	10737.6	10769.6	50821.0
2011-08-05 12:00:00	YM	Futures	10769.6	11131.8	10759.9	11084.3	54636.0
2011-08-05 13:00:00	YM	Futures	11083.3	11133.7	10997.1	11100.8	31534.0
2011-08-05 14:00:00	YM	Futures	11099.8	11106.6	11008.8	11044.6	17468.0
2011-08-05 15:00:00	YM	Futures	11045.6	11061.1	10932.3	11027.2	31023.0

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

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