PREVIEW / futures_1hour / 2009-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-12.parquet
  size:    44 KB
  rows:    1,267

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-12 00:00:00	ES	Futures	957.91	958.88	957.67	958.63	2924.0
2009-08-12 01:00:00	ES	Futures	958.63	959.12	957.67	957.91	1959.0
2009-08-12 02:00:00	ES	Futures	957.91	958.63	955.26	955.5	13099.0
2009-08-12 03:00:00	ES	Futures	955.74	956.22	950.92	952.85	38868.0
2009-08-12 04:00:00	ES	Futures	953.09	955.98	952.61	955.26	16582.0
2009-08-12 05:00:00	ES	Futures	955.02	956.95	954.78	956.7	13189.0
2009-08-12 06:00:00	ES	Futures	956.7	960.32	956.46	958.88	19918.0
2009-08-12 07:00:00	ES	Futures	959.12	959.6	955.26	956.22	20985.0
2009-08-12 08:00:00	ES	Futures	956.22	959.6	955.98	956.7	36233.0
2009-08-12 09:00:00	ES	Futures	956.7	966.11	955.5	966.11	282177.0
2009-08-12 10:00:00	ES	Futures	966.11	970.93	965.87	969.73	355326.0
2009-08-12 11:00:00	ES	Futures	969.97	970.69	968.52	970.21	123825.0
2009-08-12 12:00:00	ES	Futures	970.21	970.93	968.04	970.21	113032.0
2009-08-12 13:00:00	ES	Futures	970.45	972.14	969.25	970.45	128101.0
2009-08-12 14:00:00	ES	Futures	970.45	974.55	965.15	974.31	346058.0
2009-08-12 15:00:00	ES	Futures	974.55	975.52	966.83	968.04	393283.0
2009-08-12 16:00:00	ES	Futures	967.8	969.0	966.59	968.52	86628.0
2009-08-12 17:00:00	ES	Futures	968.28	969.0	968.28	968.52	1880.0
2009-08-12 18:00:00	ES	Futures	968.76	969.0	967.56	967.8	2600.0
2009-08-12 19:00:00	ES	Futures	967.8	968.52	967.07	968.04	2637.0
2009-08-12 20:00:00	ES	Futures	968.04	969.49	967.32	969.25	3597.0
2009-08-12 21:00:00	ES	Futures	969.25	969.49	968.04	969.0	3826.0
2009-08-12 22:00:00	ES	Futures	969.0	969.73	968.76	969.49	2746.0
2009-08-12 23:00:00	ES	Futures	969.73	969.97	969.25	969.97	2042.0
2009-08-12 00:00:00	NQ	Futures	1820.22	1821.93	1819.94	1821.36	180.0
2009-08-12 01:00:00	NQ	Futures	1821.08	1822.5	1819.94	1820.51	174.0
2009-08-12 02:00:00	NQ	Futures	1819.65	1821.08	1815.95	1816.52	622.0
2009-08-12 03:00:00	NQ	Futures	1816.52	1816.52	1808.26	1810.82	2689.0
2009-08-12 04:00:00	NQ	Futures	1810.82	1815.67	1810.26	1814.81	1466.0
2009-08-12 05:00:00	NQ	Futures	1814.81	1817.38	1813.67	1816.81	827.0
2009-08-12 06:00:00	NQ	Futures	1817.09	1825.07	1816.81	1823.36	2153.0
2009-08-12 07:00:00	NQ	Futures	1823.64	1823.93	1816.81	1818.23	1799.0
2009-08-12 08:00:00	NQ	Futures	1818.23	1824.5	1814.24	1816.52	6055.0
2009-08-12 09:00:00	NQ	Futures	1816.52	1843.86	1812.82	1843.29	64223.0
2009-08-12 10:00:00	NQ	Futures	1843.29	1849.84	1841.87	1849.27	68647.0
2009-08-12 11:00:00	NQ	Futures	1849.27	1851.27	1847.28	1848.99	31612.0
2009-08-12 12:00:00	NQ	Futures	1848.99	1850.41	1845.29	1848.42	19418.0
2009-08-12 13:00:00	NQ	Futures	1848.13	1851.55	1845.0	1846.14	22387.0
2009-08-12 14:00:00	NQ	Futures	1846.14	1857.25	1838.17	1857.25	48897.0
2009-08-12 15:00:00	NQ	Futures	1856.96	1861.24	1842.15	1844.72	62680.0
2009-08-12 16:00:00	NQ	Futures	1844.72	1847.28	1843.01	1847.0	12273.0
2009-08-12 17:00:00	NQ	Futures	1846.14	1847.85	1845.86	1847.28	374.0
2009-08-12 18:00:00	NQ	Futures	1847.28	1848.13	1845.29	1845.29	355.0
2009-08-12 19:00:00	NQ	Futures	1845.29	1847.57	1844.72	1845.57	175.0
2009-08-12 20:00:00	NQ	Futures	1845.57	1847.85	1845.57	1847.57	306.0
2009-08-12 21:00:00	NQ	Futures	1847.57	1847.85	1844.43	1845.86	336.0
2009-08-12 22:00:00	NQ	Futures	1846.71	1847.85	1846.14	1847.85	251.0
2009-08-12 23:00:00	NQ	Futures	1847.57	1848.13	1846.43	1847.28	369.0
2009-08-12 00:00:00	YM	Futures	8526.1	8533.5	8524.2	8532.6	247.0
2009-08-12 01:00:00	YM	Futures	8532.6	8537.2	8525.2	8529.8	275.0

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

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