PREVIEW / futures_1hour / 2009-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-30.parquet
  size:    44 KB
  rows:    1,294

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
2009-09-30 00:00:00	ES	Futures	1023.39	1023.63	1021.93	1023.14	2227.0
2009-09-30 01:00:00	ES	Futures	1023.39	1024.11	1022.9	1023.63	1969.0
2009-09-30 02:00:00	ES	Futures	1023.87	1024.36	1022.66	1024.36	6129.0
2009-09-30 03:00:00	ES	Futures	1024.36	1025.08	1023.63	1024.11	13941.0
2009-09-30 04:00:00	ES	Futures	1024.11	1027.5	1024.11	1027.26	19079.0
2009-09-30 05:00:00	ES	Futures	1027.26	1027.99	1026.29	1027.02	13789.0
2009-09-30 06:00:00	ES	Futures	1026.78	1027.26	1025.81	1025.81	6485.0
2009-09-30 07:00:00	ES	Futures	1026.05	1027.02	1024.84	1026.29	14308.0
2009-09-30 08:00:00	ES	Futures	1026.29	1030.17	1023.39	1026.29	87133.0
2009-09-30 09:00:00	ES	Futures	1026.54	1027.02	1009.1	1010.79	462855.0
2009-09-30 10:00:00	ES	Futures	1010.79	1012.73	1009.58	1011.76	412925.0
2009-09-30 11:00:00	ES	Futures	1012.0	1017.09	1011.52	1015.88	210420.0
2009-09-30 12:00:00	ES	Futures	1015.88	1022.9	1014.91	1021.93	278083.0
2009-09-30 13:00:00	ES	Futures	1021.69	1026.29	1021.69	1022.9	290470.0
2009-09-30 14:00:00	ES	Futures	1022.9	1025.08	1019.75	1020.0	180073.0
2009-09-30 15:00:00	ES	Futures	1020.0	1021.69	1014.42	1018.54	649825.0
2009-09-30 16:00:00	ES	Futures	1018.54	1021.45	1017.57	1019.51	197663.0
2009-09-30 17:00:00	ES	Futures	1019.51	1019.75	1018.78	1019.51	2990.0
2009-09-30 18:00:00	ES	Futures	1019.27	1020.96	1018.78	1020.96	5404.0
2009-09-30 19:00:00	ES	Futures	1020.96	1021.69	1020.24	1021.21	3151.0
2009-09-30 20:00:00	ES	Futures	1021.21	1023.14	1020.72	1021.45	6649.0
2009-09-30 21:00:00	ES	Futures	1021.69	1021.69	1017.82	1017.82	7551.0
2009-09-30 22:00:00	ES	Futures	1017.82	1019.27	1017.57	1018.06	5159.0
2009-09-30 23:00:00	ES	Futures	1018.06	1018.54	1017.57	1018.3	2481.0
2009-09-30 00:00:00	NQ	Futures	1959.0	1959.85	1956.43	1958.71	269.0
2009-09-30 01:00:00	NQ	Futures	1958.43	1959.28	1957.29	1959.28	265.0
2009-09-30 02:00:00	NQ	Futures	1958.71	1959.85	1956.72	1959.57	389.0
2009-09-30 03:00:00	NQ	Futures	1959.28	1961.0	1958.43	1959.57	1222.0
2009-09-30 04:00:00	NQ	Futures	1959.85	1964.42	1959.57	1964.13	1342.0
2009-09-30 05:00:00	NQ	Futures	1964.13	1965.84	1963.28	1964.42	985.0
2009-09-30 06:00:00	NQ	Futures	1964.13	1965.56	1963.56	1963.85	1377.0
2009-09-30 07:00:00	NQ	Futures	1963.85	1966.13	1962.42	1964.42	1452.0
2009-09-30 08:00:00	NQ	Futures	1964.13	1969.27	1956.72	1965.56	7492.0
2009-09-30 09:00:00	NQ	Futures	1965.56	1968.41	1926.49	1933.33	74379.0
2009-09-30 10:00:00	NQ	Futures	1933.33	1939.04	1930.19	1936.18	62452.0
2009-09-30 11:00:00	NQ	Futures	1936.18	1951.01	1935.33	1948.73	31249.0
2009-09-30 12:00:00	NQ	Futures	1948.73	1968.41	1946.16	1965.27	60551.0
2009-09-30 13:00:00	NQ	Futures	1965.27	1973.54	1962.42	1965.27	46563.0
2009-09-30 14:00:00	NQ	Futures	1965.27	1967.55	1957.57	1957.57	29642.0
2009-09-30 15:00:00	NQ	Futures	1957.57	1961.85	1948.45	1956.43	85963.0
2009-09-30 16:00:00	NQ	Futures	1956.72	1959.57	1952.15	1955.01	21911.0
2009-09-30 17:00:00	NQ	Futures	1955.29	1955.58	1953.87	1955.29	321.0
2009-09-30 18:00:00	NQ	Futures	1955.58	1959.28	1953.87	1959.28	2132.0
2009-09-30 19:00:00	NQ	Futures	1959.0	1959.85	1958.43	1959.85	458.0
2009-09-30 20:00:00	NQ	Futures	1960.14	1969.84	1958.71	1960.42	1480.0
2009-09-30 21:00:00	NQ	Futures	1960.42	1960.42	1953.58	1953.58	898.0
2009-09-30 22:00:00	NQ	Futures	1953.29	1956.15	1953.01	1954.15	367.0
2009-09-30 23:00:00	NQ	Futures	1954.15	1955.58	1953.01	1955.29	229.0
2009-09-30 00:00:00	YM	Futures	9007.9	9008.8	8997.7	9006.0	225.0
2009-09-30 01:00:00	YM	Futures	9006.0	9013.5	9003.3	9011.6	179.0

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

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