PREVIEW / futures_1hour / 2009-09-01

all futures 1-hour files

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

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-01 00:00:00	ES	Futures	986.37	986.85	984.92	986.61	3381.0
2009-09-01 01:00:00	ES	Futures	986.61	989.26	986.13	986.37	7123.0
2009-09-01 02:00:00	ES	Futures	986.37	987.33	985.4	986.37	8423.0
2009-09-01 03:00:00	ES	Futures	986.61	988.06	985.16	986.13	19797.0
2009-09-01 04:00:00	ES	Futures	985.89	986.13	975.52	978.41	58347.0
2009-09-01 05:00:00	ES	Futures	978.17	978.41	975.03	977.2	18461.0
2009-09-01 06:00:00	ES	Futures	977.2	977.45	975.76	976.24	16027.0
2009-09-01 07:00:00	ES	Futures	976.24	979.13	976.0	978.89	21106.0
2009-09-01 08:00:00	ES	Futures	979.13	980.58	977.93	979.13	47248.0
2009-09-01 09:00:00	ES	Futures	979.37	989.02	977.93	987.57	317731.0
2009-09-01 10:00:00	ES	Futures	987.82	991.43	981.54	981.79	508835.0
2009-09-01 11:00:00	ES	Futures	981.79	981.79	964.9	966.83	740385.0
2009-09-01 12:00:00	ES	Futures	967.07	969.0	963.94	965.63	296509.0
2009-09-01 13:00:00	ES	Futures	965.63	966.83	962.25	966.59	265907.0
2009-09-01 14:00:00	ES	Futures	966.59	967.32	963.22	964.9	255345.0
2009-09-01 15:00:00	ES	Futures	964.9	966.83	960.08	962.01	438634.0
2009-09-01 16:00:00	ES	Futures	962.01	962.49	960.32	961.53	123099.0
2009-09-01 17:00:00	ES	Futures	961.53	961.77	960.56	961.53	2230.0
2009-09-01 18:00:00	ES	Futures	961.77	962.25	961.53	961.77	4092.0
2009-09-01 19:00:00	ES	Futures	961.77	962.01	960.8	960.8	4001.0
2009-09-01 20:00:00	ES	Futures	960.8	963.22	960.56	962.98	7251.0
2009-09-01 21:00:00	ES	Futures	962.98	963.7	962.25	963.22	7228.0
2009-09-01 22:00:00	ES	Futures	963.22	963.46	961.53	962.49	5521.0
2009-09-01 23:00:00	ES	Futures	962.49	962.98	961.05	961.05	3504.0
2009-09-01 00:00:00	NQ	Futures	1856.68	1856.96	1854.12	1856.96	355.0
2009-09-01 01:00:00	NQ	Futures	1856.96	1861.24	1856.39	1856.68	916.0
2009-09-01 02:00:00	NQ	Futures	1856.39	1858.1	1854.69	1856.11	476.0
2009-09-01 03:00:00	NQ	Futures	1856.39	1858.67	1853.55	1855.82	1501.0
2009-09-01 04:00:00	NQ	Futures	1855.54	1855.54	1836.74	1842.15	4095.0
2009-09-01 05:00:00	NQ	Futures	1842.15	1842.15	1835.89	1838.74	1805.0
2009-09-01 06:00:00	NQ	Futures	1838.74	1839.88	1837.03	1837.31	1084.0
2009-09-01 07:00:00	NQ	Futures	1837.31	1845.29	1836.74	1843.86	2309.0
2009-09-01 08:00:00	NQ	Futures	1843.86	1847.85	1842.72	1845.57	4884.0
2009-09-01 09:00:00	NQ	Futures	1845.29	1872.34	1843.29	1868.36	55900.0
2009-09-01 10:00:00	NQ	Futures	1868.36	1878.61	1857.82	1858.1	75533.0
2009-09-01 11:00:00	NQ	Futures	1858.1	1860.38	1822.79	1822.79	111283.0
2009-09-01 12:00:00	NQ	Futures	1823.07	1826.77	1819.65	1820.51	48409.0
2009-09-01 13:00:00	NQ	Futures	1820.51	1822.5	1811.68	1821.93	48271.0
2009-09-01 14:00:00	NQ	Futures	1822.22	1825.63	1819.08	1821.36	33768.0
2009-09-01 15:00:00	NQ	Futures	1821.36	1825.35	1814.53	1816.81	50306.0
2009-09-01 16:00:00	NQ	Futures	1817.09	1818.8	1813.67	1817.66	11598.0
2009-09-01 17:00:00	NQ	Futures	1818.23	1818.51	1817.38	1817.66	116.0
2009-09-01 18:00:00	NQ	Futures	1818.23	1818.51	1817.09	1818.23	120.0
2009-09-01 19:00:00	NQ	Futures	1818.23	1818.23	1816.52	1816.81	240.0
2009-09-01 20:00:00	NQ	Futures	1817.09	1821.65	1815.95	1821.08	880.0
2009-09-01 21:00:00	NQ	Futures	1821.08	1822.79	1819.94	1821.65	881.0
2009-09-01 22:00:00	NQ	Futures	1821.65	1821.65	1818.23	1820.22	555.0
2009-09-01 23:00:00	NQ	Futures	1819.94	1820.22	1817.38	1817.66	470.0
2009-09-01 00:00:00	YM	Futures	8797.9	8798.9	8784.1	8796.1	241.0
2009-09-01 01:00:00	YM	Futures	8798.9	8816.4	8793.3	8793.3	566.0

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

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