PREVIEW / futures_1hour / 2008-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-11.parquet
  size:    43 KB
  rows:    1,220

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-11 00:00:00	ES	Futures	1142.09	1143.25	1140.93	1141.16	1801.0
2008-09-11 01:00:00	ES	Futures	1141.16	1142.55	1140.93	1141.16	2278.0
2008-09-11 02:00:00	ES	Futures	1140.93	1141.16	1138.6	1139.07	7521.0
2008-09-11 03:00:00	ES	Futures	1139.07	1142.09	1137.44	1138.6	16634.0
2008-09-11 04:00:00	ES	Futures	1138.6	1140.93	1137.21	1138.14	9635.0
2008-09-11 05:00:00	ES	Futures	1137.91	1139.3	1133.02	1134.42	25004.0
2008-09-11 06:00:00	ES	Futures	1134.42	1137.91	1131.63	1136.98	22258.0
2008-09-11 07:00:00	ES	Futures	1137.21	1137.67	1129.54	1131.86	47392.0
2008-09-11 08:00:00	ES	Futures	1132.1	1133.72	1126.75	1129.07	78897.0
2008-09-11 09:00:00	ES	Futures	1129.31	1132.79	1126.05	1128.14	232468.0
2008-09-11 10:00:00	ES	Futures	1128.38	1141.39	1128.14	1139.76	292264.0
2008-09-11 11:00:00	ES	Futures	1139.76	1146.97	1136.28	1146.27	195469.0
2008-09-11 12:00:00	ES	Futures	1146.04	1150.46	1140.23	1142.79	161186.0
2008-09-11 13:00:00	ES	Futures	1142.55	1147.67	1136.05	1145.58	107811.0
2008-09-11 14:00:00	ES	Futures	1145.58	1154.41	1144.41	1149.99	159189.0
2008-09-11 15:00:00	ES	Futures	1149.99	1163.01	1143.48	1163.01	249080.0
2008-09-11 16:00:00	ES	Futures	1162.77	1165.56	1160.45	1165.1	68563.0
2008-09-11 17:00:00	ES	Futures	1165.1	1165.1	1162.54	1162.54	4171.0
2008-09-11 18:00:00	ES	Futures	1162.31	1164.87	1161.38	1162.08	5473.0
2008-09-11 19:00:00	ES	Futures	1162.31	1163.24	1160.91	1161.15	1925.0
2008-09-11 20:00:00	ES	Futures	1161.15	1161.61	1159.29	1160.45	4043.0
2008-09-11 21:00:00	ES	Futures	1160.68	1161.61	1159.52	1160.68	1798.0
2008-09-11 22:00:00	ES	Futures	1160.68	1160.68	1159.06	1159.52	2190.0
2008-09-11 23:00:00	ES	Futures	1159.52	1160.45	1159.29	1159.52	1951.0
2008-09-11 00:00:00	NQ	Futures	1945.96	1947.08	1943.99	1945.11	84.0
2008-09-11 01:00:00	NQ	Futures	1944.55	1946.8	1943.99	1943.99	191.0
2008-09-11 02:00:00	NQ	Futures	1943.99	1945.11	1939.77	1941.46	778.0
2008-09-11 03:00:00	NQ	Futures	1940.89	1946.24	1937.8	1940.89	1208.0
2008-09-11 04:00:00	NQ	Futures	1941.17	1943.99	1936.95	1940.05	949.0
2008-09-11 05:00:00	NQ	Futures	1939.77	1942.02	1929.36	1931.89	2740.0
2008-09-11 06:00:00	NQ	Futures	1931.89	1937.24	1928.23	1935.55	1665.0
2008-09-11 07:00:00	NQ	Futures	1935.55	1937.24	1927.95	1930.2	3987.0
2008-09-11 08:00:00	NQ	Futures	1930.48	1933.3	1918.67	1925.42	9601.0
2008-09-11 09:00:00	NQ	Futures	1925.14	1939.49	1925.14	1936.39	37924.0
2008-09-11 10:00:00	NQ	Futures	1936.11	1963.4	1935.55	1961.71	61491.0
2008-09-11 11:00:00	NQ	Futures	1961.71	1975.21	1952.99	1975.21	39494.0
2008-09-11 12:00:00	NQ	Futures	1975.49	1982.52	1964.52	1970.71	27007.0
2008-09-11 13:00:00	NQ	Futures	1970.71	1974.65	1956.36	1971.27	20727.0
2008-09-11 14:00:00	NQ	Futures	1971.27	1982.52	1969.3	1975.21	21832.0
2008-09-11 15:00:00	NQ	Futures	1975.77	1998.84	1970.43	1997.15	33333.0
2008-09-11 16:00:00	NQ	Futures	1996.87	2002.78	1994.9	2002.78	8610.0
2008-09-11 17:00:00	NQ	Futures	2002.78	2002.78	1998.84	1999.68	93.0
2008-09-11 18:00:00	NQ	Futures	1999.68	2001.09	1995.18	1998.28	188.0
2008-09-11 19:00:00	NQ	Futures	1997.99	1999.68	1996.87	1996.87	132.0
2008-09-11 20:00:00	NQ	Futures	1995.74	1997.99	1993.77	1993.77	36.0
2008-09-11 21:00:00	NQ	Futures	1994.9	1994.9	1991.52	1993.77	119.0
2008-09-11 22:00:00	NQ	Futures	1994.34	1994.34	1991.24	1993.49	67.0
2008-09-11 23:00:00	NQ	Futures	1993.21	1994.06	1991.52	1992.37	57.0
2008-09-11 00:00:00	YM	Futures	10230.3	10234.8	10216.6	10220.3	10.0
2008-09-11 01:00:00	YM	Futures	10224.8	10230.3	10218.4	10218.4	3.0

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

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