PREVIEW / futures_1hour / 2009-01-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	828.73	828.96	827.3	827.54	3067.0
2009-01-13 01:00:00	ES	Futures	827.54	827.54	825.4	825.4	2418.0
2009-01-13 02:00:00	ES	Futures	825.4	826.59	824.69	825.4	6504.0
2009-01-13 03:00:00	ES	Futures	825.17	825.88	821.14	821.61	19765.0
2009-01-13 04:00:00	ES	Futures	821.37	821.61	816.87	817.34	18828.0
2009-01-13 05:00:00	ES	Futures	817.58	819.0	813.07	814.49	24206.0
2009-01-13 06:00:00	ES	Futures	814.26	817.1	813.31	815.68	12138.0
2009-01-13 07:00:00	ES	Futures	815.68	820.19	815.68	818.05	19084.0
2009-01-13 08:00:00	ES	Futures	818.29	821.85	815.68	821.14	46843.0
2009-01-13 09:00:00	ES	Futures	820.9	827.3	817.34	825.17	264229.0
2009-01-13 10:00:00	ES	Futures	825.4	828.96	820.42	825.88	326336.0
2009-01-13 11:00:00	ES	Futures	825.88	829.2	821.61	827.78	266264.0
2009-01-13 12:00:00	ES	Futures	827.78	828.49	822.56	822.56	169079.0
2009-01-13 13:00:00	ES	Futures	822.8	823.74	814.97	815.92	208707.0
2009-01-13 14:00:00	ES	Futures	815.68	826.12	814.02	821.37	321706.0
2009-01-13 15:00:00	ES	Futures	821.61	826.35	815.68	822.56	472125.0
2009-01-13 16:00:00	ES	Futures	822.56	824.69	821.61	822.8	75690.0
2009-01-13 17:00:00	ES	Futures	822.8	824.22	822.32	823.98	1465.0
2009-01-13 18:00:00	ES	Futures	824.22	824.93	823.51	824.93	1702.0
2009-01-13 19:00:00	ES	Futures	824.93	828.73	824.93	827.54	4586.0
2009-01-13 20:00:00	ES	Futures	827.78	830.15	827.78	828.96	3702.0
2009-01-13 21:00:00	ES	Futures	828.73	829.2	827.78	828.96	1900.0
2009-01-13 22:00:00	ES	Futures	828.96	830.15	828.25	828.25	2867.0
2009-01-13 23:00:00	ES	Futures	828.25	829.91	827.54	828.25	1902.0
2009-01-13 00:00:00	NQ	Futures	1368.98	1371.52	1367.85	1368.42	245.0
2009-01-13 01:00:00	NQ	Futures	1367.85	1367.85	1365.03	1365.03	71.0
2009-01-13 02:00:00	NQ	Futures	1365.03	1366.16	1363.05	1364.46	131.0
2009-01-13 03:00:00	NQ	Futures	1363.33	1364.46	1356.84	1357.97	741.0
2009-01-13 04:00:00	NQ	Futures	1357.69	1357.69	1350.91	1351.76	1566.0
2009-01-13 05:00:00	NQ	Futures	1351.76	1353.73	1344.7	1346.39	1275.0
2009-01-13 06:00:00	NQ	Futures	1346.11	1349.78	1344.41	1348.09	900.0
2009-01-13 07:00:00	NQ	Futures	1348.09	1355.71	1348.09	1352.6	1214.0
2009-01-13 08:00:00	NQ	Futures	1352.89	1362.77	1349.21	1361.36	3861.0
2009-01-13 09:00:00	NQ	Futures	1361.36	1376.32	1352.32	1372.37	43870.0
2009-01-13 10:00:00	NQ	Futures	1372.37	1375.76	1358.25	1367.29	40843.0
2009-01-13 11:00:00	NQ	Futures	1367.57	1369.55	1358.25	1365.59	30525.0
2009-01-13 12:00:00	NQ	Futures	1365.59	1367.29	1354.3	1354.3	23270.0
2009-01-13 13:00:00	NQ	Futures	1354.58	1355.99	1340.46	1342.16	32293.0
2009-01-13 14:00:00	NQ	Futures	1342.16	1360.23	1338.48	1352.89	42491.0
2009-01-13 15:00:00	NQ	Futures	1352.6	1362.2	1342.72	1355.43	52408.0
2009-01-13 16:00:00	NQ	Futures	1355.43	1361.07	1354.86	1357.97	6820.0
2009-01-13 17:00:00	NQ	Futures	1357.97	1359.66	1357.4	1358.82	89.0
2009-01-13 18:00:00	NQ	Futures	1360.23	1360.23	1355.43	1357.69	638.0
2009-01-13 19:00:00	NQ	Futures	1358.53	1364.75	1358.53	1362.2	315.0
2009-01-13 20:00:00	NQ	Futures	1363.33	1366.72	1363.33	1365.59	56.0
2009-01-13 21:00:00	NQ	Futures	1365.03	1365.03	1363.05	1364.75	43.0
2009-01-13 22:00:00	NQ	Futures	1364.18	1367.57	1364.18	1365.03	115.0
2009-01-13 23:00:00	NQ	Futures	1364.75	1366.16	1363.62	1364.46	32.0
2009-01-13 00:00:00	YM	Futures	7732.2	7733.1	7722.1	7722.1	127.0
2009-01-13 01:00:00	YM	Futures	7724.0	7724.0	7704.8	7704.8	138.0

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

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