PREVIEW / futures_1hour / 2009-08-25

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-25.parquet
  size:    41 KB
  rows:    1,211

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-08-25 00:00:00	ES	Futures	986.61	987.57	986.61	986.61	1872.0
2009-08-25 01:00:00	ES	Futures	986.85	986.85	982.27	984.68	10115.0
2009-08-25 02:00:00	ES	Futures	984.44	986.13	982.75	984.92	12259.0
2009-08-25 03:00:00	ES	Futures	985.16	989.5	985.16	987.57	23850.0
2009-08-25 04:00:00	ES	Futures	987.57	990.47	987.09	989.5	9901.0
2009-08-25 05:00:00	ES	Futures	989.5	991.43	989.5	990.71	14968.0
2009-08-25 06:00:00	ES	Futures	990.47	991.43	989.02	989.5	8192.0
2009-08-25 07:00:00	ES	Futures	989.5	994.09	989.26	993.6	27566.0
2009-08-25 08:00:00	ES	Futures	993.6	995.05	992.88	994.09	40315.0
2009-08-25 09:00:00	ES	Futures	994.33	996.74	990.23	995.53	259359.0
2009-08-25 10:00:00	ES	Futures	995.77	1001.32	990.23	994.33	504317.0
2009-08-25 11:00:00	ES	Futures	994.33	997.46	993.6	996.26	165790.0
2009-08-25 12:00:00	ES	Futures	996.26	999.15	994.57	994.57	149427.0
2009-08-25 13:00:00	ES	Futures	994.81	995.77	990.95	991.92	168248.0
2009-08-25 14:00:00	ES	Futures	991.67	993.6	988.54	991.67	251794.0
2009-08-25 15:00:00	ES	Futures	991.67	994.09	989.5	990.95	250288.0
2009-08-25 16:00:00	ES	Futures	990.71	991.43	989.02	989.26	78483.0
2009-08-25 17:00:00	ES	Futures	989.26	989.5	989.02	989.26	1126.0
2009-08-25 18:00:00	ES	Futures	989.26	989.5	988.06	988.54	2387.0
2009-08-25 19:00:00	ES	Futures	988.54	988.54	986.13	986.37	4479.0
2009-08-25 20:00:00	ES	Futures	986.37	989.02	986.37	989.02	4560.0
2009-08-25 21:00:00	ES	Futures	989.02	989.5	986.85	989.02	4674.0
2009-08-25 22:00:00	ES	Futures	988.78	990.47	988.06	990.47	4197.0
2009-08-25 23:00:00	ES	Futures	990.23	992.64	989.74	992.4	4176.0
2009-08-25 00:00:00	NQ	Futures	1856.96	1858.39	1856.96	1857.53	164.0
2009-08-25 01:00:00	NQ	Futures	1857.25	1857.25	1851.55	1854.97	757.0
2009-08-25 02:00:00	NQ	Futures	1854.97	1855.82	1851.84	1853.83	1331.0
2009-08-25 03:00:00	NQ	Futures	1854.12	1862.66	1854.12	1858.67	1932.0
2009-08-25 04:00:00	NQ	Futures	1858.96	1864.08	1858.67	1863.51	871.0
2009-08-25 05:00:00	NQ	Futures	1863.23	1866.65	1862.66	1864.08	1195.0
2009-08-25 06:00:00	NQ	Futures	1864.94	1865.51	1862.09	1862.66	539.0
2009-08-25 07:00:00	NQ	Futures	1862.66	1870.63	1862.66	1869.78	1684.0
2009-08-25 08:00:00	NQ	Futures	1869.78	1872.06	1868.93	1870.35	3156.0
2009-08-25 09:00:00	NQ	Futures	1870.63	1878.04	1862.95	1876.9	42602.0
2009-08-25 10:00:00	NQ	Futures	1876.9	1886.01	1866.65	1873.2	86200.0
2009-08-25 11:00:00	NQ	Futures	1873.48	1879.46	1872.06	1877.76	22713.0
2009-08-25 12:00:00	NQ	Futures	1877.76	1882.88	1872.34	1872.91	26871.0
2009-08-25 13:00:00	NQ	Futures	1872.91	1874.91	1866.93	1868.07	26368.0
2009-08-25 14:00:00	NQ	Futures	1868.07	1871.2	1862.09	1868.64	29078.0
2009-08-25 15:00:00	NQ	Futures	1868.64	1872.63	1864.65	1867.79	32896.0
2009-08-25 16:00:00	NQ	Futures	1867.79	1868.07	1863.8	1864.65	8687.0
2009-08-25 17:00:00	NQ	Futures	1865.22	1865.22	1863.8	1864.65	127.0
2009-08-25 18:00:00	NQ	Futures	1864.08	1864.65	1863.51	1863.8	312.0
2009-08-25 19:00:00	NQ	Futures	1864.08	1864.37	1860.67	1860.95	352.0
2009-08-25 20:00:00	NQ	Futures	1860.95	1865.22	1860.67	1864.37	536.0
2009-08-25 21:00:00	NQ	Futures	1864.37	1865.22	1861.24	1864.65	445.0
2009-08-25 22:00:00	NQ	Futures	1864.37	1867.79	1863.23	1867.22	402.0
2009-08-25 23:00:00	NQ	Futures	1867.22	1871.2	1866.65	1870.92	446.0
2009-08-25 00:00:00	YM	Futures	8765.6	8772.0	8763.7	8767.4	89.0
2009-08-25 01:00:00	YM	Futures	8767.4	8767.4	8729.5	8749.9	828.0

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

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