PREVIEW / futures_1hour / 2011-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-17.parquet
  size:    43 KB
  rows:    1,203

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-17 00:00:00	ES	Futures	1261.74	1262.24	1259.25	1259.25	13440.0
2011-06-17 01:00:00	ES	Futures	1259.25	1259.75	1257.5	1258.5	9496.0
2011-06-17 02:00:00	ES	Futures	1258.5	1260.99	1258.25	1260.74	11697.0
2011-06-17 03:00:00	ES	Futures	1260.5	1260.99	1255.51	1256.26	35589.0
2011-06-17 04:00:00	ES	Futures	1256.26	1258.5	1256.01	1257.0	20620.0
2011-06-17 05:00:00	ES	Futures	1257.0	1265.73	1256.51	1263.99	43467.0
2011-06-17 06:00:00	ES	Futures	1263.99	1270.97	1261.74	1269.97	72409.0
2011-06-17 07:00:00	ES	Futures	1269.72	1274.21	1269.72	1273.22	64366.0
2011-06-17 08:00:00	ES	Futures	1273.46	1273.46	1270.97	1272.72	66589.0
2011-06-17 09:00:00	ES	Futures	1272.72	1272.97	1266.48	1268.73	357069.0
2011-06-17 10:00:00	ES	Futures	1268.98	1271.72	1264.24	1268.23	387468.0
2011-06-17 11:00:00	ES	Futures	1268.23	1269.22	1265.23	1268.23	290155.0
2011-06-17 12:00:00	ES	Futures	1268.23	1268.48	1261.74	1263.24	157123.0
2011-06-17 13:00:00	ES	Futures	1263.24	1264.24	1260.25	1262.24	156356.0
2011-06-17 14:00:00	ES	Futures	1261.99	1266.98	1261.74	1264.49	156249.0
2011-06-17 15:00:00	ES	Futures	1264.49	1265.98	1258.5	1263.24	309834.0
2011-06-17 16:00:00	ES	Futures	1262.99	1263.74	1261.99	1262.74	104901.0
2011-06-17 00:00:00	NQ	Futures	2531.18	2531.76	2526.0	2526.0	912.0
2011-06-17 01:00:00	NQ	Futures	2526.0	2527.44	2523.13	2525.72	460.0
2011-06-17 02:00:00	NQ	Futures	2525.14	2527.44	2524.56	2526.87	738.0
2011-06-17 03:00:00	NQ	Futures	2526.58	2526.87	2518.23	2520.25	3048.0
2011-06-17 04:00:00	NQ	Futures	2520.25	2522.84	2519.39	2520.54	1560.0
2011-06-17 05:00:00	NQ	Futures	2520.25	2536.94	2519.67	2534.35	5085.0
2011-06-17 06:00:00	NQ	Futures	2534.35	2545.28	2529.74	2542.98	7813.0
2011-06-17 07:00:00	NQ	Futures	2542.98	2550.18	2542.69	2548.16	4608.0
2011-06-17 08:00:00	NQ	Futures	2548.16	2548.16	2542.69	2547.01	7308.0
2011-06-17 09:00:00	NQ	Futures	2547.01	2553.92	2538.09	2538.95	57181.0
2011-06-17 10:00:00	NQ	Futures	2538.67	2545.0	2528.02	2532.62	54725.0
2011-06-17 11:00:00	NQ	Futures	2532.91	2536.08	2526.87	2531.76	46808.0
2011-06-17 12:00:00	NQ	Futures	2532.05	2532.91	2519.67	2522.84	20488.0
2011-06-17 13:00:00	NQ	Futures	2522.55	2526.29	2516.8	2520.54	22915.0
2011-06-17 14:00:00	NQ	Futures	2520.82	2529.17	2519.96	2523.7	19085.0
2011-06-17 15:00:00	NQ	Futures	2523.99	2525.43	2512.19	2519.39	39178.0
2011-06-17 16:00:00	NQ	Futures	2519.39	2523.13	2518.23	2521.69	9400.0
2011-06-17 00:00:00	YM	Futures	11533.6	11534.6	11509.4	11512.3	765.0
2011-06-17 01:00:00	YM	Futures	11511.4	11516.2	11497.8	11509.4	425.0
2011-06-17 02:00:00	YM	Futures	11507.5	11524.9	11504.6	11522.0	535.0
2011-06-17 03:00:00	YM	Futures	11521.0	11527.8	11483.3	11494.9	3746.0
2011-06-17 04:00:00	YM	Futures	11494.9	11510.4	11491.0	11498.8	1073.0
2011-06-17 05:00:00	YM	Futures	11497.8	11568.5	11493.9	11555.9	2715.0
2011-06-17 06:00:00	YM	Futures	11554.9	11605.3	11537.5	11596.6	3785.0
2011-06-17 07:00:00	YM	Futures	11597.6	11626.6	11595.6	11620.8	3190.0
2011-06-17 08:00:00	YM	Futures	11621.8	11624.7	11601.4	11615.0	4204.0
2011-06-17 09:00:00	YM	Futures	11615.0	11615.0	11572.4	11599.5	20166.0
2011-06-17 10:00:00	YM	Futures	11598.5	11624.7	11571.4	11601.4	21854.0
2011-06-17 11:00:00	YM	Futures	11600.5	11610.1	11580.1	11595.6	15977.0
2011-06-17 12:00:00	YM	Futures	11595.6	11599.5	11549.1	11558.8	10434.0
2011-06-17 13:00:00	YM	Futures	11557.8	11565.6	11536.5	11551.1	9896.0
2011-06-17 14:00:00	YM	Futures	11550.1	11596.6	11549.1	11572.4	8180.0
2011-06-17 15:00:00	YM	Futures	11572.4	11587.9	11524.0	11558.8	18590.0

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

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