PREVIEW / futures_1hour / 2009-08-10

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-10.parquet
  size:    41 KB
  rows:    1,237

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-10 00:00:00	ES	Futures	969.97	970.45	968.76	969.73	2921.0
2009-08-10 01:00:00	ES	Futures	969.49	969.97	968.76	969.49	2580.0
2009-08-10 02:00:00	ES	Futures	969.49	970.69	969.25	970.45	4236.0
2009-08-10 03:00:00	ES	Futures	970.21	971.42	968.52	969.25	15787.0
2009-08-10 04:00:00	ES	Futures	969.0	970.69	968.04	969.97	10569.0
2009-08-10 05:00:00	ES	Futures	969.97	970.21	969.25	969.25	3937.0
2009-08-10 06:00:00	ES	Futures	969.49	969.97	968.52	968.76	7963.0
2009-08-10 07:00:00	ES	Futures	968.76	968.76	966.59	968.52	13885.0
2009-08-10 08:00:00	ES	Futures	968.52	970.21	965.15	967.07	32832.0
2009-08-10 09:00:00	ES	Futures	967.07	970.69	965.63	969.25	176884.0
2009-08-10 10:00:00	ES	Futures	969.25	972.14	967.56	970.93	186095.0
2009-08-10 11:00:00	ES	Futures	970.93	972.14	968.76	969.73	93256.0
2009-08-10 12:00:00	ES	Futures	969.73	970.69	967.07	967.32	77710.0
2009-08-10 13:00:00	ES	Futures	967.32	967.56	964.18	965.63	159981.0
2009-08-10 14:00:00	ES	Futures	965.63	966.35	962.98	966.11	97742.0
2009-08-10 15:00:00	ES	Futures	966.35	969.97	966.11	969.49	196248.0
2009-08-10 16:00:00	ES	Futures	969.49	972.14	969.49	971.17	88650.0
2009-08-10 17:00:00	ES	Futures	971.42	971.66	970.93	971.42	1025.0
2009-08-10 18:00:00	ES	Futures	971.17	971.17	969.97	970.21	4242.0
2009-08-10 19:00:00	ES	Futures	969.97	970.45	969.73	969.97	1355.0
2009-08-10 20:00:00	ES	Futures	969.97	970.69	969.73	970.21	2139.0
2009-08-10 21:00:00	ES	Futures	970.45	971.66	970.21	970.69	2538.0
2009-08-10 22:00:00	ES	Futures	970.93	970.93	969.49	970.21	3798.0
2009-08-10 23:00:00	ES	Futures	970.21	970.69	969.97	969.97	1354.0
2009-08-10 00:00:00	NQ	Futures	1841.87	1842.72	1839.59	1841.3	142.0
2009-08-10 01:00:00	NQ	Futures	1841.01	1842.15	1839.02	1840.16	204.0
2009-08-10 02:00:00	NQ	Futures	1840.44	1841.58	1839.59	1841.3	370.0
2009-08-10 03:00:00	NQ	Futures	1840.44	1843.01	1837.88	1838.45	1609.0
2009-08-10 04:00:00	NQ	Futures	1838.74	1841.3	1836.74	1840.16	1008.0
2009-08-10 05:00:00	NQ	Futures	1840.16	1841.01	1838.74	1839.59	443.0
2009-08-10 06:00:00	NQ	Futures	1839.31	1839.88	1835.6	1836.46	1153.0
2009-08-10 07:00:00	NQ	Futures	1836.17	1840.73	1832.47	1840.16	2690.0
2009-08-10 08:00:00	NQ	Futures	1840.16	1842.44	1833.89	1837.6	4900.0
2009-08-10 09:00:00	NQ	Futures	1837.88	1844.15	1831.62	1840.16	31725.0
2009-08-10 10:00:00	NQ	Futures	1840.73	1842.44	1835.03	1840.16	32130.0
2009-08-10 11:00:00	NQ	Futures	1840.16	1841.87	1832.47	1833.04	18719.0
2009-08-10 12:00:00	NQ	Futures	1833.04	1835.89	1824.78	1826.77	26812.0
2009-08-10 13:00:00	NQ	Futures	1826.77	1830.48	1822.5	1827.06	27170.0
2009-08-10 14:00:00	NQ	Futures	1827.06	1827.34	1820.22	1826.49	24609.0
2009-08-10 15:00:00	NQ	Futures	1826.77	1833.61	1826.49	1833.32	32532.0
2009-08-10 16:00:00	NQ	Futures	1833.04	1839.31	1832.19	1835.89	9594.0
2009-08-10 17:00:00	NQ	Futures	1836.74	1837.31	1836.46	1836.46	48.0
2009-08-10 18:00:00	NQ	Futures	1837.03	1837.03	1833.32	1833.32	431.0
2009-08-10 19:00:00	NQ	Futures	1833.32	1833.89	1832.76	1833.04	198.0
2009-08-10 20:00:00	NQ	Futures	1833.04	1834.46	1832.76	1833.89	117.0
2009-08-10 21:00:00	NQ	Futures	1834.18	1836.46	1834.18	1835.32	135.0
2009-08-10 22:00:00	NQ	Futures	1835.32	1835.32	1832.19	1833.04	243.0
2009-08-10 23:00:00	NQ	Futures	1832.19	1834.18	1832.19	1833.32	87.0
2009-08-10 00:00:00	YM	Futures	8619.5	8623.2	8611.2	8615.8	127.0
2009-08-10 01:00:00	YM	Futures	8614.9	8620.4	8609.3	8614.9	156.0

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

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