PREVIEW / futures_1hour / 2008-11-24

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-11-24.parquet
  size:    44 KB
  rows:    1,198

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-11-24 00:00:00	ES	Futures	760.59	763.67	758.7	759.88	6804.0
2008-11-24 01:00:00	ES	Futures	760.12	763.2	758.46	762.96	4736.0
2008-11-24 02:00:00	ES	Futures	762.49	762.49	749.71	751.13	17533.0
2008-11-24 03:00:00	ES	Futures	751.13	751.6	741.42	749.0	33311.0
2008-11-24 04:00:00	ES	Futures	749.23	762.72	748.76	761.3	28493.0
2008-11-24 05:00:00	ES	Futures	761.3	764.85	759.65	760.12	23402.0
2008-11-24 06:00:00	ES	Futures	760.12	772.9	759.88	770.77	37269.0
2008-11-24 07:00:00	ES	Futures	770.77	773.61	769.82	770.06	40147.0
2008-11-24 08:00:00	ES	Futures	770.29	771.0	767.45	770.06	34634.0
2008-11-24 09:00:00	ES	Futures	770.06	774.55	764.14	771.95	277714.0
2008-11-24 10:00:00	ES	Futures	771.71	791.83	771.48	790.88	557158.0
2008-11-24 11:00:00	ES	Futures	790.88	797.51	785.91	793.96	363446.0
2008-11-24 12:00:00	ES	Futures	793.72	796.56	780.94	789.94	332057.0
2008-11-24 13:00:00	ES	Futures	789.94	796.8	785.68	796.8	215607.0
2008-11-24 14:00:00	ES	Futures	796.56	800.59	785.2	796.56	337791.0
2008-11-24 15:00:00	ES	Futures	796.56	819.99	792.3	799.88	867300.0
2008-11-24 16:00:00	ES	Futures	799.88	807.21	797.27	800.35	156713.0
2008-11-24 17:00:00	ES	Futures	800.59	803.43	798.93	802.48	3763.0
2008-11-24 18:00:00	ES	Futures	801.77	805.32	799.64	803.19	7147.0
2008-11-24 19:00:00	ES	Futures	803.43	805.08	803.19	803.9	5865.0
2008-11-24 20:00:00	ES	Futures	803.9	804.14	800.82	803.9	5478.0
2008-11-24 21:00:00	ES	Futures	803.66	804.14	801.06	803.19	3327.0
2008-11-24 22:00:00	ES	Futures	803.19	804.61	800.11	800.11	4955.0
2008-11-24 23:00:00	ES	Futures	800.11	801.77	799.4	800.59	4485.0
2008-11-24 00:00:00	NQ	Futures	1248.15	1252.68	1243.91	1246.74	198.0
2008-11-24 01:00:00	NQ	Futures	1246.74	1250.13	1245.04	1249.0	172.0
2008-11-24 02:00:00	NQ	Futures	1247.3	1247.3	1229.76	1230.89	488.0
2008-11-24 03:00:00	NQ	Futures	1232.59	1232.87	1213.63	1229.19	2794.0
2008-11-24 04:00:00	NQ	Futures	1228.91	1250.13	1227.78	1246.45	2019.0
2008-11-24 05:00:00	NQ	Futures	1246.74	1252.4	1243.91	1245.89	1446.0
2008-11-24 06:00:00	NQ	Futures	1245.32	1261.45	1244.76	1258.06	2102.0
2008-11-24 07:00:00	NQ	Futures	1258.06	1262.87	1254.09	1256.36	2417.0
2008-11-24 08:00:00	NQ	Futures	1256.07	1262.58	1252.68	1262.58	5087.0
2008-11-24 09:00:00	NQ	Futures	1262.58	1263.15	1239.95	1254.38	53155.0
2008-11-24 10:00:00	NQ	Futures	1254.38	1286.35	1254.38	1282.67	66327.0
2008-11-24 11:00:00	NQ	Futures	1282.67	1290.03	1272.77	1286.07	45994.0
2008-11-24 12:00:00	NQ	Futures	1286.07	1290.03	1265.7	1276.45	51656.0
2008-11-24 13:00:00	NQ	Futures	1276.73	1285.79	1268.52	1285.79	26493.0
2008-11-24 14:00:00	NQ	Futures	1285.79	1292.29	1274.18	1288.05	42307.0
2008-11-24 15:00:00	NQ	Futures	1287.48	1317.48	1282.96	1301.35	93709.0
2008-11-24 16:00:00	NQ	Futures	1301.63	1305.03	1290.6	1293.43	16316.0
2008-11-24 17:00:00	NQ	Futures	1293.43	1298.24	1290.31	1295.41	1204.0
2008-11-24 18:00:00	NQ	Futures	1295.69	1300.22	1293.43	1297.67	368.0
2008-11-24 19:00:00	NQ	Futures	1297.67	1299.08	1296.54	1298.24	272.0
2008-11-24 20:00:00	NQ	Futures	1296.82	1297.95	1292.29	1297.95	307.0
2008-11-24 21:00:00	NQ	Futures	1297.95	1298.24	1294.27	1297.67	182.0
2008-11-24 22:00:00	NQ	Futures	1297.95	1299.93	1290.88	1290.88	227.0
2008-11-24 23:00:00	NQ	Futures	1292.01	1292.58	1290.03	1291.16	65.0
2008-11-24 00:00:00	YM	Futures	7361.6	7387.1	7343.5	7348.9	510.0
2008-11-24 01:00:00	YM	Futures	7353.5	7379.8	7344.4	7377.1	654.0

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

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