PREVIEW / futures_1hour / 2008-09-14

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-14.parquet
  size:    15 KB
  rows:    268

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
2008-09-14 18:00:00	ES	Futures	1169.05	1169.05	1150.59	1153.67	88263.0
2008-09-14 19:00:00	ES	Futures	1153.43	1167.16	1152.48	1161.24	40637.0
2008-09-14 20:00:00	ES	Futures	1161.48	1165.5	1155.32	1164.32	24913.0
2008-09-14 21:00:00	ES	Futures	1164.55	1164.79	1154.38	1155.32	28483.0
2008-09-14 22:00:00	ES	Futures	1155.09	1158.64	1150.12	1150.83	17359.0
2008-09-14 23:00:00	ES	Futures	1151.06	1152.48	1146.09	1147.75	15585.0
2008-09-14 18:00:00	NQ	Futures	1996.31	1996.31	1954.15	1961.79	2868.0
2008-09-14 19:00:00	NQ	Futures	1961.79	1980.46	1961.5	1968.58	1805.0
2008-09-14 20:00:00	NQ	Futures	1969.71	1974.8	1963.77	1974.52	977.0
2008-09-14 21:00:00	NQ	Futures	1972.82	1972.82	1962.63	1964.33	1042.0
2008-09-14 22:00:00	NQ	Futures	1964.33	1969.43	1959.24	1959.24	809.0
2008-09-14 23:00:00	NQ	Futures	1959.24	1962.35	1954.71	1956.97	1150.0
2008-09-14 18:00:00	YM	Futures	10249.4	10263.9	10114.8	10135.7	1977.0
2008-09-14 19:00:00	YM	Futures	10134.8	10239.4	10128.4	10175.7	1335.0
2008-09-14 20:00:00	YM	Futures	10174.8	10209.3	10124.8	10202.1	1030.0
2008-09-14 21:00:00	YM	Futures	10203.9	10203.9	10132.0	10146.6	1151.0
2008-09-14 22:00:00	YM	Futures	10147.5	10172.1	10118.4	10120.2	863.0
2008-09-14 23:00:00	YM	Futures	10122.0	10132.9	10090.2	10108.4	1165.0
2008-09-14 10:00:00	CL	Futures	382.06	382.06	375.35	376.41	474.0
2008-09-14 11:00:00	CL	Futures	376.75	376.75	374.63	375.09	151.0
2008-09-14 12:00:00	CL	Futures	375.2	375.24	372.56	374.52	260.0
2008-09-14 13:00:00	CL	Futures	374.11	374.86	373.24	373.24	143.0
2008-09-14 14:00:00	CL	Futures	374.07	374.86	374.07	374.52	249.0
2008-09-14 15:00:00	CL	Futures	374.3	375.28	372.52	372.6	58.0
2008-09-14 16:00:00	CL	Futures	373.88	375.2	373.88	374.82	61.0
2008-09-14 17:00:00	CL	Futures	374.75	375.09	373.31	374.14	168.0
2008-09-14 18:00:00	CL	Futures	373.54	377.84	373.39	377.84	288.0
2008-09-14 19:00:00	CL	Futures	377.61	377.61	376.11	377.01	188.0
2008-09-14 20:00:00	CL	Futures	377.54	378.18	377.05	377.54	186.0
2008-09-14 21:00:00	CL	Futures	377.39	377.65	376.6	377.12	219.0
2008-09-14 22:00:00	CL	Futures	377.12	377.16	376.29	376.29	373.0
2008-09-14 23:00:00	CL	Futures	376.41	376.41	374.52	374.97	257.0
2008-09-14 18:00:00	GC	Futures	1103.5	1118.5	1103.5	1117.2	3555.0
2008-09-14 19:00:00	GC	Futures	1117.5	1119.4	1113.2	1115.7	2755.0
2008-09-14 20:00:00	GC	Futures	1116.2	1125.5	1114.9	1122.2	2873.0
2008-09-14 21:00:00	GC	Futures	1122.4	1126.8	1121.1	1121.4	2191.0
2008-09-14 22:00:00	GC	Futures	1121.8	1126.2	1118.9	1121.7	1951.0
2008-09-14 23:00:00	GC	Futures	1121.4	1125.4	1120.9	1122.2	1204.0
2008-09-14 18:00:00	ZN	Futures	88.687041	89.005974	88.616167	88.923288	29459.0
2008-09-14 19:00:00	ZN	Futures	88.911475	88.923288	88.356296	88.651604	24590.0
2008-09-14 20:00:00	ZN	Futures	88.651604	88.840601	88.592542	88.675229	14946.0
2008-09-14 21:00:00	ZN	Futures	88.663416	88.805164	88.651604	88.793352	7320.0
2008-09-14 22:00:00	ZN	Futures	88.805164	89.088661	88.78154	89.076848	13582.0
2008-09-14 23:00:00	ZN	Futures	89.076848	89.183159	89.017787	89.13591	9407.0

> showing 44 of 268 rows — these rows as CSV

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