PREVIEW / futures_1hour / 2009-08-13

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-13.parquet
  size:    45 KB
  rows:    1,259

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-13 00:00:00	ES	Futures	969.97	970.45	969.73	970.45	1772.0
2009-08-13 01:00:00	ES	Futures	970.45	971.42	970.21	970.69	3226.0
2009-08-13 02:00:00	ES	Futures	970.93	972.14	970.45	971.42	6941.0
2009-08-13 03:00:00	ES	Futures	971.17	974.07	970.21	973.35	21020.0
2009-08-13 04:00:00	ES	Futures	973.35	975.76	972.62	975.52	20313.0
2009-08-13 05:00:00	ES	Futures	975.52	976.72	975.27	975.52	13470.0
2009-08-13 06:00:00	ES	Futures	975.52	976.48	974.79	976.48	8228.0
2009-08-13 07:00:00	ES	Futures	976.24	979.37	976.0	976.72	33970.0
2009-08-13 08:00:00	ES	Futures	976.72	979.37	969.49	972.62	126413.0
2009-08-13 09:00:00	ES	Futures	972.62	974.31	962.73	964.18	344319.0
2009-08-13 10:00:00	ES	Futures	963.94	974.55	963.22	973.1	371116.0
2009-08-13 11:00:00	ES	Futures	973.35	974.07	969.97	972.62	169109.0
2009-08-13 12:00:00	ES	Futures	972.38	973.83	971.9	972.62	70015.0
2009-08-13 13:00:00	ES	Futures	972.62	976.24	969.97	971.17	161185.0
2009-08-13 14:00:00	ES	Futures	970.93	972.14	967.07	969.73	148839.0
2009-08-13 15:00:00	ES	Futures	969.73	975.76	969.49	975.76	202478.0
2009-08-13 16:00:00	ES	Futures	975.76	978.17	975.52	977.2	100791.0
2009-08-13 17:00:00	ES	Futures	977.45	978.17	977.2	977.45	1419.0
2009-08-13 18:00:00	ES	Futures	977.45	977.69	976.48	976.72	1187.0
2009-08-13 19:00:00	ES	Futures	976.72	976.96	976.24	976.72	1666.0
2009-08-13 20:00:00	ES	Futures	976.48	979.86	976.48	979.13	5234.0
2009-08-13 21:00:00	ES	Futures	979.13	979.13	976.96	977.45	3477.0
2009-08-13 22:00:00	ES	Futures	977.69	978.17	976.96	977.2	2416.0
2009-08-13 23:00:00	ES	Futures	977.2	977.45	975.76	976.24	4998.0
2009-08-13 00:00:00	NQ	Futures	1847.28	1848.99	1847.28	1848.99	139.0
2009-08-13 01:00:00	NQ	Futures	1848.7	1850.13	1848.42	1849.27	249.0
2009-08-13 02:00:00	NQ	Futures	1849.56	1852.12	1848.42	1851.27	1017.0
2009-08-13 03:00:00	NQ	Futures	1851.27	1855.82	1849.27	1853.83	2417.0
2009-08-13 04:00:00	NQ	Futures	1854.4	1858.1	1852.69	1857.82	1565.0
2009-08-13 05:00:00	NQ	Futures	1857.53	1862.09	1857.25	1859.24	2385.0
2009-08-13 06:00:00	NQ	Futures	1859.24	1859.81	1858.39	1859.53	694.0
2009-08-13 07:00:00	NQ	Futures	1859.24	1865.51	1858.96	1862.66	4238.0
2009-08-13 08:00:00	NQ	Futures	1862.95	1866.65	1850.98	1857.53	13726.0
2009-08-13 09:00:00	NQ	Futures	1858.1	1860.67	1834.18	1838.74	56699.0
2009-08-13 10:00:00	NQ	Futures	1838.74	1858.1	1837.31	1855.54	50397.0
2009-08-13 11:00:00	NQ	Futures	1855.54	1856.96	1847.85	1852.41	26358.0
2009-08-13 12:00:00	NQ	Futures	1852.41	1855.26	1849.56	1852.98	15886.0
2009-08-13 13:00:00	NQ	Futures	1853.26	1858.39	1847.0	1848.7	22829.0
2009-08-13 14:00:00	NQ	Futures	1848.7	1849.84	1840.16	1845.0	25093.0
2009-08-13 15:00:00	NQ	Futures	1845.29	1855.54	1845.0	1855.54	34670.0
2009-08-13 16:00:00	NQ	Futures	1855.82	1859.81	1854.97	1859.81	11196.0
2009-08-13 17:00:00	NQ	Futures	1859.53	1861.24	1858.67	1859.81	262.0
2009-08-13 18:00:00	NQ	Futures	1860.1	1860.1	1858.39	1858.39	127.0
2009-08-13 19:00:00	NQ	Futures	1858.1	1858.67	1857.25	1857.82	109.0
2009-08-13 20:00:00	NQ	Futures	1857.82	1861.52	1857.82	1861.24	883.0
2009-08-13 21:00:00	NQ	Futures	1860.95	1860.95	1857.53	1858.39	253.0
2009-08-13 22:00:00	NQ	Futures	1857.82	1859.81	1857.25	1857.25	272.0
2009-08-13 23:00:00	NQ	Futures	1856.96	1857.53	1854.69	1855.82	441.0
2009-08-13 00:00:00	YM	Futures	8645.4	8651.8	8644.4	8651.8	118.0
2009-08-13 01:00:00	YM	Futures	8649.1	8657.4	8646.3	8653.7	222.0

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

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