PREVIEW / futures_1hour / 2009-01-02

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-02.parquet
  size:    31 KB
  rows:    831

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-01-02 06:00:00	ES	Futures	853.87	861.22	851.97	859.56	20360.0
2009-01-02 07:00:00	ES	Futures	859.32	860.75	856.95	858.37	9464.0
2009-01-02 08:00:00	ES	Futures	858.37	859.09	851.02	853.87	21781.0
2009-01-02 09:00:00	ES	Futures	853.63	857.9	850.55	852.44	113920.0
2009-01-02 10:00:00	ES	Futures	852.44	866.91	850.78	866.44	173575.0
2009-01-02 11:00:00	ES	Futures	866.44	869.76	864.54	867.39	135399.0
2009-01-02 12:00:00	ES	Futures	867.39	872.37	866.91	870.47	91442.0
2009-01-02 13:00:00	ES	Futures	870.23	876.64	869.52	874.74	99987.0
2009-01-02 14:00:00	ES	Futures	874.74	879.96	872.37	878.77	137277.0
2009-01-02 15:00:00	ES	Futures	878.77	884.94	878.53	880.19	237390.0
2009-01-02 16:00:00	ES	Futures	879.96	881.14	877.59	878.53	66884.0
2009-01-02 06:00:00	NQ	Futures	1367.85	1378.58	1362.77	1376.32	1569.0
2009-01-02 07:00:00	NQ	Futures	1376.32	1378.02	1372.93	1374.63	523.0
2009-01-02 08:00:00	NQ	Futures	1374.63	1374.91	1359.95	1363.05	3248.0
2009-01-02 09:00:00	NQ	Futures	1363.05	1375.19	1361.92	1370.11	19640.0
2009-01-02 10:00:00	NQ	Futures	1370.11	1396.94	1367.85	1395.53	36340.0
2009-01-02 11:00:00	NQ	Futures	1395.81	1401.17	1391.57	1398.91	23762.0
2009-01-02 12:00:00	NQ	Futures	1398.91	1409.93	1397.5	1407.1	18787.0
2009-01-02 13:00:00	NQ	Futures	1407.1	1416.7	1405.13	1413.03	19883.0
2009-01-02 14:00:00	NQ	Futures	1412.75	1422.92	1409.64	1420.09	19130.0
2009-01-02 15:00:00	NQ	Futures	1420.09	1432.52	1419.81	1426.59	37506.0
2009-01-02 16:00:00	NQ	Futures	1426.3	1428.85	1414.44	1416.14	11991.0
2009-01-02 06:00:00	YM	Futures	7944.5	8015.6	7942.7	8001.9	1153.0
2009-01-02 07:00:00	YM	Futures	8004.6	8011.9	7982.8	7993.7	477.0
2009-01-02 08:00:00	YM	Futures	7992.8	8001.0	7943.6	7965.4	1830.0
2009-01-02 09:00:00	YM	Futures	7964.5	7995.5	7941.8	7962.7	9881.0
2009-01-02 10:00:00	YM	Futures	7961.8	8077.5	7948.1	8072.1	15100.0
2009-01-02 11:00:00	YM	Futures	8073.9	8103.0	8060.2	8085.7	10524.0
2009-01-02 12:00:00	YM	Futures	8085.7	8119.5	8080.3	8099.4	6469.0
2009-01-02 13:00:00	YM	Futures	8099.4	8145.0	8091.2	8131.3	8066.0
2009-01-02 14:00:00	YM	Futures	8132.2	8175.0	8113.1	8162.3	12346.0
2009-01-02 15:00:00	YM	Futures	8162.3	8218.8	8161.4	8175.9	19654.0
2009-01-02 16:00:00	YM	Futures	8176.9	8188.7	8156.8	8157.7	3384.0
2009-01-02 00:00:00	CL	Futures	148.31	149.28	147.85	148.94	424.0
2009-01-02 01:00:00	CL	Futures	148.8	148.8	146.46	146.49	656.0
2009-01-02 02:00:00	CL	Futures	146.56	146.7	143.39	146.6	1175.0
2009-01-02 03:00:00	CL	Futures	146.7	148.59	145.34	146.04	1190.0
2009-01-02 04:00:00	CL	Futures	146.14	146.18	143.28	145.03	1568.0
2009-01-02 05:00:00	CL	Futures	144.99	146.11	144.36	145.97	1399.0
2009-01-02 06:00:00	CL	Futures	146.0	147.26	144.05	144.61	2905.0
2009-01-02 07:00:00	CL	Futures	144.54	146.74	144.33	145.93	5041.0
2009-01-02 08:00:00	CL	Futures	146.0	150.89	145.9	150.68	7408.0
2009-01-02 09:00:00	CL	Futures	150.79	156.06	150.19	153.02	20015.0
2009-01-02 10:00:00	CL	Futures	153.09	156.72	151.94	156.26	15348.0
2009-01-02 11:00:00	CL	Futures	156.3	163.14	155.85	160.98	28776.0
2009-01-02 12:00:00	CL	Futures	161.01	161.78	159.09	159.51	13453.0
2009-01-02 13:00:00	CL	Futures	159.55	161.26	157.56	158.71	11875.0
2009-01-02 14:00:00	CL	Futures	158.78	162.65	158.22	161.88	21824.0
2009-01-02 15:00:00	CL	Futures	161.99	162.2	160.77	161.64	1682.0
2009-01-02 16:00:00	CL	Futures	161.64	162.3	161.36	162.3	604.0

> showing 50 of 831 rows — these rows as CSV

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