PREVIEW / futures_1hour / 2009-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-04.parquet
  size:    44 KB
  rows:    1,265

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-02-04 00:00:00	ES	Futures	792.67	793.15	790.78	791.49	1465.0
2009-02-04 01:00:00	ES	Futures	791.49	792.44	790.06	790.78	1518.0
2009-02-04 02:00:00	ES	Futures	791.01	792.2	788.4	789.59	6285.0
2009-02-04 03:00:00	ES	Futures	789.59	791.25	786.51	789.12	18601.0
2009-02-04 04:00:00	ES	Futures	789.12	793.62	788.64	792.91	12896.0
2009-02-04 05:00:00	ES	Futures	792.67	795.05	791.96	792.2	13419.0
2009-02-04 06:00:00	ES	Futures	792.2	792.2	788.88	790.3	13057.0
2009-02-04 07:00:00	ES	Futures	790.06	792.44	789.12	791.49	13550.0
2009-02-04 08:00:00	ES	Futures	791.25	797.65	790.3	793.62	48653.0
2009-02-04 09:00:00	ES	Futures	793.86	800.97	791.72	800.26	229138.0
2009-02-04 10:00:00	ES	Futures	800.26	805.96	800.03	803.35	339102.0
2009-02-04 11:00:00	ES	Futures	803.58	804.06	799.08	799.79	200936.0
2009-02-04 12:00:00	ES	Futures	799.79	801.45	796.71	797.42	147705.0
2009-02-04 13:00:00	ES	Futures	797.42	798.37	785.08	788.88	367064.0
2009-02-04 14:00:00	ES	Futures	788.64	791.25	783.66	790.06	360162.0
2009-02-04 15:00:00	ES	Futures	790.06	791.01	785.56	786.03	329713.0
2009-02-04 16:00:00	ES	Futures	786.03	789.12	783.66	784.13	82908.0
2009-02-04 17:00:00	ES	Futures	783.9	784.85	781.76	783.19	6717.0
2009-02-04 18:00:00	ES	Futures	782.71	784.13	782.24	783.9	3468.0
2009-02-04 19:00:00	ES	Futures	783.9	784.13	781.05	781.76	3807.0
2009-02-04 20:00:00	ES	Futures	782.0	782.95	781.05	782.71	2170.0
2009-02-04 21:00:00	ES	Futures	782.71	783.42	782.24	782.71	1865.0
2009-02-04 22:00:00	ES	Futures	782.71	785.56	782.71	785.32	3581.0
2009-02-04 23:00:00	ES	Futures	785.08	786.51	782.95	783.42	3322.0
2009-02-04 00:00:00	NQ	Futures	1369.55	1370.39	1365.31	1366.16	162.0
2009-02-04 01:00:00	NQ	Futures	1366.16	1367.29	1364.46	1365.88	128.0
2009-02-04 02:00:00	NQ	Futures	1365.88	1367.57	1362.77	1363.62	306.0
2009-02-04 03:00:00	NQ	Futures	1363.62	1366.44	1359.66	1361.64	1149.0
2009-02-04 04:00:00	NQ	Futures	1362.77	1370.11	1361.64	1368.7	432.0
2009-02-04 05:00:00	NQ	Futures	1368.98	1372.37	1367.85	1368.7	851.0
2009-02-04 06:00:00	NQ	Futures	1368.13	1368.13	1361.36	1365.03	1200.0
2009-02-04 07:00:00	NQ	Futures	1364.75	1368.98	1362.77	1365.59	1104.0
2009-02-04 08:00:00	NQ	Futures	1365.88	1374.63	1365.03	1369.83	5400.0
2009-02-04 09:00:00	NQ	Futures	1369.83	1391.85	1367.29	1390.72	41248.0
2009-02-04 10:00:00	NQ	Futures	1391.01	1403.71	1390.72	1400.04	58740.0
2009-02-04 11:00:00	NQ	Futures	1399.76	1402.58	1393.55	1395.53	28963.0
2009-02-04 12:00:00	NQ	Futures	1395.53	1398.07	1388.47	1389.31	22937.0
2009-02-04 13:00:00	NQ	Futures	1389.31	1391.57	1366.72	1373.78	50318.0
2009-02-04 14:00:00	NQ	Futures	1374.06	1378.02	1365.31	1377.45	43199.0
2009-02-04 15:00:00	NQ	Futures	1377.17	1379.99	1370.11	1370.96	44189.0
2009-02-04 16:00:00	NQ	Futures	1371.24	1375.76	1361.36	1363.9	9373.0
2009-02-04 17:00:00	NQ	Futures	1366.72	1366.72	1346.39	1347.52	4962.0
2009-02-04 18:00:00	NQ	Futures	1349.21	1349.5	1344.7	1346.39	1391.0
2009-02-04 19:00:00	NQ	Futures	1346.67	1346.96	1343.85	1345.54	1010.0
2009-02-04 20:00:00	NQ	Futures	1344.7	1344.98	1343.85	1343.85	640.0
2009-02-04 21:00:00	NQ	Futures	1344.41	1345.26	1343.85	1344.7	437.0
2009-02-04 22:00:00	NQ	Futures	1344.41	1347.24	1344.41	1346.39	1007.0
2009-02-04 23:00:00	NQ	Futures	1346.39	1349.21	1344.7	1345.26	487.0
2009-02-04 00:00:00	YM	Futures	7307.5	7307.5	7290.2	7294.7	165.0
2009-02-04 01:00:00	YM	Futures	7293.8	7302.9	7287.5	7290.2	277.0

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

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