PREVIEW / futures_1hour / 2011-10-31

all futures 1-hour files

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

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-31 00:00:00	ES	Futures	1275.86	1276.36	1273.1	1274.85	9206.0
2011-10-31 01:00:00	ES	Futures	1274.6	1274.85	1271.09	1273.85	11347.0
2011-10-31 02:00:00	ES	Futures	1273.6	1275.61	1271.59	1274.85	7711.0
2011-10-31 03:00:00	ES	Futures	1274.6	1278.11	1273.6	1275.86	13546.0
2011-10-31 04:00:00	ES	Futures	1275.86	1276.86	1271.84	1272.85	39051.0
2011-10-31 05:00:00	ES	Futures	1272.85	1273.35	1270.34	1272.35	36497.0
2011-10-31 06:00:00	ES	Futures	1272.1	1274.1	1271.09	1273.6	21113.0
2011-10-31 07:00:00	ES	Futures	1273.6	1274.6	1270.09	1272.35	32655.0
2011-10-31 08:00:00	ES	Futures	1272.6	1273.35	1268.33	1269.59	44207.0
2011-10-31 09:00:00	ES	Futures	1269.59	1271.84	1265.58	1267.08	206296.0
2011-10-31 10:00:00	ES	Futures	1267.33	1271.34	1265.83	1268.33	227535.0
2011-10-31 11:00:00	ES	Futures	1268.33	1270.84	1265.33	1267.58	248726.0
2011-10-31 12:00:00	ES	Futures	1267.33	1268.84	1262.57	1265.07	216982.0
2011-10-31 13:00:00	ES	Futures	1265.33	1271.09	1264.57	1269.59	155195.0
2011-10-31 14:00:00	ES	Futures	1269.59	1270.09	1265.07	1267.33	131153.0
2011-10-31 15:00:00	ES	Futures	1267.58	1267.58	1251.78	1252.03	596195.0
2011-10-31 16:00:00	ES	Futures	1252.03	1253.79	1245.77	1246.77	214347.0
2011-10-31 17:00:00	ES	Futures	1246.77	1246.77	1245.26	1245.77	7730.0
2011-10-31 18:00:00	ES	Futures	1246.02	1247.77	1245.77	1247.27	9853.0
2011-10-31 19:00:00	ES	Futures	1247.27	1248.78	1246.27	1247.02	6398.0
2011-10-31 20:00:00	ES	Futures	1247.02	1251.78	1247.02	1248.02	14551.0
2011-10-31 21:00:00	ES	Futures	1248.27	1249.53	1244.76	1248.78	13092.0
2011-10-31 22:00:00	ES	Futures	1248.78	1249.28	1246.77	1247.52	7333.0
2011-10-31 23:00:00	ES	Futures	1247.27	1247.52	1242.51	1245.26	9740.0
2011-10-31 00:00:00	NQ	Futures	2746.56	2746.56	2740.79	2743.39	780.0
2011-10-31 01:00:00	NQ	Futures	2743.39	2744.54	2737.33	2741.95	794.0
2011-10-31 02:00:00	NQ	Futures	2741.66	2745.98	2737.33	2744.25	445.0
2011-10-31 03:00:00	NQ	Futures	2744.54	2751.75	2742.52	2747.42	1066.0
2011-10-31 04:00:00	NQ	Futures	2747.42	2749.15	2739.35	2741.95	2852.0
2011-10-31 05:00:00	NQ	Futures	2741.95	2742.81	2737.05	2740.79	3650.0
2011-10-31 06:00:00	NQ	Futures	2740.79	2746.27	2738.2	2745.41	2030.0
2011-10-31 07:00:00	NQ	Futures	2745.41	2747.14	2737.33	2741.66	1929.0
2011-10-31 08:00:00	NQ	Futures	2741.66	2743.39	2735.03	2737.91	2529.0
2011-10-31 09:00:00	NQ	Futures	2737.62	2742.52	2726.95	2732.72	24920.0
2011-10-31 10:00:00	NQ	Futures	2732.72	2752.04	2729.55	2741.95	34117.0
2011-10-31 11:00:00	NQ	Futures	2741.95	2746.56	2735.03	2739.06	29867.0
2011-10-31 12:00:00	NQ	Futures	2738.78	2740.22	2728.68	2735.03	25492.0
2011-10-31 13:00:00	NQ	Futures	2734.74	2747.14	2733.87	2745.41	20401.0
2011-10-31 14:00:00	NQ	Futures	2745.12	2746.56	2732.72	2740.22	19448.0
2011-10-31 15:00:00	NQ	Futures	2740.22	2740.22	2717.44	2717.44	53301.0
2011-10-31 16:00:00	NQ	Futures	2717.44	2722.92	2706.48	2707.64	16541.0
2011-10-31 17:00:00	NQ	Futures	2707.06	2707.64	2705.04	2705.33	177.0
2011-10-31 18:00:00	NQ	Futures	2707.06	2709.94	2705.04	2707.35	444.0
2011-10-31 19:00:00	NQ	Futures	2707.64	2710.23	2706.19	2707.64	482.0
2011-10-31 20:00:00	NQ	Futures	2707.35	2716.86	2707.35	2711.38	757.0
2011-10-31 21:00:00	NQ	Futures	2710.81	2712.83	2702.73	2711.1	880.0
2011-10-31 22:00:00	NQ	Futures	2711.38	2712.54	2708.5	2709.37	332.0
2011-10-31 23:00:00	NQ	Futures	2709.08	2709.08	2699.85	2704.75	628.0
2011-10-31 00:00:00	YM	Futures	11906.3	11911.2	11883.6	11896.4	783.0
2011-10-31 01:00:00	YM	Futures	11893.5	11897.4	11871.8	11886.6	875.0

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

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