PREVIEW / futures_1hour / 2010-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-07-04.parquet
  size:    11 KB
  rows:    177

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
2010-07-04 18:00:00	ES	Futures	996.24	997.71	995.01	996.0	3670.0
2010-07-04 19:00:00	ES	Futures	995.5	996.98	994.28	996.24	3016.0
2010-07-04 20:00:00	ES	Futures	996.24	998.69	996.24	996.73	6803.0
2010-07-04 21:00:00	ES	Futures	996.73	998.45	996.0	996.98	5030.0
2010-07-04 22:00:00	ES	Futures	996.49	999.43	996.0	998.2	6404.0
2010-07-04 23:00:00	ES	Futures	997.96	998.94	996.49	996.73	5141.0
2010-07-04 18:00:00	NQ	Futures	1973.87	1975.01	1970.14	1973.58	226.0
2010-07-04 19:00:00	NQ	Futures	1972.72	1975.59	1971.0	1973.87	188.0
2010-07-04 20:00:00	NQ	Futures	1974.15	1978.74	1974.15	1975.3	463.0
2010-07-04 21:00:00	NQ	Futures	1975.59	1977.88	1973.87	1975.3	244.0
2010-07-04 22:00:00	NQ	Futures	1975.01	1980.46	1973.58	1978.45	374.0
2010-07-04 23:00:00	NQ	Futures	1978.17	1978.45	1975.01	1975.01	220.0
2010-07-04 18:00:00	YM	Futures	9081.7	9126.2	9079.8	9085.5	114.0
2010-07-04 19:00:00	YM	Futures	9083.6	9086.5	9074.2	9078.9	810.0
2010-07-04 20:00:00	YM	Futures	9079.8	9101.6	9079.8	9087.4	676.0
2010-07-04 21:00:00	YM	Futures	9088.4	9100.7	9085.5	9089.3	390.0
2010-07-04 22:00:00	YM	Futures	9092.2	9104.5	9082.7	9095.0	397.0
2010-07-04 23:00:00	YM	Futures	9096.9	9100.7	9087.4	9088.4	217.0
2010-07-04 18:00:00	CL	Futures	139.11	140.1	139.11	140.0	429.0
2010-07-04 19:00:00	CL	Futures	140.0	140.0	139.48	139.86	308.0
2010-07-04 20:00:00	CL	Futures	139.94	140.1	139.69	139.9	208.0
2010-07-04 21:00:00	CL	Futures	139.98	140.13	139.77	140.04	321.0
2010-07-04 22:00:00	CL	Futures	140.04	140.35	139.88	139.98	571.0
2010-07-04 23:00:00	CL	Futures	139.98	140.1	139.88	140.0	156.0
2010-07-04 18:00:00	GC	Futures	1701.3	1705.2	1700.1	1700.8	435.0
2010-07-04 19:00:00	GC	Futures	1700.6	1703.8	1700.5	1702.7	176.0
2010-07-04 20:00:00	GC	Futures	1702.6	1702.6	1700.3	1701.7	517.0
2010-07-04 21:00:00	GC	Futures	1701.6	1703.3	1698.9	1702.9	609.0
2010-07-04 22:00:00	GC	Futures	1702.2	1704.4	1702.0	1704.1	573.0
2010-07-04 23:00:00	GC	Futures	1704.3	1705.4	1703.6	1704.3	634.0
2010-07-04 18:00:00	ZN	Futures	101.260905	101.286767	101.247974	101.273836	347.0
2010-07-04 19:00:00	ZN	Futures	101.273836	101.33849	101.273836	101.286767	1144.0
2010-07-04 20:00:00	ZN	Futures	101.273836	101.273836	101.209182	101.260905	1319.0
2010-07-04 21:00:00	ZN	Futures	101.260905	101.299698	101.235044	101.286767	2153.0
2010-07-04 22:00:00	ZN	Futures	101.273836	101.286767	101.247974	101.247974	554.0
2010-07-04 23:00:00	ZN	Futures	101.260905	101.325559	101.260905	101.312628	680.0

> showing 36 of 177 rows — these rows as CSV

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