PREVIEW / futures_1hour / 2009-08-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	944.65	944.65	942.96	943.44	4736.0
2009-08-18 01:00:00	ES	Futures	943.44	948.51	943.2	948.26	6212.0
2009-08-18 02:00:00	ES	Futures	948.02	949.47	947.06	948.99	11868.0
2009-08-18 03:00:00	ES	Futures	948.99	951.4	948.75	949.23	25880.0
2009-08-18 04:00:00	ES	Futures	949.23	950.68	947.78	950.19	15264.0
2009-08-18 05:00:00	ES	Futures	950.43	951.4	948.26	948.99	15575.0
2009-08-18 06:00:00	ES	Futures	948.99	950.68	948.75	949.71	13045.0
2009-08-18 07:00:00	ES	Futures	949.47	949.95	948.02	949.23	15112.0
2009-08-18 08:00:00	ES	Futures	948.99	950.68	945.61	946.09	74816.0
2009-08-18 09:00:00	ES	Futures	946.09	948.51	944.41	945.85	222088.0
2009-08-18 10:00:00	ES	Futures	945.85	950.43	945.85	947.54	265941.0
2009-08-18 11:00:00	ES	Futures	947.78	952.61	947.54	951.88	228350.0
2009-08-18 12:00:00	ES	Futures	952.12	954.05	951.64	952.85	164129.0
2009-08-18 13:00:00	ES	Futures	953.09	954.29	950.92	952.36	139757.0
2009-08-18 14:00:00	ES	Futures	952.12	954.78	952.12	953.09	126351.0
2009-08-18 15:00:00	ES	Futures	952.85	955.02	951.64	952.61	262994.0
2009-08-18 16:00:00	ES	Futures	952.61	955.02	951.4	953.81	125556.0
2009-08-18 17:00:00	ES	Futures	953.81	954.29	952.85	953.09	2741.0
2009-08-18 18:00:00	ES	Futures	953.33	953.57	952.85	953.09	1040.0
2009-08-18 19:00:00	ES	Futures	953.33	953.81	952.85	953.57	2493.0
2009-08-18 20:00:00	ES	Futures	953.57	953.81	952.36	952.85	3595.0
2009-08-18 21:00:00	ES	Futures	952.85	953.09	951.88	952.12	3909.0
2009-08-18 22:00:00	ES	Futures	952.12	953.33	951.88	952.85	4255.0
2009-08-18 23:00:00	ES	Futures	952.85	953.09	952.12	953.09	1844.0
2009-08-18 00:00:00	NQ	Futures	1787.19	1787.47	1784.05	1785.19	278.0
2009-08-18 01:00:00	NQ	Futures	1785.48	1794.59	1785.48	1793.45	416.0
2009-08-18 02:00:00	NQ	Futures	1794.02	1796.3	1791.46	1795.44	1055.0
2009-08-18 03:00:00	NQ	Futures	1795.16	1800.0	1794.31	1796.58	2254.0
2009-08-18 04:00:00	NQ	Futures	1796.58	1798.58	1793.45	1798.01	1393.0
2009-08-18 05:00:00	NQ	Futures	1798.29	1799.43	1794.88	1796.3	1196.0
2009-08-18 06:00:00	NQ	Futures	1796.3	1798.86	1796.01	1797.72	1923.0
2009-08-18 07:00:00	NQ	Futures	1797.72	1798.86	1794.88	1797.44	1960.0
2009-08-18 08:00:00	NQ	Futures	1797.44	1799.15	1790.32	1790.89	6182.0
2009-08-18 09:00:00	NQ	Futures	1790.89	1797.72	1786.33	1789.46	41004.0
2009-08-18 10:00:00	NQ	Futures	1789.46	1797.72	1789.46	1792.31	40715.0
2009-08-18 11:00:00	NQ	Futures	1792.03	1803.42	1792.03	1801.14	39969.0
2009-08-18 12:00:00	NQ	Futures	1801.14	1805.98	1800.86	1804.56	24644.0
2009-08-18 13:00:00	NQ	Futures	1804.56	1806.55	1800.29	1803.13	22554.0
2009-08-18 14:00:00	NQ	Futures	1802.85	1807.69	1802.57	1804.84	26252.0
2009-08-18 15:00:00	NQ	Futures	1804.84	1809.4	1803.7	1805.41	41683.0
2009-08-18 16:00:00	NQ	Futures	1805.41	1808.55	1804.27	1805.13	15139.0
2009-08-18 17:00:00	NQ	Futures	1805.13	1805.7	1803.13	1803.42	791.0
2009-08-18 18:00:00	NQ	Futures	1803.7	1803.99	1802.57	1803.42	292.0
2009-08-18 19:00:00	NQ	Futures	1803.42	1803.99	1802.57	1803.7	207.0
2009-08-18 20:00:00	NQ	Futures	1803.42	1804.27	1801.43	1802.85	534.0
2009-08-18 21:00:00	NQ	Futures	1803.13	1803.13	1800.29	1800.86	398.0
2009-08-18 22:00:00	NQ	Futures	1801.43	1803.7	1800.86	1802.28	626.0
2009-08-18 23:00:00	NQ	Futures	1802.28	1802.85	1801.14	1802.85	238.0
2009-08-18 00:00:00	YM	Futures	8442.0	8442.0	8428.1	8433.6	298.0
2009-08-18 01:00:00	YM	Futures	8433.6	8471.5	8433.6	8468.8	614.0

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

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