PREVIEW / futures_1hour / 2011-02-27

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-02-27.parquet
  size:    14 KB
  rows:    270

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-02-27 18:00:00	ES	Futures	1304.68	1304.93	1300.72	1301.47	21663.0
2011-02-27 19:00:00	ES	Futures	1301.47	1302.21	1300.72	1301.47	6920.0
2011-02-27 20:00:00	ES	Futures	1301.47	1301.96	1299.49	1299.98	10969.0
2011-02-27 21:00:00	ES	Futures	1299.73	1301.22	1299.73	1300.97	4757.0
2011-02-27 22:00:00	ES	Futures	1300.97	1302.21	1300.48	1302.21	4045.0
2011-02-27 23:00:00	ES	Futures	1302.21	1302.7	1301.96	1302.7	3250.0
2011-02-27 18:00:00	NQ	Futures	2692.65	2694.09	2680.6	2687.77	1433.0
2011-02-27 19:00:00	NQ	Futures	2688.35	2688.92	2685.19	2685.76	356.0
2011-02-27 20:00:00	NQ	Futures	2686.34	2686.62	2682.89	2683.47	592.0
2011-02-27 21:00:00	NQ	Futures	2683.47	2687.2	2683.47	2685.48	358.0
2011-02-27 22:00:00	NQ	Futures	2685.19	2688.63	2684.9	2688.63	214.0
2011-02-27 23:00:00	NQ	Futures	2688.63	2688.92	2686.91	2687.77	235.0
2011-02-27 18:00:00	YM	Futures	11600.7	11602.6	11567.1	11571.9	791.0
2011-02-27 19:00:00	YM	Futures	11571.9	11576.7	11568.1	11573.8	154.0
2011-02-27 20:00:00	YM	Futures	11573.8	11573.8	11557.6	11561.4	319.0
2011-02-27 21:00:00	YM	Futures	11560.4	11571.9	11560.4	11569.1	210.0
2011-02-27 22:00:00	YM	Futures	11570.0	11577.7	11569.1	11576.7	168.0
2011-02-27 23:00:00	YM	Futures	11577.7	11581.5	11575.8	11579.6	142.0
2011-02-27 18:00:00	CL	Futures	173.99	175.84	173.76	175.77	6140.0
2011-02-27 19:00:00	CL	Futures	175.77	176.57	175.72	175.72	2713.0
2011-02-27 20:00:00	CL	Futures	175.74	176.16	175.53	175.93	1518.0
2011-02-27 21:00:00	CL	Futures	175.93	175.93	175.49	175.88	1141.0
2011-02-27 22:00:00	CL	Futures	175.86	176.29	175.74	175.88	1001.0
2011-02-27 23:00:00	CL	Futures	175.91	176.11	175.54	176.02	704.0
2011-02-27 18:00:00	GC	Futures	1969.8	1975.6	1966.1	1974.0	2931.0
2011-02-27 19:00:00	GC	Futures	1974.2	1976.0	1973.6	1975.7	1710.0
2011-02-27 20:00:00	GC	Futures	1975.7	1975.8	1972.3	1972.8	1070.0
2011-02-27 21:00:00	GC	Futures	1972.8	1974.2	1971.4	1973.6	892.0
2011-02-27 22:00:00	GC	Futures	1973.5	1974.9	1972.9	1974.2	759.0
2011-02-27 23:00:00	GC	Futures	1974.2	1974.4	1973.0	1973.0	1109.0
2011-02-27 18:00:00	ZN	Futures	101.154166	101.167307	101.101605	101.154166	3320.0
2011-02-27 19:00:00	ZN	Futures	101.154166	101.219868	101.127886	101.180447	2476.0
2011-02-27 20:00:00	ZN	Futures	101.193587	101.29871	101.193587	101.28557	5586.0
2011-02-27 21:00:00	ZN	Futures	101.28557	101.31185	101.233008	101.28557	3366.0
2011-02-27 22:00:00	ZN	Futures	101.28557	101.29871	101.259289	101.272429	807.0
2011-02-27 23:00:00	ZN	Futures	101.259289	101.272429	101.246149	101.259289	1855.0

> showing 36 of 270 rows — these rows as CSV

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