PREVIEW / futures_1hour / 2009-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-02-06.parquet
  size:    38 KB
  rows:    1,066

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-06 00:00:00	ES	Futures	796.94	797.65	795.99	796.47	1206.0
2009-02-06 01:00:00	ES	Futures	796.47	798.6	796.23	796.47	1897.0
2009-02-06 02:00:00	ES	Futures	796.47	799.31	794.1	797.89	8125.0
2009-02-06 03:00:00	ES	Futures	797.89	799.55	794.81	795.28	12645.0
2009-02-06 04:00:00	ES	Futures	795.28	797.42	793.86	796.23	9403.0
2009-02-06 05:00:00	ES	Futures	796.23	798.84	796.23	798.37	8932.0
2009-02-06 06:00:00	ES	Futures	798.37	800.5	797.18	799.31	10249.0
2009-02-06 07:00:00	ES	Futures	799.31	800.5	796.71	798.6	13083.0
2009-02-06 08:00:00	ES	Futures	798.6	804.77	794.57	803.11	118072.0
2009-02-06 09:00:00	ES	Futures	803.11	814.97	799.08	813.55	374866.0
2009-02-06 10:00:00	ES	Futures	813.78	815.44	809.99	813.07	329166.0
2009-02-06 11:00:00	ES	Futures	813.31	818.05	813.07	816.87	261620.0
2009-02-06 12:00:00	ES	Futures	816.87	817.82	813.31	816.63	182842.0
2009-02-06 13:00:00	ES	Futures	816.63	823.98	815.44	822.8	242317.0
2009-02-06 14:00:00	ES	Futures	822.8	823.98	818.05	820.19	262439.0
2009-02-06 15:00:00	ES	Futures	820.19	824.69	815.68	820.66	439312.0
2009-02-06 16:00:00	ES	Futures	820.9	823.98	820.19	823.51	112384.0
2009-02-06 00:00:00	NQ	Futures	1394.96	1396.09	1394.4	1394.96	213.0
2009-02-06 01:00:00	NQ	Futures	1394.96	1398.63	1394.96	1395.81	59.0
2009-02-06 02:00:00	NQ	Futures	1395.81	1399.76	1390.72	1398.07	493.0
2009-02-06 03:00:00	NQ	Futures	1399.48	1400.61	1392.98	1392.98	550.0
2009-02-06 04:00:00	NQ	Futures	1393.55	1397.22	1391.29	1394.68	665.0
2009-02-06 05:00:00	NQ	Futures	1396.09	1401.74	1394.68	1400.89	858.0
2009-02-06 06:00:00	NQ	Futures	1401.17	1405.69	1400.33	1403.71	1524.0
2009-02-06 07:00:00	NQ	Futures	1402.87	1404.84	1397.78	1400.61	941.0
2009-02-06 08:00:00	NQ	Futures	1400.89	1409.64	1390.44	1406.26	12346.0
2009-02-06 09:00:00	NQ	Futures	1406.26	1430.82	1401.74	1428.0	72763.0
2009-02-06 10:00:00	NQ	Futures	1428.28	1430.54	1418.96	1425.74	55354.0
2009-02-06 11:00:00	NQ	Futures	1425.74	1435.06	1425.74	1433.36	34800.0
2009-02-06 12:00:00	NQ	Futures	1433.36	1435.34	1427.15	1432.8	26009.0
2009-02-06 13:00:00	NQ	Futures	1432.8	1444.94	1431.11	1442.4	33306.0
2009-02-06 14:00:00	NQ	Futures	1442.68	1445.22	1435.06	1439.01	31553.0
2009-02-06 15:00:00	NQ	Futures	1439.01	1444.94	1430.26	1437.88	50978.0
2009-02-06 16:00:00	NQ	Futures	1437.88	1441.55	1435.91	1440.71	10903.0
2009-02-06 00:00:00	YM	Futures	7280.2	7286.5	7274.7	7280.2	126.0
2009-02-06 01:00:00	YM	Futures	7279.3	7299.3	7279.3	7279.3	139.0
2009-02-06 02:00:00	YM	Futures	7278.3	7297.5	7261.9	7287.5	794.0
2009-02-06 03:00:00	YM	Futures	7287.5	7307.5	7270.1	7272.9	1571.0
2009-02-06 04:00:00	YM	Futures	7271.1	7286.5	7258.3	7274.7	799.0
2009-02-06 05:00:00	YM	Futures	7273.8	7299.3	7273.8	7295.7	570.0
2009-02-06 06:00:00	YM	Futures	7292.0	7310.2	7282.9	7301.1	877.0
2009-02-06 07:00:00	YM	Futures	7301.1	7310.2	7282.9	7296.6	744.0
2009-02-06 08:00:00	YM	Futures	7298.4	7351.2	7262.9	7338.5	8842.0
2009-02-06 09:00:00	YM	Futures	7338.5	7459.7	7310.2	7450.6	33885.0
2009-02-06 10:00:00	YM	Futures	7451.5	7471.5	7422.3	7455.1	34869.0
2009-02-06 11:00:00	YM	Futures	7455.1	7498.0	7455.1	7487.0	22486.0
2009-02-06 12:00:00	YM	Futures	7487.0	7493.4	7456.0	7479.7	17841.0
2009-02-06 13:00:00	YM	Futures	7480.6	7533.5	7470.6	7524.4	21714.0
2009-02-06 14:00:00	YM	Futures	7524.4	7545.3	7496.1	7509.8	24037.0
2009-02-06 15:00:00	YM	Futures	7508.9	7543.5	7469.7	7508.9	31591.0

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

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