PREVIEW / futures_1hour / 2009-08-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	967.8	968.04	967.07	967.56	2856.0
2009-08-05 01:00:00	ES	Futures	967.32	967.56	965.87	966.11	5002.0
2009-08-05 02:00:00	ES	Futures	966.11	966.35	963.94	964.42	9967.0
2009-08-05 03:00:00	ES	Futures	964.42	967.32	963.7	965.15	19081.0
2009-08-05 04:00:00	ES	Futures	965.15	967.07	964.66	966.11	12361.0
2009-08-05 05:00:00	ES	Futures	966.11	968.76	965.87	968.04	10840.0
2009-08-05 06:00:00	ES	Futures	968.28	969.97	968.04	969.73	10324.0
2009-08-05 07:00:00	ES	Futures	969.49	970.93	967.8	968.52	23121.0
2009-08-05 08:00:00	ES	Futures	968.52	970.45	965.63	967.07	51553.0
2009-08-05 09:00:00	ES	Futures	967.07	968.76	961.77	963.22	251486.0
2009-08-05 10:00:00	ES	Futures	962.98	963.46	956.22	958.88	395121.0
2009-08-05 11:00:00	ES	Futures	959.12	961.05	957.91	959.12	159294.0
2009-08-05 12:00:00	ES	Futures	959.12	962.01	958.15	959.84	128341.0
2009-08-05 13:00:00	ES	Futures	959.6	963.46	957.67	961.53	187231.0
2009-08-05 14:00:00	ES	Futures	961.53	966.83	960.56	966.35	208071.0
2009-08-05 15:00:00	ES	Futures	966.35	968.28	962.98	964.42	280268.0
2009-08-05 16:00:00	ES	Futures	964.42	965.63	962.25	962.49	92944.0
2009-08-05 17:00:00	ES	Futures	962.49	962.98	961.77	962.01	4621.0
2009-08-05 18:00:00	ES	Futures	962.01	962.25	961.29	961.77	2357.0
2009-08-05 19:00:00	ES	Futures	961.77	962.25	961.05	962.01	1656.0
2009-08-05 20:00:00	ES	Futures	962.25	964.42	962.01	964.18	3909.0
2009-08-05 21:00:00	ES	Futures	964.42	965.15	962.49	962.98	6079.0
2009-08-05 22:00:00	ES	Futures	962.98	963.94	961.05	961.53	5038.0
2009-08-05 23:00:00	ES	Futures	961.53	963.7	961.05	963.7	2914.0
2009-08-05 00:00:00	NQ	Futures	1854.69	1855.26	1853.55	1853.55	139.0
2009-08-05 01:00:00	NQ	Futures	1853.55	1853.83	1851.27	1851.27	230.0
2009-08-05 02:00:00	NQ	Futures	1851.27	1851.84	1848.7	1848.99	532.0
2009-08-05 03:00:00	NQ	Futures	1848.99	1852.41	1847.0	1847.85	1522.0
2009-08-05 04:00:00	NQ	Futures	1848.13	1851.27	1847.0	1850.41	721.0
2009-08-05 05:00:00	NQ	Futures	1849.84	1854.4	1849.84	1854.12	816.0
2009-08-05 06:00:00	NQ	Futures	1854.4	1856.39	1853.83	1855.54	1014.0
2009-08-05 07:00:00	NQ	Futures	1855.54	1858.1	1853.26	1854.12	2386.0
2009-08-05 08:00:00	NQ	Futures	1854.12	1857.82	1851.27	1854.4	5757.0
2009-08-05 09:00:00	NQ	Futures	1854.69	1858.39	1837.88	1839.59	46245.0
2009-08-05 10:00:00	NQ	Futures	1839.59	1840.16	1829.05	1834.46	61786.0
2009-08-05 11:00:00	NQ	Futures	1834.46	1837.03	1827.63	1829.05	33450.0
2009-08-05 12:00:00	NQ	Futures	1828.77	1834.46	1827.06	1828.2	23510.0
2009-08-05 13:00:00	NQ	Futures	1827.91	1836.46	1825.63	1831.62	32141.0
2009-08-05 14:00:00	NQ	Futures	1831.33	1841.87	1829.91	1840.16	30108.0
2009-08-05 15:00:00	NQ	Futures	1840.16	1844.15	1836.46	1839.02	43448.0
2009-08-05 16:00:00	NQ	Futures	1838.74	1840.73	1828.48	1830.19	17626.0
2009-08-05 17:00:00	NQ	Futures	1830.19	1830.48	1825.92	1827.06	1151.0
2009-08-05 18:00:00	NQ	Futures	1826.49	1826.49	1825.07	1825.92	679.0
2009-08-05 19:00:00	NQ	Futures	1825.92	1827.34	1825.07	1826.77	315.0
2009-08-05 20:00:00	NQ	Futures	1827.06	1831.62	1827.06	1830.76	360.0
2009-08-05 21:00:00	NQ	Futures	1831.33	1832.76	1828.2	1829.91	603.0
2009-08-05 22:00:00	NQ	Futures	1829.05	1831.05	1826.77	1827.34	385.0
2009-08-05 23:00:00	NQ	Futures	1827.34	1831.62	1827.06	1831.05	222.0
2009-08-05 00:00:00	YM	Futures	8574.2	8577.9	8570.5	8571.4	106.0
2009-08-05 01:00:00	YM	Futures	8571.4	8571.4	8560.3	8562.2	220.0

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

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