PREVIEW / futures_1hour / 2009-07-22

all futures 1-hour files

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

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-22 00:00:00	ES	Futures	918.6	919.08	918.12	918.84	3360.0
2009-07-22 01:00:00	ES	Futures	918.84	919.57	918.36	918.84	1609.0
2009-07-22 02:00:00	ES	Futures	919.08	919.08	917.15	917.39	4608.0
2009-07-22 03:00:00	ES	Futures	917.39	917.39	913.05	914.26	23052.0
2009-07-22 04:00:00	ES	Futures	914.26	914.98	911.85	914.02	15611.0
2009-07-22 05:00:00	ES	Futures	913.78	915.95	913.05	915.47	10843.0
2009-07-22 06:00:00	ES	Futures	915.71	916.91	914.26	915.22	12953.0
2009-07-22 07:00:00	ES	Futures	915.47	917.39	914.74	916.91	18438.0
2009-07-22 08:00:00	ES	Futures	916.67	917.39	910.16	911.85	59008.0
2009-07-22 09:00:00	ES	Futures	912.09	918.84	911.12	917.88	331167.0
2009-07-22 10:00:00	ES	Futures	917.64	920.77	914.26	918.12	357226.0
2009-07-22 11:00:00	ES	Futures	917.88	919.81	915.71	917.15	215363.0
2009-07-22 12:00:00	ES	Futures	917.15	922.94	916.19	921.01	183327.0
2009-07-22 13:00:00	ES	Futures	921.25	922.94	917.64	919.81	147430.0
2009-07-22 14:00:00	ES	Futures	920.05	921.01	917.15	919.81	190550.0
2009-07-22 15:00:00	ES	Futures	919.57	920.53	914.74	917.15	328571.0
2009-07-22 16:00:00	ES	Futures	917.15	917.88	914.98	916.91	93552.0
2009-07-22 17:00:00	ES	Futures	917.15	917.15	915.71	915.95	2881.0
2009-07-22 18:00:00	ES	Futures	915.95	916.43	915.47	915.71	1946.0
2009-07-22 19:00:00	ES	Futures	915.95	916.67	915.47	915.71	2080.0
2009-07-22 20:00:00	ES	Futures	915.47	916.19	915.47	915.71	1615.0
2009-07-22 21:00:00	ES	Futures	915.71	915.95	915.22	915.95	3363.0
2009-07-22 22:00:00	ES	Futures	915.95	919.08	915.95	918.6	4532.0
2009-07-22 23:00:00	ES	Futures	918.6	920.29	918.36	919.57	5421.0
2009-07-22 00:00:00	NQ	Futures	1774.37	1774.94	1773.8	1774.08	219.0
2009-07-22 01:00:00	NQ	Futures	1774.08	1774.94	1772.94	1773.23	347.0
2009-07-22 02:00:00	NQ	Futures	1772.94	1773.23	1768.96	1769.53	784.0
2009-07-22 03:00:00	NQ	Futures	1769.53	1769.53	1762.69	1764.12	1980.0
2009-07-22 04:00:00	NQ	Futures	1764.69	1766.11	1760.41	1763.55	1811.0
2009-07-22 05:00:00	NQ	Futures	1763.26	1767.82	1761.55	1767.25	839.0
2009-07-22 06:00:00	NQ	Futures	1767.25	1770.1	1764.69	1766.68	1064.0
2009-07-22 07:00:00	NQ	Futures	1766.68	1772.38	1765.82	1771.24	2458.0
2009-07-22 08:00:00	NQ	Futures	1771.52	1772.09	1761.84	1764.12	6006.0
2009-07-22 09:00:00	NQ	Futures	1764.4	1781.49	1763.83	1778.64	48833.0
2009-07-22 10:00:00	NQ	Futures	1778.64	1782.91	1767.82	1775.79	52653.0
2009-07-22 11:00:00	NQ	Futures	1775.79	1781.77	1773.51	1778.64	31557.0
2009-07-22 12:00:00	NQ	Futures	1778.64	1790.03	1777.79	1784.91	36345.0
2009-07-22 13:00:00	NQ	Futures	1784.62	1787.47	1778.07	1781.2	26454.0
2009-07-22 14:00:00	NQ	Futures	1781.2	1784.05	1776.08	1783.48	29972.0
2009-07-22 15:00:00	NQ	Futures	1783.48	1785.48	1774.65	1780.35	47127.0
2009-07-22 16:00:00	NQ	Futures	1780.35	1783.77	1771.81	1775.51	21292.0
2009-07-22 17:00:00	NQ	Futures	1775.79	1776.08	1772.38	1772.94	811.0
2009-07-22 18:00:00	NQ	Futures	1772.66	1773.23	1771.52	1772.66	800.0
2009-07-22 19:00:00	NQ	Futures	1772.38	1774.37	1772.38	1772.94	242.0
2009-07-22 20:00:00	NQ	Futures	1773.23	1773.51	1772.38	1772.38	135.0
2009-07-22 21:00:00	NQ	Futures	1772.38	1772.66	1772.09	1772.38	688.0
2009-07-22 22:00:00	NQ	Futures	1772.66	1777.79	1772.66	1777.22	798.0
2009-07-22 23:00:00	NQ	Futures	1777.22	1779.5	1776.93	1778.93	586.0
2009-07-22 00:00:00	YM	Futures	8199.7	8206.2	8196.9	8200.6	77.0
2009-07-22 01:00:00	YM	Futures	8203.4	8209.9	8200.6	8208.0	155.0

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

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