PREVIEW / futures_1hour / 2009-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-09-03.parquet
  size:    42 KB
  rows:    1,250

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-09-03 00:00:00	ES	Futures	959.36	960.32	958.88	960.32	1877.0
2009-09-03 01:00:00	ES	Futures	960.08	961.29	959.6	961.05	2521.0
2009-09-03 02:00:00	ES	Futures	961.05	964.9	961.05	964.66	13947.0
2009-09-03 03:00:00	ES	Futures	964.9	964.9	961.77	963.22	19819.0
2009-09-03 04:00:00	ES	Futures	963.46	964.9	962.49	964.9	10690.0
2009-09-03 05:00:00	ES	Futures	964.66	964.9	962.73	962.98	8362.0
2009-09-03 06:00:00	ES	Futures	962.98	964.66	962.73	964.18	12823.0
2009-09-03 07:00:00	ES	Futures	963.94	968.76	963.7	966.35	42016.0
2009-09-03 08:00:00	ES	Futures	966.59	968.04	963.46	964.66	58272.0
2009-09-03 09:00:00	ES	Futures	964.42	966.11	961.05	963.22	218255.0
2009-09-03 10:00:00	ES	Futures	963.22	965.87	956.22	960.32	340635.0
2009-09-03 11:00:00	ES	Futures	960.08	963.22	960.08	961.77	148937.0
2009-09-03 12:00:00	ES	Futures	961.53	962.98	960.8	961.53	66208.0
2009-09-03 13:00:00	ES	Futures	961.53	963.7	961.29	961.77	68524.0
2009-09-03 14:00:00	ES	Futures	962.01	962.73	959.12	960.8	74432.0
2009-09-03 15:00:00	ES	Futures	960.8	967.8	960.56	966.59	213058.0
2009-09-03 16:00:00	ES	Futures	966.35	967.8	965.63	966.59	63229.0
2009-09-03 17:00:00	ES	Futures	966.59	967.07	966.35	966.35	1219.0
2009-09-03 18:00:00	ES	Futures	966.59	967.07	966.59	966.59	1242.0
2009-09-03 19:00:00	ES	Futures	966.59	967.32	966.59	967.32	1152.0
2009-09-03 20:00:00	ES	Futures	967.07	967.56	966.11	966.35	3579.0
2009-09-03 21:00:00	ES	Futures	966.35	966.59	965.63	966.11	3817.0
2009-09-03 22:00:00	ES	Futures	966.11	966.11	965.39	965.63	3486.0
2009-09-03 23:00:00	ES	Futures	965.63	966.11	965.15	965.63	1566.0
2009-09-03 00:00:00	NQ	Futures	1815.95	1817.66	1815.1	1817.66	144.0
2009-09-03 01:00:00	NQ	Futures	1817.09	1819.65	1816.81	1818.8	251.0
2009-09-03 02:00:00	NQ	Futures	1818.8	1824.78	1818.51	1824.5	910.0
2009-09-03 03:00:00	NQ	Futures	1824.5	1825.35	1819.37	1822.22	1574.0
2009-09-03 04:00:00	NQ	Futures	1822.22	1826.2	1820.22	1826.2	1602.0
2009-09-03 05:00:00	NQ	Futures	1825.92	1825.92	1820.51	1821.08	752.0
2009-09-03 06:00:00	NQ	Futures	1821.08	1824.78	1820.51	1822.79	768.0
2009-09-03 07:00:00	NQ	Futures	1822.79	1832.47	1822.22	1827.91	3031.0
2009-09-03 08:00:00	NQ	Futures	1827.91	1829.91	1822.22	1825.07	4764.0
2009-09-03 09:00:00	NQ	Futures	1825.07	1827.34	1811.39	1816.24	41184.0
2009-09-03 10:00:00	NQ	Futures	1816.52	1821.93	1805.13	1815.95	50744.0
2009-09-03 11:00:00	NQ	Futures	1815.95	1821.36	1815.67	1820.79	21613.0
2009-09-03 12:00:00	NQ	Futures	1820.51	1824.21	1819.65	1821.08	14071.0
2009-09-03 13:00:00	NQ	Futures	1821.08	1826.77	1821.08	1823.07	11608.0
2009-09-03 14:00:00	NQ	Futures	1823.07	1824.21	1816.24	1820.79	12533.0
2009-09-03 15:00:00	NQ	Futures	1820.51	1831.33	1820.22	1828.48	32289.0
2009-09-03 16:00:00	NQ	Futures	1828.48	1830.48	1826.77	1829.05	9069.0
2009-09-03 17:00:00	NQ	Futures	1829.34	1830.19	1829.34	1829.62	146.0
2009-09-03 18:00:00	NQ	Futures	1829.62	1830.19	1829.05	1829.05	134.0
2009-09-03 19:00:00	NQ	Futures	1829.05	1830.76	1829.05	1830.76	111.0
2009-09-03 20:00:00	NQ	Futures	1830.19	1830.48	1829.05	1829.05	507.0
2009-09-03 21:00:00	NQ	Futures	1828.77	1829.34	1827.06	1827.91	376.0
2009-09-03 22:00:00	NQ	Futures	1827.91	1827.91	1826.49	1827.34	266.0
2009-09-03 23:00:00	NQ	Futures	1827.63	1827.91	1826.49	1827.06	202.0
2009-09-03 00:00:00	YM	Futures	8578.8	8588.0	8576.0	8585.3	159.0
2009-09-03 01:00:00	YM	Futures	8584.3	8594.5	8578.8	8592.7	164.0

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

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