PREVIEW / futures_1hour / 2009-01-28

all futures 1-hour files

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

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-28 00:00:00	ES	Futures	812.36	812.83	810.94	811.89	3486.0
2009-01-28 01:00:00	ES	Futures	812.12	812.12	811.17	811.89	2140.0
2009-01-28 02:00:00	ES	Futures	811.89	813.55	810.46	812.12	9620.0
2009-01-28 03:00:00	ES	Futures	812.12	816.15	811.41	815.21	33163.0
2009-01-28 04:00:00	ES	Futures	814.97	815.68	812.83	813.78	12032.0
2009-01-28 05:00:00	ES	Futures	813.78	816.15	811.65	812.36	15440.0
2009-01-28 06:00:00	ES	Futures	812.12	816.39	811.89	815.68	18526.0
2009-01-28 07:00:00	ES	Futures	815.44	817.34	811.89	817.1	27207.0
2009-01-28 08:00:00	ES	Futures	817.1	819.48	814.49	816.87	59305.0
2009-01-28 09:00:00	ES	Futures	817.1	818.76	812.6	813.31	258060.0
2009-01-28 10:00:00	ES	Futures	813.31	820.42	812.6	819.0	285833.0
2009-01-28 11:00:00	ES	Futures	819.0	821.37	816.39	818.05	240444.0
2009-01-28 12:00:00	ES	Futures	817.82	820.66	817.58	819.48	107498.0
2009-01-28 13:00:00	ES	Futures	819.48	827.3	818.29	824.22	213617.0
2009-01-28 14:00:00	ES	Futures	823.98	831.1	821.37	827.07	402542.0
2009-01-28 15:00:00	ES	Futures	827.07	828.73	817.1	825.4	458353.0
2009-01-28 16:00:00	ES	Futures	825.64	827.78	825.17	826.12	92191.0
2009-01-28 17:00:00	ES	Futures	826.12	826.83	825.88	826.12	838.0
2009-01-28 18:00:00	ES	Futures	825.88	826.83	824.46	824.93	4073.0
2009-01-28 19:00:00	ES	Futures	824.93	825.17	822.8	823.98	3254.0
2009-01-28 20:00:00	ES	Futures	823.74	825.17	823.51	824.46	1833.0
2009-01-28 21:00:00	ES	Futures	824.22	824.46	822.32	823.27	2679.0
2009-01-28 22:00:00	ES	Futures	823.27	824.46	821.85	821.85	2623.0
2009-01-28 23:00:00	ES	Futures	822.08	823.51	820.9	821.85	3175.0
2009-01-28 00:00:00	NQ	Futures	1364.18	1364.18	1361.92	1363.05	117.0
2009-01-28 01:00:00	NQ	Futures	1363.05	1363.33	1361.64	1362.77	107.0
2009-01-28 02:00:00	NQ	Futures	1362.77	1366.72	1360.79	1363.05	823.0
2009-01-28 03:00:00	NQ	Futures	1363.33	1373.78	1362.49	1372.37	2857.0
2009-01-28 04:00:00	NQ	Futures	1372.37	1372.37	1368.7	1370.68	884.0
2009-01-28 05:00:00	NQ	Futures	1371.24	1373.22	1366.44	1367.85	1028.0
2009-01-28 06:00:00	NQ	Futures	1368.13	1372.93	1367.57	1371.81	828.0
2009-01-28 07:00:00	NQ	Futures	1371.24	1371.24	1363.62	1369.83	2271.0
2009-01-28 08:00:00	NQ	Futures	1369.55	1374.63	1366.72	1370.39	4965.0
2009-01-28 09:00:00	NQ	Futures	1370.68	1376.32	1365.31	1369.26	41691.0
2009-01-28 10:00:00	NQ	Futures	1369.26	1383.95	1368.98	1381.12	45404.0
2009-01-28 11:00:00	NQ	Futures	1381.12	1387.9	1380.28	1384.51	36587.0
2009-01-28 12:00:00	NQ	Futures	1384.51	1389.6	1384.23	1387.62	17942.0
2009-01-28 13:00:00	NQ	Futures	1387.05	1400.33	1385.36	1395.24	34584.0
2009-01-28 14:00:00	NQ	Futures	1394.96	1405.97	1390.72	1399.76	51164.0
2009-01-28 15:00:00	NQ	Futures	1399.76	1402.02	1378.58	1392.14	63445.0
2009-01-28 16:00:00	NQ	Futures	1392.14	1394.11	1386.21	1387.62	12046.0
2009-01-28 17:00:00	NQ	Futures	1387.9	1389.6	1387.05	1389.31	75.0
2009-01-28 18:00:00	NQ	Futures	1387.34	1388.75	1384.51	1385.36	256.0
2009-01-28 19:00:00	NQ	Futures	1385.36	1385.92	1383.95	1384.23	59.0
2009-01-28 20:00:00	NQ	Futures	1384.79	1388.18	1383.95	1387.9	191.0
2009-01-28 21:00:00	NQ	Futures	1387.05	1387.05	1382.25	1382.54	357.0
2009-01-28 22:00:00	NQ	Futures	1383.1	1384.51	1381.69	1381.69	184.0
2009-01-28 23:00:00	NQ	Futures	1381.97	1383.95	1381.41	1381.41	183.0
2009-01-28 00:00:00	YM	Futures	7498.9	7498.9	7487.0	7493.4	298.0
2009-01-28 01:00:00	YM	Futures	7493.4	7494.3	7485.2	7488.8	186.0

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

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