PREVIEW / futures_1hour / 2011-12-27

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-27.parquet
  size:    35 KB
  rows:    1,071

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-27 06:00:00	ES	Futures	1270.52	1271.03	1269.01	1269.52	10558.0
2011-12-27 07:00:00	ES	Futures	1269.52	1269.52	1267.0	1267.75	8752.0
2011-12-27 08:00:00	ES	Futures	1267.75	1269.77	1266.24	1267.25	13587.0
2011-12-27 09:00:00	ES	Futures	1267.25	1273.55	1265.99	1273.3	92739.0
2011-12-27 10:00:00	ES	Futures	1273.3	1274.05	1269.26	1269.77	114137.0
2011-12-27 11:00:00	ES	Futures	1269.77	1271.53	1269.52	1271.28	56244.0
2011-12-27 12:00:00	ES	Futures	1271.03	1272.79	1271.03	1271.53	31194.0
2011-12-27 13:00:00	ES	Futures	1271.78	1273.55	1270.78	1273.3	30859.0
2011-12-27 14:00:00	ES	Futures	1273.3	1273.55	1271.03	1273.04	38370.0
2011-12-27 15:00:00	ES	Futures	1273.04	1273.55	1270.02	1270.78	70881.0
2011-12-27 16:00:00	ES	Futures	1270.52	1271.53	1269.26	1269.77	42162.0
2011-12-27 17:00:00	ES	Futures	1269.77	1269.77	1269.26	1269.52	419.0
2011-12-27 18:00:00	ES	Futures	1269.26	1269.77	1268.0	1268.51	3036.0
2011-12-27 19:00:00	ES	Futures	1268.51	1269.52	1267.75	1269.01	4290.0
2011-12-27 20:00:00	ES	Futures	1269.01	1271.03	1268.76	1270.78	4103.0
2011-12-27 21:00:00	ES	Futures	1270.78	1271.03	1270.27	1270.52	966.0
2011-12-27 22:00:00	ES	Futures	1270.52	1270.78	1269.01	1269.26	2326.0
2011-12-27 23:00:00	ES	Futures	1269.26	1269.26	1266.74	1266.74	3367.0
2011-12-27 06:00:00	NQ	Futures	2633.84	2644.53	2633.55	2635.57	1262.0
2011-12-27 07:00:00	NQ	Futures	2635.57	2635.57	2628.06	2630.38	847.0
2011-12-27 08:00:00	NQ	Futures	2630.09	2639.62	2630.09	2633.55	1966.0
2011-12-27 09:00:00	NQ	Futures	2633.55	2647.13	2629.51	2646.26	16455.0
2011-12-27 10:00:00	NQ	Futures	2646.26	2649.44	2637.31	2638.75	17551.0
2011-12-27 11:00:00	NQ	Futures	2638.75	2644.53	2638.17	2644.24	6725.0
2011-12-27 12:00:00	NQ	Futures	2643.95	2648.28	2643.95	2646.84	5172.0
2011-12-27 13:00:00	NQ	Futures	2646.84	2652.04	2645.39	2651.46	4755.0
2011-12-27 14:00:00	NQ	Futures	2651.46	2652.9	2647.7	2651.46	5531.0
2011-12-27 15:00:00	NQ	Futures	2651.46	2651.46	2642.22	2643.95	9491.0
2011-12-27 16:00:00	NQ	Futures	2643.66	2645.68	2637.31	2637.88	4463.0
2011-12-27 17:00:00	NQ	Futures	2638.17	2639.33	2638.17	2638.75	17.0
2011-12-27 18:00:00	NQ	Futures	2638.75	2638.75	2635.57	2636.73	155.0
2011-12-27 19:00:00	NQ	Futures	2636.44	2638.17	2635.57	2637.31	215.0
2011-12-27 20:00:00	NQ	Futures	2637.6	2641.35	2637.02	2641.35	254.0
2011-12-27 21:00:00	NQ	Futures	2641.35	2641.35	2639.62	2640.19	100.0
2011-12-27 22:00:00	NQ	Futures	2640.19	2640.48	2637.31	2637.31	97.0
2011-12-27 23:00:00	NQ	Futures	2637.31	2637.31	2633.84	2633.84	100.0
2011-12-27 06:00:00	YM	Futures	12126.5	12135.5	12102.8	12108.7	838.0
2011-12-27 07:00:00	YM	Futures	12107.7	12107.7	12082.9	12091.9	679.0
2011-12-27 08:00:00	YM	Futures	12092.8	12109.7	12079.0	12090.9	803.0
2011-12-27 09:00:00	YM	Futures	12090.9	12144.4	12080.9	12143.4	8037.0
2011-12-27 10:00:00	YM	Futures	12145.4	12151.3	12103.7	12109.7	7807.0
2011-12-27 11:00:00	YM	Futures	12109.7	12130.5	12104.7	12125.5	4027.0
2011-12-27 12:00:00	YM	Futures	12125.5	12138.4	12125.5	12127.5	2253.0
2011-12-27 13:00:00	YM	Futures	12126.5	12145.4	12122.6	12141.4	2525.0
2011-12-27 14:00:00	YM	Futures	12141.4	12145.4	12124.6	12138.4	2858.0
2011-12-27 15:00:00	YM	Futures	12138.4	12144.4	12112.7	12116.6	4155.0
2011-12-27 16:00:00	YM	Futures	12117.6	12127.5	12099.8	12109.7	1263.0
2011-12-27 17:00:00	YM	Futures	12103.7	12104.7	12100.8	12101.8	21.0
2011-12-27 18:00:00	YM	Futures	12106.7	12109.7	12090.9	12094.8	704.0
2011-12-27 19:00:00	YM	Futures	12094.8	12113.7	12093.8	12108.7	678.0

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

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