PREVIEW / futures_1hour / 2009-08-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	963.22	963.46	962.25	962.73	4048.0
2009-08-04 01:00:00	ES	Futures	962.49	962.73	961.53	961.77	3705.0
2009-08-04 02:00:00	ES	Futures	962.01	962.49	960.56	962.25	9019.0
2009-08-04 03:00:00	ES	Futures	962.25	962.98	959.6	960.56	17357.0
2009-08-04 04:00:00	ES	Futures	960.8	961.29	956.95	957.19	19374.0
2009-08-04 05:00:00	ES	Futures	957.19	959.84	956.95	958.88	12613.0
2009-08-04 06:00:00	ES	Futures	958.88	959.36	957.19	957.67	15274.0
2009-08-04 07:00:00	ES	Futures	957.91	959.36	957.67	957.91	15010.0
2009-08-04 08:00:00	ES	Futures	957.91	960.08	957.19	958.63	30982.0
2009-08-04 09:00:00	ES	Futures	958.63	961.53	958.15	961.53	228859.0
2009-08-04 10:00:00	ES	Futures	961.53	963.94	959.36	962.98	343262.0
2009-08-04 11:00:00	ES	Futures	962.98	966.35	962.73	965.39	205223.0
2009-08-04 12:00:00	ES	Futures	965.39	968.52	964.42	968.28	176306.0
2009-08-04 13:00:00	ES	Futures	968.04	968.52	962.49	962.73	183859.0
2009-08-04 14:00:00	ES	Futures	962.98	966.35	961.77	962.98	176976.0
2009-08-04 15:00:00	ES	Futures	962.98	967.32	961.77	967.07	291235.0
2009-08-04 16:00:00	ES	Futures	967.07	969.73	966.83	969.25	111143.0
2009-08-04 17:00:00	ES	Futures	969.25	970.21	968.76	969.97	2466.0
2009-08-04 18:00:00	ES	Futures	969.97	969.97	969.0	969.49	2678.0
2009-08-04 19:00:00	ES	Futures	969.25	969.49	969.0	969.0	910.0
2009-08-04 20:00:00	ES	Futures	969.0	969.25	967.8	968.28	3977.0
2009-08-04 21:00:00	ES	Futures	968.28	968.52	967.8	968.04	2668.0
2009-08-04 22:00:00	ES	Futures	968.28	969.25	968.04	969.0	2584.0
2009-08-04 23:00:00	ES	Futures	969.0	969.25	967.32	967.56	3332.0
2009-08-04 00:00:00	NQ	Futures	1848.99	1849.27	1847.0	1847.57	332.0
2009-08-04 01:00:00	NQ	Futures	1847.57	1848.13	1846.14	1847.0	226.0
2009-08-04 02:00:00	NQ	Futures	1847.0	1848.13	1844.72	1847.85	472.0
2009-08-04 03:00:00	NQ	Futures	1847.57	1849.56	1843.29	1845.0	1268.0
2009-08-04 04:00:00	NQ	Futures	1845.29	1845.86	1837.6	1837.6	1541.0
2009-08-04 05:00:00	NQ	Futures	1838.17	1843.29	1837.31	1841.01	784.0
2009-08-04 06:00:00	NQ	Futures	1841.3	1841.58	1837.31	1838.17	1020.0
2009-08-04 07:00:00	NQ	Futures	1838.17	1841.58	1838.17	1839.59	972.0
2009-08-04 08:00:00	NQ	Futures	1839.59	1842.15	1838.17	1839.88	2896.0
2009-08-04 09:00:00	NQ	Futures	1839.88	1848.13	1839.88	1847.28	36117.0
2009-08-04 10:00:00	NQ	Futures	1846.14	1851.27	1843.01	1848.13	47997.0
2009-08-04 11:00:00	NQ	Futures	1847.85	1854.97	1846.71	1853.26	28080.0
2009-08-04 12:00:00	NQ	Futures	1853.55	1857.53	1851.55	1857.25	24950.0
2009-08-04 13:00:00	NQ	Futures	1857.25	1859.81	1843.86	1845.29	29935.0
2009-08-04 14:00:00	NQ	Futures	1845.0	1850.98	1842.15	1843.58	31247.0
2009-08-04 15:00:00	NQ	Futures	1843.58	1852.41	1841.3	1852.12	46382.0
2009-08-04 16:00:00	NQ	Futures	1852.12	1858.67	1851.55	1858.1	12057.0
2009-08-04 17:00:00	NQ	Futures	1857.25	1858.67	1857.25	1858.67	87.0
2009-08-04 18:00:00	NQ	Futures	1857.53	1857.82	1857.25	1857.25	143.0
2009-08-04 19:00:00	NQ	Futures	1857.53	1858.1	1856.68	1856.96	164.0
2009-08-04 20:00:00	NQ	Futures	1856.68	1857.25	1855.26	1856.39	413.0
2009-08-04 21:00:00	NQ	Futures	1856.39	1856.68	1854.97	1856.11	216.0
2009-08-04 22:00:00	NQ	Futures	1856.39	1857.82	1856.39	1857.53	205.0
2009-08-04 23:00:00	NQ	Futures	1857.25	1857.53	1854.12	1854.97	218.0
2009-08-04 00:00:00	YM	Futures	8529.8	8531.6	8522.4	8527.0	276.0
2009-08-04 01:00:00	YM	Futures	8527.0	8527.9	8518.7	8520.5	154.0

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

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