PREVIEW / futures_1hour / 2008-09-29

all futures 1-hour files

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

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-29 00:00:00	ES	Futures	1140.41	1140.89	1136.15	1136.39	5400.0
2008-09-29 01:00:00	ES	Futures	1136.63	1137.57	1134.97	1135.68	3790.0
2008-09-29 02:00:00	ES	Futures	1135.68	1137.1	1132.61	1134.74	15338.0
2008-09-29 03:00:00	ES	Futures	1134.74	1136.63	1123.85	1127.87	54922.0
2008-09-29 04:00:00	ES	Futures	1127.87	1129.06	1123.85	1127.87	27754.0
2008-09-29 05:00:00	ES	Futures	1127.87	1132.84	1126.22	1127.64	28310.0
2008-09-29 06:00:00	ES	Futures	1127.64	1131.42	1126.69	1128.35	19647.0
2008-09-29 07:00:00	ES	Futures	1128.35	1132.37	1125.27	1131.66	28779.0
2008-09-29 08:00:00	ES	Futures	1131.66	1136.63	1129.06	1132.84	70418.0
2008-09-29 09:00:00	ES	Futures	1133.08	1135.44	1106.57	1113.91	414426.0
2008-09-29 10:00:00	ES	Futures	1113.91	1119.35	1103.5	1113.44	536814.0
2008-09-29 11:00:00	ES	Futures	1113.44	1115.8	1105.15	1110.12	271515.0
2008-09-29 12:00:00	ES	Futures	1109.89	1112.73	1100.66	1107.52	260700.0
2008-09-29 13:00:00	ES	Futures	1107.52	1115.09	1056.64	1085.51	626249.0
2008-09-29 14:00:00	ES	Futures	1085.51	1095.21	1062.32	1075.81	552234.0
2008-09-29 15:00:00	ES	Futures	1075.81	1081.73	1054.04	1070.84	708278.0
2008-09-29 16:00:00	ES	Futures	1071.08	1071.55	1052.62	1056.17	277947.0
2008-09-29 17:00:00	ES	Futures	1056.17	1058.3	1055.46	1058.06	10520.0
2008-09-29 18:00:00	ES	Futures	1057.82	1061.85	1055.22	1061.37	8498.0
2008-09-29 19:00:00	ES	Futures	1061.37	1062.32	1058.06	1058.77	6705.0
2008-09-29 20:00:00	ES	Futures	1058.53	1066.82	1058.3	1065.4	8738.0
2008-09-29 21:00:00	ES	Futures	1065.4	1066.11	1060.9	1062.08	7385.0
2008-09-29 22:00:00	ES	Futures	1062.32	1066.11	1060.66	1065.87	7403.0
2008-09-29 23:00:00	ES	Futures	1066.11	1069.42	1064.45	1069.18	8024.0
2008-09-29 00:00:00	NQ	Futures	1882.84	1885.1	1877.74	1880.01	452.0
2008-09-29 01:00:00	NQ	Futures	1880.01	1881.14	1878.31	1879.73	183.0
2008-09-29 02:00:00	NQ	Futures	1879.73	1881.14	1873.78	1877.18	399.0
2008-09-29 03:00:00	NQ	Futures	1878.03	1880.86	1848.32	1857.94	3285.0
2008-09-29 04:00:00	NQ	Futures	1858.5	1864.16	1856.24	1859.07	1079.0
2008-09-29 05:00:00	NQ	Futures	1858.5	1867.56	1854.82	1856.24	1187.0
2008-09-29 06:00:00	NQ	Futures	1856.24	1861.9	1855.39	1858.79	606.0
2008-09-29 07:00:00	NQ	Futures	1858.5	1867.28	1854.54	1862.18	1703.0
2008-09-29 08:00:00	NQ	Futures	1862.18	1866.99	1856.81	1861.05	5865.0
2008-09-29 09:00:00	NQ	Futures	1860.77	1866.43	1805.87	1814.08	65558.0
2008-09-29 10:00:00	NQ	Futures	1814.08	1822.0	1782.95	1805.87	95751.0
2008-09-29 11:00:00	NQ	Futures	1805.59	1808.7	1790.59	1795.12	40586.0
2008-09-29 12:00:00	NQ	Futures	1794.55	1805.31	1786.91	1797.67	39640.0
2008-09-29 13:00:00	NQ	Futures	1797.67	1806.16	1740.51	1762.86	84042.0
2008-09-29 14:00:00	NQ	Futures	1763.14	1782.95	1736.83	1750.69	101984.0
2008-09-29 15:00:00	NQ	Futures	1750.69	1769.94	1717.02	1729.76	113963.0
2008-09-29 16:00:00	NQ	Futures	1728.91	1730.32	1690.99	1709.38	47264.0
2008-09-29 17:00:00	NQ	Futures	1709.1	1711.93	1706.55	1710.51	529.0
2008-09-29 18:00:00	NQ	Futures	1712.49	1716.46	1709.95	1714.76	1334.0
2008-09-29 19:00:00	NQ	Futures	1715.32	1719.0	1714.48	1714.48	618.0
2008-09-29 20:00:00	NQ	Futures	1714.19	1722.4	1713.34	1721.55	610.0
2008-09-29 21:00:00	NQ	Futures	1721.83	1722.68	1717.02	1717.59	318.0
2008-09-29 22:00:00	NQ	Futures	1718.72	1723.81	1717.02	1723.81	374.0
2008-09-29 23:00:00	NQ	Futures	1724.38	1730.04	1723.53	1729.19	556.0
2008-09-29 00:00:00	YM	Futures	10072.0	10077.5	10032.0	10042.9	469.0
2008-09-29 01:00:00	YM	Futures	10038.4	10062.0	10030.2	10036.5	271.0

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

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