PREVIEW / futures_1hour / 2009-07-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	889.9	890.14	888.94	889.18	4450.0
2009-07-16 01:00:00	ES	Futures	888.94	889.42	888.7	889.18	5399.0
2009-07-16 02:00:00	ES	Futures	889.18	891.35	889.18	890.63	8078.0
2009-07-16 03:00:00	ES	Futures	890.87	893.28	889.42	889.9	25626.0
2009-07-16 04:00:00	ES	Futures	889.66	891.59	888.45	891.59	15239.0
2009-07-16 05:00:00	ES	Futures	891.59	893.04	890.63	892.55	8697.0
2009-07-16 06:00:00	ES	Futures	892.55	896.9	890.14	894.73	49406.0
2009-07-16 07:00:00	ES	Futures	894.48	895.45	891.59	891.83	25582.0
2009-07-16 08:00:00	ES	Futures	891.83	899.79	891.83	894.0	113690.0
2009-07-16 09:00:00	ES	Futures	894.0	898.1	892.07	896.65	218624.0
2009-07-16 10:00:00	ES	Futures	896.41	896.65	891.11	894.73	302767.0
2009-07-16 11:00:00	ES	Futures	894.73	896.17	892.07	895.69	148128.0
2009-07-16 12:00:00	ES	Futures	895.69	896.17	894.24	894.24	97579.0
2009-07-16 13:00:00	ES	Futures	894.48	898.1	893.04	898.1	188948.0
2009-07-16 14:00:00	ES	Futures	898.1	904.61	897.38	903.17	333523.0
2009-07-16 15:00:00	ES	Futures	903.17	907.51	901.48	904.13	442629.0
2009-07-16 16:00:00	ES	Futures	904.13	904.37	901.24	901.24	150922.0
2009-07-16 17:00:00	ES	Futures	901.48	901.72	900.51	900.51	2823.0
2009-07-16 18:00:00	ES	Futures	900.51	901.24	900.51	901.0	1998.0
2009-07-16 19:00:00	ES	Futures	901.0	901.0	900.03	900.51	1981.0
2009-07-16 20:00:00	ES	Futures	900.51	900.75	899.31	899.79	2950.0
2009-07-16 21:00:00	ES	Futures	899.79	899.79	898.34	898.58	4112.0
2009-07-16 22:00:00	ES	Futures	898.58	899.31	897.62	898.83	4495.0
2009-07-16 23:00:00	ES	Futures	898.83	900.51	898.58	899.79	2244.0
2009-07-16 00:00:00	NQ	Futures	1698.04	1699.18	1697.19	1697.47	263.0
2009-07-16 01:00:00	NQ	Futures	1697.47	1698.89	1696.9	1698.32	359.0
2009-07-16 02:00:00	NQ	Futures	1698.04	1702.03	1698.04	1700.6	451.0
2009-07-16 03:00:00	NQ	Futures	1700.6	1705.16	1698.04	1698.04	1812.0
2009-07-16 04:00:00	NQ	Futures	1698.04	1702.6	1696.33	1702.6	1262.0
2009-07-16 05:00:00	NQ	Futures	1702.6	1703.45	1700.32	1702.88	956.0
2009-07-16 06:00:00	NQ	Futures	1703.17	1707.15	1698.89	1705.16	3954.0
2009-07-16 07:00:00	NQ	Futures	1704.88	1706.01	1701.46	1702.31	2671.0
2009-07-16 08:00:00	NQ	Futures	1702.31	1708.58	1697.75	1698.61	9481.0
2009-07-16 09:00:00	NQ	Futures	1698.89	1717.69	1697.47	1715.98	49989.0
2009-07-16 10:00:00	NQ	Futures	1715.98	1716.55	1705.73	1710.29	47633.0
2009-07-16 11:00:00	NQ	Futures	1710.57	1715.98	1707.72	1714.56	25650.0
2009-07-16 12:00:00	NQ	Futures	1714.84	1715.7	1712.85	1712.85	15516.0
2009-07-16 13:00:00	NQ	Futures	1713.13	1721.11	1710.86	1720.82	23597.0
2009-07-16 14:00:00	NQ	Futures	1720.82	1727.66	1719.4	1725.38	35226.0
2009-07-16 15:00:00	NQ	Futures	1725.67	1731.93	1722.82	1728.23	51927.0
2009-07-16 16:00:00	NQ	Futures	1727.94	1729.65	1720.82	1720.82	21995.0
2009-07-16 17:00:00	NQ	Futures	1720.82	1721.68	1717.69	1717.98	979.0
2009-07-16 18:00:00	NQ	Futures	1717.12	1719.4	1717.12	1718.55	421.0
2009-07-16 19:00:00	NQ	Futures	1718.83	1719.12	1717.69	1718.55	190.0
2009-07-16 20:00:00	NQ	Futures	1717.98	1718.55	1716.84	1717.41	211.0
2009-07-16 21:00:00	NQ	Futures	1717.41	1717.41	1715.13	1715.7	356.0
2009-07-16 22:00:00	NQ	Futures	1715.7	1717.98	1714.27	1716.55	379.0
2009-07-16 23:00:00	NQ	Futures	1716.27	1718.83	1716.27	1717.12	193.0
2009-07-16 00:00:00	YM	Futures	7871.4	7873.3	7865.0	7865.0	151.0
2009-07-16 01:00:00	YM	Futures	7865.0	7869.6	7862.2	7866.8	402.0

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

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