PREVIEW / futures_1hour / 2011-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-01.parquet
  size:    48 KB
  rows:    1,461

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-03-01 00:00:00	ES	Futures	1314.83	1315.32	1314.58	1315.32	2356.0
2011-03-01 01:00:00	ES	Futures	1315.32	1317.8	1315.32	1317.55	9168.0
2011-03-01 02:00:00	ES	Futures	1317.3	1318.79	1316.56	1318.54	15900.0
2011-03-01 03:00:00	ES	Futures	1318.54	1322.5	1318.04	1322.0	42691.0
2011-03-01 04:00:00	ES	Futures	1322.0	1322.75	1319.03	1319.78	24386.0
2011-03-01 05:00:00	ES	Futures	1320.02	1320.52	1318.79	1319.78	11906.0
2011-03-01 06:00:00	ES	Futures	1319.78	1320.02	1317.55	1318.29	18431.0
2011-03-01 07:00:00	ES	Futures	1318.29	1318.29	1313.84	1316.56	64927.0
2011-03-01 08:00:00	ES	Futures	1316.81	1317.55	1315.07	1317.05	51336.0
2011-03-01 09:00:00	ES	Futures	1317.05	1318.79	1311.61	1312.6	306302.0
2011-03-01 10:00:00	ES	Futures	1312.85	1314.58	1303.94	1309.88	579151.0
2011-03-01 11:00:00	ES	Futures	1309.88	1311.36	1301.47	1301.96	384597.0
2011-03-01 12:00:00	ES	Futures	1301.96	1303.2	1298.99	1301.47	299674.0
2011-03-01 13:00:00	ES	Futures	1301.22	1301.96	1296.27	1298.5	271789.0
2011-03-01 14:00:00	ES	Futures	1298.25	1298.5	1292.06	1293.55	371517.0
2011-03-01 15:00:00	ES	Futures	1293.8	1295.78	1291.07	1291.32	390676.0
2011-03-01 16:00:00	ES	Futures	1291.07	1291.57	1284.64	1284.89	178918.0
2011-03-01 17:00:00	ES	Futures	1284.89	1285.14	1283.4	1284.15	7767.0
2011-03-01 18:00:00	ES	Futures	1284.39	1288.35	1284.39	1287.36	22224.0
2011-03-01 19:00:00	ES	Futures	1287.61	1289.1	1285.88	1286.87	12555.0
2011-03-01 20:00:00	ES	Futures	1286.87	1288.11	1285.38	1285.38	11530.0
2011-03-01 21:00:00	ES	Futures	1285.63	1286.13	1282.91	1284.39	10004.0
2011-03-01 22:00:00	ES	Futures	1284.15	1286.13	1283.9	1285.38	4456.0
2011-03-01 23:00:00	ES	Futures	1285.38	1286.37	1283.65	1284.15	4036.0
2011-03-01 00:00:00	NQ	Futures	2702.98	2703.85	2701.26	2703.27	185.0
2011-03-01 01:00:00	NQ	Futures	2703.56	2709.01	2703.56	2707.86	591.0
2011-03-01 02:00:00	NQ	Futures	2707.58	2712.17	2707.29	2711.88	1166.0
2011-03-01 03:00:00	NQ	Futures	2712.17	2722.79	2710.73	2722.5	3868.0
2011-03-01 04:00:00	NQ	Futures	2722.22	2723.08	2715.04	2716.48	1502.0
2011-03-01 05:00:00	NQ	Futures	2716.19	2719.35	2713.89	2717.34	2177.0
2011-03-01 06:00:00	NQ	Futures	2717.34	2717.62	2713.03	2714.75	1040.0
2011-03-01 07:00:00	NQ	Futures	2714.47	2715.04	2704.13	2709.87	3589.0
2011-03-01 08:00:00	NQ	Futures	2709.59	2711.88	2705.57	2709.87	11768.0
2011-03-01 09:00:00	NQ	Futures	2709.87	2711.88	2695.23	2699.54	43981.0
2011-03-01 10:00:00	NQ	Futures	2699.54	2703.27	2678.01	2694.09	60624.0
2011-03-01 11:00:00	NQ	Futures	2693.8	2697.24	2672.56	2674.28	40562.0
2011-03-01 12:00:00	NQ	Futures	2673.99	2675.14	2666.24	2670.55	34254.0
2011-03-01 13:00:00	NQ	Futures	2670.55	2672.27	2662.8	2668.25	31165.0
2011-03-01 14:00:00	NQ	Futures	2667.97	2668.25	2650.17	2654.19	46409.0
2011-03-01 15:00:00	NQ	Futures	2654.48	2662.8	2649.31	2657.63	46681.0
2011-03-01 16:00:00	NQ	Futures	2657.63	2658.49	2647.3	2648.45	15400.0
2011-03-01 17:00:00	NQ	Futures	2648.45	2648.45	2645.87	2646.44	706.0
2011-03-01 18:00:00	NQ	Futures	2647.59	2655.05	2647.59	2653.61	969.0
2011-03-01 19:00:00	NQ	Futures	2653.33	2656.49	2649.88	2651.89	775.0
2011-03-01 20:00:00	NQ	Futures	2651.89	2654.76	2649.31	2649.31	999.0
2011-03-01 21:00:00	NQ	Futures	2649.6	2650.46	2642.71	2646.73	705.0
2011-03-01 22:00:00	NQ	Futures	2647.01	2649.88	2645.29	2648.45	411.0
2011-03-01 23:00:00	NQ	Futures	2649.02	2650.46	2645.29	2645.58	210.0
2011-03-01 00:00:00	YM	Futures	11710.8	11714.6	11708.9	11712.7	167.0
2011-03-01 01:00:00	YM	Futures	11713.7	11735.7	11713.7	11732.8	402.0

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

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