PREVIEW / futures_1hour / 2011-05-16

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-16.parquet
  size:    48 KB
  rows:    1,427

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-05-16 00:00:00	ES	Futures	1319.66	1320.66	1319.41	1320.41	2185.0
2011-05-16 01:00:00	ES	Futures	1320.16	1321.4	1319.41	1319.66	4186.0
2011-05-16 02:00:00	ES	Futures	1319.66	1321.9	1319.41	1321.65	10759.0
2011-05-16 03:00:00	ES	Futures	1321.65	1324.63	1320.41	1324.13	39749.0
2011-05-16 04:00:00	ES	Futures	1324.13	1324.38	1320.16	1321.15	20193.0
2011-05-16 05:00:00	ES	Futures	1321.4	1321.65	1318.67	1319.17	20209.0
2011-05-16 06:00:00	ES	Futures	1319.41	1320.41	1317.92	1319.91	18148.0
2011-05-16 07:00:00	ES	Futures	1319.91	1321.9	1319.17	1321.65	15011.0
2011-05-16 08:00:00	ES	Futures	1321.9	1323.64	1320.66	1321.4	42750.0
2011-05-16 09:00:00	ES	Futures	1321.4	1325.38	1319.66	1323.64	273612.0
2011-05-16 10:00:00	ES	Futures	1323.89	1331.34	1323.64	1331.09	323958.0
2011-05-16 11:00:00	ES	Futures	1331.09	1332.83	1327.61	1328.36	231391.0
2011-05-16 12:00:00	ES	Futures	1328.36	1328.85	1323.14	1323.39	231901.0
2011-05-16 13:00:00	ES	Futures	1323.14	1326.12	1321.15	1324.63	158783.0
2011-05-16 14:00:00	ES	Futures	1324.88	1326.87	1320.41	1321.9	185803.0
2011-05-16 15:00:00	ES	Futures	1322.15	1324.88	1316.43	1318.92	423680.0
2011-05-16 16:00:00	ES	Futures	1318.92	1319.17	1312.21	1314.2	134443.0
2011-05-16 17:00:00	ES	Futures	1314.2	1314.69	1312.96	1313.2	6605.0
2011-05-16 18:00:00	ES	Futures	1315.44	1315.44	1313.7	1314.2	5181.0
2011-05-16 19:00:00	ES	Futures	1313.95	1314.69	1313.45	1313.7	3893.0
2011-05-16 20:00:00	ES	Futures	1313.95	1315.69	1313.7	1315.69	6938.0
2011-05-16 21:00:00	ES	Futures	1315.69	1315.69	1313.7	1313.95	5153.0
2011-05-16 22:00:00	ES	Futures	1313.95	1315.44	1313.7	1315.44	3779.0
2011-05-16 23:00:00	ES	Futures	1315.19	1316.43	1315.19	1316.18	6521.0
2011-05-16 00:00:00	NQ	Futures	2715.41	2716.85	2714.84	2715.99	218.0
2011-05-16 01:00:00	NQ	Futures	2715.99	2717.14	2713.69	2714.55	248.0
2011-05-16 02:00:00	NQ	Futures	2714.26	2719.43	2714.26	2719.15	1458.0
2011-05-16 03:00:00	NQ	Futures	2719.15	2726.9	2718.57	2726.04	4513.0
2011-05-16 04:00:00	NQ	Futures	2726.04	2726.04	2719.43	2721.73	2625.0
2011-05-16 05:00:00	NQ	Futures	2721.45	2721.73	2716.27	2717.42	1734.0
2011-05-16 06:00:00	NQ	Futures	2718.0	2718.86	2715.41	2718.0	1988.0
2011-05-16 07:00:00	NQ	Futures	2717.71	2721.16	2716.27	2720.87	2167.0
2011-05-16 08:00:00	NQ	Futures	2720.58	2723.17	2718.0	2720.01	4238.0
2011-05-16 09:00:00	NQ	Futures	2720.01	2723.74	2711.68	2719.43	51833.0
2011-05-16 10:00:00	NQ	Futures	2719.43	2724.61	2716.85	2721.45	50115.0
2011-05-16 11:00:00	NQ	Futures	2721.45	2726.33	2709.09	2710.24	62591.0
2011-05-16 12:00:00	NQ	Futures	2710.53	2711.1	2694.73	2695.3	86443.0
2011-05-16 13:00:00	NQ	Futures	2695.59	2699.9	2689.27	2696.45	37340.0
2011-05-16 14:00:00	NQ	Futures	2696.74	2701.62	2685.24	2689.27	29663.0
2011-05-16 15:00:00	NQ	Futures	2688.98	2695.01	2676.91	2683.52	52416.0
2011-05-16 16:00:00	NQ	Futures	2683.52	2684.96	2672.6	2676.34	12258.0
2011-05-16 17:00:00	NQ	Futures	2676.05	2677.2	2674.04	2674.04	434.0
2011-05-16 18:00:00	NQ	Futures	2677.49	2679.79	2675.48	2676.91	465.0
2011-05-16 19:00:00	NQ	Futures	2676.91	2677.2	2674.33	2675.48	240.0
2011-05-16 20:00:00	NQ	Futures	2675.48	2679.79	2675.48	2679.21	735.0
2011-05-16 21:00:00	NQ	Futures	2679.21	2679.21	2676.05	2676.05	256.0
2011-05-16 22:00:00	NQ	Futures	2676.05	2679.21	2675.48	2679.21	274.0
2011-05-16 23:00:00	NQ	Futures	2678.92	2682.08	2678.92	2681.22	448.0
2011-05-16 00:00:00	YM	Futures	12048.5	12054.3	12044.7	12048.5	94.0
2011-05-16 01:00:00	YM	Futures	12050.4	12057.2	12046.6	12048.5	221.0

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

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