PREVIEW / futures_1hour / 2011-10-26

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-26.parquet
  size:    51 KB
  rows:    1,500

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-10-26 00:00:00	ES	Futures	1234.23	1234.98	1233.48	1234.23	5007.0
2011-10-26 01:00:00	ES	Futures	1234.23	1234.73	1232.73	1234.48	6546.0
2011-10-26 02:00:00	ES	Futures	1234.48	1236.49	1231.47	1236.24	13643.0
2011-10-26 03:00:00	ES	Futures	1235.99	1238.49	1233.73	1237.49	37064.0
2011-10-26 04:00:00	ES	Futures	1237.24	1238.49	1232.98	1232.98	28051.0
2011-10-26 05:00:00	ES	Futures	1232.73	1236.49	1232.48	1235.48	18148.0
2011-10-26 06:00:00	ES	Futures	1235.23	1237.24	1232.73	1234.48	24199.0
2011-10-26 07:00:00	ES	Futures	1234.48	1237.74	1232.98	1234.48	35695.0
2011-10-26 08:00:00	ES	Futures	1234.48	1240.5	1234.23	1239.0	73151.0
2011-10-26 09:00:00	ES	Futures	1239.25	1243.51	1236.99	1238.49	304564.0
2011-10-26 10:00:00	ES	Futures	1238.49	1239.5	1220.19	1222.95	530958.0
2011-10-26 11:00:00	ES	Futures	1222.95	1231.72	1222.45	1229.47	280087.0
2011-10-26 12:00:00	ES	Futures	1229.72	1231.47	1226.96	1227.71	108075.0
2011-10-26 13:00:00	ES	Futures	1227.46	1238.49	1224.2	1236.24	354333.0
2011-10-26 14:00:00	ES	Futures	1236.24	1243.01	1235.23	1238.24	327941.0
2011-10-26 15:00:00	ES	Futures	1238.24	1246.27	1236.99	1241.75	403308.0
2011-10-26 16:00:00	ES	Futures	1241.75	1247.27	1240.25	1246.02	112709.0
2011-10-26 17:00:00	ES	Futures	1246.02	1248.27	1245.52	1247.02	3921.0
2011-10-26 18:00:00	ES	Futures	1245.77	1246.02	1242.26	1242.51	6941.0
2011-10-26 19:00:00	ES	Futures	1242.76	1244.51	1242.0	1244.01	4554.0
2011-10-26 20:00:00	ES	Futures	1244.01	1247.02	1242.76	1245.01	11305.0
2011-10-26 21:00:00	ES	Futures	1245.26	1252.79	1241.5	1251.03	25019.0
2011-10-26 22:00:00	ES	Futures	1251.03	1256.55	1250.78	1255.55	27845.0
2011-10-26 23:00:00	ES	Futures	1255.55	1258.55	1253.54	1257.55	17060.0
2011-10-26 00:00:00	NQ	Futures	2690.63	2691.78	2689.18	2690.63	360.0
2011-10-26 01:00:00	NQ	Futures	2690.63	2691.78	2687.45	2689.47	444.0
2011-10-26 02:00:00	NQ	Futures	2689.18	2692.07	2684.28	2692.07	1297.0
2011-10-26 03:00:00	NQ	Futures	2691.78	2697.55	2687.45	2695.82	3836.0
2011-10-26 04:00:00	NQ	Futures	2695.82	2697.83	2688.32	2688.61	2045.0
2011-10-26 05:00:00	NQ	Futures	2688.61	2694.95	2688.03	2693.51	1209.0
2011-10-26 06:00:00	NQ	Futures	2693.51	2696.1	2687.45	2690.05	2153.0
2011-10-26 07:00:00	NQ	Futures	2690.05	2695.82	2688.61	2689.47	2920.0
2011-10-26 08:00:00	NQ	Futures	2689.76	2704.46	2689.18	2698.41	5322.0
2011-10-26 09:00:00	NQ	Futures	2698.41	2710.52	2694.66	2699.27	39334.0
2011-10-26 10:00:00	NQ	Futures	2698.99	2700.43	2637.29	2641.32	75040.0
2011-10-26 11:00:00	NQ	Futures	2641.32	2673.04	2641.03	2664.96	44966.0
2011-10-26 12:00:00	NQ	Futures	2665.25	2669.58	2656.89	2658.04	13762.0
2011-10-26 13:00:00	NQ	Futures	2658.04	2685.72	2649.68	2681.69	43988.0
2011-10-26 14:00:00	NQ	Futures	2682.26	2696.1	2677.94	2681.98	38095.0
2011-10-26 15:00:00	NQ	Futures	2682.26	2697.83	2679.96	2688.9	37966.0
2011-10-26 16:00:00	NQ	Futures	2688.9	2697.55	2683.71	2694.66	6733.0
2011-10-26 17:00:00	NQ	Futures	2694.66	2700.14	2694.09	2697.83	176.0
2011-10-26 18:00:00	NQ	Futures	2696.97	2696.97	2688.61	2688.9	355.0
2011-10-26 19:00:00	NQ	Futures	2689.18	2692.93	2687.74	2692.64	371.0
2011-10-26 20:00:00	NQ	Futures	2692.64	2697.83	2689.76	2693.8	663.0
2011-10-26 21:00:00	NQ	Futures	2693.8	2709.08	2687.17	2705.04	2117.0
2011-10-26 22:00:00	NQ	Futures	2705.04	2715.71	2705.04	2712.83	2156.0
2011-10-26 23:00:00	NQ	Futures	2712.83	2721.19	2709.94	2718.59	1280.0
2011-10-26 00:00:00	YM	Futures	11528.2	11537.1	11525.3	11530.2	473.0
2011-10-26 01:00:00	YM	Futures	11529.2	11535.1	11521.3	11533.1	491.0

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

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