PREVIEW / futures_1hour / 2011-04-19

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-19.parquet
  size:    49 KB
  rows:    1,490

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-04-19 00:00:00	ES	Futures	1287.86	1288.86	1286.87	1288.61	3058.0
2011-04-19 01:00:00	ES	Futures	1288.61	1290.6	1288.36	1289.6	6677.0
2011-04-19 02:00:00	ES	Futures	1289.35	1291.34	1289.35	1290.6	11216.0
2011-04-19 03:00:00	ES	Futures	1290.6	1292.34	1289.6	1291.09	32414.0
2011-04-19 04:00:00	ES	Futures	1290.85	1291.09	1289.35	1290.6	12568.0
2011-04-19 05:00:00	ES	Futures	1290.6	1293.33	1290.35	1293.33	17141.0
2011-04-19 06:00:00	ES	Futures	1293.33	1293.33	1291.09	1292.34	13155.0
2011-04-19 07:00:00	ES	Futures	1292.34	1295.32	1292.34	1294.57	35120.0
2011-04-19 08:00:00	ES	Futures	1294.57	1296.56	1293.58	1294.82	59161.0
2011-04-19 09:00:00	ES	Futures	1294.82	1298.05	1293.33	1295.32	220595.0
2011-04-19 10:00:00	ES	Futures	1295.32	1297.55	1293.33	1293.83	199363.0
2011-04-19 11:00:00	ES	Futures	1293.83	1294.32	1291.59	1293.83	209448.0
2011-04-19 12:00:00	ES	Futures	1293.83	1295.32	1293.08	1294.57	101936.0
2011-04-19 13:00:00	ES	Futures	1294.82	1299.54	1294.57	1298.55	185942.0
2011-04-19 14:00:00	ES	Futures	1298.3	1299.54	1297.55	1298.3	85946.0
2011-04-19 15:00:00	ES	Futures	1298.05	1300.78	1298.05	1300.04	196639.0
2011-04-19 16:00:00	ES	Futures	1299.79	1304.26	1298.79	1302.77	107258.0
2011-04-19 17:00:00	ES	Futures	1302.52	1305.75	1302.02	1305.25	10827.0
2011-04-19 18:00:00	ES	Futures	1305.25	1305.25	1304.01	1304.01	2927.0
2011-04-19 19:00:00	ES	Futures	1304.01	1305.5	1303.76	1305.01	3760.0
2011-04-19 20:00:00	ES	Futures	1305.01	1305.01	1303.27	1304.51	7561.0
2011-04-19 21:00:00	ES	Futures	1304.26	1306.74	1304.26	1306.0	7292.0
2011-04-19 22:00:00	ES	Futures	1305.75	1307.74	1305.5	1307.24	6600.0
2011-04-19 23:00:00	ES	Futures	1307.24	1307.99	1307.24	1307.74	4059.0
2011-04-19 00:00:00	NQ	Futures	2620.89	2622.61	2619.16	2622.61	140.0
2011-04-19 01:00:00	NQ	Futures	2622.61	2626.63	2622.61	2625.77	1015.0
2011-04-19 02:00:00	NQ	Futures	2625.77	2629.22	2622.61	2628.36	1429.0
2011-04-19 03:00:00	NQ	Futures	2628.36	2631.8	2626.92	2628.93	1761.0
2011-04-19 04:00:00	NQ	Futures	2628.64	2629.22	2625.48	2626.63	1156.0
2011-04-19 05:00:00	NQ	Futures	2626.63	2633.24	2626.63	2632.95	1102.0
2011-04-19 06:00:00	NQ	Futures	2632.67	2632.95	2628.93	2630.94	977.0
2011-04-19 07:00:00	NQ	Futures	2630.94	2636.4	2630.65	2634.96	3102.0
2011-04-19 08:00:00	NQ	Futures	2634.96	2638.99	2634.39	2636.69	6583.0
2011-04-19 09:00:00	NQ	Futures	2636.69	2639.85	2628.93	2632.09	37602.0
2011-04-19 10:00:00	NQ	Futures	2632.09	2637.26	2626.06	2628.07	35571.0
2011-04-19 11:00:00	NQ	Futures	2628.07	2630.65	2623.18	2627.49	28470.0
2011-04-19 12:00:00	NQ	Futures	2627.49	2630.37	2624.62	2628.93	15482.0
2011-04-19 13:00:00	NQ	Futures	2628.93	2639.85	2628.64	2637.55	20451.0
2011-04-19 14:00:00	NQ	Futures	2637.26	2639.85	2633.53	2638.41	13894.0
2011-04-19 15:00:00	NQ	Futures	2638.41	2646.17	2638.12	2646.17	32404.0
2011-04-19 16:00:00	NQ	Futures	2646.17	2665.99	2645.31	2662.83	24100.0
2011-04-19 17:00:00	NQ	Futures	2662.83	2670.02	2661.4	2668.29	1349.0
2011-04-19 18:00:00	NQ	Futures	2668.01	2668.01	2664.27	2664.27	368.0
2011-04-19 19:00:00	NQ	Futures	2665.13	2667.14	2664.27	2666.86	420.0
2011-04-19 20:00:00	NQ	Futures	2666.57	2666.86	2662.83	2664.84	511.0
2011-04-19 21:00:00	NQ	Futures	2664.56	2669.15	2664.56	2666.28	415.0
2011-04-19 22:00:00	NQ	Futures	2666.57	2673.75	2666.28	2672.6	646.0
2011-04-19 23:00:00	NQ	Futures	2672.6	2676.05	2672.31	2674.33	976.0
2011-04-19 00:00:00	YM	Futures	11657.5	11666.1	11651.7	11662.3	289.0
2011-04-19 01:00:00	YM	Futures	11664.2	11679.6	11664.2	11670.0	457.0

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

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