PREVIEW / futures_1hour / 2009-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-05.parquet
  size:    44 KB
  rows:    1,253

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-05 00:00:00	ES	Futures	874.27	875.45	873.55	874.98	965.0
2009-01-05 01:00:00	ES	Futures	874.98	876.64	874.74	875.69	911.0
2009-01-05 02:00:00	ES	Futures	875.69	878.06	873.55	877.82	5665.0
2009-01-05 03:00:00	ES	Futures	877.82	879.72	874.98	878.3	18794.0
2009-01-05 04:00:00	ES	Futures	878.3	879.25	876.87	877.11	9159.0
2009-01-05 05:00:00	ES	Futures	877.11	877.35	873.32	876.4	8619.0
2009-01-05 06:00:00	ES	Futures	876.4	879.72	875.45	876.87	11121.0
2009-01-05 07:00:00	ES	Futures	876.87	878.53	873.55	874.27	9962.0
2009-01-05 08:00:00	ES	Futures	874.27	875.21	870.0	872.13	31827.0
2009-01-05 09:00:00	ES	Futures	872.37	876.87	869.52	870.94	168910.0
2009-01-05 10:00:00	ES	Futures	870.94	883.75	870.47	881.38	268330.0
2009-01-05 11:00:00	ES	Futures	881.38	882.33	876.87	876.87	166717.0
2009-01-05 12:00:00	ES	Futures	876.87	883.04	876.64	879.72	147831.0
2009-01-05 13:00:00	ES	Futures	879.72	885.65	878.53	884.23	152189.0
2009-01-05 14:00:00	ES	Futures	884.23	886.36	874.27	875.93	212801.0
2009-01-05 15:00:00	ES	Futures	875.93	879.25	871.42	878.06	301414.0
2009-01-05 16:00:00	ES	Futures	878.06	880.43	877.82	878.06	72478.0
2009-01-05 17:00:00	ES	Futures	878.3	878.77	878.06	878.77	1498.0
2009-01-05 18:00:00	ES	Futures	878.77	880.19	878.3	879.72	1777.0
2009-01-05 19:00:00	ES	Futures	879.72	879.72	876.16	877.11	3205.0
2009-01-05 20:00:00	ES	Futures	876.87	880.19	876.87	879.96	2406.0
2009-01-05 21:00:00	ES	Futures	879.96	881.86	878.77	880.91	2646.0
2009-01-05 22:00:00	ES	Futures	880.91	881.86	880.91	881.38	2084.0
2009-01-05 23:00:00	ES	Futures	881.38	882.33	878.53	882.09	4670.0
2009-01-05 00:00:00	NQ	Futures	1409.36	1411.9	1408.23	1411.9	57.0
2009-01-05 01:00:00	NQ	Futures	1411.06	1413.32	1411.06	1413.03	35.0
2009-01-05 02:00:00	NQ	Futures	1412.47	1416.7	1408.8	1416.14	308.0
2009-01-05 03:00:00	NQ	Futures	1416.14	1420.94	1412.19	1416.99	1455.0
2009-01-05 04:00:00	NQ	Futures	1416.99	1418.12	1414.16	1415.01	485.0
2009-01-05 05:00:00	NQ	Futures	1415.01	1415.01	1408.8	1413.88	578.0
2009-01-05 06:00:00	NQ	Futures	1413.88	1419.25	1411.9	1415.57	894.0
2009-01-05 07:00:00	NQ	Futures	1415.86	1418.68	1411.62	1412.19	982.0
2009-01-05 08:00:00	NQ	Futures	1412.75	1415.29	1405.41	1410.77	5275.0
2009-01-05 09:00:00	NQ	Futures	1410.77	1421.5	1406.26	1407.39	32173.0
2009-01-05 10:00:00	NQ	Futures	1407.95	1431.11	1405.97	1426.02	34244.0
2009-01-05 11:00:00	NQ	Futures	1426.02	1429.69	1420.09	1420.94	18941.0
2009-01-05 12:00:00	NQ	Futures	1420.94	1432.8	1420.37	1425.74	16345.0
2009-01-05 13:00:00	NQ	Futures	1425.74	1436.75	1424.61	1435.62	22024.0
2009-01-05 14:00:00	NQ	Futures	1435.62	1440.14	1418.4	1421.79	30806.0
2009-01-05 15:00:00	NQ	Futures	1421.79	1428.0	1415.86	1425.18	33946.0
2009-01-05 16:00:00	NQ	Futures	1425.18	1430.54	1424.61	1425.18	6817.0
2009-01-05 17:00:00	NQ	Futures	1424.89	1425.74	1424.33	1425.74	77.0
2009-01-05 18:00:00	NQ	Futures	1426.59	1429.41	1426.3	1427.72	76.0
2009-01-05 19:00:00	NQ	Futures	1427.72	1427.72	1422.63	1424.61	233.0
2009-01-05 20:00:00	NQ	Futures	1424.61	1428.85	1424.61	1428.0	114.0
2009-01-05 21:00:00	NQ	Futures	1428.56	1431.39	1426.59	1429.69	70.0
2009-01-05 22:00:00	NQ	Futures	1429.98	1431.67	1429.98	1431.11	28.0
2009-01-05 23:00:00	NQ	Futures	1430.54	1431.67	1426.59	1431.67	108.0
2009-01-05 00:00:00	YM	Futures	8130.4	8137.7	8126.7	8136.8	87.0
2009-01-05 01:00:00	YM	Futures	8135.9	8146.8	8132.2	8139.5	129.0

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

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