PREVIEW / futures_1hour / 2011-12-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-06.parquet
  size:    46 KB
  rows:    1,442

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-06 00:00:00	ES	Futures	1251.28	1252.79	1249.03	1252.79	8324.0
2011-12-06 01:00:00	ES	Futures	1252.54	1254.54	1252.03	1253.79	6030.0
2011-12-06 02:00:00	ES	Futures	1253.79	1254.54	1250.53	1253.29	15688.0
2011-12-06 03:00:00	ES	Futures	1253.04	1262.82	1253.04	1260.81	56132.0
2011-12-06 04:00:00	ES	Futures	1260.56	1261.56	1255.29	1259.06	30222.0
2011-12-06 05:00:00	ES	Futures	1258.81	1264.82	1258.05	1264.57	30018.0
2011-12-06 06:00:00	ES	Futures	1264.57	1265.58	1261.06	1263.32	29268.0
2011-12-06 07:00:00	ES	Futures	1263.07	1264.82	1260.56	1261.56	30609.0
2011-12-06 08:00:00	ES	Futures	1261.31	1263.32	1258.05	1259.31	62172.0
2011-12-06 09:00:00	ES	Futures	1259.31	1262.57	1255.8	1258.3	233683.0
2011-12-06 10:00:00	ES	Futures	1258.3	1264.07	1257.8	1259.56	382960.0
2011-12-06 11:00:00	ES	Futures	1259.56	1261.06	1256.55	1260.31	259454.0
2011-12-06 12:00:00	ES	Futures	1260.06	1261.06	1258.3	1259.56	92672.0
2011-12-06 13:00:00	ES	Futures	1259.56	1262.82	1258.05	1260.81	125078.0
2011-12-06 14:00:00	ES	Futures	1260.81	1268.58	1259.56	1267.33	234506.0
2011-12-06 15:00:00	ES	Futures	1267.33	1269.59	1261.06	1261.31	377238.0
2011-12-06 16:00:00	ES	Futures	1261.31	1261.81	1258.05	1260.56	103407.0
2011-12-06 17:00:00	ES	Futures	1260.31	1260.56	1259.56	1259.56	1544.0
2011-12-06 18:00:00	ES	Futures	1259.56	1261.56	1258.55	1261.31	7993.0
2011-12-06 19:00:00	ES	Futures	1261.06	1263.07	1260.06	1263.07	8191.0
2011-12-06 20:00:00	ES	Futures	1262.82	1265.07	1262.07	1264.32	7657.0
2011-12-06 21:00:00	ES	Futures	1264.57	1265.33	1263.32	1263.82	7296.0
2011-12-06 22:00:00	ES	Futures	1263.82	1264.82	1263.57	1264.82	3492.0
2011-12-06 23:00:00	ES	Futures	1264.82	1266.08	1264.07	1264.57	4466.0
2011-12-06 00:00:00	NQ	Futures	2670.73	2674.19	2667.27	2673.9	490.0
2011-12-06 01:00:00	NQ	Futures	2673.61	2677.07	2673.04	2676.79	435.0
2011-12-06 02:00:00	NQ	Futures	2676.21	2677.94	2669.87	2675.63	874.0
2011-12-06 03:00:00	NQ	Futures	2675.92	2695.82	2674.19	2692.07	4571.0
2011-12-06 04:00:00	NQ	Futures	2692.36	2694.09	2681.69	2688.61	2478.0
2011-12-06 05:00:00	NQ	Futures	2688.9	2698.99	2687.17	2698.7	2125.0
2011-12-06 06:00:00	NQ	Futures	2698.7	2700.43	2692.93	2697.26	2360.0
2011-12-06 07:00:00	NQ	Futures	2697.26	2698.99	2689.18	2690.05	3145.0
2011-12-06 08:00:00	NQ	Futures	2690.34	2693.8	2682.26	2685.72	5130.0
2011-12-06 09:00:00	NQ	Futures	2685.72	2694.95	2681.98	2686.59	25910.0
2011-12-06 10:00:00	NQ	Futures	2686.3	2692.36	2677.07	2677.94	38081.0
2011-12-06 11:00:00	NQ	Futures	2677.65	2680.82	2668.71	2675.63	27913.0
2011-12-06 12:00:00	NQ	Futures	2675.34	2678.23	2670.44	2673.61	11916.0
2011-12-06 13:00:00	NQ	Futures	2673.9	2679.38	2669.58	2674.77	14857.0
2011-12-06 14:00:00	NQ	Futures	2674.77	2690.63	2671.31	2688.03	25507.0
2011-12-06 15:00:00	NQ	Futures	2688.03	2692.64	2677.36	2677.65	31214.0
2011-12-06 16:00:00	NQ	Futures	2677.94	2681.4	2676.21	2680.53	9406.0
2011-12-06 17:00:00	NQ	Futures	2680.25	2680.53	2678.52	2679.09	101.0
2011-12-06 18:00:00	NQ	Futures	2679.09	2683.13	2678.23	2682.26	391.0
2011-12-06 19:00:00	NQ	Futures	2682.26	2685.44	2681.11	2684.86	624.0
2011-12-06 20:00:00	NQ	Futures	2685.15	2689.18	2683.99	2688.32	824.0
2011-12-06 21:00:00	NQ	Futures	2688.61	2690.34	2686.88	2687.45	365.0
2011-12-06 22:00:00	NQ	Futures	2687.74	2690.05	2687.45	2689.18	216.0
2011-12-06 23:00:00	NQ	Futures	2689.18	2691.49	2688.9	2689.76	234.0
2011-12-06 00:00:00	YM	Futures	11828.5	11843.3	11813.7	11841.3	516.0
2011-12-06 01:00:00	YM	Futures	11839.3	11855.1	11837.4	11846.2	991.0

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

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