PREVIEW / futures_1hour / 2009-06-02

all futures 1-hour files

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

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-02 00:00:00	ES	Futures	899.82	900.3	898.63	898.87	2613.0
2009-06-02 01:00:00	ES	Futures	899.11	899.59	897.91	898.63	3692.0
2009-06-02 02:00:00	ES	Futures	898.39	899.11	895.99	896.71	14683.0
2009-06-02 03:00:00	ES	Futures	896.71	899.35	895.75	899.35	20668.0
2009-06-02 04:00:00	ES	Futures	899.11	900.3	896.95	898.15	17236.0
2009-06-02 05:00:00	ES	Futures	898.39	901.74	897.19	901.26	13464.0
2009-06-02 06:00:00	ES	Futures	901.26	903.42	900.3	902.46	19465.0
2009-06-02 07:00:00	ES	Futures	902.22	903.42	900.54	903.18	19361.0
2009-06-02 08:00:00	ES	Futures	903.18	903.42	897.91	900.3	34537.0
2009-06-02 09:00:00	ES	Futures	900.3	904.62	897.91	904.62	245856.0
2009-06-02 10:00:00	ES	Futures	904.62	909.65	903.42	904.38	437860.0
2009-06-02 11:00:00	ES	Futures	904.38	906.3	900.78	902.22	221820.0
2009-06-02 12:00:00	ES	Futures	902.22	903.9	900.3	902.94	147100.0
2009-06-02 13:00:00	ES	Futures	902.94	906.3	901.74	905.58	120274.0
2009-06-02 14:00:00	ES	Futures	905.58	908.21	903.42	905.82	176459.0
2009-06-02 15:00:00	ES	Futures	905.82	908.45	903.9	904.86	306763.0
2009-06-02 16:00:00	ES	Futures	904.86	905.34	901.5	902.94	97296.0
2009-06-02 17:00:00	ES	Futures	902.7	902.94	902.22	902.7	1043.0
2009-06-02 18:00:00	ES	Futures	902.7	902.94	901.02	901.26	2967.0
2009-06-02 19:00:00	ES	Futures	901.26	901.98	901.02	901.5	1503.0
2009-06-02 20:00:00	ES	Futures	901.5	902.94	901.26	901.5	3810.0
2009-06-02 21:00:00	ES	Futures	901.74	901.98	900.54	900.78	4088.0
2009-06-02 22:00:00	ES	Futures	900.78	902.46	900.3	902.22	3703.0
2009-06-02 23:00:00	ES	Futures	902.22	903.66	901.74	903.66	3481.0
2009-06-02 00:00:00	NQ	Futures	1669.61	1670.74	1667.9	1667.9	115.0
2009-06-02 01:00:00	NQ	Futures	1668.47	1669.61	1667.33	1667.9	274.0
2009-06-02 02:00:00	NQ	Futures	1668.19	1669.04	1665.06	1665.91	843.0
2009-06-02 03:00:00	NQ	Futures	1665.91	1670.17	1664.49	1669.61	1100.0
2009-06-02 04:00:00	NQ	Futures	1670.17	1672.16	1667.05	1667.9	1154.0
2009-06-02 05:00:00	NQ	Futures	1667.9	1673.87	1667.33	1673.3	972.0
2009-06-02 06:00:00	NQ	Futures	1673.02	1677.28	1671.59	1675.29	1067.0
2009-06-02 07:00:00	NQ	Futures	1675.0	1677.28	1673.3	1676.43	1894.0
2009-06-02 08:00:00	NQ	Futures	1676.14	1676.71	1665.91	1669.04	4468.0
2009-06-02 09:00:00	NQ	Futures	1668.75	1684.38	1666.48	1684.38	39484.0
2009-06-02 10:00:00	NQ	Futures	1684.38	1698.59	1678.98	1680.69	84179.0
2009-06-02 11:00:00	NQ	Futures	1680.69	1686.09	1675.86	1678.98	34753.0
2009-06-02 12:00:00	NQ	Futures	1678.98	1681.54	1673.02	1679.55	26784.0
2009-06-02 13:00:00	NQ	Futures	1679.83	1684.1	1675.29	1683.81	19892.0
2009-06-02 14:00:00	NQ	Futures	1684.1	1688.07	1680.12	1683.53	25067.0
2009-06-02 15:00:00	NQ	Futures	1683.53	1688.64	1678.41	1680.97	44372.0
2009-06-02 16:00:00	NQ	Futures	1680.69	1681.82	1678.13	1679.83	6173.0
2009-06-02 17:00:00	NQ	Futures	1680.12	1680.4	1679.55	1679.83	74.0
2009-06-02 18:00:00	NQ	Futures	1680.12	1680.12	1677.85	1678.41	133.0
2009-06-02 19:00:00	NQ	Futures	1678.41	1678.98	1677.56	1678.98	130.0
2009-06-02 20:00:00	NQ	Futures	1678.7	1680.4	1678.13	1678.13	225.0
2009-06-02 21:00:00	NQ	Futures	1678.13	1678.7	1676.14	1676.43	123.0
2009-06-02 22:00:00	NQ	Futures	1676.43	1679.83	1676.43	1679.55	72.0
2009-06-02 23:00:00	NQ	Futures	1679.55	1682.11	1678.41	1681.82	329.0
2009-06-02 00:00:00	YM	Futures	7982.9	7988.4	7972.8	7972.8	173.0
2009-06-02 01:00:00	YM	Futures	7975.6	7978.3	7968.2	7971.0	202.0

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

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