PREVIEW / futures_1hour / 2009-07-21

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-21.parquet
  size:    43 KB
  rows:    1,267

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-21 00:00:00	ES	Futures	912.09	913.05	911.85	912.57	1722.0
2009-07-21 01:00:00	ES	Futures	912.33	913.54	912.09	913.54	2098.0
2009-07-21 02:00:00	ES	Futures	913.54	914.02	911.61	911.85	8479.0
2009-07-21 03:00:00	ES	Futures	912.09	914.98	911.37	914.02	13907.0
2009-07-21 04:00:00	ES	Futures	914.26	915.47	913.3	914.5	12407.0
2009-07-21 05:00:00	ES	Futures	914.5	915.95	913.78	915.71	9144.0
2009-07-21 06:00:00	ES	Futures	915.71	917.39	915.22	915.95	16564.0
2009-07-21 07:00:00	ES	Futures	915.95	920.29	915.47	919.32	41934.0
2009-07-21 08:00:00	ES	Futures	919.32	920.05	918.36	919.57	42695.0
2009-07-21 09:00:00	ES	Futures	919.32	922.46	913.78	916.19	295093.0
2009-07-21 10:00:00	ES	Futures	916.43	918.12	911.61	915.95	334078.0
2009-07-21 11:00:00	ES	Futures	916.19	916.67	908.23	908.47	212788.0
2009-07-21 12:00:00	ES	Futures	908.71	910.64	907.75	908.71	129311.0
2009-07-21 13:00:00	ES	Futures	908.71	910.4	906.3	909.2	156833.0
2009-07-21 14:00:00	ES	Futures	909.2	913.3	908.95	913.05	199734.0
2009-07-21 15:00:00	ES	Futures	913.3	917.64	912.33	917.64	285347.0
2009-07-21 16:00:00	ES	Futures	917.39	921.74	915.71	921.49	118123.0
2009-07-21 17:00:00	ES	Futures	921.74	921.74	919.81	920.29	3948.0
2009-07-21 18:00:00	ES	Futures	920.29	921.25	919.57	920.05	4585.0
2009-07-21 19:00:00	ES	Futures	920.05	920.53	917.88	917.88	3511.0
2009-07-21 20:00:00	ES	Futures	918.12	918.36	916.43	917.15	6686.0
2009-07-21 21:00:00	ES	Futures	917.15	917.64	916.43	917.15	2461.0
2009-07-21 22:00:00	ES	Futures	917.15	917.88	916.91	917.39	3020.0
2009-07-21 23:00:00	ES	Futures	917.15	918.84	916.91	918.6	3282.0
2009-07-21 00:00:00	NQ	Futures	1748.74	1751.3	1748.45	1749.88	225.0
2009-07-21 01:00:00	NQ	Futures	1749.88	1751.87	1749.59	1751.87	133.0
2009-07-21 02:00:00	NQ	Futures	1751.3	1751.87	1749.02	1749.31	499.0
2009-07-21 03:00:00	NQ	Futures	1749.02	1754.15	1748.45	1753.29	1038.0
2009-07-21 04:00:00	NQ	Futures	1753.58	1755.0	1751.3	1754.15	1410.0
2009-07-21 05:00:00	NQ	Futures	1754.15	1756.43	1753.86	1756.14	1029.0
2009-07-21 06:00:00	NQ	Futures	1756.14	1758.13	1754.43	1755.57	1781.0
2009-07-21 07:00:00	NQ	Futures	1755.29	1762.98	1753.86	1759.84	4171.0
2009-07-21 08:00:00	NQ	Futures	1759.84	1761.27	1757.0	1758.99	4090.0
2009-07-21 09:00:00	NQ	Futures	1758.7	1762.98	1747.31	1751.58	43627.0
2009-07-21 10:00:00	NQ	Futures	1751.87	1758.99	1743.89	1755.57	53295.0
2009-07-21 11:00:00	NQ	Futures	1755.86	1757.28	1743.61	1745.03	35311.0
2009-07-21 12:00:00	NQ	Futures	1745.32	1749.02	1743.04	1745.32	22457.0
2009-07-21 13:00:00	NQ	Futures	1745.32	1751.87	1741.05	1748.45	30151.0
2009-07-21 14:00:00	NQ	Futures	1748.45	1757.85	1747.88	1757.57	30160.0
2009-07-21 15:00:00	NQ	Futures	1757.57	1766.11	1755.86	1766.11	50899.0
2009-07-21 16:00:00	NQ	Futures	1765.82	1776.93	1759.84	1776.93	23594.0
2009-07-21 17:00:00	NQ	Futures	1776.65	1777.22	1774.08	1776.08	889.0
2009-07-21 18:00:00	NQ	Futures	1776.36	1777.79	1774.94	1776.08	696.0
2009-07-21 19:00:00	NQ	Futures	1775.79	1777.22	1773.8	1774.94	595.0
2009-07-21 20:00:00	NQ	Futures	1774.37	1774.37	1770.67	1770.67	1190.0
2009-07-21 21:00:00	NQ	Futures	1770.95	1772.09	1770.67	1771.81	504.0
2009-07-21 22:00:00	NQ	Futures	1771.81	1772.94	1771.52	1772.38	276.0
2009-07-21 23:00:00	NQ	Futures	1772.66	1774.65	1772.09	1774.37	561.0
2009-07-21 00:00:00	YM	Futures	8114.6	8122.0	8113.7	8117.4	51.0
2009-07-21 01:00:00	YM	Futures	8117.4	8125.7	8116.5	8124.8	78.0

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

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