PREVIEW / futures_1hour / 2012-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-05.parquet
  size:    47 KB
  rows:    1,457

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
2012-01-05 00:00:00	ES	Futures	1280.1	1281.86	1279.85	1280.6	2428.0
2012-01-05 01:00:00	ES	Futures	1280.6	1281.11	1279.6	1280.6	2661.0
2012-01-05 02:00:00	ES	Futures	1280.6	1282.87	1279.34	1282.37	9013.0
2012-01-05 03:00:00	ES	Futures	1282.37	1282.62	1275.56	1276.57	38440.0
2012-01-05 04:00:00	ES	Futures	1276.57	1278.08	1274.3	1274.81	27073.0
2012-01-05 05:00:00	ES	Futures	1275.06	1275.82	1271.28	1272.04	37832.0
2012-01-05 06:00:00	ES	Futures	1272.29	1274.3	1270.78	1273.55	29617.0
2012-01-05 07:00:00	ES	Futures	1273.8	1276.07	1273.3	1274.81	23349.0
2012-01-05 08:00:00	ES	Futures	1275.06	1282.62	1274.3	1278.08	118936.0
2012-01-05 09:00:00	ES	Futures	1278.08	1278.59	1270.27	1273.04	243304.0
2012-01-05 10:00:00	ES	Futures	1273.04	1276.82	1269.77	1274.05	297723.0
2012-01-05 11:00:00	ES	Futures	1274.05	1281.11	1273.3	1279.09	213998.0
2012-01-05 12:00:00	ES	Futures	1279.34	1284.63	1278.59	1284.63	165186.0
2012-01-05 13:00:00	ES	Futures	1284.38	1288.16	1283.12	1286.4	139527.0
2012-01-05 14:00:00	ES	Futures	1286.4	1287.41	1283.63	1284.13	141265.0
2012-01-05 15:00:00	ES	Futures	1284.13	1287.15	1283.37	1286.4	212284.0
2012-01-05 16:00:00	ES	Futures	1286.4	1286.9	1282.62	1283.12	90983.0
2012-01-05 17:00:00	ES	Futures	1282.87	1282.87	1281.36	1281.86	6043.0
2012-01-05 18:00:00	ES	Futures	1282.37	1284.13	1281.61	1283.63	5450.0
2012-01-05 19:00:00	ES	Futures	1283.63	1284.38	1281.61	1282.11	6599.0
2012-01-05 20:00:00	ES	Futures	1282.11	1282.62	1280.86	1281.86	11021.0
2012-01-05 21:00:00	ES	Futures	1281.61	1282.37	1280.35	1281.61	6673.0
2012-01-05 22:00:00	ES	Futures	1281.36	1281.61	1280.1	1280.35	3675.0
2012-01-05 23:00:00	ES	Futures	1280.35	1280.6	1278.34	1278.34	6059.0
2012-01-05 00:00:00	NQ	Futures	2685.54	2688.71	2685.25	2686.4	132.0
2012-01-05 01:00:00	NQ	Futures	2686.4	2687.56	2684.96	2686.69	181.0
2012-01-05 02:00:00	NQ	Futures	2686.69	2689.58	2684.67	2689.0	463.0
2012-01-05 03:00:00	NQ	Futures	2689.29	2690.73	2676.58	2678.03	2206.0
2012-01-05 04:00:00	NQ	Futures	2678.32	2681.2	2675.14	2676.29	1678.0
2012-01-05 05:00:00	NQ	Futures	2675.72	2677.74	2667.63	2668.79	1842.0
2012-01-05 06:00:00	NQ	Futures	2668.79	2675.72	2668.5	2673.7	2502.0
2012-01-05 07:00:00	NQ	Futures	2673.7	2680.34	2673.12	2678.03	2270.0
2012-01-05 08:00:00	NQ	Futures	2678.32	2692.47	2677.16	2684.67	9669.0
2012-01-05 09:00:00	NQ	Futures	2684.67	2690.45	2671.38	2680.34	29389.0
2012-01-05 10:00:00	NQ	Futures	2680.34	2689.87	2675.43	2683.8	29310.0
2012-01-05 11:00:00	NQ	Futures	2683.51	2695.93	2680.63	2692.18	21471.0
2012-01-05 12:00:00	NQ	Futures	2692.18	2701.13	2691.31	2701.13	18328.0
2012-01-05 13:00:00	NQ	Futures	2701.13	2711.82	2698.82	2708.06	18643.0
2012-01-05 14:00:00	NQ	Futures	2708.06	2709.79	2703.44	2703.73	12956.0
2012-01-05 15:00:00	NQ	Futures	2703.73	2710.95	2702.0	2709.79	36150.0
2012-01-05 16:00:00	NQ	Futures	2709.79	2710.37	2703.15	2704.31	6571.0
2012-01-05 17:00:00	NQ	Futures	2704.02	2704.02	2702.29	2703.15	202.0
2012-01-05 18:00:00	NQ	Futures	2703.15	2706.91	2702.86	2706.04	291.0
2012-01-05 19:00:00	NQ	Futures	2706.33	2707.2	2702.57	2703.15	316.0
2012-01-05 20:00:00	NQ	Futures	2703.15	2703.44	2700.55	2701.42	708.0
2012-01-05 21:00:00	NQ	Futures	2701.71	2702.0	2699.11	2701.13	609.0
2012-01-05 22:00:00	NQ	Futures	2700.84	2701.13	2699.69	2699.69	213.0
2012-01-05 23:00:00	NQ	Futures	2699.98	2699.98	2697.38	2697.38	210.0
2012-01-05 00:00:00	YM	Futures	12223.7	12234.6	12220.7	12223.7	188.0
2012-01-05 01:00:00	YM	Futures	12223.7	12229.6	12217.7	12226.6	246.0

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

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