PREVIEW / futures_1hour / 2011-04-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	1307.74	1308.73	1307.49	1308.24	2453.0
2011-04-18 01:00:00	ES	Futures	1308.24	1308.98	1307.99	1308.24	2996.0
2011-04-18 02:00:00	ES	Futures	1308.24	1308.48	1306.74	1306.74	9054.0
2011-04-18 03:00:00	ES	Futures	1306.74	1306.99	1301.28	1304.76	49159.0
2011-04-18 04:00:00	ES	Futures	1304.51	1305.25	1302.02	1302.27	19228.0
2011-04-18 05:00:00	ES	Futures	1302.27	1303.76	1302.02	1302.52	13893.0
2011-04-18 06:00:00	ES	Futures	1302.52	1302.52	1300.04	1301.28	23296.0
2011-04-18 07:00:00	ES	Futures	1301.28	1302.77	1300.78	1301.28	27147.0
2011-04-18 08:00:00	ES	Futures	1301.28	1303.27	1300.78	1301.03	36088.0
2011-04-18 09:00:00	ES	Futures	1301.28	1301.78	1287.12	1287.37	570700.0
2011-04-18 10:00:00	ES	Futures	1287.62	1289.85	1283.14	1284.14	448158.0
2011-04-18 11:00:00	ES	Futures	1284.39	1288.36	1282.15	1287.62	223912.0
2011-04-18 12:00:00	ES	Futures	1287.62	1288.61	1285.63	1286.87	77457.0
2011-04-18 13:00:00	ES	Futures	1286.87	1289.6	1284.88	1289.11	87858.0
2011-04-18 14:00:00	ES	Futures	1289.35	1294.07	1287.86	1292.58	189522.0
2011-04-18 15:00:00	ES	Futures	1292.58	1295.57	1290.35	1292.83	319312.0
2011-04-18 16:00:00	ES	Futures	1292.83	1294.32	1290.6	1291.09	123372.0
2011-04-18 17:00:00	ES	Futures	1291.09	1291.34	1290.85	1291.09	1639.0
2011-04-18 18:00:00	ES	Futures	1291.59	1292.09	1289.6	1289.85	5908.0
2011-04-18 19:00:00	ES	Futures	1289.85	1290.85	1289.11	1290.1	5097.0
2011-04-18 20:00:00	ES	Futures	1290.35	1290.6	1288.36	1289.11	8084.0
2011-04-18 21:00:00	ES	Futures	1289.35	1289.6	1286.37	1287.12	9246.0
2011-04-18 22:00:00	ES	Futures	1287.12	1288.11	1286.12	1286.12	6698.0
2011-04-18 23:00:00	ES	Futures	1286.37	1288.11	1285.88	1287.86	6216.0
2011-04-18 00:00:00	NQ	Futures	2651.34	2653.64	2651.05	2652.78	176.0
2011-04-18 01:00:00	NQ	Futures	2652.2	2653.64	2651.63	2652.78	173.0
2011-04-18 02:00:00	NQ	Futures	2652.49	2652.78	2649.04	2649.33	720.0
2011-04-18 03:00:00	NQ	Futures	2649.33	2649.33	2638.7	2645.02	3590.0
2011-04-18 04:00:00	NQ	Futures	2644.73	2646.17	2638.99	2639.85	1145.0
2011-04-18 05:00:00	NQ	Futures	2639.85	2644.73	2639.85	2642.43	1492.0
2011-04-18 06:00:00	NQ	Futures	2642.43	2642.43	2636.4	2638.7	1752.0
2011-04-18 07:00:00	NQ	Futures	2638.7	2641.28	2637.55	2639.56	3797.0
2011-04-18 08:00:00	NQ	Futures	2639.56	2642.72	2638.7	2639.85	3518.0
2011-04-18 09:00:00	NQ	Futures	2639.85	2641.0	2597.04	2599.05	103246.0
2011-04-18 10:00:00	NQ	Futures	2599.05	2600.2	2586.12	2590.72	82272.0
2011-04-18 11:00:00	NQ	Futures	2590.72	2602.21	2588.42	2600.77	38976.0
2011-04-18 12:00:00	NQ	Futures	2601.06	2604.51	2598.47	2602.21	14841.0
2011-04-18 13:00:00	NQ	Futures	2602.21	2613.13	2596.18	2611.98	19094.0
2011-04-18 14:00:00	NQ	Futures	2611.98	2624.91	2608.53	2622.32	38920.0
2011-04-18 15:00:00	NQ	Futures	2622.03	2631.23	2615.43	2629.79	49640.0
2011-04-18 16:00:00	NQ	Futures	2629.79	2634.1	2627.78	2629.22	10485.0
2011-04-18 17:00:00	NQ	Futures	2628.93	2629.79	2628.36	2628.36	178.0
2011-04-18 18:00:00	NQ	Futures	2628.36	2630.08	2625.48	2625.77	353.0
2011-04-18 19:00:00	NQ	Futures	2625.77	2626.63	2624.05	2625.48	420.0
2011-04-18 20:00:00	NQ	Futures	2626.06	2626.34	2622.61	2622.9	480.0
2011-04-18 21:00:00	NQ	Futures	2622.9	2623.76	2618.59	2620.02	752.0
2011-04-18 22:00:00	NQ	Futures	2620.31	2622.61	2617.73	2618.59	374.0
2011-04-18 23:00:00	NQ	Futures	2618.59	2621.75	2618.01	2620.6	358.0
2011-04-18 00:00:00	YM	Futures	11831.8	11839.5	11827.0	11831.8	205.0
2011-04-18 01:00:00	YM	Futures	11832.8	11839.5	11832.8	11836.6	123.0

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

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