PREVIEW / futures_1hour / 2009-08-07

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-08-07.parquet
  size:    37 KB
  rows:    1,030

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-07 00:00:00	ES	Futures	957.91	958.88	957.67	958.88	1496.0
2009-08-07 01:00:00	ES	Futures	958.88	959.6	957.19	959.6	3742.0
2009-08-07 02:00:00	ES	Futures	959.36	960.56	958.88	960.08	5843.0
2009-08-07 03:00:00	ES	Futures	959.84	959.84	956.22	956.22	14211.0
2009-08-07 04:00:00	ES	Futures	956.22	957.91	955.02	956.7	19053.0
2009-08-07 05:00:00	ES	Futures	956.46	957.91	955.98	956.22	7147.0
2009-08-07 06:00:00	ES	Futures	956.22	956.95	955.02	956.22	11064.0
2009-08-07 07:00:00	ES	Futures	956.46	959.36	955.98	958.39	16216.0
2009-08-07 08:00:00	ES	Futures	958.63	969.25	957.67	967.56	179726.0
2009-08-07 09:00:00	ES	Futures	967.32	972.14	966.35	966.59	306032.0
2009-08-07 10:00:00	ES	Futures	966.59	976.0	964.18	975.27	412421.0
2009-08-07 11:00:00	ES	Futures	975.03	977.2	972.62	975.03	205361.0
2009-08-07 12:00:00	ES	Futures	974.79	977.2	973.83	976.24	111047.0
2009-08-07 13:00:00	ES	Futures	976.24	980.1	976.0	978.17	129556.0
2009-08-07 14:00:00	ES	Futures	977.93	978.89	976.0	976.48	89154.0
2009-08-07 15:00:00	ES	Futures	976.24	976.48	971.66	971.66	348576.0
2009-08-07 16:00:00	ES	Futures	971.9	971.9	969.97	970.45	99026.0
2009-08-07 00:00:00	NQ	Futures	1822.5	1823.93	1822.22	1823.93	166.0
2009-08-07 01:00:00	NQ	Futures	1823.36	1824.78	1821.65	1824.21	680.0
2009-08-07 02:00:00	NQ	Futures	1824.78	1826.2	1823.93	1824.78	545.0
2009-08-07 03:00:00	NQ	Futures	1825.07	1825.63	1819.65	1819.65	1138.0
2009-08-07 04:00:00	NQ	Futures	1819.94	1821.36	1817.38	1819.08	1610.0
2009-08-07 05:00:00	NQ	Futures	1819.08	1823.07	1819.08	1820.51	1219.0
2009-08-07 06:00:00	NQ	Futures	1820.22	1821.93	1818.51	1820.79	710.0
2009-08-07 07:00:00	NQ	Futures	1821.08	1825.63	1819.08	1823.64	1570.0
2009-08-07 08:00:00	NQ	Futures	1823.93	1847.28	1823.64	1844.43	20356.0
2009-08-07 09:00:00	NQ	Futures	1844.15	1852.69	1838.17	1838.45	55889.0
2009-08-07 10:00:00	NQ	Futures	1838.17	1850.98	1832.19	1848.99	58739.0
2009-08-07 11:00:00	NQ	Futures	1848.99	1854.4	1846.14	1849.56	31534.0
2009-08-07 12:00:00	NQ	Futures	1849.56	1852.12	1846.71	1849.84	16764.0
2009-08-07 13:00:00	NQ	Futures	1850.13	1854.4	1849.27	1851.84	19674.0
2009-08-07 14:00:00	NQ	Futures	1851.84	1853.83	1848.13	1848.7	15303.0
2009-08-07 15:00:00	NQ	Futures	1848.7	1849.56	1842.72	1845.0	42498.0
2009-08-07 16:00:00	NQ	Futures	1845.29	1845.57	1842.15	1844.72	10109.0
2009-08-07 00:00:00	YM	Futures	8517.8	8528.9	8515.9	8527.9	144.0
2009-08-07 01:00:00	YM	Futures	8527.9	8536.3	8515.9	8534.4	298.0
2009-08-07 02:00:00	YM	Futures	8533.5	8540.9	8529.8	8532.6	335.0
2009-08-07 03:00:00	YM	Futures	8535.3	8536.3	8508.5	8508.5	1140.0
2009-08-07 04:00:00	YM	Futures	8507.6	8517.8	8498.4	8508.5	978.0
2009-08-07 05:00:00	YM	Futures	8506.7	8518.7	8503.9	8505.8	334.0
2009-08-07 06:00:00	YM	Futures	8505.8	8513.1	8498.4	8503.0	649.0
2009-08-07 07:00:00	YM	Futures	8502.1	8525.2	8499.3	8520.5	867.0
2009-08-07 08:00:00	YM	Futures	8519.6	8601.9	8514.1	8587.1	7147.0
2009-08-07 09:00:00	YM	Futures	8588.0	8626.0	8579.7	8580.6	19376.0
2009-08-07 10:00:00	YM	Futures	8580.6	8667.6	8564.9	8659.2	31516.0
2009-08-07 11:00:00	YM	Futures	8659.2	8675.9	8634.3	8651.8	14780.0
2009-08-07 12:00:00	YM	Futures	8651.8	8670.3	8642.6	8663.9	7420.0
2009-08-07 13:00:00	YM	Futures	8662.9	8695.3	8662.9	8680.5	10748.0
2009-08-07 14:00:00	YM	Futures	8679.6	8687.0	8665.7	8666.6	6237.0
2009-08-07 15:00:00	YM	Futures	8668.5	8668.5	8628.7	8629.7	20287.0

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

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