PREVIEW / futures_1hour / 2009-08-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	962.98	963.7	962.49	962.73	3033.0
2009-08-17 01:00:00	ES	Futures	962.73	962.98	959.84	960.08	7400.0
2009-08-17 02:00:00	ES	Futures	960.32	960.32	957.91	958.15	15839.0
2009-08-17 03:00:00	ES	Futures	958.15	958.39	955.26	955.5	28164.0
2009-08-17 04:00:00	ES	Futures	955.74	955.74	948.02	949.71	55776.0
2009-08-17 05:00:00	ES	Futures	949.47	952.36	947.78	951.16	30896.0
2009-08-17 06:00:00	ES	Futures	951.16	952.36	948.26	948.99	20651.0
2009-08-17 07:00:00	ES	Futures	948.99	949.71	945.61	947.3	51650.0
2009-08-17 08:00:00	ES	Futures	947.54	953.09	947.3	951.16	70126.0
2009-08-17 09:00:00	ES	Futures	951.4	952.85	942.96	946.09	362920.0
2009-08-17 10:00:00	ES	Futures	945.85	947.06	943.92	944.89	358588.0
2009-08-17 11:00:00	ES	Futures	944.89	948.51	942.72	947.54	251105.0
2009-08-17 12:00:00	ES	Futures	947.78	948.02	945.85	946.33	132730.0
2009-08-17 13:00:00	ES	Futures	946.33	947.54	944.16	947.06	151555.0
2009-08-17 14:00:00	ES	Futures	947.06	947.3	944.65	945.61	119909.0
2009-08-17 15:00:00	ES	Futures	945.37	947.06	941.99	943.44	349033.0
2009-08-17 16:00:00	ES	Futures	943.44	944.65	941.03	943.68	161562.0
2009-08-17 17:00:00	ES	Futures	943.44	944.89	942.23	942.48	2397.0
2009-08-17 18:00:00	ES	Futures	942.23	943.2	942.23	943.2	1912.0
2009-08-17 19:00:00	ES	Futures	943.2	944.65	942.72	944.16	2108.0
2009-08-17 20:00:00	ES	Futures	944.16	946.09	943.92	945.37	8397.0
2009-08-17 21:00:00	ES	Futures	945.37	947.06	945.37	947.06	6777.0
2009-08-17 22:00:00	ES	Futures	947.3	948.75	945.85	946.09	7751.0
2009-08-17 23:00:00	ES	Futures	946.09	946.09	943.2	944.41	5763.0
2009-08-17 00:00:00	NQ	Futures	1827.06	1827.63	1825.63	1826.49	166.0
2009-08-17 01:00:00	NQ	Futures	1826.49	1826.49	1822.79	1823.36	522.0
2009-08-17 02:00:00	NQ	Futures	1823.07	1823.64	1819.94	1820.51	787.0
2009-08-17 03:00:00	NQ	Futures	1820.51	1821.36	1814.53	1815.38	1941.0
2009-08-17 04:00:00	NQ	Futures	1815.38	1815.67	1800.86	1804.84	6467.0
2009-08-17 05:00:00	NQ	Futures	1804.84	1809.4	1802.28	1806.84	2377.0
2009-08-17 06:00:00	NQ	Futures	1807.12	1809.69	1803.99	1804.84	1316.0
2009-08-17 07:00:00	NQ	Futures	1805.13	1806.55	1800.29	1802.28	4015.0
2009-08-17 08:00:00	NQ	Futures	1802.0	1814.24	1802.0	1809.4	11427.0
2009-08-17 09:00:00	NQ	Futures	1809.4	1811.68	1788.61	1798.29	73793.0
2009-08-17 10:00:00	NQ	Futures	1798.01	1798.86	1788.61	1789.46	56528.0
2009-08-17 11:00:00	NQ	Futures	1789.46	1792.6	1783.2	1790.32	47581.0
2009-08-17 12:00:00	NQ	Futures	1790.6	1791.17	1787.47	1788.61	21409.0
2009-08-17 13:00:00	NQ	Futures	1788.61	1789.18	1782.63	1788.61	35835.0
2009-08-17 14:00:00	NQ	Futures	1788.61	1788.61	1782.63	1784.34	22410.0
2009-08-17 15:00:00	NQ	Futures	1784.34	1787.47	1778.93	1780.07	60340.0
2009-08-17 16:00:00	NQ	Futures	1780.35	1785.48	1778.64	1784.91	17390.0
2009-08-17 17:00:00	NQ	Futures	1784.62	1785.76	1782.06	1782.06	407.0
2009-08-17 18:00:00	NQ	Futures	1782.34	1783.2	1781.77	1782.91	405.0
2009-08-17 19:00:00	NQ	Futures	1782.63	1785.19	1782.34	1784.34	143.0
2009-08-17 20:00:00	NQ	Futures	1784.62	1789.18	1784.62	1788.32	653.0
2009-08-17 21:00:00	NQ	Futures	1788.32	1790.89	1788.04	1790.6	844.0
2009-08-17 22:00:00	NQ	Futures	1790.89	1795.73	1790.6	1792.03	1133.0
2009-08-17 23:00:00	NQ	Futures	1791.74	1791.74	1786.33	1787.47	327.0
2009-08-17 00:00:00	YM	Futures	8555.7	8563.1	8552.0	8556.6	185.0
2009-08-17 01:00:00	YM	Futures	8555.7	8556.6	8533.5	8534.4	683.0

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

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