PREVIEW / futures_1hour / 2008-09-26

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-26.parquet
  size:    37 KB
  rows:    1,004

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-26 00:00:00	ES	Futures	1130.24	1130.24	1127.4	1128.58	6388.0
2008-09-26 01:00:00	ES	Futures	1128.82	1131.9	1127.64	1131.9	4930.0
2008-09-26 02:00:00	ES	Futures	1131.19	1132.84	1130.95	1131.42	11102.0
2008-09-26 03:00:00	ES	Futures	1131.19	1131.42	1128.11	1130.24	19226.0
2008-09-26 04:00:00	ES	Futures	1130.0	1134.03	1128.35	1132.61	11341.0
2008-09-26 05:00:00	ES	Futures	1132.61	1134.03	1128.58	1129.53	10953.0
2008-09-26 06:00:00	ES	Futures	1129.77	1130.48	1125.51	1130.24	20605.0
2008-09-26 07:00:00	ES	Futures	1130.24	1132.84	1126.93	1130.0	32794.0
2008-09-26 08:00:00	ES	Futures	1130.0	1131.19	1121.48	1124.09	66151.0
2008-09-26 09:00:00	ES	Futures	1123.85	1138.99	1123.85	1133.55	308742.0
2008-09-26 10:00:00	ES	Futures	1133.32	1141.36	1131.19	1138.28	316822.0
2008-09-26 11:00:00	ES	Futures	1138.28	1140.18	1130.24	1131.66	260485.0
2008-09-26 12:00:00	ES	Futures	1131.66	1138.52	1129.53	1138.28	180302.0
2008-09-26 13:00:00	ES	Futures	1138.05	1146.8	1136.86	1142.31	240797.0
2008-09-26 14:00:00	ES	Futures	1142.31	1145.62	1138.76	1139.23	137583.0
2008-09-26 15:00:00	ES	Futures	1139.23	1155.8	1134.26	1154.14	387678.0
2008-09-26 16:00:00	ES	Futures	1154.14	1154.38	1149.17	1149.88	87129.0
2008-09-26 00:00:00	NQ	Futures	1873.22	1875.76	1869.82	1875.76	177.0
2008-09-26 01:00:00	NQ	Futures	1874.35	1878.88	1872.93	1877.46	155.0
2008-09-26 02:00:00	NQ	Futures	1876.61	1880.86	1876.61	1877.74	306.0
2008-09-26 03:00:00	NQ	Futures	1876.9	1880.29	1873.22	1878.03	653.0
2008-09-26 04:00:00	NQ	Futures	1878.31	1884.25	1876.9	1881.42	918.0
2008-09-26 05:00:00	NQ	Futures	1881.14	1884.25	1880.01	1882.56	1079.0
2008-09-26 06:00:00	NQ	Futures	1882.56	1882.56	1873.22	1878.88	1233.0
2008-09-26 07:00:00	NQ	Futures	1878.59	1878.88	1872.65	1877.74	2034.0
2008-09-26 08:00:00	NQ	Futures	1877.18	1879.16	1844.92	1849.45	18184.0
2008-09-26 09:00:00	NQ	Futures	1849.45	1883.12	1849.17	1874.92	65899.0
2008-09-26 10:00:00	NQ	Futures	1874.35	1882.84	1865.58	1876.33	48806.0
2008-09-26 11:00:00	NQ	Futures	1876.05	1880.29	1866.14	1870.67	33391.0
2008-09-26 12:00:00	NQ	Futures	1870.67	1881.71	1864.16	1879.16	29257.0
2008-09-26 13:00:00	NQ	Futures	1879.16	1896.99	1879.16	1884.82	50898.0
2008-09-26 14:00:00	NQ	Futures	1884.82	1888.21	1875.76	1876.05	22761.0
2008-09-26 15:00:00	NQ	Futures	1875.76	1906.04	1868.12	1901.23	71056.0
2008-09-26 16:00:00	NQ	Futures	1901.23	1902.08	1894.44	1898.12	10133.0
2008-09-26 00:00:00	YM	Futures	9872.8	9872.8	9848.3	9853.7	441.0
2008-09-26 01:00:00	YM	Futures	9857.4	9885.6	9851.0	9885.6	266.0
2008-09-26 02:00:00	YM	Futures	9886.5	9899.2	9880.1	9889.2	520.0
2008-09-26 03:00:00	YM	Futures	9887.4	9888.3	9861.0	9881.9	1589.0
2008-09-26 04:00:00	YM	Futures	9881.0	9909.2	9868.3	9900.1	913.0
2008-09-26 05:00:00	YM	Futures	9899.2	9911.0	9869.2	9874.6	1093.0
2008-09-26 06:00:00	YM	Futures	9875.6	9883.7	9848.3	9882.8	1968.0
2008-09-26 07:00:00	YM	Futures	9881.9	9905.6	9857.4	9889.2	2788.0
2008-09-26 08:00:00	YM	Futures	9887.4	9891.0	9822.8	9840.1	6380.0
2008-09-26 09:00:00	YM	Futures	9840.1	9982.9	9837.4	9939.2	29329.0
2008-09-26 10:00:00	YM	Futures	9938.3	10027.4	9929.2	10005.6	29635.0
2008-09-26 11:00:00	YM	Futures	10003.8	10022.9	9948.3	9957.4	22591.0
2008-09-26 12:00:00	YM	Futures	9958.3	10012.9	9933.8	10006.5	16900.0
2008-09-26 13:00:00	YM	Futures	10007.4	10066.6	9992.0	10029.3	20723.0
2008-09-26 14:00:00	YM	Futures	10030.2	10056.5	10006.5	10018.4	13298.0
2008-09-26 15:00:00	YM	Futures	10018.4	10165.7	9983.8	10153.0	35962.0

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

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