PREVIEW / futures_1hour / 2011-06-10

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-10.parquet
  size:    40 KB
  rows:    1,146

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-10 00:00:00	ES	Futures	1275.44	1275.69	1274.45	1274.95	3618.0
2011-06-10 01:00:00	ES	Futures	1275.19	1275.69	1274.45	1275.44	5079.0
2011-06-10 02:00:00	ES	Futures	1275.19	1276.93	1274.45	1276.68	10475.0
2011-06-10 03:00:00	ES	Futures	1276.68	1276.93	1273.21	1275.44	21658.0
2011-06-10 04:00:00	ES	Futures	1275.19	1278.92	1274.95	1278.67	15500.0
2011-06-10 05:00:00	ES	Futures	1278.67	1279.42	1276.93	1277.93	12128.0
2011-06-10 06:00:00	ES	Futures	1277.68	1278.67	1274.7	1275.44	14672.0
2011-06-10 07:00:00	ES	Futures	1275.19	1277.18	1273.95	1276.68	22962.0
2011-06-10 08:00:00	ES	Futures	1276.68	1278.42	1274.45	1274.7	29937.0
2011-06-10 09:00:00	ES	Futures	1274.7	1275.94	1268.49	1269.48	137000.0
2011-06-10 10:00:00	ES	Futures	1269.48	1269.98	1263.77	1265.26	160244.0
2011-06-10 11:00:00	ES	Futures	1265.51	1265.75	1261.78	1265.01	116144.0
2011-06-10 12:00:00	ES	Futures	1265.01	1266.75	1263.27	1265.26	56156.0
2011-06-10 13:00:00	ES	Futures	1265.26	1265.26	1259.05	1260.54	75787.0
2011-06-10 14:00:00	ES	Futures	1260.78	1270.23	1260.54	1270.23	144394.0
2011-06-10 15:00:00	ES	Futures	1270.23	1270.97	1261.53	1261.78	122465.0
2011-06-10 16:00:00	ES	Futures	1262.03	1262.28	1260.04	1261.78	41354.0
2011-06-10 00:00:00	NQ	Futures	2582.67	2582.96	2580.95	2581.52	306.0
2011-06-10 01:00:00	NQ	Futures	2581.52	2582.39	2580.95	2582.1	393.0
2011-06-10 02:00:00	NQ	Futures	2582.1	2583.53	2580.95	2583.25	1059.0
2011-06-10 03:00:00	NQ	Futures	2583.25	2584.68	2579.8	2583.53	2474.0
2011-06-10 04:00:00	NQ	Futures	2583.25	2589.57	2582.67	2589.57	984.0
2011-06-10 05:00:00	NQ	Futures	2589.28	2589.57	2585.55	2586.41	596.0
2011-06-10 06:00:00	NQ	Futures	2586.7	2587.56	2580.37	2581.52	680.0
2011-06-10 07:00:00	NQ	Futures	2581.52	2584.68	2580.37	2583.25	856.0
2011-06-10 08:00:00	NQ	Futures	2583.25	2586.7	2580.95	2581.81	2082.0
2011-06-10 09:00:00	NQ	Futures	2581.81	2586.98	2577.21	2579.8	14560.0
2011-06-10 10:00:00	NQ	Futures	2579.51	2580.37	2560.55	2563.14	17846.0
2011-06-10 11:00:00	NQ	Futures	2562.85	2566.58	2555.95	2565.15	13445.0
2011-06-10 12:00:00	NQ	Futures	2565.43	2568.59	2561.7	2566.87	6035.0
2011-06-10 13:00:00	NQ	Futures	2566.58	2566.58	2553.08	2557.1	7334.0
2011-06-10 14:00:00	NQ	Futures	2557.1	2571.47	2557.1	2571.18	11773.0
2011-06-10 15:00:00	NQ	Futures	2571.18	2572.04	2551.64	2553.08	12874.0
2011-06-10 16:00:00	NQ	Futures	2553.08	2555.09	2549.63	2554.23	4369.0
2011-06-10 00:00:00	YM	Futures	11633.4	11633.4	11621.8	11627.6	143.0
2011-06-10 01:00:00	YM	Futures	11627.6	11634.4	11624.7	11631.4	183.0
2011-06-10 02:00:00	YM	Futures	11629.5	11644.0	11624.7	11644.0	392.0
2011-06-10 03:00:00	YM	Futures	11643.1	11643.1	11613.0	11629.5	929.0
2011-06-10 04:00:00	YM	Futures	11629.5	11659.5	11626.6	11657.6	905.0
2011-06-10 05:00:00	YM	Futures	11658.6	11662.4	11644.0	11650.8	712.0
2011-06-10 06:00:00	YM	Futures	11650.8	11657.6	11626.6	11631.4	698.0
2011-06-10 07:00:00	YM	Futures	11632.4	11646.0	11621.8	11642.1	800.0
2011-06-10 08:00:00	YM	Futures	11643.1	11655.7	11620.8	11622.7	1463.0
2011-06-10 09:00:00	YM	Futures	11621.8	11631.4	11557.8	11564.6	12729.0
2011-06-10 10:00:00	YM	Futures	11565.6	11572.4	11523.0	11534.6	15489.0
2011-06-10 11:00:00	YM	Futures	11533.6	11536.5	11507.5	11528.8	9935.0
2011-06-10 12:00:00	YM	Futures	11528.8	11548.2	11519.1	11535.6	5640.0
2011-06-10 13:00:00	YM	Futures	11534.6	11534.6	11482.3	11492.0	6736.0
2011-06-10 14:00:00	YM	Futures	11491.0	11556.9	11491.0	11555.9	10554.0
2011-06-10 15:00:00	YM	Futures	11556.9	11560.8	11488.1	11496.8	12863.0

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

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