PREVIEW / futures_1hour / 2009-09-02

all futures 1-hour files

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

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-02 00:00:00	ES	Futures	961.29	963.22	960.8	962.73	3171.0
2009-09-02 01:00:00	ES	Futures	962.98	963.22	962.01	963.22	2808.0
2009-09-02 02:00:00	ES	Futures	963.22	965.39	962.98	964.42	12682.0
2009-09-02 03:00:00	ES	Futures	964.42	965.63	957.19	958.39	57076.0
2009-09-02 04:00:00	ES	Futures	958.39	961.29	957.19	961.05	24917.0
2009-09-02 05:00:00	ES	Futures	961.05	961.53	958.15	959.84	16725.0
2009-09-02 06:00:00	ES	Futures	959.84	961.53	959.36	961.29	14544.0
2009-09-02 07:00:00	ES	Futures	961.29	962.01	960.32	960.56	21227.0
2009-09-02 08:00:00	ES	Futures	960.8	961.53	956.7	958.15	95876.0
2009-09-02 09:00:00	ES	Futures	958.39	963.22	956.95	960.32	331257.0
2009-09-02 10:00:00	ES	Futures	960.32	964.18	955.98	963.46	423573.0
2009-09-02 11:00:00	ES	Futures	963.7	964.42	961.05	961.53	184328.0
2009-09-02 12:00:00	ES	Futures	961.29	963.94	960.08	962.98	121014.0
2009-09-02 13:00:00	ES	Futures	962.98	963.46	960.8	961.05	77841.0
2009-09-02 14:00:00	ES	Futures	961.29	963.94	960.32	961.53	136620.0
2009-09-02 15:00:00	ES	Futures	961.53	964.18	958.15	958.39	247647.0
2009-09-02 16:00:00	ES	Futures	958.39	959.36	957.67	958.63	83021.0
2009-09-02 17:00:00	ES	Futures	958.63	958.88	958.15	958.88	943.0
2009-09-02 18:00:00	ES	Futures	958.63	959.12	957.91	958.15	2270.0
2009-09-02 19:00:00	ES	Futures	958.15	959.84	958.15	959.36	1225.0
2009-09-02 20:00:00	ES	Futures	959.36	959.84	956.7	957.67	4828.0
2009-09-02 21:00:00	ES	Futures	957.67	959.36	957.19	959.36	3736.0
2009-09-02 22:00:00	ES	Futures	959.12	961.29	958.88	960.56	5224.0
2009-09-02 23:00:00	ES	Futures	960.56	961.05	959.36	959.36	3063.0
2009-09-02 00:00:00	NQ	Futures	1817.66	1820.51	1816.81	1819.08	445.0
2009-09-02 01:00:00	NQ	Futures	1819.37	1820.79	1817.94	1820.79	401.0
2009-09-02 02:00:00	NQ	Futures	1820.79	1822.79	1819.08	1820.51	1317.0
2009-09-02 03:00:00	NQ	Futures	1820.51	1822.22	1805.98	1807.98	5866.0
2009-09-02 04:00:00	NQ	Futures	1807.98	1812.25	1805.98	1811.96	3708.0
2009-09-02 05:00:00	NQ	Futures	1811.96	1813.96	1808.26	1809.4	2561.0
2009-09-02 06:00:00	NQ	Futures	1809.69	1813.96	1808.55	1813.96	2267.0
2009-09-02 07:00:00	NQ	Futures	1814.24	1815.67	1813.1	1813.96	1965.0
2009-09-02 08:00:00	NQ	Futures	1814.24	1815.38	1808.26	1811.39	7315.0
2009-09-02 09:00:00	NQ	Futures	1811.39	1825.35	1805.98	1817.09	56593.0
2009-09-02 10:00:00	NQ	Futures	1817.09	1824.78	1809.97	1823.64	59318.0
2009-09-02 11:00:00	NQ	Futures	1823.64	1825.92	1819.08	1820.22	29694.0
2009-09-02 12:00:00	NQ	Futures	1820.22	1825.07	1816.52	1822.22	26429.0
2009-09-02 13:00:00	NQ	Futures	1822.22	1823.36	1818.51	1818.8	13352.0
2009-09-02 14:00:00	NQ	Futures	1819.08	1824.21	1817.09	1821.36	21845.0
2009-09-02 15:00:00	NQ	Futures	1821.08	1826.2	1814.24	1816.24	35428.0
2009-09-02 16:00:00	NQ	Futures	1815.95	1816.52	1812.82	1814.24	7638.0
2009-09-02 17:00:00	NQ	Futures	1813.96	1814.81	1813.1	1814.81	207.0
2009-09-02 18:00:00	NQ	Futures	1815.38	1815.38	1813.1	1813.67	134.0
2009-09-02 19:00:00	NQ	Futures	1813.96	1816.81	1813.39	1816.52	190.0
2009-09-02 20:00:00	NQ	Futures	1816.52	1817.66	1810.54	1812.82	586.0
2009-09-02 21:00:00	NQ	Futures	1812.82	1815.67	1811.96	1815.38	426.0
2009-09-02 22:00:00	NQ	Futures	1815.67	1819.37	1815.1	1817.94	421.0
2009-09-02 23:00:00	NQ	Futures	1818.23	1818.8	1815.67	1815.67	196.0
2009-09-02 00:00:00	YM	Futures	8602.8	8615.8	8596.4	8613.0	288.0
2009-09-02 01:00:00	YM	Futures	8613.0	8616.7	8605.6	8616.7	248.0

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

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