PREVIEW / futures_1hour / 2011-04-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	1307.49	1307.99	1307.24	1307.49	3112.0
2011-04-20 01:00:00	ES	Futures	1307.74	1308.24	1306.99	1307.99	3900.0
2011-04-20 02:00:00	ES	Futures	1307.99	1308.73	1306.99	1307.74	14835.0
2011-04-20 03:00:00	ES	Futures	1307.74	1309.97	1307.74	1309.23	36301.0
2011-04-20 04:00:00	ES	Futures	1309.23	1312.71	1308.98	1311.96	36298.0
2011-04-20 05:00:00	ES	Futures	1312.21	1316.68	1311.71	1315.19	50727.0
2011-04-20 06:00:00	ES	Futures	1315.44	1320.16	1314.45	1317.18	52322.0
2011-04-20 07:00:00	ES	Futures	1317.43	1320.41	1316.93	1317.68	51515.0
2011-04-20 08:00:00	ES	Futures	1317.68	1318.92	1317.43	1317.43	36107.0
2011-04-20 09:00:00	ES	Futures	1317.68	1317.92	1314.94	1316.43	268084.0
2011-04-20 10:00:00	ES	Futures	1316.43	1321.15	1315.94	1319.41	259770.0
2011-04-20 11:00:00	ES	Futures	1319.66	1320.41	1317.18	1319.66	207233.0
2011-04-20 12:00:00	ES	Futures	1319.41	1319.91	1316.43	1316.68	190326.0
2011-04-20 13:00:00	ES	Futures	1316.68	1318.17	1315.44	1317.43	134834.0
2011-04-20 14:00:00	ES	Futures	1317.18	1318.17	1315.94	1317.43	84946.0
2011-04-20 15:00:00	ES	Futures	1317.43	1319.41	1315.94	1318.67	244111.0
2011-04-20 16:00:00	ES	Futures	1318.42	1325.38	1318.42	1324.88	161930.0
2011-04-20 17:00:00	ES	Futures	1324.88	1326.37	1324.63	1325.87	7330.0
2011-04-20 18:00:00	ES	Futures	1325.38	1327.12	1325.13	1326.12	9352.0
2011-04-20 19:00:00	ES	Futures	1326.12	1326.87	1325.13	1326.12	3978.0
2011-04-20 20:00:00	ES	Futures	1325.87	1326.62	1325.13	1325.13	7010.0
2011-04-20 21:00:00	ES	Futures	1325.38	1325.38	1323.89	1324.13	9340.0
2011-04-20 22:00:00	ES	Futures	1324.13	1325.87	1324.13	1325.38	3892.0
2011-04-20 23:00:00	ES	Futures	1325.38	1326.12	1324.38	1325.13	3468.0
2011-04-20 00:00:00	NQ	Futures	2674.61	2675.48	2674.04	2674.04	233.0
2011-04-20 01:00:00	NQ	Futures	2674.33	2675.48	2673.46	2674.9	214.0
2011-04-20 02:00:00	NQ	Futures	2674.61	2675.76	2663.41	2668.87	6279.0
2011-04-20 03:00:00	NQ	Futures	2668.58	2676.62	2662.83	2672.6	5815.0
2011-04-20 04:00:00	NQ	Futures	2672.89	2680.07	2672.31	2679.5	1595.0
2011-04-20 05:00:00	NQ	Futures	2679.21	2687.26	2678.64	2685.53	2796.0
2011-04-20 06:00:00	NQ	Futures	2685.24	2695.01	2684.96	2688.98	3828.0
2011-04-20 07:00:00	NQ	Futures	2688.98	2695.01	2687.54	2688.69	5012.0
2011-04-20 08:00:00	NQ	Futures	2688.12	2691.85	2687.83	2689.27	5211.0
2011-04-20 09:00:00	NQ	Futures	2689.55	2698.46	2688.69	2694.73	49869.0
2011-04-20 10:00:00	NQ	Futures	2695.01	2709.09	2693.0	2707.08	58643.0
2011-04-20 11:00:00	NQ	Futures	2707.37	2708.8	2701.05	2706.51	33805.0
2011-04-20 12:00:00	NQ	Futures	2706.22	2707.08	2701.05	2701.05	26382.0
2011-04-20 13:00:00	NQ	Futures	2701.33	2705.36	2699.04	2704.78	21246.0
2011-04-20 14:00:00	NQ	Futures	2704.49	2706.79	2701.05	2703.63	16369.0
2011-04-20 15:00:00	NQ	Futures	2703.63	2707.94	2697.89	2706.22	40338.0
2011-04-20 16:00:00	NQ	Futures	2706.22	2727.19	2702.2	2725.76	33138.0
2011-04-20 17:00:00	NQ	Futures	2725.76	2732.08	2725.47	2730.64	3104.0
2011-04-20 18:00:00	NQ	Futures	2731.79	2733.8	2730.35	2731.5	1069.0
2011-04-20 19:00:00	NQ	Futures	2731.5	2735.24	2730.64	2732.08	767.0
2011-04-20 20:00:00	NQ	Futures	2731.79	2733.23	2730.07	2730.07	587.0
2011-04-20 21:00:00	NQ	Futures	2730.07	2730.07	2726.9	2726.9	807.0
2011-04-20 22:00:00	NQ	Futures	2726.9	2731.21	2726.04	2730.93	506.0
2011-04-20 23:00:00	NQ	Futures	2731.21	2732.36	2729.78	2730.93	288.0
2011-04-20 00:00:00	YM	Futures	11814.5	11822.2	11814.5	11814.5	250.0
2011-04-20 01:00:00	YM	Futures	11814.5	11822.2	11811.6	11817.4	317.0

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

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