PREVIEW / futures_1hour / 2011-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-24.parquet
  size:    41 KB
  rows:    1,191

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-06-24 00:00:00	ES	Futures	1279.95	1280.7	1279.7	1280.2	2761.0
2011-06-24 01:00:00	ES	Futures	1279.95	1281.94	1279.95	1280.45	9730.0
2011-06-24 02:00:00	ES	Futures	1280.2	1281.2	1277.46	1277.46	18470.0
2011-06-24 03:00:00	ES	Futures	1277.46	1279.45	1276.21	1276.46	41666.0
2011-06-24 04:00:00	ES	Futures	1276.71	1282.44	1276.46	1282.44	35511.0
2011-06-24 05:00:00	ES	Futures	1282.19	1282.94	1279.45	1279.45	20781.0
2011-06-24 06:00:00	ES	Futures	1279.45	1279.45	1272.47	1273.96	90438.0
2011-06-24 07:00:00	ES	Futures	1273.71	1276.71	1273.22	1273.46	33760.0
2011-06-24 08:00:00	ES	Futures	1273.46	1278.7	1271.47	1277.21	110368.0
2011-06-24 09:00:00	ES	Futures	1277.46	1278.45	1269.22	1271.22	286418.0
2011-06-24 10:00:00	ES	Futures	1270.97	1272.22	1261.74	1263.74	469591.0
2011-06-24 11:00:00	ES	Futures	1263.74	1266.98	1261.24	1264.98	299658.0
2011-06-24 12:00:00	ES	Futures	1265.23	1266.48	1260.5	1261.99	173249.0
2011-06-24 13:00:00	ES	Futures	1261.99	1265.98	1259.75	1264.49	188576.0
2011-06-24 14:00:00	ES	Futures	1264.24	1264.74	1260.99	1261.74	148139.0
2011-06-24 15:00:00	ES	Futures	1261.99	1262.74	1258.25	1260.25	344034.0
2011-06-24 16:00:00	ES	Futures	1260.5	1261.24	1258.5	1260.74	158124.0
2011-06-24 00:00:00	NQ	Futures	2590.46	2591.04	2588.74	2589.31	223.0
2011-06-24 01:00:00	NQ	Futures	2589.6	2591.9	2588.74	2589.89	704.0
2011-06-24 02:00:00	NQ	Futures	2589.89	2592.48	2584.71	2585.0	1484.0
2011-06-24 03:00:00	NQ	Futures	2585.28	2590.18	2581.54	2581.83	3906.0
2011-06-24 04:00:00	NQ	Futures	2582.12	2599.67	2582.12	2597.08	5303.0
2011-06-24 05:00:00	NQ	Futures	2597.37	2597.66	2590.75	2591.04	2561.0
2011-06-24 06:00:00	NQ	Futures	2591.04	2591.33	2579.53	2583.27	6445.0
2011-06-24 07:00:00	NQ	Futures	2583.27	2586.72	2579.53	2579.82	3117.0
2011-06-24 08:00:00	NQ	Futures	2579.53	2588.74	2577.8	2586.15	10985.0
2011-06-24 09:00:00	NQ	Futures	2586.15	2588.74	2568.31	2574.06	54244.0
2011-06-24 10:00:00	NQ	Futures	2574.06	2576.94	2556.22	2561.4	56973.0
2011-06-24 11:00:00	NQ	Futures	2561.4	2566.29	2555.64	2560.82	39577.0
2011-06-24 12:00:00	NQ	Futures	2561.11	2564.56	2549.89	2552.48	31390.0
2011-06-24 13:00:00	NQ	Futures	2552.77	2558.81	2547.87	2556.22	23699.0
2011-06-24 14:00:00	NQ	Futures	2555.93	2556.51	2549.02	2550.18	16407.0
2011-06-24 15:00:00	NQ	Futures	2550.46	2551.04	2541.54	2545.86	40817.0
2011-06-24 16:00:00	NQ	Futures	2546.15	2547.3	2540.1	2542.41	13540.0
2011-06-24 00:00:00	YM	Futures	11640.2	11644.0	11636.3	11640.2	138.0
2011-06-24 01:00:00	YM	Futures	11641.1	11658.6	11640.2	11647.9	491.0
2011-06-24 02:00:00	YM	Futures	11647.9	11655.7	11626.6	11626.6	936.0
2011-06-24 03:00:00	YM	Futures	11626.6	11640.2	11612.1	11620.8	2463.0
2011-06-24 04:00:00	YM	Futures	11621.8	11672.1	11620.8	11671.1	3121.0
2011-06-24 05:00:00	YM	Futures	11670.2	11677.0	11646.9	11646.9	1779.0
2011-06-24 06:00:00	YM	Futures	11646.9	11646.9	11591.7	11600.5	5308.0
2011-06-24 07:00:00	YM	Futures	11599.5	11620.8	11581.1	11581.1	3718.0
2011-06-24 08:00:00	YM	Futures	11582.1	11626.6	11567.5	11620.8	6536.0
2011-06-24 09:00:00	YM	Futures	11618.9	11626.6	11537.5	11554.0	21056.0
2011-06-24 10:00:00	YM	Futures	11554.0	11561.7	11484.2	11506.5	25605.0
2011-06-24 11:00:00	YM	Futures	11505.6	11538.5	11486.2	11518.1	15432.0
2011-06-24 12:00:00	YM	Futures	11517.2	11532.7	11491.0	11505.6	7508.0
2011-06-24 13:00:00	YM	Futures	11506.5	11539.4	11487.2	11527.8	7600.0
2011-06-24 14:00:00	YM	Futures	11527.8	11529.8	11497.8	11507.5	6680.0
2011-06-24 15:00:00	YM	Futures	11508.5	11510.4	11478.4	11496.8	15930.0

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

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