PREVIEW / futures_1hour / 2009-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-24.parquet
  size:    44 KB
  rows:    1,250

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-06-24 00:00:00	ES	Futures	859.27	860.96	859.03	860.48	3928.0
2009-06-24 01:00:00	ES	Futures	860.48	861.2	860.0	860.48	1757.0
2009-06-24 02:00:00	ES	Futures	860.24	863.37	860.0	863.13	10467.0
2009-06-24 03:00:00	ES	Futures	863.13	863.13	858.07	858.79	19440.0
2009-06-24 04:00:00	ES	Futures	859.03	862.17	859.03	861.44	11878.0
2009-06-24 05:00:00	ES	Futures	861.2	863.37	860.0	863.13	15755.0
2009-06-24 06:00:00	ES	Futures	862.89	863.37	861.69	862.41	7953.0
2009-06-24 07:00:00	ES	Futures	862.41	865.06	861.44	863.13	24102.0
2009-06-24 08:00:00	ES	Futures	863.13	868.2	862.41	866.75	62311.0
2009-06-24 09:00:00	ES	Futures	866.75	868.44	864.34	868.2	127743.0
2009-06-24 10:00:00	ES	Futures	868.2	874.47	866.51	873.26	321304.0
2009-06-24 11:00:00	ES	Futures	873.02	874.47	871.09	872.06	124454.0
2009-06-24 12:00:00	ES	Futures	872.06	872.54	869.4	870.61	72137.0
2009-06-24 13:00:00	ES	Futures	870.61	872.54	869.64	870.37	70023.0
2009-06-24 14:00:00	ES	Futures	870.37	872.3	862.17	865.3	384417.0
2009-06-24 15:00:00	ES	Futures	865.54	866.51	860.0	864.82	406508.0
2009-06-24 16:00:00	ES	Futures	865.06	866.51	864.58	866.03	72463.0
2009-06-24 17:00:00	ES	Futures	866.27	866.27	864.82	865.06	1337.0
2009-06-24 18:00:00	ES	Futures	865.3	866.27	865.06	866.03	1446.0
2009-06-24 19:00:00	ES	Futures	865.79	866.03	865.54	865.79	857.0
2009-06-24 20:00:00	ES	Futures	866.03	867.71	865.54	866.75	5094.0
2009-06-24 21:00:00	ES	Futures	866.75	868.2	866.27	867.47	3692.0
2009-06-24 22:00:00	ES	Futures	867.71	867.71	865.79	867.23	2911.0
2009-06-24 23:00:00	ES	Futures	866.99	868.44	866.99	868.2	3178.0
2009-06-24 00:00:00	NQ	Futures	1622.85	1625.98	1622.85	1624.84	178.0
2009-06-24 01:00:00	NQ	Futures	1625.98	1625.98	1624.56	1625.13	66.0
2009-06-24 02:00:00	NQ	Futures	1625.7	1627.98	1624.27	1627.98	579.0
2009-06-24 03:00:00	NQ	Futures	1627.41	1627.41	1618.58	1620.57	1495.0
2009-06-24 04:00:00	NQ	Futures	1620.57	1627.41	1620.57	1625.13	1251.0
2009-06-24 05:00:00	NQ	Futures	1625.41	1629.4	1623.7	1628.55	908.0
2009-06-24 06:00:00	NQ	Futures	1628.55	1628.83	1625.98	1628.26	518.0
2009-06-24 07:00:00	NQ	Futures	1628.55	1632.25	1626.27	1627.98	1630.0
2009-06-24 08:00:00	NQ	Futures	1627.98	1637.09	1625.98	1635.1	6646.0
2009-06-24 09:00:00	NQ	Futures	1635.38	1642.5	1632.25	1641.93	25568.0
2009-06-24 10:00:00	NQ	Futures	1641.65	1659.88	1638.51	1655.6	65669.0
2009-06-24 11:00:00	NQ	Futures	1655.6	1658.17	1653.61	1655.89	20815.0
2009-06-24 12:00:00	NQ	Futures	1655.6	1657.03	1651.05	1654.18	16035.0
2009-06-24 13:00:00	NQ	Futures	1654.46	1657.03	1650.48	1651.33	12018.0
2009-06-24 14:00:00	NQ	Futures	1651.62	1656.74	1639.37	1647.06	45948.0
2009-06-24 15:00:00	NQ	Futures	1646.77	1650.19	1636.81	1645.63	52954.0
2009-06-24 16:00:00	NQ	Futures	1645.92	1649.34	1645.92	1647.06	8021.0
2009-06-24 17:00:00	NQ	Futures	1647.34	1647.91	1647.06	1647.06	177.0
2009-06-24 18:00:00	NQ	Futures	1647.06	1648.77	1647.06	1648.2	216.0
2009-06-24 19:00:00	NQ	Futures	1648.2	1648.48	1647.34	1647.34	80.0
2009-06-24 20:00:00	NQ	Futures	1647.91	1650.19	1647.34	1648.2	394.0
2009-06-24 21:00:00	NQ	Futures	1648.77	1650.76	1647.63	1649.91	391.0
2009-06-24 22:00:00	NQ	Futures	1649.62	1649.91	1646.2	1647.91	250.0
2009-06-24 23:00:00	NQ	Futures	1648.77	1651.33	1648.77	1651.05	250.0
2009-06-24 00:00:00	YM	Futures	7647.7	7658.8	7646.8	7656.9	308.0
2009-06-24 01:00:00	YM	Futures	7654.2	7659.7	7653.2	7653.2	135.0

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

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