PREVIEW / futures_1hour / 2011-05-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-25.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-05-25 00:00:00	ES	Futures	1297.3	1298.3	1295.57	1297.55	4470.0
2011-05-25 01:00:00	ES	Futures	1297.8	1298.05	1295.32	1296.31	6735.0
2011-05-25 02:00:00	ES	Futures	1296.31	1299.04	1295.81	1299.04	17459.0
2011-05-25 03:00:00	ES	Futures	1299.04	1301.53	1298.55	1301.03	31708.0
2011-05-25 04:00:00	ES	Futures	1300.78	1303.02	1299.04	1301.53	33918.0
2011-05-25 05:00:00	ES	Futures	1301.53	1305.5	1301.53	1304.01	34193.0
2011-05-25 06:00:00	ES	Futures	1304.01	1304.26	1301.28	1302.77	22548.0
2011-05-25 07:00:00	ES	Futures	1302.52	1305.01	1302.52	1304.76	24706.0
2011-05-25 08:00:00	ES	Futures	1304.76	1305.01	1299.29	1301.78	76116.0
2011-05-25 09:00:00	ES	Futures	1301.78	1306.74	1298.55	1304.76	330791.0
2011-05-25 10:00:00	ES	Futures	1304.51	1309.48	1302.27	1307.24	326928.0
2011-05-25 11:00:00	ES	Futures	1307.24	1312.96	1307.24	1310.72	298480.0
2011-05-25 12:00:00	ES	Futures	1310.72	1311.46	1308.98	1310.72	93739.0
2011-05-25 13:00:00	ES	Futures	1310.72	1311.46	1308.24	1308.98	102813.0
2011-05-25 14:00:00	ES	Futures	1309.23	1311.96	1308.73	1311.46	115214.0
2011-05-25 15:00:00	ES	Futures	1311.22	1316.18	1310.22	1310.22	373842.0
2011-05-25 16:00:00	ES	Futures	1310.22	1310.72	1307.49	1307.99	125361.0
2011-05-25 17:00:00	ES	Futures	1307.99	1308.48	1307.74	1308.48	2384.0
2011-05-25 18:00:00	ES	Futures	1308.48	1309.48	1308.24	1309.23	3294.0
2011-05-25 19:00:00	ES	Futures	1309.23	1309.48	1307.74	1307.99	3939.0
2011-05-25 20:00:00	ES	Futures	1307.99	1311.46	1307.74	1311.22	12877.0
2011-05-25 21:00:00	ES	Futures	1310.97	1312.21	1310.47	1311.71	11440.0
2011-05-25 22:00:00	ES	Futures	1311.46	1312.21	1311.22	1311.22	4031.0
2011-05-25 23:00:00	ES	Futures	1311.22	1312.21	1310.22	1311.22	6034.0
2011-05-25 00:00:00	NQ	Futures	2626.63	2628.36	2624.33	2626.92	371.0
2011-05-25 01:00:00	NQ	Futures	2627.21	2627.21	2622.61	2624.05	756.0
2011-05-25 02:00:00	NQ	Futures	2624.05	2630.65	2624.05	2628.64	2195.0
2011-05-25 03:00:00	NQ	Futures	2628.64	2636.4	2628.64	2634.96	3587.0
2011-05-25 04:00:00	NQ	Futures	2634.68	2641.0	2631.8	2638.12	2688.0
2011-05-25 05:00:00	NQ	Futures	2637.55	2646.46	2637.55	2644.45	2770.0
2011-05-25 06:00:00	NQ	Futures	2644.16	2645.02	2639.56	2641.57	2611.0
2011-05-25 07:00:00	NQ	Futures	2641.28	2645.59	2641.28	2645.59	3539.0
2011-05-25 08:00:00	NQ	Futures	2645.59	2645.59	2637.55	2641.0	6769.0
2011-05-25 09:00:00	NQ	Futures	2641.0	2652.78	2634.68	2648.76	72903.0
2011-05-25 10:00:00	NQ	Futures	2648.76	2657.37	2645.59	2649.9	50005.0
2011-05-25 11:00:00	NQ	Futures	2649.9	2660.25	2649.62	2657.37	21489.0
2011-05-25 12:00:00	NQ	Futures	2657.37	2659.1	2655.36	2657.66	11397.0
2011-05-25 13:00:00	NQ	Futures	2657.66	2657.95	2651.63	2653.64	15583.0
2011-05-25 14:00:00	NQ	Futures	2653.93	2660.25	2653.06	2658.81	12163.0
2011-05-25 15:00:00	NQ	Futures	2658.52	2667.14	2654.21	2655.08	34513.0
2011-05-25 16:00:00	NQ	Futures	2654.5	2655.65	2652.2	2653.35	12331.0
2011-05-25 17:00:00	NQ	Futures	2653.35	2653.93	2652.78	2653.64	157.0
2011-05-25 18:00:00	NQ	Futures	2653.93	2655.94	2653.93	2655.94	535.0
2011-05-25 19:00:00	NQ	Futures	2655.36	2655.94	2652.2	2652.49	366.0
2011-05-25 20:00:00	NQ	Futures	2652.49	2659.39	2652.49	2659.1	961.0
2011-05-25 21:00:00	NQ	Futures	2658.81	2660.82	2658.24	2659.1	822.0
2011-05-25 22:00:00	NQ	Futures	2659.1	2660.82	2658.52	2659.1	341.0
2011-05-25 23:00:00	NQ	Futures	2658.81	2660.82	2657.37	2659.1	279.0
2011-05-25 00:00:00	YM	Futures	11802.9	11811.6	11793.3	11806.8	214.0
2011-05-25 01:00:00	YM	Futures	11807.7	11809.6	11777.9	11793.3	1622.0

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

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