PREVIEW / futures_1hour / 2009-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-06.parquet
  size:    44 KB
  rows:    1,256

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-04-06 00:00:00	ES	Futures	811.4	812.6	810.68	810.92	2286.0
2009-04-06 01:00:00	ES	Futures	811.16	812.12	807.09	807.33	4944.0
2009-04-06 02:00:00	ES	Futures	807.33	810.44	805.41	805.65	11823.0
2009-04-06 03:00:00	ES	Futures	805.65	809.72	804.21	808.52	22135.0
2009-04-06 04:00:00	ES	Futures	808.52	811.64	808.28	810.2	12658.0
2009-04-06 05:00:00	ES	Futures	809.96	811.16	807.57	807.81	14474.0
2009-04-06 06:00:00	ES	Futures	807.81	809.24	807.33	807.81	10791.0
2009-04-06 07:00:00	ES	Futures	808.05	808.05	800.86	801.34	27286.0
2009-04-06 08:00:00	ES	Futures	801.34	802.29	795.82	797.02	54642.0
2009-04-06 09:00:00	ES	Futures	797.26	797.26	790.79	793.43	230352.0
2009-04-06 10:00:00	ES	Futures	793.19	797.02	789.35	791.27	312930.0
2009-04-06 11:00:00	ES	Futures	791.27	791.51	786.24	787.2	222081.0
2009-04-06 12:00:00	ES	Futures	786.96	789.11	784.8	789.11	129313.0
2009-04-06 13:00:00	ES	Futures	788.87	791.51	786.0	790.55	156159.0
2009-04-06 14:00:00	ES	Futures	790.55	793.67	787.68	791.51	254251.0
2009-04-06 15:00:00	ES	Futures	791.51	799.42	789.59	796.3	405829.0
2009-04-06 16:00:00	ES	Futures	796.3	798.7	795.58	797.5	90776.0
2009-04-06 17:00:00	ES	Futures	797.74	799.18	797.5	798.22	2999.0
2009-04-06 18:00:00	ES	Futures	797.98	798.94	797.26	797.26	2623.0
2009-04-06 19:00:00	ES	Futures	797.26	797.98	794.87	796.78	4122.0
2009-04-06 20:00:00	ES	Futures	796.78	797.26	794.87	794.87	3827.0
2009-04-06 21:00:00	ES	Futures	795.1	796.54	794.87	796.3	2427.0
2009-04-06 22:00:00	ES	Futures	796.3	796.3	793.67	793.67	3331.0
2009-04-06 23:00:00	ES	Futures	793.91	795.1	792.95	795.1	3050.0
2009-04-06 00:00:00	NQ	Futures	1505.66	1507.36	1504.52	1505.37	128.0
2009-04-06 01:00:00	NQ	Futures	1505.09	1507.65	1498.84	1499.69	347.0
2009-04-06 02:00:00	NQ	Futures	1498.55	1504.52	1496.0	1496.0	458.0
2009-04-06 03:00:00	NQ	Futures	1496.28	1502.82	1494.86	1500.54	1376.0
2009-04-06 04:00:00	NQ	Futures	1500.54	1506.51	1500.54	1505.09	850.0
2009-04-06 05:00:00	NQ	Futures	1503.95	1505.66	1499.69	1499.69	818.0
2009-04-06 06:00:00	NQ	Futures	1499.97	1502.53	1498.84	1499.97	804.0
2009-04-06 07:00:00	NQ	Futures	1499.97	1499.97	1486.62	1487.47	3038.0
2009-04-06 08:00:00	NQ	Futures	1487.47	1489.46	1473.27	1476.11	6601.0
2009-04-06 09:00:00	NQ	Futures	1475.82	1481.22	1466.45	1471.84	37090.0
2009-04-06 10:00:00	NQ	Futures	1471.84	1477.81	1462.18	1465.88	39132.0
2009-04-06 11:00:00	NQ	Futures	1466.16	1470.42	1461.05	1465.59	27680.0
2009-04-06 12:00:00	NQ	Futures	1465.59	1472.41	1461.62	1472.13	21254.0
2009-04-06 13:00:00	NQ	Futures	1472.41	1480.94	1467.01	1477.53	26277.0
2009-04-06 14:00:00	NQ	Futures	1477.53	1484.35	1471.84	1482.36	29127.0
2009-04-06 15:00:00	NQ	Futures	1482.64	1492.87	1475.25	1490.03	50122.0
2009-04-06 16:00:00	NQ	Futures	1489.75	1494.86	1489.18	1494.01	7240.0
2009-04-06 17:00:00	NQ	Futures	1494.29	1495.43	1493.15	1493.15	151.0
2009-04-06 18:00:00	NQ	Futures	1493.15	1494.86	1491.17	1491.73	151.0
2009-04-06 19:00:00	NQ	Futures	1491.45	1492.87	1487.76	1491.45	172.0
2009-04-06 20:00:00	NQ	Futures	1491.73	1493.44	1489.18	1489.46	294.0
2009-04-06 21:00:00	NQ	Futures	1489.46	1492.3	1488.89	1492.3	134.0
2009-04-06 22:00:00	NQ	Futures	1491.73	1492.02	1487.47	1487.76	119.0
2009-04-06 23:00:00	NQ	Futures	1488.04	1490.31	1486.05	1490.03	362.0
2009-04-06 00:00:00	YM	Futures	7387.4	7394.8	7383.8	7383.8	334.0
2009-04-06 01:00:00	YM	Futures	7385.6	7393.9	7352.5	7353.4	664.0

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

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