PREVIEW / futures_1hour / 2011-02-25

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-25.parquet
  size:    39 KB
  rows:    1,120

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-02-25 00:00:00	ES	Futures	1294.29	1295.28	1294.04	1294.79	2711.0
2011-02-25 01:00:00	ES	Futures	1294.79	1295.03	1293.8	1294.54	4970.0
2011-02-25 02:00:00	ES	Futures	1294.29	1295.28	1292.31	1293.8	17226.0
2011-02-25 03:00:00	ES	Futures	1293.55	1294.79	1291.82	1294.54	25873.0
2011-02-25 04:00:00	ES	Futures	1294.29	1296.77	1294.29	1296.02	35155.0
2011-02-25 05:00:00	ES	Futures	1296.02	1297.26	1294.54	1296.52	17367.0
2011-02-25 06:00:00	ES	Futures	1296.77	1298.25	1296.02	1297.76	24277.0
2011-02-25 07:00:00	ES	Futures	1297.51	1299.73	1296.52	1296.77	40186.0
2011-02-25 08:00:00	ES	Futures	1296.77	1298.99	1295.53	1298.0	63092.0
2011-02-25 09:00:00	ES	Futures	1298.25	1301.47	1296.02	1301.22	266860.0
2011-02-25 10:00:00	ES	Futures	1301.22	1304.44	1300.97	1303.45	318334.0
2011-02-25 11:00:00	ES	Futures	1303.45	1303.94	1298.74	1300.72	252851.0
2011-02-25 12:00:00	ES	Futures	1300.48	1303.94	1300.23	1303.45	100683.0
2011-02-25 13:00:00	ES	Futures	1303.45	1306.17	1302.95	1304.68	152926.0
2011-02-25 14:00:00	ES	Futures	1304.68	1306.41	1303.69	1305.43	124693.0
2011-02-25 15:00:00	ES	Futures	1305.43	1305.92	1303.45	1305.43	213412.0
2011-02-25 16:00:00	ES	Futures	1305.18	1305.67	1304.44	1305.18	103694.0
2011-02-25 00:00:00	NQ	Futures	2659.36	2663.95	2659.36	2663.37	542.0
2011-02-25 01:00:00	NQ	Futures	2663.66	2663.66	2660.5	2662.51	172.0
2011-02-25 02:00:00	NQ	Futures	2662.51	2663.95	2659.64	2662.8	1720.0
2011-02-25 03:00:00	NQ	Futures	2662.8	2665.38	2659.07	2665.1	3188.0
2011-02-25 04:00:00	NQ	Futures	2665.1	2668.54	2664.81	2667.39	1960.0
2011-02-25 05:00:00	NQ	Futures	2667.39	2671.12	2664.52	2668.25	2192.0
2011-02-25 06:00:00	NQ	Futures	2668.54	2671.12	2667.11	2669.69	1538.0
2011-02-25 07:00:00	NQ	Futures	2669.69	2672.56	2668.83	2669.11	2782.0
2011-02-25 08:00:00	NQ	Futures	2669.4	2673.71	2666.24	2672.85	8891.0
2011-02-25 09:00:00	NQ	Futures	2672.85	2684.04	2669.4	2682.61	42776.0
2011-02-25 10:00:00	NQ	Futures	2682.61	2696.1	2681.46	2694.37	47175.0
2011-02-25 11:00:00	NQ	Futures	2694.37	2697.53	2681.17	2685.76	35988.0
2011-02-25 12:00:00	NQ	Futures	2685.76	2693.8	2684.61	2692.94	18215.0
2011-02-25 13:00:00	NQ	Futures	2692.94	2698.39	2690.64	2695.23	21748.0
2011-02-25 14:00:00	NQ	Futures	2695.23	2697.53	2691.5	2694.66	16877.0
2011-02-25 15:00:00	NQ	Futures	2694.95	2695.81	2692.36	2694.09	27121.0
2011-02-25 16:00:00	NQ	Futures	2694.09	2695.52	2692.36	2692.65	8391.0
2011-02-25 02:00:00	YM	Futures	11574.8	11579.6	11558.5	11572.9	846.0
2011-02-25 03:00:00	YM	Futures	11571.9	11577.7	11559.5	11574.8	1733.0
2011-02-25 04:00:00	YM	Futures	11575.8	11589.2	11573.8	11585.3	1736.0
2011-02-25 05:00:00	YM	Futures	11584.4	11589.2	11572.9	11584.4	649.0
2011-02-25 06:00:00	YM	Futures	11586.3	11596.8	11579.6	11594.0	699.0
2011-02-25 07:00:00	YM	Futures	11594.0	11605.4	11584.4	11587.3	1094.0
2011-02-25 08:00:00	YM	Futures	11587.3	11604.5	11579.6	11595.9	3193.0
2011-02-25 09:00:00	YM	Futures	11595.9	11597.8	11570.0	11593.0	17053.0
2011-02-25 10:00:00	YM	Futures	11594.0	11616.9	11591.1	11609.3	14344.0
2011-02-25 11:00:00	YM	Futures	11610.2	11612.2	11573.8	11587.3	11300.0
2011-02-25 12:00:00	YM	Futures	11586.3	11605.4	11583.4	11605.4	5105.0
2011-02-25 13:00:00	YM	Futures	11605.4	11627.5	11602.6	11615.0	7845.0
2011-02-25 14:00:00	YM	Futures	11615.0	11627.5	11606.4	11615.0	6880.0
2011-02-25 15:00:00	YM	Futures	11615.0	11620.8	11597.8	11609.3	10592.0
2011-02-25 16:00:00	YM	Futures	11609.3	11609.3	11597.8	11598.7	3174.0
2011-02-25 00:00:00	CL	Futures	172.72	172.72	172.72	172.72	1.0

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

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