PREVIEW / futures_1hour / 2009-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-15.parquet
  size:    45 KB
  rows:    1,287

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-15 00:00:00	ES	Futures	878.81	879.05	877.36	877.36	3452.0
2009-07-15 01:00:00	ES	Futures	877.36	878.81	876.64	877.6	3695.0
2009-07-15 02:00:00	ES	Futures	877.36	877.84	876.4	876.88	10351.0
2009-07-15 03:00:00	ES	Futures	876.88	878.33	876.4	877.12	17215.0
2009-07-15 04:00:00	ES	Futures	877.36	879.29	876.64	878.81	12480.0
2009-07-15 05:00:00	ES	Futures	878.81	880.26	878.81	879.77	10909.0
2009-07-15 06:00:00	ES	Futures	880.01	881.7	879.53	880.01	19197.0
2009-07-15 07:00:00	ES	Futures	880.01	880.74	877.6	879.53	24197.0
2009-07-15 08:00:00	ES	Futures	879.53	882.18	879.29	880.5	32873.0
2009-07-15 09:00:00	ES	Futures	880.5	885.08	880.26	884.11	269543.0
2009-07-15 10:00:00	ES	Futures	884.36	887.01	883.87	885.56	308719.0
2009-07-15 11:00:00	ES	Futures	885.32	890.63	885.32	888.7	243234.0
2009-07-15 12:00:00	ES	Futures	888.7	890.87	888.21	889.42	143744.0
2009-07-15 13:00:00	ES	Futures	889.66	892.8	889.18	891.83	120351.0
2009-07-15 14:00:00	ES	Futures	892.07	896.65	890.63	896.41	303903.0
2009-07-15 15:00:00	ES	Futures	896.17	897.86	893.28	895.93	452505.0
2009-07-15 16:00:00	ES	Futures	896.17	896.41	892.55	894.0	141152.0
2009-07-15 17:00:00	ES	Futures	894.0	894.97	893.76	894.73	2854.0
2009-07-15 18:00:00	ES	Futures	894.24	894.48	890.87	891.59	16476.0
2009-07-15 19:00:00	ES	Futures	891.59	892.31	890.63	891.83	7364.0
2009-07-15 20:00:00	ES	Futures	891.83	892.55	890.38	890.63	6351.0
2009-07-15 21:00:00	ES	Futures	890.63	891.83	890.14	891.35	5109.0
2009-07-15 22:00:00	ES	Futures	891.35	891.35	889.18	890.87	8590.0
2009-07-15 23:00:00	ES	Futures	890.87	892.07	889.18	889.9	5363.0
2009-07-15 00:00:00	NQ	Futures	1678.67	1678.67	1674.97	1675.54	326.0
2009-07-15 01:00:00	NQ	Futures	1675.82	1677.53	1674.12	1674.69	352.0
2009-07-15 02:00:00	NQ	Futures	1674.69	1674.69	1671.55	1671.55	938.0
2009-07-15 03:00:00	NQ	Futures	1671.84	1675.25	1670.41	1674.69	1558.0
2009-07-15 04:00:00	NQ	Futures	1674.69	1679.24	1673.83	1677.53	2190.0
2009-07-15 05:00:00	NQ	Futures	1677.82	1679.24	1677.82	1678.67	781.0
2009-07-15 06:00:00	NQ	Futures	1678.67	1682.09	1678.39	1679.24	1980.0
2009-07-15 07:00:00	NQ	Futures	1678.96	1680.38	1673.26	1676.96	3178.0
2009-07-15 08:00:00	NQ	Futures	1676.68	1678.67	1674.97	1676.68	3308.0
2009-07-15 09:00:00	NQ	Futures	1676.68	1691.2	1671.55	1684.65	87658.0
2009-07-15 10:00:00	NQ	Futures	1684.65	1694.05	1684.37	1691.77	48661.0
2009-07-15 11:00:00	NQ	Futures	1692.06	1700.03	1691.77	1695.76	41740.0
2009-07-15 12:00:00	NQ	Futures	1696.05	1699.46	1695.19	1696.9	18661.0
2009-07-15 13:00:00	NQ	Futures	1696.62	1702.88	1695.19	1700.89	18357.0
2009-07-15 14:00:00	NQ	Futures	1700.89	1707.44	1698.89	1706.87	41525.0
2009-07-15 15:00:00	NQ	Futures	1706.87	1708.29	1702.31	1706.87	55386.0
2009-07-15 16:00:00	NQ	Futures	1706.58	1707.72	1702.31	1704.02	12875.0
2009-07-15 17:00:00	NQ	Futures	1704.02	1705.73	1703.45	1704.59	447.0
2009-07-15 18:00:00	NQ	Futures	1704.31	1704.59	1699.18	1700.89	1256.0
2009-07-15 19:00:00	NQ	Futures	1700.89	1702.31	1698.61	1702.03	434.0
2009-07-15 20:00:00	NQ	Futures	1701.74	1702.03	1698.32	1698.61	249.0
2009-07-15 21:00:00	NQ	Futures	1698.61	1701.74	1698.32	1700.6	535.0
2009-07-15 22:00:00	NQ	Futures	1700.03	1700.89	1696.9	1700.89	989.0
2009-07-15 23:00:00	NQ	Futures	1700.32	1702.88	1696.9	1698.61	396.0
2009-07-15 00:00:00	YM	Futures	7742.9	7744.8	7730.9	7733.7	110.0
2009-07-15 01:00:00	YM	Futures	7732.8	7740.1	7723.5	7731.8	230.0

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

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