PREVIEW / futures_1hour / 2009-07-03

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-07-03.parquet
  size:    24 KB
  rows:    626

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-03 00:00:00	ES	Futures	861.93	863.86	861.44	863.86	2729.0
2009-07-03 01:00:00	ES	Futures	863.86	864.1	863.61	863.86	2785.0
2009-07-03 02:00:00	ES	Futures	863.86	865.54	863.86	865.3	6141.0
2009-07-03 03:00:00	ES	Futures	865.06	866.03	862.65	863.37	13517.0
2009-07-03 04:00:00	ES	Futures	863.37	863.86	860.72	863.61	10895.0
2009-07-03 05:00:00	ES	Futures	863.61	864.34	862.41	862.89	4636.0
2009-07-03 06:00:00	ES	Futures	862.89	863.61	860.96	862.89	5164.0
2009-07-03 07:00:00	ES	Futures	862.89	864.82	862.65	864.1	3871.0
2009-07-03 08:00:00	ES	Futures	864.1	865.79	864.1	864.58	5641.0
2009-07-03 09:00:00	ES	Futures	864.58	865.06	863.61	864.1	3040.0
2009-07-03 10:00:00	ES	Futures	863.86	864.34	862.65	863.13	6234.0
2009-07-03 11:00:00	ES	Futures	863.37	863.86	861.2	861.93	5988.0
2009-07-03 00:00:00	NQ	Futures	1645.92	1649.05	1645.63	1648.77	102.0
2009-07-03 01:00:00	NQ	Futures	1648.77	1649.34	1648.2	1648.77	166.0
2009-07-03 02:00:00	NQ	Futures	1649.05	1651.62	1649.05	1651.33	403.0
2009-07-03 03:00:00	NQ	Futures	1651.62	1652.19	1647.63	1647.91	1362.0
2009-07-03 04:00:00	NQ	Futures	1647.91	1648.48	1642.79	1646.49	1467.0
2009-07-03 05:00:00	NQ	Futures	1646.49	1647.91	1643.93	1645.07	487.0
2009-07-03 06:00:00	NQ	Futures	1645.07	1646.2	1641.36	1644.5	568.0
2009-07-03 07:00:00	NQ	Futures	1645.07	1648.2	1644.78	1647.34	423.0
2009-07-03 08:00:00	NQ	Futures	1647.34	1650.48	1647.34	1649.05	751.0
2009-07-03 09:00:00	NQ	Futures	1648.77	1650.19	1647.34	1647.91	252.0
2009-07-03 10:00:00	NQ	Futures	1647.91	1649.05	1645.63	1646.2	399.0
2009-07-03 11:00:00	NQ	Futures	1646.49	1647.34	1643.07	1644.21	467.0
2009-07-03 00:00:00	YM	Futures	7621.8	7634.7	7619.9	7632.9	198.0
2009-07-03 01:00:00	YM	Futures	7632.9	7635.7	7629.2	7632.0	214.0
2009-07-03 02:00:00	YM	Futures	7630.1	7644.0	7630.1	7641.2	475.0
2009-07-03 03:00:00	YM	Futures	7643.1	7646.8	7624.6	7626.4	861.0
2009-07-03 04:00:00	YM	Futures	7627.3	7632.9	7611.6	7631.0	651.0
2009-07-03 05:00:00	YM	Futures	7629.2	7636.6	7620.9	7625.5	576.0
2009-07-03 06:00:00	YM	Futures	7627.3	7633.8	7614.4	7629.2	574.0
2009-07-03 07:00:00	YM	Futures	7629.2	7641.2	7626.4	7636.6	285.0
2009-07-03 08:00:00	YM	Futures	7637.5	7644.9	7636.6	7638.4	289.0
2009-07-03 09:00:00	YM	Futures	7640.3	7643.1	7630.1	7633.8	150.0
2009-07-03 10:00:00	YM	Futures	7634.7	7637.5	7624.6	7626.4	163.0
2009-07-03 11:00:00	YM	Futures	7628.3	7631.0	7613.5	7616.2	247.0
2009-07-03 00:00:00	CL	Futures	157.425	158.23	157.378	158.065	466.0
2009-07-03 01:00:00	CL	Futures	158.088	158.396	157.662	157.686	422.0
2009-07-03 02:00:00	CL	Futures	157.709	158.657	157.709	158.633	613.0
2009-07-03 03:00:00	CL	Futures	158.609	159.059	157.733	158.041	2406.0
2009-07-03 04:00:00	CL	Futures	158.065	158.112	156.596	157.473	2678.0
2009-07-03 05:00:00	CL	Futures	157.402	157.923	156.999	157.591	956.0
2009-07-03 06:00:00	CL	Futures	157.567	157.851	157.354	157.591	630.0
2009-07-03 07:00:00	CL	Futures	157.567	158.23	157.567	157.899	999.0
2009-07-03 08:00:00	CL	Futures	157.923	158.017	157.496	157.638	678.0
2009-07-03 09:00:00	CL	Futures	157.615	157.709	157.283	157.402	1149.0
2009-07-03 10:00:00	CL	Futures	157.449	157.473	156.644	156.857	2357.0
2009-07-03 11:00:00	CL	Futures	156.833	156.857	156.194	156.573	1986.0
2009-07-03 12:00:00	CL	Futures	156.573	156.762	155.531	155.555	1649.0
2009-07-03 13:00:00	CL	Futures	155.507	155.815	154.868	155.412	1665.0

> showing 50 of 626 rows — these rows as CSV

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