PREVIEW / futures_1hour / 2011-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-18.parquet
  size:    41 KB
  rows:    1,170

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-11-18 00:00:00	ES	Futures	1217.43	1217.93	1215.42	1216.18	4439.0
2011-11-18 01:00:00	ES	Futures	1215.93	1218.68	1213.92	1214.17	8993.0
2011-11-18 02:00:00	ES	Futures	1214.17	1220.69	1213.92	1219.44	17679.0
2011-11-18 03:00:00	ES	Futures	1219.44	1221.69	1217.68	1218.93	44553.0
2011-11-18 04:00:00	ES	Futures	1218.93	1225.71	1218.93	1225.45	40433.0
2011-11-18 05:00:00	ES	Futures	1225.45	1226.96	1221.44	1222.95	30586.0
2011-11-18 06:00:00	ES	Futures	1223.2	1227.46	1220.69	1227.21	40517.0
2011-11-18 07:00:00	ES	Futures	1227.21	1233.48	1225.96	1228.71	99535.0
2011-11-18 08:00:00	ES	Futures	1228.71	1229.72	1225.96	1227.96	59901.0
2011-11-18 09:00:00	ES	Futures	1227.71	1228.97	1216.43	1221.44	386316.0
2011-11-18 10:00:00	ES	Futures	1221.69	1225.45	1215.17	1222.7	405927.0
2011-11-18 11:00:00	ES	Futures	1222.7	1223.7	1216.93	1217.93	211642.0
2011-11-18 12:00:00	ES	Futures	1217.68	1218.68	1212.42	1216.43	217163.0
2011-11-18 13:00:00	ES	Futures	1216.43	1222.95	1215.93	1220.69	128072.0
2011-11-18 14:00:00	ES	Futures	1220.69	1223.95	1217.93	1218.68	152411.0
2011-11-18 15:00:00	ES	Futures	1218.93	1220.44	1216.68	1217.68	196788.0
2011-11-18 16:00:00	ES	Futures	1217.93	1218.18	1216.43	1217.18	62836.0
2011-11-18 00:00:00	NQ	Futures	2612.78	2614.22	2610.18	2611.34	462.0
2011-11-18 01:00:00	NQ	Futures	2611.62	2615.95	2607.59	2607.88	685.0
2011-11-18 02:00:00	NQ	Futures	2607.88	2619.12	2607.59	2616.24	1326.0
2011-11-18 03:00:00	NQ	Futures	2616.53	2620.85	2611.05	2613.64	4149.0
2011-11-18 04:00:00	NQ	Futures	2613.93	2627.48	2613.93	2627.19	3370.0
2011-11-18 05:00:00	NQ	Futures	2627.19	2629.21	2616.24	2619.7	3519.0
2011-11-18 06:00:00	NQ	Futures	2619.41	2629.21	2613.93	2628.35	4044.0
2011-11-18 07:00:00	NQ	Futures	2628.35	2641.03	2625.46	2630.94	8972.0
2011-11-18 08:00:00	NQ	Futures	2630.94	2633.83	2627.19	2631.81	5238.0
2011-11-18 09:00:00	NQ	Futures	2631.52	2633.83	2604.71	2611.91	50681.0
2011-11-18 10:00:00	NQ	Futures	2611.34	2621.43	2600.09	2616.81	42610.0
2011-11-18 11:00:00	NQ	Futures	2616.81	2620.56	2603.55	2605.28	26195.0
2011-11-18 12:00:00	NQ	Futures	2605.28	2609.89	2593.75	2604.99	28859.0
2011-11-18 13:00:00	NQ	Futures	2604.99	2615.95	2603.55	2608.45	18367.0
2011-11-18 14:00:00	NQ	Futures	2608.45	2614.51	2600.38	2602.11	20650.0
2011-11-18 15:00:00	NQ	Futures	2602.11	2606.72	2596.92	2597.5	26574.0
2011-11-18 16:00:00	NQ	Futures	2597.21	2598.94	2595.19	2596.06	7334.0
2011-11-18 00:00:00	YM	Futures	11547.9	11552.8	11535.1	11538.1	261.0
2011-11-18 01:00:00	YM	Futures	11541.0	11559.7	11522.3	11526.2	586.0
2011-11-18 02:00:00	YM	Futures	11526.2	11575.5	11525.3	11566.6	923.0
2011-11-18 03:00:00	YM	Futures	11567.6	11584.3	11552.8	11560.7	2780.0
2011-11-18 04:00:00	YM	Futures	11560.7	11616.8	11560.7	11613.9	2424.0
2011-11-18 05:00:00	YM	Futures	11612.9	11623.7	11578.4	11591.2	1414.0
2011-11-18 06:00:00	YM	Futures	11589.3	11632.6	11573.5	11627.7	2104.0
2011-11-18 07:00:00	YM	Futures	11627.7	11675.9	11617.8	11638.5	4432.0
2011-11-18 08:00:00	YM	Futures	11637.5	11648.3	11619.8	11636.5	2733.0
2011-11-18 09:00:00	YM	Futures	11635.5	11645.4	11565.6	11609.0	19346.0
2011-11-18 10:00:00	YM	Futures	11609.0	11642.4	11557.8	11618.8	18842.0
2011-11-18 11:00:00	YM	Futures	11619.8	11627.7	11575.5	11587.3	10232.0
2011-11-18 12:00:00	YM	Futures	11588.3	11595.2	11542.0	11573.5	12000.0
2011-11-18 13:00:00	YM	Futures	11572.5	11623.7	11570.6	11608.0	8309.0
2011-11-18 14:00:00	YM	Futures	11608.0	11640.5	11590.2	11600.1	10058.0
2011-11-18 15:00:00	YM	Futures	11600.1	11613.9	11580.4	11589.3	12214.0

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

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