PREVIEW / futures_1hour / 2008-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-09.parquet
  size:    45 KB
  rows:    1,229

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-09 00:00:00	ES	Futures	1174.16	1174.63	1173.7	1173.93	1283.0
2008-09-09 01:00:00	ES	Futures	1174.16	1174.16	1173.0	1173.93	3258.0
2008-09-09 02:00:00	ES	Futures	1173.7	1177.65	1172.77	1176.25	7092.0
2008-09-09 03:00:00	ES	Futures	1176.25	1179.74	1173.93	1178.58	19680.0
2008-09-09 04:00:00	ES	Futures	1178.81	1182.53	1178.58	1181.83	20865.0
2008-09-09 05:00:00	ES	Futures	1181.83	1183.46	1180.44	1181.13	11843.0
2008-09-09 06:00:00	ES	Futures	1180.67	1183.92	1180.67	1181.37	14475.0
2008-09-09 07:00:00	ES	Futures	1181.37	1185.32	1181.13	1184.16	20111.0
2008-09-09 08:00:00	ES	Futures	1184.16	1184.39	1177.42	1177.65	53241.0
2008-09-09 09:00:00	ES	Futures	1177.65	1179.74	1169.98	1179.28	381385.0
2008-09-09 10:00:00	ES	Futures	1179.28	1180.21	1160.45	1161.84	561886.0
2008-09-09 11:00:00	ES	Futures	1161.84	1166.26	1157.89	1161.15	344030.0
2008-09-09 12:00:00	ES	Futures	1161.38	1165.8	1158.82	1162.54	222852.0
2008-09-09 13:00:00	ES	Futures	1162.54	1166.26	1154.64	1155.8	334114.0
2008-09-09 14:00:00	ES	Futures	1155.8	1157.2	1147.9	1148.83	424516.0
2008-09-09 15:00:00	ES	Futures	1148.83	1151.62	1138.37	1138.84	594166.0
2008-09-09 16:00:00	ES	Futures	1138.84	1143.02	1137.44	1139.07	208200.0
2008-09-09 17:00:00	ES	Futures	1139.3	1141.86	1138.84	1140.46	4946.0
2008-09-09 18:00:00	ES	Futures	1140.0	1143.25	1140.0	1143.02	5608.0
2008-09-09 19:00:00	ES	Futures	1143.02	1143.95	1141.39	1142.09	5829.0
2008-09-09 20:00:00	ES	Futures	1142.32	1143.25	1141.39	1143.02	3823.0
2008-09-09 21:00:00	ES	Futures	1143.25	1144.65	1143.02	1144.41	5376.0
2008-09-09 22:00:00	ES	Futures	1144.65	1145.11	1143.95	1144.88	2381.0
2008-09-09 23:00:00	ES	Futures	1144.88	1145.11	1144.18	1144.88	1721.0
2008-09-09 00:00:00	NQ	Futures	1972.68	1973.8	1972.12	1972.96	136.0
2008-09-09 01:00:00	NQ	Futures	1972.4	1972.96	1970.15	1972.68	257.0
2008-09-09 02:00:00	NQ	Futures	1972.96	1979.15	1970.99	1976.34	853.0
2008-09-09 03:00:00	NQ	Futures	1976.62	1982.52	1972.12	1981.68	1295.0
2008-09-09 04:00:00	NQ	Futures	1981.68	1990.68	1981.68	1989.84	2967.0
2008-09-09 05:00:00	NQ	Futures	1990.12	1993.77	1990.12	1992.65	1703.0
2008-09-09 06:00:00	NQ	Futures	1992.65	1997.15	1992.65	1994.06	2273.0
2008-09-09 07:00:00	NQ	Futures	1993.77	1999.12	1993.21	1995.46	2291.0
2008-09-09 08:00:00	NQ	Futures	1994.9	1995.46	1984.49	1984.49	5510.0
2008-09-09 09:00:00	NQ	Futures	1984.49	2003.06	1980.84	1999.4	67145.0
2008-09-09 10:00:00	NQ	Futures	2000.24	2000.81	1973.8	1978.02	78718.0
2008-09-09 11:00:00	NQ	Futures	1978.02	1982.8	1967.62	1974.37	47045.0
2008-09-09 12:00:00	NQ	Futures	1974.37	1979.99	1965.65	1974.65	43766.0
2008-09-09 13:00:00	NQ	Futures	1974.93	1986.46	1958.33	1960.58	64057.0
2008-09-09 14:00:00	NQ	Futures	1960.3	1963.4	1948.21	1951.02	61365.0
2008-09-09 15:00:00	NQ	Futures	1951.3	1956.08	1937.52	1938.08	77814.0
2008-09-09 16:00:00	NQ	Futures	1938.08	1952.99	1936.11	1946.24	26101.0
2008-09-09 17:00:00	NQ	Futures	1947.36	1951.58	1946.52	1949.05	632.0
2008-09-09 18:00:00	NQ	Futures	1948.77	1953.83	1948.77	1953.27	689.0
2008-09-09 19:00:00	NQ	Futures	1953.27	1954.68	1951.3	1951.58	292.0
2008-09-09 20:00:00	NQ	Futures	1951.58	1952.99	1951.02	1952.43	258.0
2008-09-09 21:00:00	NQ	Futures	1952.43	1955.52	1952.43	1955.52	453.0
2008-09-09 22:00:00	NQ	Futures	1955.52	1956.36	1954.11	1955.52	270.0
2008-09-09 23:00:00	NQ	Futures	1956.08	1956.08	1954.96	1955.24	50.0
2008-09-09 00:00:00	YM	Futures	10418.4	10423.9	10413.9	10416.6	179.0
2008-09-09 01:00:00	YM	Futures	10416.6	10417.5	10410.2	10414.8	167.0

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

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