PREVIEW / futures_1hour / 2011-11-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-07.parquet
  size:    48 KB
  rows:    1,447

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-11-07 00:00:00	ES	Futures	1253.54	1253.79	1251.03	1253.54	3032.0
2011-11-07 01:00:00	ES	Futures	1253.54	1254.29	1251.03	1251.78	2731.0
2011-11-07 02:00:00	ES	Futures	1251.78	1252.29	1241.25	1243.01	22348.0
2011-11-07 03:00:00	ES	Futures	1243.01	1246.02	1235.74	1237.24	69293.0
2011-11-07 04:00:00	ES	Futures	1237.24	1241.75	1236.74	1238.49	28289.0
2011-11-07 05:00:00	ES	Futures	1238.49	1243.26	1236.24	1243.26	33416.0
2011-11-07 06:00:00	ES	Futures	1243.26	1252.29	1242.0	1243.26	64618.0
2011-11-07 07:00:00	ES	Futures	1243.26	1251.78	1243.01	1250.78	42121.0
2011-11-07 08:00:00	ES	Futures	1250.78	1251.53	1246.52	1250.03	36932.0
2011-11-07 09:00:00	ES	Futures	1250.28	1259.81	1248.78	1257.3	239531.0
2011-11-07 10:00:00	ES	Futures	1257.3	1258.05	1245.26	1246.52	350738.0
2011-11-07 11:00:00	ES	Futures	1246.52	1250.78	1244.26	1245.26	225580.0
2011-11-07 12:00:00	ES	Futures	1245.26	1248.78	1240.25	1243.76	184966.0
2011-11-07 13:00:00	ES	Futures	1243.76	1252.03	1242.76	1251.03	124576.0
2011-11-07 14:00:00	ES	Futures	1251.03	1258.05	1249.78	1257.8	224604.0
2011-11-07 15:00:00	ES	Futures	1257.8	1262.32	1255.29	1261.31	218514.0
2011-11-07 16:00:00	ES	Futures	1261.31	1263.32	1260.31	1263.07	68471.0
2011-11-07 17:00:00	ES	Futures	1263.32	1267.83	1262.57	1266.33	9160.0
2011-11-07 18:00:00	ES	Futures	1265.58	1265.83	1261.81	1262.32	8578.0
2011-11-07 19:00:00	ES	Futures	1262.07	1263.07	1260.56	1261.06	7663.0
2011-11-07 20:00:00	ES	Futures	1261.31	1261.56	1259.81	1261.06	5073.0
2011-11-07 21:00:00	ES	Futures	1260.81	1261.06	1257.55	1258.55	6607.0
2011-11-07 22:00:00	ES	Futures	1258.55	1261.31	1257.8	1257.8	4069.0
2011-11-07 23:00:00	ES	Futures	1258.05	1258.55	1257.3	1258.3	3415.0
2011-11-07 00:00:00	NQ	Futures	2711.1	2711.96	2707.35	2711.1	190.0
2011-11-07 01:00:00	NQ	Futures	2711.38	2712.54	2707.35	2709.08	323.0
2011-11-07 02:00:00	NQ	Futures	2708.79	2709.65	2688.9	2691.78	1587.0
2011-11-07 03:00:00	NQ	Futures	2691.78	2696.1	2675.06	2679.38	6165.0
2011-11-07 04:00:00	NQ	Futures	2678.8	2686.3	2677.65	2680.53	2048.0
2011-11-07 05:00:00	NQ	Futures	2680.25	2690.05	2676.21	2689.76	3252.0
2011-11-07 06:00:00	NQ	Futures	2689.47	2706.19	2687.45	2691.78	6136.0
2011-11-07 07:00:00	NQ	Futures	2692.36	2708.5	2692.07	2706.48	2881.0
2011-11-07 08:00:00	NQ	Futures	2706.77	2707.35	2698.41	2704.46	2458.0
2011-11-07 09:00:00	NQ	Futures	2704.75	2724.36	2702.45	2720.03	27098.0
2011-11-07 10:00:00	NQ	Futures	2720.03	2721.76	2687.45	2688.9	42181.0
2011-11-07 11:00:00	NQ	Futures	2688.9	2699.85	2686.59	2693.51	30499.0
2011-11-07 12:00:00	NQ	Futures	2693.51	2700.14	2681.4	2689.18	24989.0
2011-11-07 13:00:00	NQ	Futures	2689.47	2708.5	2688.03	2706.48	15709.0
2011-11-07 14:00:00	NQ	Futures	2706.19	2722.05	2704.75	2721.76	30826.0
2011-11-07 15:00:00	NQ	Futures	2721.48	2733.01	2719.17	2730.99	38174.0
2011-11-07 16:00:00	NQ	Futures	2730.99	2737.62	2730.41	2737.05	8611.0
2011-11-07 17:00:00	NQ	Futures	2737.05	2744.54	2736.18	2741.95	572.0
2011-11-07 18:00:00	NQ	Futures	2739.64	2741.08	2734.16	2735.32	401.0
2011-11-07 19:00:00	NQ	Futures	2735.32	2736.47	2732.72	2733.3	416.0
2011-11-07 20:00:00	NQ	Futures	2733.3	2734.45	2730.7	2733.3	345.0
2011-11-07 21:00:00	NQ	Futures	2733.01	2733.59	2726.38	2728.97	440.0
2011-11-07 22:00:00	NQ	Futures	2728.68	2734.74	2726.95	2727.24	255.0
2011-11-07 23:00:00	NQ	Futures	2727.24	2728.97	2726.38	2728.11	190.0
2011-11-07 00:00:00	YM	Futures	11749.7	11753.7	11733.0	11748.8	298.0
2011-11-07 01:00:00	YM	Futures	11749.7	11753.7	11731.0	11733.0	480.0

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

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