PREVIEW / futures_1hour / 2009-01-16

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-01-16.parquet
  size:    38 KB
  rows:    1,030

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-16 00:00:00	ES	Futures	801.92	804.53	801.45	804.3	3709.0
2009-01-16 01:00:00	ES	Futures	804.3	806.43	803.35	803.35	5423.0
2009-01-16 02:00:00	ES	Futures	803.35	804.53	800.03	803.11	8022.0
2009-01-16 03:00:00	ES	Futures	803.11	806.43	800.26	805.72	22791.0
2009-01-16 04:00:00	ES	Futures	805.72	810.23	802.87	809.04	23911.0
2009-01-16 05:00:00	ES	Futures	809.04	810.7	805.72	806.43	23569.0
2009-01-16 06:00:00	ES	Futures	806.43	813.78	803.58	812.12	34769.0
2009-01-16 07:00:00	ES	Futures	812.36	813.07	808.56	811.17	25802.0
2009-01-16 08:00:00	ES	Futures	810.94	811.17	804.77	807.62	58587.0
2009-01-16 09:00:00	ES	Futures	807.62	812.12	804.06	805.24	339123.0
2009-01-16 10:00:00	ES	Futures	805.01	809.51	801.69	802.87	372839.0
2009-01-16 11:00:00	ES	Futures	802.87	803.58	791.72	793.38	360852.0
2009-01-16 12:00:00	ES	Futures	793.38	794.57	783.9	791.49	363046.0
2009-01-16 13:00:00	ES	Futures	791.72	797.18	787.93	796.71	230370.0
2009-01-16 14:00:00	ES	Futures	796.71	802.87	793.62	802.4	333478.0
2009-01-16 15:00:00	ES	Futures	802.4	807.85	798.84	802.4	468838.0
2009-01-16 16:00:00	ES	Futures	802.4	805.96	801.92	805.72	102333.0
2009-01-16 00:00:00	NQ	Futures	1340.18	1343.85	1340.18	1343.85	131.0
2009-01-16 01:00:00	NQ	Futures	1343.85	1346.39	1342.44	1342.72	187.0
2009-01-16 02:00:00	NQ	Futures	1342.16	1343.0	1336.51	1342.16	232.0
2009-01-16 03:00:00	NQ	Futures	1343.0	1345.26	1336.79	1344.41	951.0
2009-01-16 04:00:00	NQ	Futures	1344.7	1350.63	1339.61	1349.21	914.0
2009-01-16 05:00:00	NQ	Futures	1348.93	1353.45	1344.7	1346.11	1604.0
2009-01-16 06:00:00	NQ	Futures	1346.11	1356.56	1341.59	1354.3	1840.0
2009-01-16 07:00:00	NQ	Futures	1354.3	1355.14	1348.65	1352.04	1883.0
2009-01-16 08:00:00	NQ	Futures	1352.32	1352.6	1344.13	1348.09	5505.0
2009-01-16 09:00:00	NQ	Futures	1347.8	1355.99	1341.03	1343.0	52972.0
2009-01-16 10:00:00	NQ	Futures	1343.0	1350.63	1336.23	1341.87	43300.0
2009-01-16 11:00:00	NQ	Futures	1341.59	1342.72	1326.62	1330.01	37255.0
2009-01-16 12:00:00	NQ	Futures	1330.01	1331.99	1315.33	1327.47	38918.0
2009-01-16 13:00:00	NQ	Futures	1327.75	1339.05	1322.11	1337.07	26990.0
2009-01-16 14:00:00	NQ	Futures	1337.07	1347.24	1332.55	1346.39	35432.0
2009-01-16 15:00:00	NQ	Futures	1346.39	1354.86	1341.03	1348.65	49766.0
2009-01-16 16:00:00	NQ	Futures	1348.65	1354.3	1347.52	1352.32	9928.0
2009-01-16 00:00:00	YM	Futures	7482.5	7507.1	7482.5	7507.1	355.0
2009-01-16 01:00:00	YM	Futures	7507.1	7527.1	7503.4	7503.4	685.0
2009-01-16 02:00:00	YM	Futures	7502.5	7511.6	7474.3	7507.1	637.0
2009-01-16 03:00:00	YM	Futures	7507.1	7527.1	7483.4	7522.6	1154.0
2009-01-16 04:00:00	YM	Futures	7520.7	7556.3	7497.1	7546.3	752.0
2009-01-16 05:00:00	YM	Futures	7547.2	7562.7	7530.8	7536.2	1071.0
2009-01-16 06:00:00	YM	Futures	7535.3	7586.4	7508.9	7568.1	1810.0
2009-01-16 07:00:00	YM	Futures	7570.0	7580.0	7543.5	7564.5	1234.0
2009-01-16 08:00:00	YM	Futures	7562.7	7563.6	7513.5	7534.4	3886.0
2009-01-16 09:00:00	YM	Futures	7533.5	7559.0	7496.1	7502.5	20573.0
2009-01-16 10:00:00	YM	Futures	7501.6	7539.0	7481.6	7512.5	30123.0
2009-01-16 11:00:00	YM	Futures	7511.6	7516.2	7412.3	7426.9	28880.0
2009-01-16 12:00:00	YM	Futures	7426.9	7434.2	7344.0	7398.6	25753.0
2009-01-16 13:00:00	YM	Futures	7398.6	7443.3	7365.8	7439.6	20136.0
2009-01-16 14:00:00	YM	Futures	7440.6	7504.3	7415.9	7499.8	29744.0
2009-01-16 15:00:00	YM	Futures	7501.6	7548.1	7473.4	7489.8	39224.0

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

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