PREVIEW / futures_1hour / 2011-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-21.parquet
  size:    42 KB
  rows:    1,182

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-21 00:00:00	ES	Futures	1215.42	1216.68	1214.92	1215.93	4997.0
2011-10-21 01:00:00	ES	Futures	1215.93	1219.19	1215.42	1218.18	6254.0
2011-10-21 02:00:00	ES	Futures	1218.18	1218.68	1215.42	1216.43	8585.0
2011-10-21 03:00:00	ES	Futures	1216.43	1217.43	1213.17	1216.68	32619.0
2011-10-21 04:00:00	ES	Futures	1216.93	1217.68	1214.42	1216.68	23098.0
2011-10-21 05:00:00	ES	Futures	1216.43	1219.44	1215.17	1217.18	29741.0
2011-10-21 06:00:00	ES	Futures	1217.18	1219.44	1216.68	1218.93	32299.0
2011-10-21 07:00:00	ES	Futures	1218.93	1227.46	1218.68	1225.2	79724.0
2011-10-21 08:00:00	ES	Futures	1225.2	1227.96	1223.7	1225.96	58513.0
2011-10-21 09:00:00	ES	Futures	1226.21	1233.48	1225.96	1231.97	320054.0
2011-10-21 10:00:00	ES	Futures	1231.97	1239.5	1229.97	1235.99	429450.0
2011-10-21 11:00:00	ES	Futures	1235.99	1236.99	1232.23	1235.48	196137.0
2011-10-21 12:00:00	ES	Futures	1235.23	1235.74	1231.22	1231.47	126971.0
2011-10-21 13:00:00	ES	Futures	1231.22	1231.47	1225.45	1226.21	212768.0
2011-10-21 14:00:00	ES	Futures	1226.21	1233.48	1225.45	1233.48	168333.0
2011-10-21 15:00:00	ES	Futures	1233.23	1237.99	1230.72	1237.74	244434.0
2011-10-21 16:00:00	ES	Futures	1237.74	1239.5	1236.49	1238.49	92840.0
2011-10-21 00:00:00	NQ	Futures	2656.89	2660.06	2656.31	2658.62	202.0
2011-10-21 01:00:00	NQ	Futures	2658.91	2664.1	2657.76	2662.95	376.0
2011-10-21 02:00:00	NQ	Futures	2663.23	2663.52	2656.6	2658.91	614.0
2011-10-21 03:00:00	NQ	Futures	2658.62	2661.22	2651.99	2660.06	2378.0
2011-10-21 04:00:00	NQ	Futures	2660.06	2661.79	2654.01	2659.49	2308.0
2011-10-21 05:00:00	NQ	Futures	2659.49	2669.87	2656.6	2663.52	3181.0
2011-10-21 06:00:00	NQ	Futures	2663.81	2667.85	2661.22	2666.41	2344.0
2011-10-21 07:00:00	NQ	Futures	2666.41	2682.55	2665.54	2678.52	5595.0
2011-10-21 08:00:00	NQ	Futures	2678.52	2682.55	2673.04	2678.52	5897.0
2011-10-21 09:00:00	NQ	Futures	2678.8	2696.39	2677.07	2688.61	41566.0
2011-10-21 10:00:00	NQ	Futures	2688.61	2705.04	2686.01	2694.95	39454.0
2011-10-21 11:00:00	NQ	Futures	2695.24	2696.39	2689.76	2690.91	22989.0
2011-10-21 12:00:00	NQ	Futures	2690.91	2691.49	2678.8	2679.38	21005.0
2011-10-21 13:00:00	NQ	Futures	2679.09	2679.38	2663.23	2667.56	38393.0
2011-10-21 14:00:00	NQ	Futures	2667.85	2679.96	2666.12	2679.96	27645.0
2011-10-21 15:00:00	NQ	Futures	2680.25	2688.61	2673.33	2688.03	35061.0
2011-10-21 16:00:00	NQ	Futures	2688.32	2694.66	2685.15	2692.36	7502.0
2011-10-21 00:00:00	YM	Futures	11308.7	11321.5	11306.7	11318.5	424.0
2011-10-21 01:00:00	YM	Futures	11320.5	11339.2	11316.5	11333.3	551.0
2011-10-21 02:00:00	YM	Futures	11334.3	11335.2	11306.7	11318.5	475.0
2011-10-21 03:00:00	YM	Futures	11318.5	11330.3	11290.9	11326.4	2241.0
2011-10-21 04:00:00	YM	Futures	11328.4	11334.3	11300.8	11320.5	1586.0
2011-10-21 05:00:00	YM	Futures	11321.5	11350.0	11309.6	11322.4	1673.0
2011-10-21 06:00:00	YM	Futures	11324.4	11341.1	11317.5	11336.2	1380.0
2011-10-21 07:00:00	YM	Futures	11337.2	11402.2	11333.3	11388.4	3674.0
2011-10-21 08:00:00	YM	Futures	11387.4	11412.0	11385.5	11402.2	3198.0
2011-10-21 09:00:00	YM	Futures	11402.2	11481.9	11402.2	11470.1	15177.0
2011-10-21 10:00:00	YM	Futures	11470.1	11524.3	11450.4	11517.4	19216.0
2011-10-21 11:00:00	YM	Futures	11517.4	11534.1	11486.9	11524.3	12036.0
2011-10-21 12:00:00	YM	Futures	11524.3	11526.2	11494.7	11496.7	8399.0
2011-10-21 13:00:00	YM	Futures	11495.7	11495.7	11453.4	11458.3	11660.0
2011-10-21 14:00:00	YM	Futures	11459.3	11524.3	11450.4	11524.3	11160.0
2011-10-21 15:00:00	YM	Futures	11524.3	11572.5	11507.5	11565.6	15154.0

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

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