PREVIEW / futures_1hour / 2011-12-07

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-07.parquet
  size:    47 KB
  rows:    1,445

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-12-07 00:00:00	ES	Futures	1264.57	1265.83	1263.82	1263.82	2968.0
2011-12-07 01:00:00	ES	Futures	1264.07	1267.33	1263.07	1267.08	8069.0
2011-12-07 02:00:00	ES	Futures	1267.33	1271.84	1267.08	1270.09	24813.0
2011-12-07 03:00:00	ES	Futures	1269.84	1271.09	1267.58	1269.84	33075.0
2011-12-07 04:00:00	ES	Futures	1270.09	1271.09	1267.08	1267.33	25336.0
2011-12-07 05:00:00	ES	Futures	1267.33	1269.59	1265.33	1266.33	35148.0
2011-12-07 06:00:00	ES	Futures	1266.33	1266.83	1263.32	1265.07	32286.0
2011-12-07 07:00:00	ES	Futures	1265.07	1265.33	1260.06	1260.81	41202.0
2011-12-07 08:00:00	ES	Futures	1260.56	1261.56	1253.29	1256.8	140603.0
2011-12-07 09:00:00	ES	Futures	1256.55	1259.31	1249.53	1253.04	300421.0
2011-12-07 10:00:00	ES	Futures	1253.04	1253.79	1247.77	1253.29	365339.0
2011-12-07 11:00:00	ES	Futures	1253.29	1258.05	1252.29	1257.8	280145.0
2011-12-07 12:00:00	ES	Futures	1257.55	1262.57	1256.05	1261.56	235635.0
2011-12-07 13:00:00	ES	Futures	1261.81	1262.32	1258.05	1259.31	182226.0
2011-12-07 14:00:00	ES	Futures	1259.56	1260.31	1254.79	1256.05	195323.0
2011-12-07 15:00:00	ES	Futures	1256.05	1270.84	1255.55	1264.57	469852.0
2011-12-07 16:00:00	ES	Futures	1264.57	1268.58	1263.57	1267.08	94603.0
2011-12-07 17:00:00	ES	Futures	1267.08	1270.34	1266.83	1269.84	2637.0
2011-12-07 18:00:00	ES	Futures	1269.34	1270.09	1266.83	1267.08	6563.0
2011-12-07 19:00:00	ES	Futures	1267.08	1269.09	1266.33	1268.58	6487.0
2011-12-07 20:00:00	ES	Futures	1268.58	1269.09	1266.33	1266.83	4797.0
2011-12-07 21:00:00	ES	Futures	1266.83	1267.08	1265.33	1265.58	4748.0
2011-12-07 22:00:00	ES	Futures	1265.58	1268.08	1265.33	1268.08	4267.0
2011-12-07 23:00:00	ES	Futures	1268.08	1269.09	1267.08	1268.84	3047.0
2011-12-07 00:00:00	NQ	Futures	2689.47	2691.78	2688.32	2688.32	158.0
2011-12-07 01:00:00	NQ	Futures	2688.32	2693.51	2686.3	2692.93	382.0
2011-12-07 02:00:00	NQ	Futures	2693.22	2703.02	2692.93	2700.14	1632.0
2011-12-07 03:00:00	NQ	Futures	2699.56	2702.45	2695.24	2699.27	1840.0
2011-12-07 04:00:00	NQ	Futures	2699.56	2703.02	2694.09	2694.37	1989.0
2011-12-07 05:00:00	NQ	Futures	2694.37	2698.41	2690.34	2692.07	2057.0
2011-12-07 06:00:00	NQ	Futures	2692.07	2692.93	2686.59	2688.61	1987.0
2011-12-07 07:00:00	NQ	Futures	2688.9	2689.47	2678.23	2678.8	3687.0
2011-12-07 08:00:00	NQ	Futures	2678.8	2680.25	2665.54	2670.73	8445.0
2011-12-07 09:00:00	NQ	Futures	2670.73	2674.19	2643.63	2651.7	43427.0
2011-12-07 10:00:00	NQ	Futures	2651.7	2656.6	2642.76	2656.31	34475.0
2011-12-07 11:00:00	NQ	Futures	2656.6	2671.31	2655.16	2670.15	34286.0
2011-12-07 12:00:00	NQ	Futures	2670.15	2678.8	2664.96	2677.07	28202.0
2011-12-07 13:00:00	NQ	Futures	2677.07	2678.23	2667.85	2670.15	18962.0
2011-12-07 14:00:00	NQ	Futures	2670.15	2672.17	2658.62	2661.22	21807.0
2011-12-07 15:00:00	NQ	Futures	2660.93	2689.76	2659.2	2676.21	40382.0
2011-12-07 16:00:00	NQ	Futures	2676.5	2681.69	2673.9	2679.09	7833.0
2011-12-07 17:00:00	NQ	Futures	2679.09	2684.57	2679.09	2684.57	128.0
2011-12-07 18:00:00	NQ	Futures	2683.71	2684.28	2679.67	2679.67	334.0
2011-12-07 19:00:00	NQ	Futures	2679.96	2683.13	2678.8	2681.98	234.0
2011-12-07 20:00:00	NQ	Futures	2681.98	2682.55	2677.94	2678.52	226.0
2011-12-07 21:00:00	NQ	Futures	2678.23	2679.96	2677.07	2677.65	297.0
2011-12-07 22:00:00	NQ	Futures	2677.65	2681.69	2677.07	2681.69	248.0
2011-12-07 23:00:00	NQ	Futures	2681.4	2683.13	2679.96	2682.55	283.0
2011-12-07 00:00:00	YM	Futures	11980.1	11986.0	11972.3	11977.2	341.0
2011-12-07 01:00:00	YM	Futures	11976.2	12005.7	11970.3	12002.8	2038.0

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

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