PREVIEW / futures_1hour / 2011-08-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-01.parquet
  size:    50 KB
  rows:    1,453

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-08-01 00:00:00	ES	Futures	1304.89	1305.89	1304.64	1304.89	2254.0
2011-08-01 01:00:00	ES	Futures	1305.14	1305.14	1303.64	1304.64	5440.0
2011-08-01 02:00:00	ES	Futures	1304.89	1306.64	1303.64	1304.14	19207.0
2011-08-01 03:00:00	ES	Futures	1304.14	1304.89	1296.91	1298.16	49728.0
2011-08-01 04:00:00	ES	Futures	1298.16	1300.15	1295.91	1299.15	40389.0
2011-08-01 05:00:00	ES	Futures	1299.15	1301.15	1298.41	1300.9	14923.0
2011-08-01 06:00:00	ES	Futures	1300.9	1305.14	1300.4	1304.39	31571.0
2011-08-01 07:00:00	ES	Futures	1304.39	1305.39	1300.4	1300.9	35320.0
2011-08-01 08:00:00	ES	Futures	1301.15	1302.4	1297.41	1298.16	57254.0
2011-08-01 09:00:00	ES	Futures	1298.16	1301.65	1288.43	1288.68	409242.0
2011-08-01 10:00:00	ES	Futures	1288.68	1288.93	1272.47	1277.46	721691.0
2011-08-01 11:00:00	ES	Futures	1277.46	1277.7	1267.98	1268.98	478018.0
2011-08-01 12:00:00	ES	Futures	1268.73	1272.97	1267.23	1271.72	227389.0
2011-08-01 13:00:00	ES	Futures	1271.72	1273.96	1269.97	1273.96	131002.0
2011-08-01 14:00:00	ES	Futures	1273.96	1277.21	1269.22	1276.46	191686.0
2011-08-01 15:00:00	ES	Futures	1276.71	1281.94	1275.96	1279.7	411307.0
2011-08-01 16:00:00	ES	Futures	1279.7	1279.95	1274.96	1276.46	89320.0
2011-08-01 17:00:00	ES	Futures	1276.21	1276.46	1273.96	1275.21	5883.0
2011-08-01 18:00:00	ES	Futures	1275.21	1279.95	1274.96	1279.45	8867.0
2011-08-01 19:00:00	ES	Futures	1279.45	1281.94	1276.96	1278.7	11806.0
2011-08-01 20:00:00	ES	Futures	1278.95	1279.7	1277.46	1279.2	6357.0
2011-08-01 21:00:00	ES	Futures	1279.2	1279.45	1274.71	1275.96	7934.0
2011-08-01 22:00:00	ES	Futures	1275.96	1275.96	1274.21	1274.96	5595.0
2011-08-01 23:00:00	ES	Futures	1274.96	1275.71	1272.22	1273.46	5707.0
2011-08-01 00:00:00	NQ	Futures	2751.32	2753.34	2750.17	2751.04	165.0
2011-08-01 01:00:00	NQ	Futures	2750.46	2753.63	2749.31	2752.76	411.0
2011-08-01 02:00:00	NQ	Futures	2752.47	2756.79	2752.19	2752.47	1891.0
2011-08-01 03:00:00	NQ	Futures	2752.76	2756.5	2744.13	2744.99	4837.0
2011-08-01 04:00:00	NQ	Futures	2744.99	2749.02	2741.25	2746.72	3027.0
2011-08-01 05:00:00	NQ	Futures	2746.72	2747.3	2742.98	2747.01	1802.0
2011-08-01 06:00:00	NQ	Futures	2747.3	2755.64	2746.14	2753.63	2197.0
2011-08-01 07:00:00	NQ	Futures	2753.63	2755.06	2743.84	2745.86	2787.0
2011-08-01 08:00:00	NQ	Futures	2746.14	2750.17	2740.39	2742.12	5672.0
2011-08-01 09:00:00	NQ	Futures	2742.12	2755.64	2723.99	2725.43	59441.0
2011-08-01 10:00:00	NQ	Futures	2724.85	2725.14	2692.62	2702.12	84268.0
2011-08-01 11:00:00	NQ	Futures	2702.4	2702.69	2677.08	2678.81	54705.0
2011-08-01 12:00:00	NQ	Futures	2678.81	2685.14	2671.33	2682.84	32871.0
2011-08-01 13:00:00	NQ	Futures	2682.84	2687.44	2677.66	2687.44	17011.0
2011-08-01 14:00:00	NQ	Futures	2687.44	2692.62	2675.93	2691.76	19506.0
2011-08-01 15:00:00	NQ	Futures	2692.04	2709.02	2691.47	2705.28	50531.0
2011-08-01 16:00:00	NQ	Futures	2705.28	2707.3	2699.24	2700.96	10071.0
2011-08-01 17:00:00	NQ	Futures	2700.96	2701.25	2695.79	2696.94	562.0
2011-08-01 18:00:00	NQ	Futures	2698.09	2709.02	2698.09	2707.01	849.0
2011-08-01 19:00:00	NQ	Futures	2707.01	2711.04	2701.83	2704.13	873.0
2011-08-01 20:00:00	NQ	Futures	2704.13	2706.43	2702.12	2704.99	490.0
2011-08-01 21:00:00	NQ	Futures	2705.57	2706.14	2696.07	2698.66	518.0
2011-08-01 22:00:00	NQ	Futures	2698.38	2699.53	2695.79	2697.51	268.0
2011-08-01 23:00:00	NQ	Futures	2697.22	2698.66	2684.56	2690.89	647.0
2011-08-01 00:00:00	YM	Futures	11881.3	11885.2	11874.5	11880.3	157.0
2011-08-01 01:00:00	YM	Futures	11879.4	11886.1	11867.7	11874.5	467.0

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

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