PREVIEW / futures_1hour / 2009-08-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-06.parquet
  size:    43 KB
  rows:    1,281

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-06 00:00:00	ES	Futures	963.7	965.15	962.98	964.66	4235.0
2009-08-06 01:00:00	ES	Futures	964.42	965.15	963.94	964.42	2777.0
2009-08-06 02:00:00	ES	Futures	964.42	966.11	963.46	965.63	8894.0
2009-08-06 03:00:00	ES	Futures	965.39	967.56	965.39	967.32	15443.0
2009-08-06 04:00:00	ES	Futures	967.32	968.04	964.66	965.87	12840.0
2009-08-06 05:00:00	ES	Futures	965.87	966.59	964.42	966.11	6843.0
2009-08-06 06:00:00	ES	Futures	966.11	967.07	964.42	965.63	10318.0
2009-08-06 07:00:00	ES	Futures	965.63	969.73	964.66	968.76	31546.0
2009-08-06 08:00:00	ES	Futures	968.76	972.14	968.52	968.76	52788.0
2009-08-06 09:00:00	ES	Futures	969.0	970.21	962.01	962.49	263418.0
2009-08-06 10:00:00	ES	Futures	962.73	962.98	957.67	960.8	371547.0
2009-08-06 11:00:00	ES	Futures	961.05	963.7	960.56	961.05	137560.0
2009-08-06 12:00:00	ES	Futures	961.29	961.29	957.91	959.12	143469.0
2009-08-06 13:00:00	ES	Futures	959.12	962.49	958.15	958.63	106436.0
2009-08-06 14:00:00	ES	Futures	958.63	958.88	954.78	956.7	206605.0
2009-08-06 15:00:00	ES	Futures	956.95	961.05	956.46	959.36	254635.0
2009-08-06 16:00:00	ES	Futures	959.36	960.56	958.15	959.36	66700.0
2009-08-06 17:00:00	ES	Futures	959.6	959.84	958.88	958.88	1013.0
2009-08-06 18:00:00	ES	Futures	958.88	959.84	958.63	958.63	2026.0
2009-08-06 19:00:00	ES	Futures	958.88	959.84	958.63	959.6	1218.0
2009-08-06 20:00:00	ES	Futures	959.6	960.08	958.63	958.88	2251.0
2009-08-06 21:00:00	ES	Futures	958.88	960.08	958.15	958.39	2873.0
2009-08-06 22:00:00	ES	Futures	958.39	958.88	957.91	958.63	2703.0
2009-08-06 23:00:00	ES	Futures	958.63	959.12	957.43	957.91	2730.0
2009-08-06 00:00:00	NQ	Futures	1831.05	1833.89	1830.76	1833.04	228.0
2009-08-06 01:00:00	NQ	Futures	1833.04	1834.18	1832.76	1832.76	204.0
2009-08-06 02:00:00	NQ	Futures	1833.89	1836.74	1832.76	1835.6	470.0
2009-08-06 03:00:00	NQ	Futures	1835.89	1838.45	1835.6	1838.17	1211.0
2009-08-06 04:00:00	NQ	Futures	1838.17	1840.73	1834.46	1835.89	1426.0
2009-08-06 05:00:00	NQ	Futures	1835.6	1837.03	1833.61	1836.17	658.0
2009-08-06 06:00:00	NQ	Futures	1836.46	1837.31	1832.19	1833.89	1174.0
2009-08-06 07:00:00	NQ	Futures	1833.61	1841.3	1832.19	1839.88	3425.0
2009-08-06 08:00:00	NQ	Futures	1839.88	1850.7	1839.88	1843.29	9711.0
2009-08-06 09:00:00	NQ	Futures	1843.29	1847.57	1826.2	1827.06	42513.0
2009-08-06 10:00:00	NQ	Futures	1826.49	1829.91	1820.79	1825.35	47283.0
2009-08-06 11:00:00	NQ	Futures	1825.63	1834.75	1824.78	1825.63	31097.0
2009-08-06 12:00:00	NQ	Futures	1825.63	1827.63	1818.51	1822.79	26741.0
2009-08-06 13:00:00	NQ	Futures	1823.07	1830.76	1821.08	1823.36	17960.0
2009-08-06 14:00:00	NQ	Futures	1823.64	1823.64	1815.38	1819.94	31684.0
2009-08-06 15:00:00	NQ	Futures	1819.94	1826.49	1818.8	1823.07	40198.0
2009-08-06 16:00:00	NQ	Futures	1823.36	1825.63	1820.22	1823.64	7980.0
2009-08-06 17:00:00	NQ	Futures	1823.36	1823.93	1821.65	1822.22	173.0
2009-08-06 18:00:00	NQ	Futures	1822.79	1824.21	1821.93	1823.07	139.0
2009-08-06 19:00:00	NQ	Futures	1822.79	1823.93	1822.79	1823.36	88.0
2009-08-06 20:00:00	NQ	Futures	1823.64	1824.5	1822.22	1822.79	376.0
2009-08-06 21:00:00	NQ	Futures	1822.79	1826.2	1822.79	1823.36	381.0
2009-08-06 22:00:00	NQ	Futures	1823.36	1824.21	1821.65	1823.64	482.0
2009-08-06 23:00:00	NQ	Futures	1823.93	1825.63	1821.93	1822.5	275.0
2009-08-06 00:00:00	YM	Futures	8538.1	8551.1	8536.3	8544.6	187.0
2009-08-06 01:00:00	YM	Futures	8543.7	8554.8	8542.7	8547.4	311.0

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

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