PREVIEW / futures_1hour / 2008-09-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	1170.94	1171.42	1169.29	1170.71	1869.0
2008-09-22 01:00:00	ES	Futures	1170.71	1173.31	1170.23	1171.18	2772.0
2008-09-22 02:00:00	ES	Futures	1171.18	1174.73	1170.0	1174.49	11641.0
2008-09-22 03:00:00	ES	Futures	1174.26	1174.49	1169.05	1172.84	28033.0
2008-09-22 04:00:00	ES	Futures	1172.84	1175.68	1169.76	1175.2	18271.0
2008-09-22 05:00:00	ES	Futures	1175.44	1177.57	1170.0	1172.84	23243.0
2008-09-22 06:00:00	ES	Futures	1172.6	1174.73	1169.05	1173.31	20163.0
2008-09-22 07:00:00	ES	Futures	1173.31	1173.78	1169.76	1172.6	20355.0
2008-09-22 08:00:00	ES	Futures	1172.36	1181.35	1170.71	1176.62	79357.0
2008-09-22 09:00:00	ES	Futures	1176.39	1183.48	1170.47	1173.07	310064.0
2008-09-22 10:00:00	ES	Futures	1173.07	1174.97	1166.45	1172.6	385556.0
2008-09-22 11:00:00	ES	Futures	1172.6	1173.07	1160.29	1164.08	327161.0
2008-09-22 12:00:00	ES	Futures	1163.84	1169.05	1161.0	1167.87	168610.0
2008-09-22 13:00:00	ES	Futures	1167.63	1168.58	1156.74	1163.61	287063.0
2008-09-22 14:00:00	ES	Futures	1163.61	1166.45	1156.03	1157.45	292677.0
2008-09-22 15:00:00	ES	Futures	1157.45	1160.77	1140.89	1143.73	565450.0
2008-09-22 16:00:00	ES	Futures	1143.73	1150.59	1143.25	1150.35	118498.0
2008-09-22 17:00:00	ES	Futures	1150.35	1152.01	1149.17	1151.06	3661.0
2008-09-22 18:00:00	ES	Futures	1151.06	1151.54	1149.64	1150.83	4754.0
2008-09-22 19:00:00	ES	Futures	1151.06	1151.54	1149.64	1150.59	1619.0
2008-09-22 20:00:00	ES	Futures	1150.59	1151.77	1150.12	1151.54	2798.0
2008-09-22 21:00:00	ES	Futures	1151.3	1151.77	1150.35	1151.3	2377.0
2008-09-22 22:00:00	ES	Futures	1151.54	1152.72	1151.3	1152.48	4841.0
2008-09-22 23:00:00	ES	Futures	1152.72	1153.67	1152.01	1153.19	2009.0
2008-09-22 00:00:00	NQ	Futures	1954.15	1955.56	1953.58	1954.71	197.0
2008-09-22 01:00:00	NQ	Futures	1954.43	1958.11	1953.58	1955.56	198.0
2008-09-22 02:00:00	NQ	Futures	1955.56	1963.2	1953.58	1962.92	633.0
2008-09-22 03:00:00	NQ	Futures	1962.63	1963.48	1954.71	1961.5	1369.0
2008-09-22 04:00:00	NQ	Futures	1961.79	1967.16	1957.82	1966.03	825.0
2008-09-22 05:00:00	NQ	Futures	1966.03	1968.58	1959.24	1963.48	707.0
2008-09-22 06:00:00	NQ	Futures	1964.05	1967.16	1956.69	1962.35	788.0
2008-09-22 07:00:00	NQ	Futures	1961.79	1963.48	1956.69	1956.97	1850.0
2008-09-22 08:00:00	NQ	Futures	1956.97	1975.65	1954.99	1975.65	10227.0
2008-09-22 09:00:00	NQ	Futures	1975.37	1983.01	1957.26	1961.79	50358.0
2008-09-22 10:00:00	NQ	Futures	1961.79	1965.46	1951.88	1963.2	52878.0
2008-09-22 11:00:00	NQ	Futures	1963.2	1963.77	1934.34	1939.15	49250.0
2008-09-22 12:00:00	NQ	Futures	1939.15	1945.37	1936.04	1940.85	27712.0
2008-09-22 13:00:00	NQ	Futures	1940.85	1942.26	1923.3	1932.64	38415.0
2008-09-22 14:00:00	NQ	Futures	1932.64	1939.43	1918.77	1920.76	49988.0
2008-09-22 15:00:00	NQ	Futures	1920.76	1924.15	1884.25	1885.1	83040.0
2008-09-22 16:00:00	NQ	Futures	1885.38	1893.02	1882.56	1892.18	19299.0
2008-09-22 17:00:00	NQ	Futures	1893.02	1895.01	1892.46	1895.01	374.0
2008-09-22 18:00:00	NQ	Futures	1894.72	1895.85	1891.89	1894.16	373.0
2008-09-22 19:00:00	NQ	Futures	1894.72	1895.29	1893.02	1894.16	156.0
2008-09-22 20:00:00	NQ	Futures	1893.31	1897.84	1893.31	1897.84	686.0
2008-09-22 21:00:00	NQ	Futures	1897.84	1897.84	1896.42	1897.84	917.0
2008-09-22 22:00:00	NQ	Futures	1897.84	1899.82	1897.27	1899.82	143.0
2008-09-22 23:00:00	NQ	Futures	1899.53	1900.38	1898.68	1900.38	132.0
2008-09-22 00:00:00	YM	Futures	10239.4	10243.0	10225.7	10238.5	101.0
2008-09-22 01:00:00	YM	Futures	10241.2	10264.8	10237.5	10253.0	268.0

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

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