PREVIEW / futures_1hour / 2009-01-27

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-27.parquet
  size:    45 KB
  rows:    1,307

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-27 00:00:00	ES	Futures	796.94	799.08	796.23	796.71	2748.0
2009-01-27 01:00:00	ES	Futures	796.94	799.55	796.71	798.37	1878.0
2009-01-27 02:00:00	ES	Futures	798.37	801.45	798.37	800.74	7477.0
2009-01-27 03:00:00	ES	Futures	800.74	801.69	797.65	799.79	19898.0
2009-01-27 04:00:00	ES	Futures	799.79	801.45	796.23	796.71	14112.0
2009-01-27 05:00:00	ES	Futures	796.94	797.18	792.91	794.81	17201.0
2009-01-27 06:00:00	ES	Futures	795.05	795.99	790.78	792.44	17442.0
2009-01-27 07:00:00	ES	Futures	792.2	794.81	789.83	793.62	15571.0
2009-01-27 08:00:00	ES	Futures	793.86	798.6	793.38	797.65	34198.0
2009-01-27 09:00:00	ES	Futures	797.89	801.21	792.91	797.42	214557.0
2009-01-27 10:00:00	ES	Futures	797.42	798.37	788.64	794.1	373858.0
2009-01-27 11:00:00	ES	Futures	794.33	799.79	793.15	796.71	198913.0
2009-01-27 12:00:00	ES	Futures	796.71	804.06	795.28	801.45	196525.0
2009-01-27 13:00:00	ES	Futures	801.21	803.58	797.18	797.18	199217.0
2009-01-27 14:00:00	ES	Futures	797.18	800.5	793.15	799.79	211814.0
2009-01-27 15:00:00	ES	Futures	799.79	803.58	796.23	798.37	286953.0
2009-01-27 16:00:00	ES	Futures	798.13	800.03	794.81	799.08	100944.0
2009-01-27 17:00:00	ES	Futures	798.84	806.9	798.84	805.24	14146.0
2009-01-27 18:00:00	ES	Futures	805.01	808.56	804.77	806.19	10887.0
2009-01-27 19:00:00	ES	Futures	805.96	808.09	805.24	805.72	6652.0
2009-01-27 20:00:00	ES	Futures	805.48	807.85	805.48	807.62	4361.0
2009-01-27 21:00:00	ES	Futures	807.85	809.28	807.62	809.04	5491.0
2009-01-27 22:00:00	ES	Futures	809.04	812.12	809.04	811.17	9021.0
2009-01-27 23:00:00	ES	Futures	811.17	812.83	811.17	812.36	3579.0
2009-01-27 00:00:00	NQ	Futures	1343.57	1346.39	1343.0	1344.98	160.0
2009-01-27 01:00:00	NQ	Futures	1345.26	1348.09	1344.13	1346.96	96.0
2009-01-27 02:00:00	NQ	Futures	1347.52	1349.21	1344.98	1345.83	1050.0
2009-01-27 03:00:00	NQ	Futures	1345.83	1347.52	1340.74	1342.72	1667.0
2009-01-27 04:00:00	NQ	Futures	1344.7	1347.24	1337.92	1340.18	998.0
2009-01-27 05:00:00	NQ	Futures	1340.74	1341.03	1332.84	1336.79	808.0
2009-01-27 06:00:00	NQ	Futures	1337.07	1339.33	1330.86	1333.4	1000.0
2009-01-27 07:00:00	NQ	Futures	1333.4	1338.2	1328.6	1336.79	1262.0
2009-01-27 08:00:00	NQ	Futures	1337.07	1343.0	1335.1	1341.31	2204.0
2009-01-27 09:00:00	NQ	Futures	1341.31	1351.76	1334.81	1346.96	33373.0
2009-01-27 10:00:00	NQ	Futures	1346.96	1347.8	1334.81	1341.87	41883.0
2009-01-27 11:00:00	NQ	Futures	1342.16	1350.34	1340.46	1344.13	24267.0
2009-01-27 12:00:00	NQ	Futures	1344.13	1355.71	1341.31	1351.76	31956.0
2009-01-27 13:00:00	NQ	Futures	1351.76	1354.02	1345.54	1345.54	26514.0
2009-01-27 14:00:00	NQ	Futures	1345.83	1350.34	1338.77	1349.5	32288.0
2009-01-27 15:00:00	NQ	Futures	1349.78	1355.43	1343.85	1345.83	38379.0
2009-01-27 16:00:00	NQ	Futures	1345.26	1347.52	1336.51	1346.39	10642.0
2009-01-27 17:00:00	NQ	Futures	1346.67	1356.56	1345.83	1353.45	1024.0
2009-01-27 18:00:00	NQ	Futures	1355.71	1358.53	1354.3	1355.99	836.0
2009-01-27 19:00:00	NQ	Futures	1355.43	1359.1	1355.43	1356.84	435.0
2009-01-27 20:00:00	NQ	Futures	1357.12	1358.25	1355.43	1357.97	302.0
2009-01-27 21:00:00	NQ	Futures	1358.25	1360.23	1357.69	1359.95	212.0
2009-01-27 22:00:00	NQ	Futures	1359.95	1363.33	1359.66	1361.92	518.0
2009-01-27 23:00:00	NQ	Futures	1362.77	1364.46	1362.49	1363.62	333.0
2009-01-27 00:00:00	YM	Futures	7403.2	7417.8	7400.5	7402.3	223.0
2009-01-27 01:00:00	YM	Futures	7402.3	7419.6	7402.3	7410.5	83.0

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

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