PREVIEW / futures_1hour / 2009-10-01

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-10-01.parquet
  size:    45 KB
  rows:    1,308

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-10-01 00:00:00	ES	Futures	1018.54	1019.03	1017.57	1018.3	2570.0
2009-10-01 01:00:00	ES	Futures	1018.3	1018.78	1017.82	1018.3	2652.0
2009-10-01 02:00:00	ES	Futures	1018.06	1019.75	1017.57	1019.03	6341.0
2009-10-01 03:00:00	ES	Futures	1019.03	1022.42	1017.57	1020.72	25661.0
2009-10-01 04:00:00	ES	Futures	1020.72	1020.96	1015.15	1016.12	26169.0
2009-10-01 05:00:00	ES	Futures	1015.88	1018.06	1014.91	1015.39	16632.0
2009-10-01 06:00:00	ES	Futures	1015.15	1016.36	1013.46	1014.18	18961.0
2009-10-01 07:00:00	ES	Futures	1014.18	1015.88	1013.7	1015.15	21184.0
2009-10-01 08:00:00	ES	Futures	1014.91	1017.82	1012.49	1016.85	80748.0
2009-10-01 09:00:00	ES	Futures	1016.85	1017.57	1010.06	1011.76	300118.0
2009-10-01 10:00:00	ES	Futures	1012.0	1014.91	1004.49	1006.43	552140.0
2009-10-01 11:00:00	ES	Futures	1006.19	1006.67	999.41	1001.34	388230.0
2009-10-01 12:00:00	ES	Futures	1001.34	1003.52	999.65	1001.59	151169.0
2009-10-01 13:00:00	ES	Futures	1001.59	1001.83	996.74	999.89	241983.0
2009-10-01 14:00:00	ES	Futures	999.65	1002.56	998.44	999.89	198772.0
2009-10-01 15:00:00	ES	Futures	1000.13	1000.62	992.62	993.11	488743.0
2009-10-01 16:00:00	ES	Futures	993.11	996.74	992.87	995.53	178880.0
2009-10-01 17:00:00	ES	Futures	995.53	995.77	994.32	994.56	3023.0
2009-10-01 18:00:00	ES	Futures	994.56	994.8	993.59	994.56	4302.0
2009-10-01 19:00:00	ES	Futures	994.56	994.56	993.35	993.35	3670.0
2009-10-01 20:00:00	ES	Futures	993.35	994.8	991.9	994.56	8950.0
2009-10-01 21:00:00	ES	Futures	994.32	994.8	993.35	994.56	4909.0
2009-10-01 22:00:00	ES	Futures	994.32	994.8	993.11	993.35	4002.0
2009-10-01 23:00:00	ES	Futures	993.35	993.59	992.38	993.11	2058.0
2009-10-01 00:00:00	NQ	Futures	1955.01	1956.72	1953.58	1954.44	145.0
2009-10-01 01:00:00	NQ	Futures	1954.72	1955.29	1952.44	1954.44	395.0
2009-10-01 02:00:00	NQ	Futures	1953.87	1955.58	1952.15	1954.44	872.0
2009-10-01 03:00:00	NQ	Futures	1955.29	1961.0	1953.01	1957.86	1895.0
2009-10-01 04:00:00	NQ	Futures	1958.14	1958.43	1948.16	1949.87	2052.0
2009-10-01 05:00:00	NQ	Futures	1949.59	1953.58	1948.16	1948.45	1226.0
2009-10-01 06:00:00	NQ	Futures	1948.73	1950.44	1946.16	1947.31	1239.0
2009-10-01 07:00:00	NQ	Futures	1947.02	1950.44	1946.45	1948.45	1818.0
2009-10-01 08:00:00	NQ	Futures	1948.73	1953.58	1942.17	1952.15	6414.0
2009-10-01 09:00:00	NQ	Futures	1952.15	1953.01	1939.61	1944.45	46512.0
2009-10-01 10:00:00	NQ	Futures	1944.45	1949.02	1922.49	1925.63	100541.0
2009-10-01 11:00:00	NQ	Futures	1925.63	1926.2	1906.52	1911.37	70161.0
2009-10-01 12:00:00	NQ	Futures	1911.37	1916.5	1908.52	1912.23	27457.0
2009-10-01 13:00:00	NQ	Futures	1912.23	1912.8	1903.67	1910.23	30598.0
2009-10-01 14:00:00	NQ	Futures	1910.52	1916.5	1907.95	1911.37	29294.0
2009-10-01 15:00:00	NQ	Futures	1911.66	1913.94	1898.82	1899.39	53968.0
2009-10-01 16:00:00	NQ	Futures	1899.39	1906.52	1897.97	1904.53	22016.0
2009-10-01 17:00:00	NQ	Futures	1904.81	1905.67	1903.1	1903.1	104.0
2009-10-01 18:00:00	NQ	Futures	1903.67	1903.96	1901.67	1902.53	285.0
2009-10-01 19:00:00	NQ	Futures	1902.82	1902.82	1900.53	1900.82	197.0
2009-10-01 20:00:00	NQ	Futures	1901.1	1904.53	1898.25	1902.25	978.0
2009-10-01 21:00:00	NQ	Futures	1902.25	1904.24	1900.53	1901.96	687.0
2009-10-01 22:00:00	NQ	Futures	1901.96	1902.82	1900.25	1900.82	253.0
2009-10-01 23:00:00	NQ	Futures	1900.82	1901.1	1899.68	1900.53	132.0
2009-10-01 00:00:00	YM	Futures	8973.5	8975.4	8966.0	8967.9	142.0
2009-10-01 01:00:00	YM	Futures	8970.7	8973.5	8965.1	8969.8	191.0

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

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