PREVIEW / futures_1hour / 2009-02-03

all futures 1-hour files

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

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-03 00:00:00	ES	Futures	782.71	784.37	778.68	779.87	4305.0
2009-02-03 01:00:00	ES	Futures	779.87	782.95	778.68	781.05	2534.0
2009-02-03 02:00:00	ES	Futures	781.05	783.19	778.44	782.0	5996.0
2009-02-03 03:00:00	ES	Futures	782.0	784.37	779.15	782.47	13362.0
2009-02-03 04:00:00	ES	Futures	782.24	782.71	778.21	778.68	10144.0
2009-02-03 05:00:00	ES	Futures	778.44	778.92	774.17	774.88	15750.0
2009-02-03 06:00:00	ES	Futures	774.88	779.15	774.88	777.26	11554.0
2009-02-03 07:00:00	ES	Futures	777.02	783.19	776.31	780.58	20270.0
2009-02-03 08:00:00	ES	Futures	780.58	781.76	778.21	781.29	20368.0
2009-02-03 09:00:00	ES	Futures	781.05	785.56	776.07	778.21	247980.0
2009-02-03 10:00:00	ES	Futures	778.44	785.08	776.54	782.24	387085.0
2009-02-03 11:00:00	ES	Futures	782.47	787.22	781.05	781.76	219052.0
2009-02-03 12:00:00	ES	Futures	781.76	783.9	779.87	780.1	179310.0
2009-02-03 13:00:00	ES	Futures	780.1	784.85	779.39	782.95	150583.0
2009-02-03 14:00:00	ES	Futures	782.95	791.72	781.76	789.59	286945.0
2009-02-03 15:00:00	ES	Futures	789.35	796.71	787.93	791.25	400730.0
2009-02-03 16:00:00	ES	Futures	791.25	791.72	787.46	788.88	90958.0
2009-02-03 17:00:00	ES	Futures	788.88	791.25	788.4	791.25	2475.0
2009-02-03 18:00:00	ES	Futures	790.3	791.49	789.12	789.59	3222.0
2009-02-03 19:00:00	ES	Futures	789.35	791.72	788.88	791.01	2363.0
2009-02-03 20:00:00	ES	Futures	791.01	791.72	790.78	791.25	1424.0
2009-02-03 21:00:00	ES	Futures	791.49	792.2	790.78	791.25	2098.0
2009-02-03 22:00:00	ES	Futures	791.01	791.49	789.59	791.01	1678.0
2009-02-03 23:00:00	ES	Futures	791.25	793.15	790.06	792.67	1907.0
2009-02-03 00:00:00	NQ	Futures	1348.37	1350.06	1341.87	1343.0	240.0
2009-02-03 01:00:00	NQ	Futures	1342.72	1345.54	1340.18	1344.7	155.0
2009-02-03 02:00:00	NQ	Futures	1344.98	1348.93	1341.31	1347.52	505.0
2009-02-03 03:00:00	NQ	Futures	1347.52	1352.6	1343.28	1350.91	1791.0
2009-02-03 04:00:00	NQ	Futures	1350.34	1351.76	1345.83	1346.67	1263.0
2009-02-03 05:00:00	NQ	Futures	1346.39	1346.39	1337.64	1338.2	1228.0
2009-02-03 06:00:00	NQ	Futures	1338.48	1348.65	1337.92	1341.87	961.0
2009-02-03 07:00:00	NQ	Futures	1341.59	1351.76	1340.46	1348.09	1616.0
2009-02-03 08:00:00	NQ	Futures	1348.09	1348.37	1342.72	1346.96	3498.0
2009-02-03 09:00:00	NQ	Futures	1346.96	1354.02	1330.01	1335.38	50949.0
2009-02-03 10:00:00	NQ	Futures	1335.38	1354.58	1333.68	1349.78	60206.0
2009-02-03 11:00:00	NQ	Futures	1350.06	1359.1	1349.5	1351.47	32832.0
2009-02-03 12:00:00	NQ	Futures	1351.76	1353.17	1346.96	1347.24	24598.0
2009-02-03 13:00:00	NQ	Futures	1347.24	1354.02	1345.54	1350.91	22384.0
2009-02-03 14:00:00	NQ	Futures	1350.91	1367.29	1350.63	1363.05	41564.0
2009-02-03 15:00:00	NQ	Futures	1363.33	1375.48	1360.23	1369.26	51249.0
2009-02-03 16:00:00	NQ	Futures	1369.55	1370.11	1361.07	1363.62	9671.0
2009-02-03 17:00:00	NQ	Futures	1364.46	1369.55	1363.33	1368.42	192.0
2009-02-03 18:00:00	NQ	Futures	1367.0	1368.7	1366.44	1366.72	152.0
2009-02-03 19:00:00	NQ	Futures	1366.16	1368.98	1365.03	1367.85	98.0
2009-02-03 20:00:00	NQ	Futures	1367.85	1368.42	1367.57	1368.42	35.0
2009-02-03 21:00:00	NQ	Futures	1367.85	1368.98	1366.72	1366.72	119.0
2009-02-03 22:00:00	NQ	Futures	1367.0	1367.0	1364.46	1366.16	172.0
2009-02-03 23:00:00	NQ	Futures	1365.88	1369.55	1364.75	1368.98	65.0
2009-02-03 00:00:00	YM	Futures	7209.1	7220.9	7180.8	7190.0	612.0
2009-02-03 01:00:00	YM	Futures	7190.0	7212.7	7180.8	7196.3	404.0

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

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