PREVIEW / futures_1hour / 2009-07-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	907.02	907.75	906.78	907.02	1094.0
2009-07-20 01:00:00	ES	Futures	906.78	907.51	906.78	907.51	1582.0
2009-07-20 02:00:00	ES	Futures	907.51	908.23	905.58	906.78	8117.0
2009-07-20 03:00:00	ES	Futures	906.78	907.27	903.89	905.82	18494.0
2009-07-20 04:00:00	ES	Futures	905.82	907.27	905.58	905.82	10853.0
2009-07-20 05:00:00	ES	Futures	906.06	910.64	905.82	910.16	19202.0
2009-07-20 06:00:00	ES	Futures	910.16	911.37	909.92	910.4	11810.0
2009-07-20 07:00:00	ES	Futures	910.4	910.64	908.95	909.44	14157.0
2009-07-20 08:00:00	ES	Futures	909.44	910.4	907.51	909.2	23704.0
2009-07-20 09:00:00	ES	Futures	909.2	912.09	908.23	909.92	247132.0
2009-07-20 10:00:00	ES	Futures	909.92	912.09	904.13	905.82	313582.0
2009-07-20 11:00:00	ES	Futures	906.06	909.2	905.34	907.99	122955.0
2009-07-20 12:00:00	ES	Futures	907.75	911.12	907.51	909.92	78269.0
2009-07-20 13:00:00	ES	Futures	909.92	910.4	906.78	909.44	111905.0
2009-07-20 14:00:00	ES	Futures	909.44	911.61	908.23	909.44	178752.0
2009-07-20 15:00:00	ES	Futures	909.44	914.74	909.44	913.3	282411.0
2009-07-20 16:00:00	ES	Futures	913.05	915.71	912.33	913.3	114744.0
2009-07-20 17:00:00	ES	Futures	913.3	913.54	913.3	913.3	1102.0
2009-07-20 18:00:00	ES	Futures	913.54	913.54	912.57	912.81	2975.0
2009-07-20 19:00:00	ES	Futures	912.81	914.02	912.57	912.81	1647.0
2009-07-20 20:00:00	ES	Futures	913.05	913.78	912.33	912.57	3030.0
2009-07-20 21:00:00	ES	Futures	912.81	913.05	911.85	912.09	3168.0
2009-07-20 22:00:00	ES	Futures	911.85	912.57	911.61	911.85	2930.0
2009-07-20 23:00:00	ES	Futures	911.85	912.57	911.61	912.09	2160.0
2009-07-20 00:00:00	NQ	Futures	1749.31	1749.88	1747.6	1747.88	102.0
2009-07-20 01:00:00	NQ	Futures	1747.88	1749.88	1747.6	1749.59	262.0
2009-07-20 02:00:00	NQ	Futures	1749.31	1750.73	1745.6	1747.6	869.0
2009-07-20 03:00:00	NQ	Futures	1747.6	1747.6	1741.33	1745.03	1891.0
2009-07-20 04:00:00	NQ	Futures	1744.75	1747.88	1743.32	1743.61	1030.0
2009-07-20 05:00:00	NQ	Futures	1743.89	1751.58	1743.89	1751.01	1896.0
2009-07-20 06:00:00	NQ	Futures	1750.73	1753.58	1750.44	1751.01	1074.0
2009-07-20 07:00:00	NQ	Futures	1750.73	1750.73	1746.17	1747.88	2729.0
2009-07-20 08:00:00	NQ	Futures	1747.88	1749.88	1742.76	1744.75	4634.0
2009-07-20 09:00:00	NQ	Futures	1744.75	1752.72	1739.62	1752.44	49913.0
2009-07-20 10:00:00	NQ	Futures	1752.44	1756.43	1740.48	1743.04	50302.0
2009-07-20 11:00:00	NQ	Futures	1743.04	1751.01	1742.47	1748.74	21624.0
2009-07-20 12:00:00	NQ	Futures	1748.45	1754.15	1748.17	1752.15	14705.0
2009-07-20 13:00:00	NQ	Futures	1752.15	1753.29	1746.17	1750.73	18999.0
2009-07-20 14:00:00	NQ	Futures	1750.44	1754.15	1743.89	1745.6	31617.0
2009-07-20 15:00:00	NQ	Futures	1745.6	1758.99	1745.6	1755.0	44744.0
2009-07-20 16:00:00	NQ	Futures	1755.0	1757.0	1749.02	1752.15	12344.0
2009-07-20 17:00:00	NQ	Futures	1752.15	1752.15	1751.3	1751.3	183.0
2009-07-20 18:00:00	NQ	Futures	1751.3	1753.01	1751.01	1751.58	212.0
2009-07-20 19:00:00	NQ	Futures	1751.01	1753.58	1751.01	1751.87	237.0
2009-07-20 20:00:00	NQ	Futures	1751.87	1753.01	1750.16	1750.44	282.0
2009-07-20 21:00:00	NQ	Futures	1750.44	1751.01	1748.74	1748.74	336.0
2009-07-20 22:00:00	NQ	Futures	1749.31	1749.59	1746.74	1748.45	290.0
2009-07-20 23:00:00	NQ	Futures	1748.17	1749.31	1748.17	1748.17	212.0
2009-07-20 00:00:00	YM	Futures	8071.2	8074.9	8066.5	8069.3	131.0
2009-07-20 01:00:00	YM	Futures	8069.3	8073.0	8068.4	8072.1	44.0

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

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