PREVIEW / futures_1hour / 2009-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-06-09.parquet
  size:    43 KB
  rows:    1,247

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-09 00:00:00	ES	Futures	897.43	898.63	895.51	897.91	5742.0
2009-06-09 01:00:00	ES	Futures	897.67	897.91	896.47	897.19	2086.0
2009-06-09 02:00:00	ES	Futures	897.19	900.06	896.47	899.59	9088.0
2009-06-09 03:00:00	ES	Futures	899.35	903.18	899.35	900.54	20504.0
2009-06-09 04:00:00	ES	Futures	900.3	901.98	898.15	899.59	15289.0
2009-06-09 05:00:00	ES	Futures	899.35	900.06	897.43	898.39	10291.0
2009-06-09 06:00:00	ES	Futures	898.39	898.63	897.43	897.91	11819.0
2009-06-09 07:00:00	ES	Futures	897.67	903.9	897.19	903.18	36906.0
2009-06-09 08:00:00	ES	Futures	903.18	903.18	900.54	901.26	24455.0
2009-06-09 09:00:00	ES	Futures	901.26	906.06	900.06	900.78	278907.0
2009-06-09 10:00:00	ES	Futures	900.54	902.94	897.43	898.39	316636.0
2009-06-09 11:00:00	ES	Futures	898.39	899.59	896.71	898.63	126454.0
2009-06-09 12:00:00	ES	Futures	898.63	902.94	898.39	901.98	157725.0
2009-06-09 13:00:00	ES	Futures	901.74	904.62	900.06	904.38	168275.0
2009-06-09 14:00:00	ES	Futures	904.14	907.73	903.42	905.34	205429.0
2009-06-09 15:00:00	ES	Futures	905.1	906.3	902.22	902.7	270173.0
2009-06-09 16:00:00	ES	Futures	902.7	902.94	899.35	900.78	88972.0
2009-06-09 17:00:00	ES	Futures	900.78	901.02	899.82	900.54	1010.0
2009-06-09 18:00:00	ES	Futures	900.54	900.54	898.87	899.35	2394.0
2009-06-09 19:00:00	ES	Futures	899.11	899.35	898.39	899.11	2550.0
2009-06-09 20:00:00	ES	Futures	899.11	901.74	899.11	901.74	4000.0
2009-06-09 21:00:00	ES	Futures	901.74	902.22	901.02	902.22	3367.0
2009-06-09 22:00:00	ES	Futures	901.98	902.7	901.02	901.5	2993.0
2009-06-09 23:00:00	ES	Futures	901.5	904.38	901.26	904.14	3710.0
2009-06-09 00:00:00	NQ	Futures	1691.77	1694.33	1689.5	1692.91	491.0
2009-06-09 01:00:00	NQ	Futures	1692.62	1692.62	1690.06	1691.77	203.0
2009-06-09 02:00:00	NQ	Futures	1691.48	1696.6	1690.92	1695.46	365.0
2009-06-09 03:00:00	NQ	Futures	1695.18	1701.15	1694.61	1696.88	1775.0
2009-06-09 04:00:00	NQ	Futures	1696.88	1700.29	1693.76	1695.75	1113.0
2009-06-09 05:00:00	NQ	Futures	1695.75	1696.88	1692.62	1693.19	981.0
2009-06-09 06:00:00	NQ	Futures	1692.91	1694.04	1692.05	1692.62	556.0
2009-06-09 07:00:00	NQ	Futures	1692.34	1703.13	1692.05	1702.57	3006.0
2009-06-09 08:00:00	NQ	Futures	1702.57	1703.13	1698.87	1700.29	2488.0
2009-06-09 09:00:00	NQ	Futures	1700.01	1707.4	1696.03	1700.58	37771.0
2009-06-09 10:00:00	NQ	Futures	1700.58	1705.41	1692.34	1695.18	36397.0
2009-06-09 11:00:00	NQ	Futures	1694.89	1698.87	1692.05	1696.31	19936.0
2009-06-09 12:00:00	NQ	Futures	1696.31	1705.69	1695.75	1704.55	23662.0
2009-06-09 13:00:00	NQ	Futures	1704.55	1709.95	1701.15	1709.1	24585.0
2009-06-09 14:00:00	NQ	Futures	1709.39	1715.64	1707.4	1710.52	33093.0
2009-06-09 15:00:00	NQ	Futures	1710.52	1712.79	1704.27	1705.41	39406.0
2009-06-09 16:00:00	NQ	Futures	1705.12	1706.26	1702.0	1704.55	9366.0
2009-06-09 17:00:00	NQ	Futures	1704.55	1704.55	1702.85	1704.27	231.0
2009-06-09 18:00:00	NQ	Futures	1703.7	1704.84	1702.0	1702.28	101.0
2009-06-09 19:00:00	NQ	Futures	1701.71	1702.57	1701.15	1702.28	172.0
2009-06-09 20:00:00	NQ	Futures	1702.28	1707.11	1702.28	1706.26	289.0
2009-06-09 21:00:00	NQ	Futures	1707.11	1708.25	1705.41	1707.4	294.0
2009-06-09 22:00:00	NQ	Futures	1707.4	1708.53	1706.26	1706.83	140.0
2009-06-09 23:00:00	NQ	Futures	1706.83	1711.94	1706.83	1711.37	246.0
2009-06-09 00:00:00	YM	Futures	8025.2	8037.1	8010.5	8030.7	373.0
2009-06-09 01:00:00	YM	Futures	8030.7	8033.5	8018.8	8026.1	195.0

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

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