PREVIEW / futures_1hour / 2009-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-06.parquet
  size:    46 KB
  rows:    1,306

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-06 00:00:00	ES	Futures	882.09	882.8	881.38	881.62	1885.0
2009-01-06 01:00:00	ES	Futures	881.62	882.8	880.91	882.33	3190.0
2009-01-06 02:00:00	ES	Futures	882.57	882.8	881.38	882.09	2809.0
2009-01-06 03:00:00	ES	Futures	882.33	883.04	878.06	879.48	12047.0
2009-01-06 04:00:00	ES	Futures	879.48	885.41	879.25	884.23	10704.0
2009-01-06 05:00:00	ES	Futures	884.23	886.84	883.52	886.6	8769.0
2009-01-06 06:00:00	ES	Futures	886.6	887.78	885.41	886.36	7455.0
2009-01-06 07:00:00	ES	Futures	886.12	888.5	884.7	887.55	15997.0
2009-01-06 08:00:00	ES	Futures	887.55	888.5	885.89	887.07	23346.0
2009-01-06 09:00:00	ES	Futures	887.31	893.0	884.23	891.58	218467.0
2009-01-06 10:00:00	ES	Futures	891.82	894.43	878.53	880.91	390022.0
2009-01-06 11:00:00	ES	Futures	880.67	883.04	877.11	881.62	183466.0
2009-01-06 12:00:00	ES	Futures	881.62	886.84	880.43	885.65	160629.0
2009-01-06 13:00:00	ES	Futures	885.89	885.89	879.01	882.33	178409.0
2009-01-06 14:00:00	ES	Futures	882.33	891.34	879.48	891.11	248552.0
2009-01-06 15:00:00	ES	Futures	891.34	891.58	879.01	883.99	353682.0
2009-01-06 16:00:00	ES	Futures	883.99	885.65	879.01	880.43	71140.0
2009-01-06 17:00:00	ES	Futures	880.19	880.67	879.72	880.43	880.0
2009-01-06 18:00:00	ES	Futures	880.91	880.91	879.25	879.96	1889.0
2009-01-06 19:00:00	ES	Futures	880.19	883.75	879.72	883.52	2504.0
2009-01-06 20:00:00	ES	Futures	883.28	883.99	881.14	881.14	2619.0
2009-01-06 21:00:00	ES	Futures	881.14	881.86	880.19	881.14	1836.0
2009-01-06 22:00:00	ES	Futures	880.91	881.38	879.72	879.96	1864.0
2009-01-06 23:00:00	ES	Futures	879.96	880.43	879.25	880.19	1604.0
2009-01-06 00:00:00	NQ	Futures	1432.23	1432.8	1430.26	1430.26	28.0
2009-01-06 01:00:00	NQ	Futures	1431.11	1433.08	1430.82	1432.23	30.0
2009-01-06 02:00:00	NQ	Futures	1432.52	1434.49	1431.39	1432.23	84.0
2009-01-06 03:00:00	NQ	Futures	1432.52	1433.36	1424.05	1426.59	633.0
2009-01-06 04:00:00	NQ	Futures	1426.02	1437.6	1426.02	1435.34	715.0
2009-01-06 05:00:00	NQ	Futures	1435.34	1443.53	1433.93	1441.84	1721.0
2009-01-06 06:00:00	NQ	Futures	1441.55	1443.81	1441.27	1441.55	818.0
2009-01-06 07:00:00	NQ	Futures	1441.84	1443.53	1437.88	1440.71	1308.0
2009-01-06 08:00:00	NQ	Futures	1440.99	1447.2	1437.6	1444.09	4069.0
2009-01-06 09:00:00	NQ	Futures	1444.09	1450.87	1433.65	1448.05	39551.0
2009-01-06 10:00:00	NQ	Futures	1448.05	1451.44	1432.52	1435.62	53519.0
2009-01-06 11:00:00	NQ	Futures	1435.91	1439.29	1429.41	1437.32	26187.0
2009-01-06 12:00:00	NQ	Futures	1437.6	1450.31	1435.91	1448.9	25648.0
2009-01-06 13:00:00	NQ	Futures	1448.61	1448.9	1436.47	1440.42	25828.0
2009-01-06 14:00:00	NQ	Futures	1440.14	1453.7	1435.91	1451.72	36684.0
2009-01-06 15:00:00	NQ	Futures	1452.0	1452.57	1433.36	1438.16	39900.0
2009-01-06 16:00:00	NQ	Futures	1438.16	1441.27	1431.11	1432.8	6689.0
2009-01-06 17:00:00	NQ	Futures	1432.8	1432.8	1431.11	1432.8	80.0
2009-01-06 18:00:00	NQ	Futures	1432.8	1434.21	1432.23	1434.21	46.0
2009-01-06 19:00:00	NQ	Futures	1433.65	1437.88	1432.52	1437.88	98.0
2009-01-06 20:00:00	NQ	Futures	1437.88	1437.88	1434.49	1434.49	96.0
2009-01-06 21:00:00	NQ	Futures	1434.78	1435.62	1432.8	1433.65	97.0
2009-01-06 22:00:00	NQ	Futures	1434.49	1434.49	1431.95	1432.52	38.0
2009-01-06 23:00:00	NQ	Futures	1432.52	1433.08	1430.82	1433.08	61.0
2009-01-06 00:00:00	YM	Futures	8142.2	8151.3	8135.9	8137.7	163.0
2009-01-06 01:00:00	YM	Futures	8140.4	8150.4	8138.6	8142.2	144.0

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

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