PREVIEW / futures_1hour / 2009-07-07

all futures 1-hour files

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

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-07 00:00:00	ES	Futures	863.61	863.61	862.65	862.89	1688.0
2009-07-07 01:00:00	ES	Futures	863.13	863.13	861.93	862.17	1403.0
2009-07-07 02:00:00	ES	Futures	862.17	862.41	860.72	861.44	7947.0
2009-07-07 03:00:00	ES	Futures	861.44	861.69	858.07	859.03	20328.0
2009-07-07 04:00:00	ES	Futures	858.79	864.34	858.79	864.1	17167.0
2009-07-07 05:00:00	ES	Futures	864.1	864.82	862.89	864.82	10145.0
2009-07-07 06:00:00	ES	Futures	864.82	866.51	864.34	865.3	13177.0
2009-07-07 07:00:00	ES	Futures	865.3	866.03	863.13	863.13	12110.0
2009-07-07 08:00:00	ES	Futures	863.37	863.37	860.48	861.2	25151.0
2009-07-07 09:00:00	ES	Futures	861.2	861.93	857.83	859.52	230586.0
2009-07-07 10:00:00	ES	Futures	859.27	859.52	854.21	855.17	263613.0
2009-07-07 11:00:00	ES	Futures	855.17	857.1	852.04	853.73	197909.0
2009-07-07 12:00:00	ES	Futures	853.73	853.97	851.07	852.52	115262.0
2009-07-07 13:00:00	ES	Futures	852.52	856.86	852.04	854.45	190323.0
2009-07-07 14:00:00	ES	Futures	854.21	854.69	849.39	850.35	186049.0
2009-07-07 15:00:00	ES	Futures	850.11	850.35	844.32	845.05	469973.0
2009-07-07 16:00:00	ES	Futures	845.29	848.66	844.8	847.22	151154.0
2009-07-07 17:00:00	ES	Futures	846.97	847.22	846.49	846.73	1716.0
2009-07-07 18:00:00	ES	Futures	847.22	847.46	846.49	846.73	2892.0
2009-07-07 19:00:00	ES	Futures	846.73	847.94	846.49	846.73	2736.0
2009-07-07 20:00:00	ES	Futures	846.73	848.66	846.73	846.97	4612.0
2009-07-07 21:00:00	ES	Futures	846.73	847.46	846.49	847.22	2917.0
2009-07-07 22:00:00	ES	Futures	847.22	847.7	846.49	846.73	2660.0
2009-07-07 23:00:00	ES	Futures	846.73	846.97	845.77	846.25	4063.0
2009-07-07 00:00:00	NQ	Futures	1641.36	1641.65	1639.37	1639.37	60.0
2009-07-07 01:00:00	NQ	Futures	1639.65	1639.65	1638.23	1638.8	68.0
2009-07-07 02:00:00	NQ	Futures	1638.8	1639.08	1635.95	1636.52	1014.0
2009-07-07 03:00:00	NQ	Futures	1636.81	1637.09	1632.25	1633.39	1744.0
2009-07-07 04:00:00	NQ	Futures	1634.24	1643.07	1633.67	1642.5	1035.0
2009-07-07 05:00:00	NQ	Futures	1642.5	1644.21	1639.94	1643.93	698.0
2009-07-07 06:00:00	NQ	Futures	1643.93	1648.2	1643.36	1645.07	1402.0
2009-07-07 07:00:00	NQ	Futures	1645.35	1646.49	1642.79	1642.79	744.0
2009-07-07 08:00:00	NQ	Futures	1642.79	1642.79	1637.66	1638.51	2578.0
2009-07-07 09:00:00	NQ	Futures	1638.8	1641.36	1627.69	1629.4	42605.0
2009-07-07 10:00:00	NQ	Futures	1629.12	1629.4	1618.58	1618.86	47562.0
2009-07-07 11:00:00	NQ	Futures	1619.15	1622.57	1609.18	1614.31	37264.0
2009-07-07 12:00:00	NQ	Futures	1614.31	1614.88	1608.32	1610.89	20090.0
2009-07-07 13:00:00	NQ	Futures	1610.89	1617.44	1610.32	1613.45	23833.0
2009-07-07 14:00:00	NQ	Futures	1613.45	1615.73	1606.33	1607.75	27246.0
2009-07-07 15:00:00	NQ	Futures	1607.75	1607.75	1596.36	1597.79	63675.0
2009-07-07 16:00:00	NQ	Futures	1597.79	1604.91	1597.22	1602.06	14810.0
2009-07-07 17:00:00	NQ	Futures	1602.06	1602.91	1601.2	1602.06	87.0
2009-07-07 18:00:00	NQ	Futures	1602.91	1603.2	1601.77	1602.63	384.0
2009-07-07 19:00:00	NQ	Futures	1602.34	1603.77	1601.49	1601.49	172.0
2009-07-07 20:00:00	NQ	Futures	1601.49	1604.34	1601.49	1603.2	389.0
2009-07-07 21:00:00	NQ	Futures	1603.2	1604.05	1602.06	1603.77	231.0
2009-07-07 22:00:00	NQ	Futures	1603.77	1604.62	1602.91	1603.2	197.0
2009-07-07 23:00:00	NQ	Futures	1602.91	1602.91	1600.92	1601.49	353.0
2009-07-07 00:00:00	YM	Futures	7649.5	7649.5	7643.1	7643.1	77.0
2009-07-07 01:00:00	YM	Futures	7643.1	7645.8	7637.5	7637.5	106.0

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

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