PREVIEW / futures_1hour / 2011-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-25.parquet
  size:    50 KB
  rows:    1,478

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-25 00:00:00	ES	Futures	1247.27	1249.03	1247.02	1248.52	3730.0
2011-10-25 01:00:00	ES	Futures	1248.52	1249.03	1245.77	1246.52	6866.0
2011-10-25 02:00:00	ES	Futures	1246.27	1249.03	1246.27	1246.77	9056.0
2011-10-25 03:00:00	ES	Futures	1246.52	1253.54	1246.27	1252.29	39983.0
2011-10-25 04:00:00	ES	Futures	1252.29	1252.79	1249.03	1251.03	19701.0
2011-10-25 05:00:00	ES	Futures	1250.78	1253.79	1249.53	1252.03	17627.0
2011-10-25 06:00:00	ES	Futures	1251.78	1258.05	1250.53	1256.3	34262.0
2011-10-25 07:00:00	ES	Futures	1256.3	1258.3	1254.54	1255.55	33301.0
2011-10-25 08:00:00	ES	Futures	1255.55	1256.3	1245.77	1247.02	84689.0
2011-10-25 09:00:00	ES	Futures	1246.77	1249.28	1231.22	1238.74	545019.0
2011-10-25 10:00:00	ES	Futures	1238.74	1245.52	1234.23	1240.0	485250.0
2011-10-25 11:00:00	ES	Futures	1240.0	1241.25	1234.98	1238.24	258222.0
2011-10-25 12:00:00	ES	Futures	1238.49	1244.76	1237.24	1239.25	174548.0
2011-10-25 13:00:00	ES	Futures	1239.0	1243.26	1237.74	1240.0	150902.0
2011-10-25 14:00:00	ES	Futures	1240.25	1240.25	1233.98	1237.99	212658.0
2011-10-25 15:00:00	ES	Futures	1238.24	1240.5	1225.96	1228.97	390809.0
2011-10-25 16:00:00	ES	Futures	1228.71	1231.22	1226.21	1228.71	125036.0
2011-10-25 17:00:00	ES	Futures	1228.46	1229.47	1227.96	1229.47	2446.0
2011-10-25 18:00:00	ES	Futures	1229.47	1229.97	1227.71	1227.96	3170.0
2011-10-25 19:00:00	ES	Futures	1228.21	1228.71	1226.71	1228.21	4307.0
2011-10-25 20:00:00	ES	Futures	1227.96	1230.72	1227.46	1230.72	8448.0
2011-10-25 21:00:00	ES	Futures	1230.72	1231.47	1229.97	1231.47	5822.0
2011-10-25 22:00:00	ES	Futures	1231.22	1233.23	1230.72	1232.48	6792.0
2011-10-25 23:00:00	ES	Futures	1232.23	1234.23	1231.97	1234.23	5071.0
2011-10-25 00:00:00	NQ	Futures	2731.28	2734.16	2730.41	2733.01	265.0
2011-10-25 01:00:00	NQ	Futures	2733.3	2733.87	2728.11	2730.13	360.0
2011-10-25 02:00:00	NQ	Futures	2730.13	2735.03	2730.13	2730.13	781.0
2011-10-25 03:00:00	NQ	Futures	2730.41	2746.27	2729.84	2743.1	3075.0
2011-10-25 04:00:00	NQ	Futures	2742.81	2743.96	2736.47	2740.22	1831.0
2011-10-25 05:00:00	NQ	Futures	2740.22	2746.85	2737.62	2742.52	1848.0
2011-10-25 06:00:00	NQ	Futures	2742.24	2750.88	2739.93	2747.71	2864.0
2011-10-25 07:00:00	NQ	Futures	2747.42	2752.61	2746.56	2748.29	3026.0
2011-10-25 08:00:00	NQ	Futures	2748.29	2749.73	2733.3	2734.45	6583.0
2011-10-25 09:00:00	NQ	Futures	2734.16	2738.78	2710.52	2718.59	61856.0
2011-10-25 10:00:00	NQ	Futures	2717.15	2731.86	2710.81	2721.19	48271.0
2011-10-25 11:00:00	NQ	Futures	2721.19	2724.36	2706.77	2709.94	37788.0
2011-10-25 12:00:00	NQ	Futures	2710.23	2723.21	2707.35	2711.67	26978.0
2011-10-25 13:00:00	NQ	Futures	2711.96	2720.32	2707.64	2710.81	23249.0
2011-10-25 14:00:00	NQ	Futures	2710.52	2710.52	2695.24	2705.91	39201.0
2011-10-25 15:00:00	NQ	Futures	2706.19	2710.81	2683.99	2691.49	45219.0
2011-10-25 16:00:00	NQ	Futures	2691.49	2694.09	2671.02	2676.79	18515.0
2011-10-25 17:00:00	NQ	Futures	2677.65	2680.82	2677.65	2680.53	178.0
2011-10-25 18:00:00	NQ	Futures	2681.11	2682.26	2678.52	2678.52	277.0
2011-10-25 19:00:00	NQ	Futures	2679.38	2679.67	2676.5	2678.8	255.0
2011-10-25 20:00:00	NQ	Futures	2679.09	2683.42	2677.94	2683.42	589.0
2011-10-25 21:00:00	NQ	Futures	2683.71	2684.57	2681.98	2684.28	487.0
2011-10-25 22:00:00	NQ	Futures	2683.99	2689.18	2683.13	2687.17	786.0
2011-10-25 23:00:00	NQ	Futures	2687.45	2691.2	2686.3	2690.91	241.0
2011-10-25 00:00:00	YM	Futures	11616.8	11630.6	11615.8	11625.7	404.0
2011-10-25 01:00:00	YM	Futures	11627.7	11629.6	11603.0	11605.0	519.0

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

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