PREVIEW / futures_1hour / 2008-10-23

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-10-23.parquet
  size:    47 KB
  rows:    1,296

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-23 00:00:00	ES	Futures	854.78	870.4	854.78	867.79	11201.0
2008-10-23 01:00:00	ES	Futures	867.79	869.92	862.59	868.5	6391.0
2008-10-23 02:00:00	ES	Futures	868.5	870.87	861.88	870.16	15321.0
2008-10-23 03:00:00	ES	Futures	870.4	873.24	860.46	871.11	36867.0
2008-10-23 04:00:00	ES	Futures	871.34	873.24	860.22	860.46	30185.0
2008-10-23 05:00:00	ES	Futures	860.93	862.11	848.63	851.94	37982.0
2008-10-23 06:00:00	ES	Futures	851.7	859.98	846.73	847.92	32158.0
2008-10-23 07:00:00	ES	Futures	848.15	853.83	835.61	836.79	55715.0
2008-10-23 08:00:00	ES	Futures	836.56	848.86	835.85	848.63	84386.0
2008-10-23 09:00:00	ES	Futures	848.63	859.98	834.43	847.21	391257.0
2008-10-23 10:00:00	ES	Futures	847.21	872.29	845.08	870.87	604112.0
2008-10-23 11:00:00	ES	Futures	870.87	873.95	857.85	864.24	333028.0
2008-10-23 12:00:00	ES	Futures	864.24	864.48	833.48	834.66	395329.0
2008-10-23 13:00:00	ES	Futures	834.66	843.42	825.91	830.64	418645.0
2008-10-23 14:00:00	ES	Futures	830.4	833.24	810.29	820.7	587908.0
2008-10-23 15:00:00	ES	Futures	820.46	863.3	815.49	860.93	832668.0
2008-10-23 16:00:00	ES	Futures	860.93	867.79	858.09	867.08	137938.0
2008-10-23 17:00:00	ES	Futures	867.32	867.56	864.72	865.66	4458.0
2008-10-23 18:00:00	ES	Futures	864.95	867.56	864.01	865.19	5000.0
2008-10-23 19:00:00	ES	Futures	865.19	868.27	864.72	864.72	4799.0
2008-10-23 20:00:00	ES	Futures	864.95	865.66	859.98	860.46	10123.0
2008-10-23 21:00:00	ES	Futures	860.46	861.4	853.6	853.6	7418.0
2008-10-23 22:00:00	ES	Futures	853.6	856.2	852.41	855.73	6478.0
2008-10-23 23:00:00	ES	Futures	855.73	856.2	850.28	851.47	6954.0
2008-10-23 00:00:00	NQ	Futures	1409.72	1431.79	1409.72	1428.4	665.0
2008-10-23 01:00:00	NQ	Futures	1428.4	1429.25	1417.65	1428.4	263.0
2008-10-23 02:00:00	NQ	Futures	1427.27	1429.53	1416.51	1428.97	584.0
2008-10-23 03:00:00	NQ	Futures	1428.97	1429.53	1411.7	1427.27	2296.0
2008-10-23 04:00:00	NQ	Futures	1427.83	1430.1	1405.2	1405.76	2781.0
2008-10-23 05:00:00	NQ	Futures	1406.61	1412.84	1401.23	1403.5	3882.0
2008-10-23 06:00:00	NQ	Futures	1404.63	1416.51	1399.25	1399.82	1759.0
2008-10-23 07:00:00	NQ	Futures	1400.95	1411.99	1384.26	1389.07	2641.0
2008-10-23 08:00:00	NQ	Futures	1389.07	1399.54	1382.28	1396.14	9029.0
2008-10-23 09:00:00	NQ	Futures	1395.86	1418.78	1375.48	1394.73	61856.0
2008-10-23 10:00:00	NQ	Futures	1394.73	1427.83	1389.07	1424.44	81664.0
2008-10-23 11:00:00	NQ	Futures	1424.44	1432.36	1401.52	1409.72	54200.0
2008-10-23 12:00:00	NQ	Futures	1409.72	1410.29	1370.67	1371.81	63091.0
2008-10-23 13:00:00	NQ	Futures	1372.09	1384.82	1357.94	1364.73	64985.0
2008-10-23 14:00:00	NQ	Futures	1364.45	1367.84	1330.78	1350.58	91168.0
2008-10-23 15:00:00	NQ	Futures	1350.58	1407.18	1342.94	1405.76	126594.0
2008-10-23 16:00:00	NQ	Futures	1405.76	1422.46	1398.97	1416.8	16423.0
2008-10-23 17:00:00	NQ	Futures	1418.78	1418.78	1410.86	1410.86	611.0
2008-10-23 18:00:00	NQ	Futures	1410.86	1417.36	1410.29	1413.12	195.0
2008-10-23 19:00:00	NQ	Futures	1413.97	1419.34	1413.12	1415.1	298.0
2008-10-23 20:00:00	NQ	Futures	1413.68	1413.97	1409.72	1410.29	1160.0
2008-10-23 21:00:00	NQ	Futures	1410.29	1412.84	1403.5	1403.5	961.0
2008-10-23 22:00:00	NQ	Futures	1403.5	1411.42	1401.8	1410.86	1104.0
2008-10-23 23:00:00	NQ	Futures	1411.99	1412.84	1404.06	1407.46	1293.0
2008-10-23 00:00:00	YM	Futures	7797.3	7932.8	7791.8	7909.2	1043.0
2008-10-23 01:00:00	YM	Futures	7908.3	7920.1	7860.1	7903.7	491.0

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

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