PREVIEW / futures_1hour / 2011-08-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-04.parquet
  size:    54 KB
  rows:    1,517

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-04 00:00:00	ES	Futures	1257.75	1258.25	1254.01	1254.26	3736.0
2011-08-04 01:00:00	ES	Futures	1254.01	1255.76	1251.52	1251.77	7646.0
2011-08-04 02:00:00	ES	Futures	1252.02	1258.75	1251.77	1258.5	23983.0
2011-08-04 03:00:00	ES	Futures	1258.5	1258.5	1252.76	1253.26	55981.0
2011-08-04 04:00:00	ES	Futures	1253.26	1253.76	1249.27	1251.02	54386.0
2011-08-04 05:00:00	ES	Futures	1251.02	1252.02	1243.29	1244.78	74371.0
2011-08-04 06:00:00	ES	Futures	1244.53	1245.28	1237.3	1242.54	71258.0
2011-08-04 07:00:00	ES	Futures	1242.54	1244.28	1240.04	1241.04	59058.0
2011-08-04 08:00:00	ES	Futures	1241.04	1245.78	1233.06	1240.79	317030.0
2011-08-04 09:00:00	ES	Futures	1241.04	1244.78	1229.32	1233.56	493417.0
2011-08-04 10:00:00	ES	Futures	1233.31	1235.56	1222.34	1223.83	656295.0
2011-08-04 11:00:00	ES	Futures	1224.08	1226.58	1209.37	1215.85	745873.0
2011-08-04 12:00:00	ES	Futures	1216.1	1225.33	1214.36	1220.59	421996.0
2011-08-04 13:00:00	ES	Futures	1220.59	1223.58	1213.86	1215.35	260535.0
2011-08-04 14:00:00	ES	Futures	1215.35	1216.35	1205.38	1211.86	528843.0
2011-08-04 15:00:00	ES	Futures	1211.86	1216.6	1192.41	1193.9	945556.0
2011-08-04 16:00:00	ES	Futures	1193.9	1197.4	1190.41	1192.66	237439.0
2011-08-04 17:00:00	ES	Futures	1192.41	1194.15	1192.16	1193.65	6068.0
2011-08-04 18:00:00	ES	Futures	1194.65	1197.65	1192.66	1194.15	13839.0
2011-08-04 19:00:00	ES	Futures	1194.15	1194.4	1191.41	1192.66	11242.0
2011-08-04 20:00:00	ES	Futures	1192.66	1197.15	1192.16	1195.65	14172.0
2011-08-04 21:00:00	ES	Futures	1195.65	1197.65	1193.16	1197.15	12513.0
2011-08-04 22:00:00	ES	Futures	1197.4	1198.14	1196.15	1196.65	8653.0
2011-08-04 23:00:00	ES	Futures	1196.9	1196.9	1193.16	1194.15	4476.0
2011-08-04 00:00:00	NQ	Futures	2662.98	2663.27	2655.5	2655.5	450.0
2011-08-04 01:00:00	NQ	Futures	2655.5	2658.95	2650.32	2650.32	498.0
2011-08-04 02:00:00	NQ	Futures	2650.89	2663.84	2650.32	2663.56	1960.0
2011-08-04 03:00:00	NQ	Futures	2663.56	2663.84	2652.62	2653.48	5303.0
2011-08-04 04:00:00	NQ	Futures	2653.77	2654.63	2645.43	2648.02	5960.0
2011-08-04 05:00:00	NQ	Futures	2648.3	2649.74	2632.48	2635.35	5703.0
2011-08-04 06:00:00	NQ	Futures	2635.07	2636.79	2623.27	2632.48	5214.0
2011-08-04 07:00:00	NQ	Futures	2632.19	2636.51	2627.58	2631.61	5572.0
2011-08-04 08:00:00	NQ	Futures	2631.33	2639.67	2616.07	2631.04	29212.0
2011-08-04 09:00:00	NQ	Futures	2630.75	2640.25	2608.3	2616.36	62393.0
2011-08-04 10:00:00	NQ	Futures	2616.36	2623.27	2591.33	2594.49	77782.0
2011-08-04 11:00:00	NQ	Futures	2594.2	2601.4	2568.02	2580.1	78288.0
2011-08-04 12:00:00	NQ	Futures	2580.39	2606.29	2577.23	2595.93	50933.0
2011-08-04 13:00:00	NQ	Futures	2595.93	2601.69	2578.95	2583.56	27848.0
2011-08-04 14:00:00	NQ	Futures	2583.84	2587.87	2566.29	2577.23	55872.0
2011-08-04 15:00:00	NQ	Futures	2577.23	2587.01	2537.8	2538.09	91102.0
2011-08-04 16:00:00	NQ	Futures	2538.09	2548.16	2526.58	2540.39	28930.0
2011-08-04 17:00:00	NQ	Futures	2539.53	2542.12	2538.67	2541.54	391.0
2011-08-04 18:00:00	NQ	Futures	2540.39	2546.72	2537.8	2542.12	976.0
2011-08-04 19:00:00	NQ	Futures	2541.26	2541.26	2534.35	2535.79	687.0
2011-08-04 20:00:00	NQ	Futures	2535.5	2544.42	2534.92	2539.82	839.0
2011-08-04 21:00:00	NQ	Futures	2539.82	2545.28	2535.5	2544.42	758.0
2011-08-04 22:00:00	NQ	Futures	2544.42	2545.57	2541.54	2542.41	502.0
2011-08-04 23:00:00	NQ	Futures	2543.27	2543.27	2535.79	2537.23	471.0
2011-08-04 00:00:00	YM	Futures	11493.9	11496.8	11465.8	11465.8	244.0
2011-08-04 01:00:00	YM	Futures	11464.9	11477.5	11439.7	11443.6	686.0

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

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