PREVIEW / futures_1hour / 2009-06-11

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-11.parquet
  size:    41 KB
  rows:    1,204

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-11 00:00:00	ES	Futures	904.86	906.3	904.86	906.06	1923.0
2009-06-11 01:00:00	ES	Futures	905.82	906.06	904.14	904.38	1682.0
2009-06-11 02:00:00	ES	Futures	904.38	905.1	901.98	902.7	6848.0
2009-06-11 03:00:00	ES	Futures	902.7	903.42	900.3	902.7	14048.0
2009-06-11 04:00:00	ES	Futures	902.46	905.1	902.22	904.62	8043.0
2009-06-11 05:00:00	ES	Futures	904.62	904.86	903.9	903.9	4345.0
2009-06-11 06:00:00	ES	Futures	903.9	905.1	903.42	903.9	6643.0
2009-06-11 07:00:00	ES	Futures	903.9	903.9	902.46	902.46	11740.0
2009-06-11 08:00:00	ES	Futures	902.7	907.01	897.91	898.63	71062.0
2009-06-11 09:00:00	ES	Futures	898.39	909.65	898.15	907.97	148929.0
2009-06-11 10:00:00	ES	Futures	907.97	911.33	906.3	906.77	121614.0
2009-06-11 11:00:00	ES	Futures	906.77	910.13	905.58	908.69	76267.0
2009-06-11 12:00:00	ES	Futures	908.45	912.77	906.3	912.29	83971.0
2009-06-11 13:00:00	ES	Futures	912.29	916.84	911.09	913.24	111589.0
2009-06-11 14:00:00	ES	Futures	913.48	914.68	910.13	913.24	82509.0
2009-06-11 15:00:00	ES	Futures	913.24	914.2	904.14	905.1	125196.0
2009-06-11 16:00:00	ES	Futures	905.1	905.34	901.74	902.7	29115.0
2009-06-11 17:00:00	ES	Futures	902.7	903.18	902.22	902.46	372.0
2009-06-11 18:00:00	ES	Futures	902.22	902.94	901.74	901.98	1171.0
2009-06-11 19:00:00	ES	Futures	901.98	902.94	901.74	902.22	847.0
2009-06-11 20:00:00	ES	Futures	902.22	903.18	901.98	902.7	3101.0
2009-06-11 21:00:00	ES	Futures	902.46	902.94	901.74	901.98	983.0
2009-06-11 22:00:00	ES	Futures	901.98	903.9	901.74	903.18	1587.0
2009-06-11 23:00:00	ES	Futures	903.42	904.14	902.46	903.9	817.0
2009-06-11 00:00:00	NQ	Futures	1706.83	1708.25	1706.54	1707.68	170.0
2009-06-11 01:00:00	NQ	Futures	1707.11	1707.4	1704.84	1705.98	157.0
2009-06-11 02:00:00	NQ	Futures	1705.98	1705.98	1700.86	1702.0	437.0
2009-06-11 03:00:00	NQ	Futures	1702.0	1703.7	1698.59	1702.0	896.0
2009-06-11 04:00:00	NQ	Futures	1702.0	1706.83	1700.58	1705.41	701.0
2009-06-11 05:00:00	NQ	Futures	1705.12	1707.4	1705.12	1705.69	691.0
2009-06-11 06:00:00	NQ	Futures	1705.98	1707.68	1704.27	1705.12	539.0
2009-06-11 07:00:00	NQ	Futures	1705.69	1705.98	1702.57	1702.57	1149.0
2009-06-11 08:00:00	NQ	Futures	1702.85	1703.7	1691.48	1692.05	6797.0
2009-06-11 09:00:00	NQ	Futures	1691.77	1715.64	1691.77	1712.51	29143.0
2009-06-11 10:00:00	NQ	Futures	1712.23	1717.06	1705.69	1706.26	19551.0
2009-06-11 11:00:00	NQ	Futures	1706.54	1711.37	1702.85	1705.69	10273.0
2009-06-11 12:00:00	NQ	Futures	1705.12	1711.09	1697.17	1710.24	11588.0
2009-06-11 13:00:00	NQ	Futures	1710.24	1718.48	1707.96	1713.36	14171.0
2009-06-11 14:00:00	NQ	Futures	1713.36	1715.64	1708.25	1713.65	13475.0
2009-06-11 15:00:00	NQ	Futures	1713.65	1715.64	1698.02	1698.87	19310.0
2009-06-11 16:00:00	NQ	Futures	1698.59	1701.15	1691.48	1693.47	5102.0
2009-06-11 17:00:00	NQ	Futures	1693.76	1693.76	1692.05	1692.91	100.0
2009-06-11 18:00:00	NQ	Futures	1693.19	1694.33	1691.77	1692.05	148.0
2009-06-11 19:00:00	NQ	Futures	1692.91	1693.47	1692.05	1693.19	60.0
2009-06-11 20:00:00	NQ	Futures	1693.19	1694.61	1692.05	1694.04	66.0
2009-06-11 21:00:00	NQ	Futures	1694.04	1694.04	1691.77	1693.19	43.0
2009-06-11 22:00:00	NQ	Futures	1693.19	1696.88	1693.19	1695.18	293.0
2009-06-11 23:00:00	NQ	Futures	1695.46	1697.17	1695.46	1696.88	109.0
2009-06-11 00:00:00	YM	Futures	8075.8	8075.8	8073.9	8073.9	10.0
2009-06-11 01:00:00	YM	Futures	8073.0	8073.0	8072.1	8072.1	8.0

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

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