PREVIEW / futures_1hour / 2009-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-23.parquet
  size:    44 KB
  rows:    1,275

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-07-23 00:00:00	ES	Futures	919.57	919.81	918.6	919.57	2106.0
2009-07-23 01:00:00	ES	Futures	919.81	920.29	917.64	918.12	3319.0
2009-07-23 02:00:00	ES	Futures	918.12	920.29	918.12	919.81	7180.0
2009-07-23 03:00:00	ES	Futures	919.57	920.53	917.39	918.84	12791.0
2009-07-23 04:00:00	ES	Futures	919.08	920.05	917.64	919.32	13586.0
2009-07-23 05:00:00	ES	Futures	919.32	920.05	918.36	918.84	5908.0
2009-07-23 06:00:00	ES	Futures	918.84	919.57	916.67	917.39	10215.0
2009-07-23 07:00:00	ES	Futures	917.39	921.74	917.15	920.53	23913.0
2009-07-23 08:00:00	ES	Futures	920.53	922.7	918.36	918.6	53999.0
2009-07-23 09:00:00	ES	Futures	918.6	926.32	917.15	926.08	261869.0
2009-07-23 10:00:00	ES	Futures	926.08	934.52	923.42	933.07	541529.0
2009-07-23 11:00:00	ES	Futures	933.07	939.1	932.83	936.45	286976.0
2009-07-23 12:00:00	ES	Futures	936.69	940.06	936.45	939.82	176351.0
2009-07-23 13:00:00	ES	Futures	940.06	941.75	937.89	938.86	180235.0
2009-07-23 14:00:00	ES	Futures	938.86	940.79	937.89	940.06	177034.0
2009-07-23 15:00:00	ES	Futures	940.06	941.99	936.21	937.89	388635.0
2009-07-23 16:00:00	ES	Futures	938.14	939.34	929.45	929.94	140961.0
2009-07-23 17:00:00	ES	Futures	929.94	930.9	928.73	930.66	7151.0
2009-07-23 18:00:00	ES	Futures	930.18	931.38	929.69	930.9	2764.0
2009-07-23 19:00:00	ES	Futures	931.14	931.38	930.66	930.9	2203.0
2009-07-23 20:00:00	ES	Futures	931.14	931.14	929.69	930.18	4172.0
2009-07-23 21:00:00	ES	Futures	930.18	931.38	929.94	930.66	4148.0
2009-07-23 22:00:00	ES	Futures	930.66	930.9	929.69	930.66	3007.0
2009-07-23 23:00:00	ES	Futures	930.42	931.14	929.45	929.45	2680.0
2009-07-23 00:00:00	NQ	Futures	1778.64	1780.07	1777.79	1780.07	329.0
2009-07-23 01:00:00	NQ	Futures	1779.78	1780.63	1776.65	1776.93	266.0
2009-07-23 02:00:00	NQ	Futures	1778.07	1781.2	1776.93	1780.63	820.0
2009-07-23 03:00:00	NQ	Futures	1780.07	1781.49	1777.22	1778.64	1346.0
2009-07-23 04:00:00	NQ	Futures	1779.21	1782.06	1777.22	1780.63	878.0
2009-07-23 05:00:00	NQ	Futures	1780.63	1781.2	1778.64	1779.5	455.0
2009-07-23 06:00:00	NQ	Futures	1780.07	1780.07	1775.22	1776.36	1554.0
2009-07-23 07:00:00	NQ	Futures	1776.36	1782.63	1776.08	1780.07	1754.0
2009-07-23 08:00:00	NQ	Futures	1780.35	1783.77	1776.93	1777.5	5493.0
2009-07-23 09:00:00	NQ	Futures	1777.22	1797.44	1775.22	1796.58	46291.0
2009-07-23 10:00:00	NQ	Futures	1796.87	1811.11	1792.6	1806.55	74974.0
2009-07-23 11:00:00	NQ	Futures	1806.55	1820.79	1806.27	1815.67	56015.0
2009-07-23 12:00:00	NQ	Futures	1815.67	1823.93	1815.38	1823.36	30578.0
2009-07-23 13:00:00	NQ	Futures	1823.36	1827.06	1819.65	1821.36	25543.0
2009-07-23 14:00:00	NQ	Futures	1821.65	1824.78	1818.51	1823.07	27803.0
2009-07-23 15:00:00	NQ	Futures	1823.07	1827.06	1816.81	1820.79	52783.0
2009-07-23 16:00:00	NQ	Futures	1820.79	1821.08	1791.74	1792.31	27174.0
2009-07-23 17:00:00	NQ	Futures	1792.03	1795.16	1790.89	1794.31	1759.0
2009-07-23 18:00:00	NQ	Futures	1794.31	1796.58	1793.17	1796.3	916.0
2009-07-23 19:00:00	NQ	Futures	1796.01	1796.58	1794.31	1795.73	355.0
2009-07-23 20:00:00	NQ	Futures	1796.01	1796.58	1792.88	1793.74	804.0
2009-07-23 21:00:00	NQ	Futures	1793.45	1794.88	1793.45	1794.31	488.0
2009-07-23 22:00:00	NQ	Futures	1793.74	1794.02	1792.31	1793.45	282.0
2009-07-23 23:00:00	NQ	Futures	1793.74	1794.31	1790.89	1792.6	865.0
2009-07-23 00:00:00	YM	Futures	8199.7	8201.5	8192.3	8199.7	88.0
2009-07-23 01:00:00	YM	Futures	8200.6	8204.3	8183.1	8186.8	261.0

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

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