PREVIEW / futures_1hour / 2008-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-10-29.parquet
  size:    46 KB
  rows:    1,286

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
2008-10-29 00:00:00	ES	Futures	879.63	880.1	869.69	870.4	14388.0
2008-10-29 01:00:00	ES	Futures	870.16	880.81	869.69	880.1	7665.0
2008-10-29 02:00:00	ES	Futures	880.34	884.12	874.66	874.66	10230.0
2008-10-29 03:00:00	ES	Futures	874.66	879.39	870.87	871.58	29169.0
2008-10-29 04:00:00	ES	Futures	871.58	876.31	867.56	868.74	51801.0
2008-10-29 05:00:00	ES	Futures	868.74	871.82	865.43	870.4	24946.0
2008-10-29 06:00:00	ES	Futures	870.4	887.2	870.16	885.07	34569.0
2008-10-29 07:00:00	ES	Futures	885.31	895.96	878.92	891.7	47196.0
2008-10-29 08:00:00	ES	Futures	891.7	901.4	885.07	886.73	86241.0
2008-10-29 09:00:00	ES	Futures	886.73	891.46	876.79	881.52	298806.0
2008-10-29 10:00:00	ES	Futures	881.52	895.01	878.21	880.1	375833.0
2008-10-29 11:00:00	ES	Futures	880.1	890.75	878.44	890.04	227170.0
2008-10-29 12:00:00	ES	Futures	890.04	902.11	886.02	894.06	201009.0
2008-10-29 13:00:00	ES	Futures	894.06	903.76	891.7	896.67	163259.0
2008-10-29 14:00:00	ES	Futures	896.67	902.58	876.79	892.41	521556.0
2008-10-29 15:00:00	ES	Futures	892.41	919.38	869.45	871.58	914219.0
2008-10-29 16:00:00	ES	Futures	871.58	887.91	869.92	882.47	176586.0
2008-10-29 17:00:00	ES	Futures	882.23	883.18	881.28	882.23	2048.0
2008-10-29 18:00:00	ES	Futures	882.47	885.07	881.76	884.6	4507.0
2008-10-29 19:00:00	ES	Futures	884.6	885.07	881.76	884.12	2663.0
2008-10-29 20:00:00	ES	Futures	883.89	886.02	882.23	884.83	5605.0
2008-10-29 21:00:00	ES	Futures	884.6	899.98	884.6	897.14	15614.0
2008-10-29 22:00:00	ES	Futures	897.14	898.8	895.25	896.67	5553.0
2008-10-29 23:00:00	ES	Futures	896.67	898.56	894.06	898.56	5909.0
2008-10-29 00:00:00	NQ	Futures	1462.07	1462.07	1445.66	1445.94	349.0
2008-10-29 01:00:00	NQ	Futures	1446.79	1463.49	1446.23	1463.49	314.0
2008-10-29 02:00:00	NQ	Futures	1463.49	1468.01	1455.0	1455.56	214.0
2008-10-29 03:00:00	NQ	Futures	1455.56	1463.49	1449.34	1451.89	748.0
2008-10-29 04:00:00	NQ	Futures	1451.32	1460.37	1443.11	1445.38	2633.0
2008-10-29 05:00:00	NQ	Futures	1446.51	1449.9	1438.87	1445.94	1281.0
2008-10-29 06:00:00	NQ	Futures	1446.51	1471.98	1446.51	1469.71	1404.0
2008-10-29 07:00:00	NQ	Futures	1471.41	1490.37	1457.83	1482.45	4132.0
2008-10-29 08:00:00	NQ	Futures	1482.45	1494.33	1466.88	1469.43	11047.0
2008-10-29 09:00:00	NQ	Futures	1469.43	1476.79	1440.0	1454.43	62360.0
2008-10-29 10:00:00	NQ	Futures	1454.71	1478.2	1447.07	1450.47	69119.0
2008-10-29 11:00:00	NQ	Futures	1451.04	1472.54	1449.06	1471.41	50682.0
2008-10-29 12:00:00	NQ	Futures	1471.41	1494.9	1466.32	1486.69	47468.0
2008-10-29 13:00:00	NQ	Futures	1486.97	1502.25	1483.86	1487.82	47951.0
2008-10-29 14:00:00	NQ	Futures	1487.82	1499.71	1458.68	1487.26	80866.0
2008-10-29 15:00:00	NQ	Futures	1487.54	1524.32	1461.22	1466.32	114470.0
2008-10-29 16:00:00	NQ	Futures	1465.75	1478.77	1460.09	1471.98	23195.0
2008-10-29 17:00:00	NQ	Futures	1470.28	1472.54	1468.01	1471.98	166.0
2008-10-29 18:00:00	NQ	Futures	1473.67	1475.37	1471.69	1475.37	152.0
2008-10-29 19:00:00	NQ	Futures	1475.37	1475.37	1471.98	1473.67	123.0
2008-10-29 20:00:00	NQ	Futures	1474.52	1475.65	1469.43	1472.54	252.0
2008-10-29 21:00:00	NQ	Futures	1473.11	1499.71	1473.11	1497.73	740.0
2008-10-29 22:00:00	NQ	Futures	1497.44	1499.71	1493.76	1497.16	259.0
2008-10-29 23:00:00	NQ	Futures	1497.16	1501.12	1494.05	1498.01	312.0
2008-10-29 00:00:00	YM	Futures	8172.9	8175.7	8106.5	8107.5	1175.0
2008-10-29 01:00:00	YM	Futures	8107.5	8188.4	8099.3	8187.5	990.0

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

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