PREVIEW / futures_1hour / 2011-05-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	1311.22	1311.96	1310.72	1311.46	3190.0
2011-05-26 01:00:00	ES	Futures	1311.71	1312.96	1310.72	1312.71	5644.0
2011-05-26 02:00:00	ES	Futures	1312.71	1313.45	1311.71	1312.71	10404.0
2011-05-26 03:00:00	ES	Futures	1312.71	1315.19	1311.96	1314.94	28411.0
2011-05-26 04:00:00	ES	Futures	1314.69	1314.94	1311.46	1311.71	23851.0
2011-05-26 05:00:00	ES	Futures	1311.71	1311.71	1308.73	1311.46	28348.0
2011-05-26 06:00:00	ES	Futures	1311.46	1311.96	1309.97	1310.47	22590.0
2011-05-26 07:00:00	ES	Futures	1310.72	1311.71	1309.48	1311.46	28650.0
2011-05-26 08:00:00	ES	Futures	1311.46	1313.7	1306.25	1308.98	110072.0
2011-05-26 09:00:00	ES	Futures	1308.98	1310.97	1305.01	1305.75	284857.0
2011-05-26 10:00:00	ES	Futures	1305.75	1309.23	1304.26	1305.25	397348.0
2011-05-26 11:00:00	ES	Futures	1305.25	1309.48	1304.26	1308.73	263151.0
2011-05-26 12:00:00	ES	Futures	1308.98	1313.95	1307.99	1313.45	191630.0
2011-05-26 13:00:00	ES	Futures	1313.45	1316.43	1312.96	1314.45	211934.0
2011-05-26 14:00:00	ES	Futures	1314.69	1319.17	1314.45	1318.17	226835.0
2011-05-26 15:00:00	ES	Futures	1318.17	1318.67	1314.94	1316.43	314872.0
2011-05-26 16:00:00	ES	Futures	1316.68	1318.92	1316.18	1318.67	82565.0
2011-05-26 17:00:00	ES	Futures	1318.67	1318.92	1318.17	1318.42	1713.0
2011-05-26 18:00:00	ES	Futures	1318.67	1318.92	1317.92	1318.42	1996.0
2011-05-26 19:00:00	ES	Futures	1318.67	1319.41	1318.17	1318.42	3085.0
2011-05-26 20:00:00	ES	Futures	1318.67	1318.67	1316.93	1317.92	5333.0
2011-05-26 21:00:00	ES	Futures	1318.17	1320.16	1317.43	1319.91	5263.0
2011-05-26 22:00:00	ES	Futures	1319.91	1320.66	1319.41	1320.41	2557.0
2011-05-26 23:00:00	ES	Futures	1320.41	1321.65	1320.41	1320.91	9144.0
2011-05-26 00:00:00	NQ	Futures	2658.81	2659.39	2657.37	2658.24	542.0
2011-05-26 01:00:00	NQ	Futures	2658.24	2661.11	2657.09	2660.82	742.0
2011-05-26 02:00:00	NQ	Futures	2660.53	2662.83	2659.1	2660.53	1008.0
2011-05-26 03:00:00	NQ	Futures	2660.53	2664.56	2659.1	2664.27	2085.0
2011-05-26 04:00:00	NQ	Futures	2664.27	2664.27	2657.09	2657.66	1712.0
2011-05-26 05:00:00	NQ	Futures	2657.09	2657.37	2650.77	2655.94	2412.0
2011-05-26 06:00:00	NQ	Futures	2655.94	2656.8	2653.35	2654.21	1957.0
2011-05-26 07:00:00	NQ	Futures	2654.21	2656.51	2652.49	2656.51	2410.0
2011-05-26 08:00:00	NQ	Futures	2656.8	2659.67	2646.74	2650.77	8411.0
2011-05-26 09:00:00	NQ	Futures	2650.77	2660.25	2645.59	2651.05	46955.0
2011-05-26 10:00:00	NQ	Futures	2650.77	2661.97	2649.33	2653.06	40974.0
2011-05-26 11:00:00	NQ	Futures	2652.78	2663.98	2651.92	2662.55	24845.0
2011-05-26 12:00:00	NQ	Futures	2662.55	2672.03	2660.82	2670.3	21552.0
2011-05-26 13:00:00	NQ	Futures	2670.3	2674.61	2668.29	2670.88	21179.0
2011-05-26 14:00:00	NQ	Futures	2670.88	2678.92	2670.59	2677.49	22351.0
2011-05-26 15:00:00	NQ	Futures	2677.77	2678.64	2670.59	2672.03	33206.0
2011-05-26 16:00:00	NQ	Futures	2672.03	2675.48	2670.3	2674.61	9411.0
2011-05-26 17:00:00	NQ	Futures	2674.9	2675.19	2673.75	2674.61	44.0
2011-05-26 18:00:00	NQ	Futures	2674.9	2675.48	2673.75	2674.33	184.0
2011-05-26 19:00:00	NQ	Futures	2674.04	2676.05	2673.75	2674.04	270.0
2011-05-26 20:00:00	NQ	Futures	2674.04	2674.33	2671.74	2673.46	412.0
2011-05-26 21:00:00	NQ	Futures	2673.75	2677.77	2672.31	2677.77	361.0
2011-05-26 22:00:00	NQ	Futures	2677.77	2678.64	2676.91	2678.35	181.0
2011-05-26 23:00:00	NQ	Futures	2678.64	2681.22	2678.06	2679.79	524.0
2011-05-26 00:00:00	YM	Futures	11922.3	11927.2	11917.5	11924.3	146.0
2011-05-26 01:00:00	YM	Futures	11924.3	11934.9	11919.4	11934.9	207.0

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

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