PREVIEW / futures_1hour / 2008-09-30

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-30.parquet
  size:    47 KB
  rows:    1,269

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
2008-09-30 00:00:00	ES	Futures	1069.18	1072.73	1067.53	1071.08	7040.0
2008-09-30 01:00:00	ES	Futures	1071.08	1074.15	1069.66	1072.5	7789.0
2008-09-30 02:00:00	ES	Futures	1072.73	1078.65	1070.37	1077.94	25049.0
2008-09-30 03:00:00	ES	Futures	1078.18	1088.35	1074.63	1087.41	65943.0
2008-09-30 04:00:00	ES	Futures	1087.41	1092.85	1085.04	1087.88	47014.0
2008-09-30 05:00:00	ES	Futures	1087.88	1092.85	1085.28	1089.77	29141.0
2008-09-30 06:00:00	ES	Futures	1090.01	1092.37	1084.09	1084.33	35028.0
2008-09-30 07:00:00	ES	Futures	1084.09	1088.35	1080.54	1084.09	42483.0
2008-09-30 08:00:00	ES	Futures	1084.09	1084.57	1078.18	1079.6	71856.0
2008-09-30 09:00:00	ES	Futures	1079.83	1081.73	1071.55	1076.28	289956.0
2008-09-30 10:00:00	ES	Futures	1076.28	1090.72	1072.73	1083.15	462359.0
2008-09-30 11:00:00	ES	Futures	1083.15	1092.14	1080.54	1090.24	285397.0
2008-09-30 12:00:00	ES	Futures	1090.48	1091.66	1082.44	1090.24	157766.0
2008-09-30 13:00:00	ES	Futures	1090.24	1099.71	1084.57	1096.4	317085.0
2008-09-30 14:00:00	ES	Futures	1096.4	1104.21	1094.27	1100.66	253388.0
2008-09-30 15:00:00	ES	Futures	1100.66	1112.96	1096.87	1111.31	569275.0
2008-09-30 16:00:00	ES	Futures	1111.07	1112.73	1101.84	1102.79	179480.0
2008-09-30 17:00:00	ES	Futures	1102.79	1104.68	1102.08	1103.73	5673.0
2008-09-30 18:00:00	ES	Futures	1103.26	1106.57	1100.42	1100.42	7451.0
2008-09-30 19:00:00	ES	Futures	1100.42	1108.94	1100.42	1105.63	8713.0
2008-09-30 20:00:00	ES	Futures	1105.63	1107.99	1100.42	1101.6	5992.0
2008-09-30 21:00:00	ES	Futures	1101.6	1101.6	1098.76	1099.0	4393.0
2008-09-30 22:00:00	ES	Futures	1098.76	1101.6	1098.76	1100.18	2618.0
2008-09-30 23:00:00	ES	Futures	1100.18	1100.42	1098.53	1099.24	1987.0
2008-09-30 00:00:00	NQ	Futures	1729.47	1731.17	1722.4	1726.64	640.0
2008-09-30 01:00:00	NQ	Futures	1726.64	1730.6	1724.38	1729.47	528.0
2008-09-30 02:00:00	NQ	Futures	1728.62	1733.72	1727.77	1733.43	1712.0
2008-09-30 03:00:00	NQ	Futures	1733.43	1743.62	1728.06	1743.05	3771.0
2008-09-30 04:00:00	NQ	Futures	1743.05	1752.96	1741.36	1745.88	2605.0
2008-09-30 05:00:00	NQ	Futures	1746.45	1756.07	1742.49	1749.0	1568.0
2008-09-30 06:00:00	NQ	Futures	1749.28	1754.09	1727.49	1728.34	4624.0
2008-09-30 07:00:00	NQ	Futures	1728.34	1744.75	1721.27	1738.53	5364.0
2008-09-30 08:00:00	NQ	Futures	1738.24	1739.94	1727.77	1732.3	5834.0
2008-09-30 09:00:00	NQ	Futures	1731.74	1755.79	1729.47	1745.88	57063.0
2008-09-30 10:00:00	NQ	Futures	1745.32	1769.65	1737.68	1758.05	76028.0
2008-09-30 11:00:00	NQ	Futures	1758.05	1780.41	1753.24	1778.42	52516.0
2008-09-30 12:00:00	NQ	Futures	1778.42	1780.69	1760.88	1776.44	30706.0
2008-09-30 13:00:00	NQ	Futures	1776.44	1788.33	1767.11	1779.56	43777.0
2008-09-30 14:00:00	NQ	Futures	1779.84	1796.25	1778.14	1791.44	32904.0
2008-09-30 15:00:00	NQ	Futures	1791.44	1817.47	1785.22	1812.95	84518.0
2008-09-30 16:00:00	NQ	Futures	1812.95	1814.93	1800.78	1805.87	20877.0
2008-09-30 17:00:00	NQ	Futures	1805.87	1808.14	1805.31	1807.85	407.0
2008-09-30 18:00:00	NQ	Futures	1806.72	1816.06	1799.65	1801.91	835.0
2008-09-30 19:00:00	NQ	Futures	1800.78	1811.25	1799.93	1808.98	561.0
2008-09-30 20:00:00	NQ	Futures	1809.27	1810.68	1802.76	1804.46	239.0
2008-09-30 21:00:00	NQ	Futures	1803.04	1805.02	1800.21	1800.21	222.0
2008-09-30 22:00:00	NQ	Futures	1800.21	1802.76	1799.08	1801.06	142.0
2008-09-30 23:00:00	NQ	Futures	1800.78	1801.34	1800.5	1801.06	54.0
2008-09-30 00:00:00	YM	Futures	9600.0	9618.2	9569.0	9604.5	533.0
2008-09-30 01:00:00	YM	Futures	9606.3	9633.6	9590.9	9622.7	375.0

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

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