PREVIEW / futures_1hour / 2009-07-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-06.parquet
  size:    42 KB
  rows:    1,277

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-06 00:00:00	ES	Futures	854.93	857.59	854.45	854.45	4169.0
2009-07-06 01:00:00	ES	Futures	854.45	856.62	853.97	855.17	3219.0
2009-07-06 02:00:00	ES	Futures	855.17	857.1	853.73	854.93	10701.0
2009-07-06 03:00:00	ES	Futures	855.17	856.14	852.04	852.52	29248.0
2009-07-06 04:00:00	ES	Futures	852.52	855.17	851.07	853.73	15872.0
2009-07-06 05:00:00	ES	Futures	853.73	854.45	852.52	852.76	5989.0
2009-07-06 06:00:00	ES	Futures	852.76	853.24	851.07	851.8	9312.0
2009-07-06 07:00:00	ES	Futures	851.8	854.45	851.8	853.97	13553.0
2009-07-06 08:00:00	ES	Futures	854.21	855.17	853.24	854.69	25277.0
2009-07-06 09:00:00	ES	Futures	854.93	859.52	852.52	858.31	229348.0
2009-07-06 10:00:00	ES	Futures	858.55	860.48	850.83	853.0	363735.0
2009-07-06 11:00:00	ES	Futures	853.0	856.62	852.76	854.45	145426.0
2009-07-06 12:00:00	ES	Futures	854.21	856.62	853.73	855.42	90766.0
2009-07-06 13:00:00	ES	Futures	855.42	860.0	855.42	858.07	148478.0
2009-07-06 14:00:00	ES	Futures	857.83	859.52	857.1	858.55	86101.0
2009-07-06 15:00:00	ES	Futures	858.31	863.13	855.9	862.65	306487.0
2009-07-06 16:00:00	ES	Futures	862.65	864.58	861.69	863.86	110003.0
2009-07-06 17:00:00	ES	Futures	863.86	864.1	863.61	863.86	1070.0
2009-07-06 18:00:00	ES	Futures	863.86	864.1	863.13	863.61	1715.0
2009-07-06 19:00:00	ES	Futures	863.61	863.86	862.65	863.37	1725.0
2009-07-06 20:00:00	ES	Futures	863.13	863.61	862.17	862.65	3021.0
2009-07-06 21:00:00	ES	Futures	862.41	862.41	861.44	862.17	4353.0
2009-07-06 22:00:00	ES	Futures	862.17	863.86	861.93	862.65	3531.0
2009-07-06 23:00:00	ES	Futures	862.65	863.61	862.17	863.37	2494.0
2009-07-06 00:00:00	NQ	Futures	1630.82	1635.1	1629.97	1629.97	266.0
2009-07-06 01:00:00	NQ	Futures	1630.54	1634.53	1629.97	1632.25	222.0
2009-07-06 02:00:00	NQ	Futures	1632.82	1636.52	1630.54	1635.1	1023.0
2009-07-06 03:00:00	NQ	Futures	1635.1	1637.94	1634.24	1634.53	2968.0
2009-07-06 04:00:00	NQ	Futures	1634.53	1636.81	1631.11	1633.39	1807.0
2009-07-06 05:00:00	NQ	Futures	1633.39	1634.81	1631.39	1631.68	418.0
2009-07-06 06:00:00	NQ	Futures	1631.68	1632.82	1629.4	1630.25	634.0
2009-07-06 07:00:00	NQ	Futures	1630.54	1635.67	1630.54	1635.67	1365.0
2009-07-06 08:00:00	NQ	Futures	1635.95	1640.22	1635.95	1639.37	3651.0
2009-07-06 09:00:00	NQ	Futures	1639.37	1643.64	1631.39	1635.95	40071.0
2009-07-06 10:00:00	NQ	Futures	1635.95	1640.22	1620.29	1626.55	59087.0
2009-07-06 11:00:00	NQ	Futures	1626.55	1628.83	1623.42	1623.7	20738.0
2009-07-06 12:00:00	NQ	Futures	1623.7	1627.69	1622.28	1624.56	13846.0
2009-07-06 13:00:00	NQ	Futures	1624.56	1632.53	1624.27	1627.98	20128.0
2009-07-06 14:00:00	NQ	Futures	1627.98	1633.67	1627.41	1632.25	14921.0
2009-07-06 15:00:00	NQ	Futures	1632.53	1640.51	1629.12	1638.8	47178.0
2009-07-06 16:00:00	NQ	Futures	1638.8	1641.65	1637.38	1640.79	9761.0
2009-07-06 17:00:00	NQ	Futures	1641.36	1641.65	1640.79	1641.08	37.0
2009-07-06 18:00:00	NQ	Futures	1641.08	1641.08	1640.22	1641.08	71.0
2009-07-06 19:00:00	NQ	Futures	1640.79	1641.08	1639.08	1640.22	65.0
2009-07-06 20:00:00	NQ	Futures	1640.22	1640.51	1639.08	1639.37	218.0
2009-07-06 21:00:00	NQ	Futures	1638.8	1639.08	1637.94	1638.8	313.0
2009-07-06 22:00:00	NQ	Futures	1638.8	1641.65	1638.51	1639.94	167.0
2009-07-06 23:00:00	NQ	Futures	1639.08	1641.36	1639.08	1641.36	87.0
2009-07-06 00:00:00	YM	Futures	7566.3	7584.8	7561.7	7563.5	388.0
2009-07-06 01:00:00	YM	Futures	7561.7	7578.3	7559.8	7569.1	230.0

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

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