PREVIEW / futures_1hour / 2011-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-03-27.parquet
  size:    14 KB
  rows:    271

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-03-27 18:00:00	ES	Futures	1301.03	1304.26	1300.04	1300.53	14664.0
2011-03-27 19:00:00	ES	Futures	1300.53	1303.27	1299.04	1302.77	7611.0
2011-03-27 20:00:00	ES	Futures	1303.02	1303.76	1302.27	1303.52	4963.0
2011-03-27 21:00:00	ES	Futures	1303.52	1305.01	1302.77	1304.51	4224.0
2011-03-27 22:00:00	ES	Futures	1304.51	1304.76	1302.02	1302.27	3752.0
2011-03-27 23:00:00	ES	Futures	1302.27	1303.02	1300.04	1300.53	4128.0
2011-03-27 18:00:00	NQ	Futures	2661.97	2668.87	2659.1	2663.12	1734.0
2011-03-27 19:00:00	NQ	Futures	2662.83	2668.29	2659.96	2667.72	764.0
2011-03-27 20:00:00	NQ	Futures	2667.72	2669.15	2666.28	2669.15	302.0
2011-03-27 21:00:00	NQ	Futures	2668.87	2672.03	2667.14	2671.17	371.0
2011-03-27 22:00:00	NQ	Futures	2671.17	2671.17	2665.13	2665.13	322.0
2011-03-27 23:00:00	NQ	Futures	2665.71	2667.43	2662.55	2663.41	406.0
2011-03-27 18:00:00	YM	Futures	11722.0	11739.3	11710.4	11712.4	375.0
2011-03-27 19:00:00	YM	Futures	11711.4	11732.6	11702.7	11730.7	186.0
2011-03-27 20:00:00	YM	Futures	11730.7	11737.4	11724.9	11737.4	189.0
2011-03-27 21:00:00	YM	Futures	11737.4	11745.1	11731.6	11742.2	297.0
2011-03-27 22:00:00	YM	Futures	11742.2	11746.1	11724.9	11725.8	303.0
2011-03-27 23:00:00	YM	Futures	11725.8	11731.6	11710.4	11713.3	212.0
2011-03-27 18:00:00	CL	Futures	183.96	184.53	183.21	183.85	3114.0
2011-03-27 19:00:00	CL	Futures	183.8	184.03	183.68	183.91	402.0
2011-03-27 20:00:00	CL	Futures	183.89	184.08	183.78	183.94	368.0
2011-03-27 21:00:00	CL	Futures	183.91	184.26	183.87	184.01	293.0
2011-03-27 22:00:00	CL	Futures	184.03	184.05	183.68	183.82	611.0
2011-03-27 23:00:00	CL	Futures	183.82	183.91	183.28	183.35	816.0
2011-03-27 18:00:00	GC	Futures	1995.9	2000.5	1990.1	1991.6	950.0
2011-03-27 19:00:00	GC	Futures	1990.8	1993.8	1990.8	1993.1	710.0
2011-03-27 20:00:00	GC	Futures	1991.9	1993.0	1990.6	1992.0	206.0
2011-03-27 21:00:00	GC	Futures	1991.9	1995.8	1991.9	1995.4	170.0
2011-03-27 22:00:00	GC	Futures	1995.2	1995.2	1992.9	1993.4	274.0
2011-03-27 23:00:00	GC	Futures	1993.4	1994.0	1992.3	1992.3	324.0
2011-03-27 18:00:00	ZN	Futures	101.423983	101.45059	101.264344	101.33086	9232.0
2011-03-27 19:00:00	ZN	Futures	101.33086	101.37077	101.264344	101.344164	5836.0
2011-03-27 20:00:00	ZN	Futures	101.344164	101.397377	101.317557	101.37077	6619.0
2011-03-27 21:00:00	ZN	Futures	101.37077	101.397377	101.344164	101.37077	4335.0
2011-03-27 22:00:00	ZN	Futures	101.357467	101.423983	101.357467	101.41068	3333.0
2011-03-27 23:00:00	ZN	Futures	101.397377	101.41068	101.357467	101.37077	4382.0

> showing 36 of 271 rows — these rows as CSV

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