PREVIEW / futures_1hour / 2009-03-18

all futures 1-hour files

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

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-03-18 00:00:00	ES	Futures	741.19	741.19	740.23	740.71	2695.0
2009-03-18 01:00:00	ES	Futures	740.71	742.39	740.71	741.67	1838.0
2009-03-18 02:00:00	ES	Futures	741.43	742.63	740.95	742.15	1231.0
2009-03-18 03:00:00	ES	Futures	741.91	742.86	740.23	740.23	7294.0
2009-03-18 04:00:00	ES	Futures	740.23	743.1	739.51	739.99	21462.0
2009-03-18 05:00:00	ES	Futures	740.23	740.23	736.87	738.07	20704.0
2009-03-18 06:00:00	ES	Futures	738.31	740.23	738.07	738.79	13350.0
2009-03-18 07:00:00	ES	Futures	738.79	741.67	737.83	738.31	20809.0
2009-03-18 08:00:00	ES	Futures	738.31	739.99	736.63	737.83	52496.0
2009-03-18 09:00:00	ES	Futures	737.83	738.79	733.76	736.39	218777.0
2009-03-18 10:00:00	ES	Futures	736.39	737.59	730.16	736.63	373336.0
2009-03-18 11:00:00	ES	Futures	736.87	738.07	733.04	737.35	202535.0
2009-03-18 12:00:00	ES	Futures	737.35	742.39	737.11	741.67	252568.0
2009-03-18 13:00:00	ES	Futures	741.67	745.26	739.03	742.63	198964.0
2009-03-18 14:00:00	ES	Futures	742.63	767.31	740.95	764.19	770678.0
2009-03-18 15:00:00	ES	Futures	764.19	764.43	747.9	757.24	730060.0
2009-03-18 16:00:00	ES	Futures	757.24	759.4	756.04	758.92	135381.0
2009-03-18 17:00:00	ES	Futures	758.92	759.4	758.2	758.44	1968.0
2009-03-18 18:00:00	ES	Futures	758.2	758.2	755.09	755.57	5714.0
2009-03-18 19:00:00	ES	Futures	755.57	756.76	755.09	755.57	2504.0
2009-03-18 20:00:00	ES	Futures	755.57	755.57	753.17	753.89	4564.0
2009-03-18 21:00:00	ES	Futures	754.13	754.85	752.69	752.93	2864.0
2009-03-18 22:00:00	ES	Futures	752.93	753.89	751.73	753.89	3132.0
2009-03-18 23:00:00	ES	Futures	753.65	755.09	753.17	754.61	2926.0
2009-03-18 00:00:00	NQ	Futures	1349.1	1349.66	1347.39	1348.81	89.0
2009-03-18 01:00:00	NQ	Futures	1348.53	1351.08	1348.53	1348.81	76.0
2009-03-18 02:00:00	NQ	Futures	1349.66	1350.52	1348.53	1349.38	111.0
2009-03-18 03:00:00	NQ	Futures	1349.66	1352.51	1347.96	1348.53	593.0
2009-03-18 04:00:00	NQ	Futures	1348.24	1353.07	1348.24	1349.1	1516.0
2009-03-18 05:00:00	NQ	Futures	1348.81	1349.38	1344.55	1346.82	1276.0
2009-03-18 06:00:00	NQ	Futures	1346.82	1351.08	1346.82	1348.81	669.0
2009-03-18 07:00:00	NQ	Futures	1348.81	1355.92	1348.53	1348.81	1901.0
2009-03-18 08:00:00	NQ	Futures	1348.53	1351.08	1347.39	1349.38	4698.0
2009-03-18 09:00:00	NQ	Futures	1349.66	1355.63	1344.55	1352.22	30995.0
2009-03-18 10:00:00	NQ	Futures	1352.51	1355.35	1340.0	1350.8	43719.0
2009-03-18 11:00:00	NQ	Futures	1350.52	1353.07	1343.13	1352.51	26854.0
2009-03-18 12:00:00	NQ	Futures	1352.51	1361.6	1352.22	1360.46	30866.0
2009-03-18 13:00:00	NQ	Futures	1360.46	1363.59	1354.49	1359.89	27831.0
2009-03-18 14:00:00	NQ	Futures	1359.89	1392.0	1357.62	1387.45	98301.0
2009-03-18 15:00:00	NQ	Futures	1387.74	1388.31	1358.19	1368.99	91335.0
2009-03-18 16:00:00	NQ	Futures	1368.99	1379.78	1368.42	1378.36	15677.0
2009-03-18 17:00:00	NQ	Futures	1378.36	1378.65	1377.51	1377.51	131.0
2009-03-18 18:00:00	NQ	Futures	1378.36	1378.36	1375.24	1375.52	440.0
2009-03-18 19:00:00	NQ	Futures	1375.24	1376.66	1374.67	1376.09	291.0
2009-03-18 20:00:00	NQ	Futures	1374.67	1375.24	1372.11	1372.68	181.0
2009-03-18 21:00:00	NQ	Futures	1372.68	1374.67	1370.12	1370.41	148.0
2009-03-18 22:00:00	NQ	Futures	1370.41	1371.26	1368.7	1371.26	167.0
2009-03-18 23:00:00	NQ	Futures	1370.41	1372.11	1370.12	1371.54	166.0
2009-03-18 00:00:00	YM	Futures	6742.3	6742.3	6732.2	6734.1	206.0
2009-03-18 01:00:00	YM	Futures	6734.1	6746.9	6734.1	6741.4	159.0

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

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