PREVIEW / futures_1hour / 2009-07-14

all futures 1-hour files

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

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-14 00:00:00	ES	Futures	865.79	866.51	864.1	866.03	5179.0
2009-07-14 01:00:00	ES	Futures	865.79	866.51	865.3	866.03	2744.0
2009-07-14 02:00:00	ES	Futures	866.03	866.51	864.1	864.58	10488.0
2009-07-14 03:00:00	ES	Futures	864.58	866.03	861.93	865.54	25973.0
2009-07-14 04:00:00	ES	Futures	865.54	867.71	865.3	866.99	16957.0
2009-07-14 05:00:00	ES	Futures	866.75	867.96	864.82	866.75	11024.0
2009-07-14 06:00:00	ES	Futures	866.51	867.23	865.06	865.54	8630.0
2009-07-14 07:00:00	ES	Futures	865.3	871.57	864.58	870.85	35428.0
2009-07-14 08:00:00	ES	Futures	870.85	872.06	863.37	865.54	123953.0
2009-07-14 09:00:00	ES	Futures	865.54	869.64	862.89	863.86	324673.0
2009-07-14 10:00:00	ES	Futures	864.1	867.71	860.96	863.61	329900.0
2009-07-14 11:00:00	ES	Futures	863.61	870.13	863.13	869.16	240017.0
2009-07-14 12:00:00	ES	Futures	869.4	869.64	865.54	866.99	128134.0
2009-07-14 13:00:00	ES	Futures	866.99	868.68	866.27	866.99	106626.0
2009-07-14 14:00:00	ES	Futures	866.99	869.89	864.82	868.68	202091.0
2009-07-14 15:00:00	ES	Futures	868.68	870.61	867.71	870.37	320254.0
2009-07-14 16:00:00	ES	Futures	870.61	880.5	868.68	878.57	132279.0
2009-07-14 17:00:00	ES	Futures	878.81	879.53	877.6	879.29	5397.0
2009-07-14 18:00:00	ES	Futures	877.84	878.81	877.36	878.08	5613.0
2009-07-14 19:00:00	ES	Futures	878.08	878.08	877.36	877.84	2590.0
2009-07-14 20:00:00	ES	Futures	878.08	878.33	876.88	877.12	5703.0
2009-07-14 21:00:00	ES	Futures	877.12	877.84	876.4	877.12	3595.0
2009-07-14 22:00:00	ES	Futures	877.36	877.6	876.64	877.12	2767.0
2009-07-14 23:00:00	ES	Futures	877.12	879.29	877.12	879.05	4633.0
2009-07-14 00:00:00	NQ	Futures	1645.07	1646.49	1641.93	1645.35	58.0
2009-07-14 01:00:00	NQ	Futures	1645.35	1646.49	1643.93	1646.2	118.0
2009-07-14 02:00:00	NQ	Futures	1645.92	1646.77	1642.22	1642.5	537.0
2009-07-14 03:00:00	NQ	Futures	1642.5	1645.07	1637.94	1643.07	1890.0
2009-07-14 04:00:00	NQ	Futures	1643.07	1647.34	1643.07	1646.49	1689.0
2009-07-14 05:00:00	NQ	Futures	1646.49	1649.62	1643.36	1648.48	1604.0
2009-07-14 06:00:00	NQ	Futures	1648.48	1648.77	1644.5	1645.63	748.0
2009-07-14 07:00:00	NQ	Futures	1645.63	1651.33	1643.93	1651.05	2768.0
2009-07-14 08:00:00	NQ	Futures	1651.05	1654.75	1639.08	1640.22	12296.0
2009-07-14 09:00:00	NQ	Futures	1639.94	1654.46	1637.38	1641.08	44879.0
2009-07-14 10:00:00	NQ	Futures	1641.08	1650.19	1637.38	1643.36	41918.0
2009-07-14 11:00:00	NQ	Futures	1643.36	1653.61	1642.22	1652.19	29544.0
2009-07-14 12:00:00	NQ	Futures	1652.19	1652.47	1645.35	1649.05	15765.0
2009-07-14 13:00:00	NQ	Futures	1649.34	1652.19	1648.77	1649.34	17613.0
2009-07-14 14:00:00	NQ	Futures	1649.62	1655.6	1647.06	1653.89	29699.0
2009-07-14 15:00:00	NQ	Futures	1653.61	1654.75	1647.06	1651.9	46781.0
2009-07-14 16:00:00	NQ	Futures	1651.9	1679.81	1647.63	1677.82	18343.0
2009-07-14 17:00:00	NQ	Futures	1677.53	1678.1	1675.25	1677.25	2192.0
2009-07-14 18:00:00	NQ	Futures	1675.82	1676.39	1674.4	1675.82	663.0
2009-07-14 19:00:00	NQ	Futures	1676.11	1676.68	1675.54	1676.39	471.0
2009-07-14 20:00:00	NQ	Futures	1676.11	1676.68	1674.97	1675.54	721.0
2009-07-14 21:00:00	NQ	Futures	1675.54	1676.68	1674.12	1675.82	523.0
2009-07-14 22:00:00	NQ	Futures	1675.54	1676.11	1674.4	1674.97	240.0
2009-07-14 23:00:00	NQ	Futures	1675.25	1678.96	1674.4	1678.1	563.0
2009-07-14 00:00:00	YM	Futures	7654.2	7661.6	7643.1	7657.9	276.0
2009-07-14 01:00:00	YM	Futures	7656.0	7656.9	7651.4	7655.1	110.0

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

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