PREVIEW / futures_1hour / 2009-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-09.parquet
  size:    42 KB
  rows:    1,245

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-09 00:00:00	ES	Futures	985.64	985.64	984.68	985.16	3570.0
2009-09-09 01:00:00	ES	Futures	984.92	986.37	984.44	985.4	3984.0
2009-09-09 02:00:00	ES	Futures	985.64	986.13	982.75	983.23	9872.0
2009-09-09 03:00:00	ES	Futures	983.47	985.64	982.75	983.72	22390.0
2009-09-09 04:00:00	ES	Futures	983.96	985.64	983.23	985.16	13774.0
2009-09-09 05:00:00	ES	Futures	985.16	989.26	985.16	988.78	17275.0
2009-09-09 06:00:00	ES	Futures	988.78	989.5	987.09	987.57	12976.0
2009-09-09 07:00:00	ES	Futures	987.57	990.47	987.33	989.5	23817.0
2009-09-09 08:00:00	ES	Futures	989.26	991.92	988.54	989.5	60508.0
2009-09-09 09:00:00	ES	Futures	989.26	993.12	987.09	991.19	257836.0
2009-09-09 10:00:00	ES	Futures	991.43	993.84	991.19	992.64	240119.0
2009-09-09 11:00:00	ES	Futures	992.4	998.67	992.4	996.98	261165.0
2009-09-09 12:00:00	ES	Futures	996.74	998.19	996.5	998.19	85016.0
2009-09-09 13:00:00	ES	Futures	998.19	999.63	996.5	997.22	147674.0
2009-09-09 14:00:00	ES	Futures	997.22	998.19	990.71	992.16	270454.0
2009-09-09 15:00:00	ES	Futures	992.4	997.94	991.67	996.5	253015.0
2009-09-09 16:00:00	ES	Futures	996.26	997.22	995.29	995.77	67029.0
2009-09-09 17:00:00	ES	Futures	995.77	995.77	995.05	995.05	1277.0
2009-09-09 18:00:00	ES	Futures	995.29	995.53	994.57	995.29	1512.0
2009-09-09 19:00:00	ES	Futures	995.05	995.29	994.57	994.81	1074.0
2009-09-09 20:00:00	ES	Futures	994.81	997.22	994.33	997.22	4766.0
2009-09-09 21:00:00	ES	Futures	997.22	997.94	996.26	997.46	4047.0
2009-09-09 22:00:00	ES	Futures	997.46	998.19	996.98	997.7	2813.0
2009-09-09 23:00:00	ES	Futures	997.7	999.15	997.46	999.15	4484.0
2009-09-09 00:00:00	NQ	Futures	1878.89	1878.89	1877.19	1877.47	333.0
2009-09-09 01:00:00	NQ	Futures	1877.19	1880.03	1876.62	1878.32	345.0
2009-09-09 02:00:00	NQ	Futures	1878.89	1879.75	1874.34	1874.62	616.0
2009-09-09 03:00:00	NQ	Futures	1874.91	1877.76	1874.05	1875.76	2215.0
2009-09-09 04:00:00	NQ	Futures	1876.05	1878.04	1874.05	1878.04	1215.0
2009-09-09 05:00:00	NQ	Futures	1877.47	1883.74	1877.47	1883.45	1348.0
2009-09-09 06:00:00	NQ	Futures	1883.17	1884.59	1880.03	1880.32	1131.0
2009-09-09 07:00:00	NQ	Futures	1880.6	1886.3	1880.6	1884.31	1520.0
2009-09-09 08:00:00	NQ	Futures	1884.31	1888.58	1882.6	1883.74	4357.0
2009-09-09 09:00:00	NQ	Futures	1883.74	1893.42	1878.32	1890.0	38139.0
2009-09-09 10:00:00	NQ	Futures	1890.0	1897.98	1890.0	1896.27	37239.0
2009-09-09 11:00:00	NQ	Futures	1896.27	1910.51	1896.27	1906.81	43250.0
2009-09-09 12:00:00	NQ	Futures	1906.81	1907.95	1904.53	1907.95	20060.0
2009-09-09 13:00:00	NQ	Futures	1907.95	1909.37	1902.82	1904.24	29537.0
2009-09-09 14:00:00	NQ	Futures	1904.24	1905.95	1889.72	1893.42	49476.0
2009-09-09 15:00:00	NQ	Futures	1893.42	1905.95	1892.85	1900.54	49175.0
2009-09-09 16:00:00	NQ	Futures	1900.54	1902.25	1897.69	1899.4	9855.0
2009-09-09 17:00:00	NQ	Futures	1899.12	1899.4	1898.26	1898.83	203.0
2009-09-09 18:00:00	NQ	Futures	1898.83	1898.83	1897.41	1897.69	192.0
2009-09-09 19:00:00	NQ	Futures	1897.41	1898.26	1897.12	1897.69	78.0
2009-09-09 20:00:00	NQ	Futures	1897.41	1901.39	1897.12	1901.11	390.0
2009-09-09 21:00:00	NQ	Futures	1901.39	1902.53	1899.69	1901.96	519.0
2009-09-09 22:00:00	NQ	Futures	1901.68	1903.1	1900.54	1901.68	370.0
2009-09-09 23:00:00	NQ	Futures	1901.68	1905.38	1901.68	1904.81	501.0
2009-09-09 00:00:00	YM	Futures	8748.9	8748.9	8742.5	8744.3	255.0
2009-09-09 01:00:00	YM	Futures	8745.2	8755.4	8742.5	8747.1	212.0

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

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