PREVIEW / futures_1hour / 2008-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-09-23.parquet
  size:    44 KB
  rows:    1,238

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-23 00:00:00	ES	Futures	1153.43	1153.9	1152.01	1152.25	2343.0
2008-09-23 01:00:00	ES	Futures	1152.25	1153.19	1151.77	1152.48	1554.0
2008-09-23 02:00:00	ES	Futures	1152.48	1153.67	1150.83	1153.67	7207.0
2008-09-23 03:00:00	ES	Futures	1153.67	1154.38	1149.17	1152.01	18923.0
2008-09-23 04:00:00	ES	Futures	1152.01	1152.72	1146.8	1147.04	16267.0
2008-09-23 05:00:00	ES	Futures	1147.28	1149.64	1145.38	1149.17	17982.0
2008-09-23 06:00:00	ES	Futures	1148.93	1149.41	1144.44	1146.33	15034.0
2008-09-23 07:00:00	ES	Futures	1146.33	1149.64	1143.25	1144.67	34660.0
2008-09-23 08:00:00	ES	Futures	1144.67	1149.17	1142.07	1146.33	52438.0
2008-09-23 09:00:00	ES	Futures	1146.57	1157.45	1142.78	1150.83	317742.0
2008-09-23 10:00:00	ES	Futures	1150.83	1157.22	1143.49	1145.62	400371.0
2008-09-23 11:00:00	ES	Futures	1145.62	1151.54	1142.07	1144.91	318340.0
2008-09-23 12:00:00	ES	Futures	1144.91	1148.46	1136.63	1137.1	260230.0
2008-09-23 13:00:00	ES	Futures	1137.1	1137.57	1123.38	1128.58	475569.0
2008-09-23 14:00:00	ES	Futures	1128.82	1145.38	1124.8	1140.41	498411.0
2008-09-23 15:00:00	ES	Futures	1140.18	1149.64	1124.09	1125.51	521964.0
2008-09-23 16:00:00	ES	Futures	1125.51	1126.69	1122.19	1126.45	118271.0
2008-09-23 17:00:00	ES	Futures	1126.69	1126.93	1125.74	1126.93	2940.0
2008-09-23 18:00:00	ES	Futures	1135.21	1145.62	1134.97	1138.52	54229.0
2008-09-23 19:00:00	ES	Futures	1138.76	1140.65	1133.79	1138.52	10307.0
2008-09-23 20:00:00	ES	Futures	1138.28	1138.99	1133.32	1135.44	8265.0
2008-09-23 21:00:00	ES	Futures	1135.21	1138.99	1133.32	1138.05	7591.0
2008-09-23 22:00:00	ES	Futures	1137.81	1139.7	1137.34	1139.23	4326.0
2008-09-23 23:00:00	ES	Futures	1139.47	1139.7	1137.34	1138.28	1654.0
2008-09-23 00:00:00	NQ	Futures	1900.1	1904.06	1899.82	1899.82	498.0
2008-09-23 01:00:00	NQ	Futures	1900.38	1902.08	1899.25	1899.53	63.0
2008-09-23 02:00:00	NQ	Futures	1900.66	1903.49	1896.99	1902.36	679.0
2008-09-23 03:00:00	NQ	Futures	1902.65	1902.93	1896.14	1898.68	1358.0
2008-09-23 04:00:00	NQ	Futures	1899.82	1901.51	1892.46	1892.46	777.0
2008-09-23 05:00:00	NQ	Futures	1892.74	1893.31	1888.21	1891.61	1658.0
2008-09-23 06:00:00	NQ	Futures	1892.18	1893.59	1887.93	1890.2	977.0
2008-09-23 07:00:00	NQ	Futures	1889.91	1896.14	1885.38	1888.5	2108.0
2008-09-23 08:00:00	NQ	Futures	1888.5	1902.93	1883.97	1902.36	7366.0
2008-09-23 09:00:00	NQ	Futures	1902.36	1914.81	1896.99	1908.87	53681.0
2008-09-23 10:00:00	NQ	Futures	1909.15	1926.13	1903.21	1908.87	61005.0
2008-09-23 11:00:00	NQ	Futures	1908.59	1920.19	1902.93	1907.17	42356.0
2008-09-23 12:00:00	NQ	Futures	1907.17	1909.15	1887.93	1890.76	38272.0
2008-09-23 13:00:00	NQ	Futures	1891.04	1891.33	1865.01	1875.2	63749.0
2008-09-23 14:00:00	NQ	Futures	1875.48	1911.13	1870.95	1903.49	63431.0
2008-09-23 15:00:00	NQ	Futures	1903.78	1915.94	1867.84	1871.52	68657.0
2008-09-23 16:00:00	NQ	Futures	1872.09	1875.2	1866.99	1870.1	15387.0
2008-09-23 17:00:00	NQ	Futures	1870.1	1870.1	1867.28	1868.41	145.0
2008-09-23 18:00:00	NQ	Futures	1875.48	1894.72	1874.35	1882.56	3637.0
2008-09-23 19:00:00	NQ	Futures	1883.4	1887.08	1881.71	1886.8	1051.0
2008-09-23 20:00:00	NQ	Futures	1886.52	1887.93	1883.4	1886.8	635.0
2008-09-23 21:00:00	NQ	Futures	1886.23	1895.85	1885.95	1894.16	758.0
2008-09-23 22:00:00	NQ	Futures	1893.31	1896.99	1893.02	1895.01	256.0
2008-09-23 23:00:00	NQ	Futures	1895.01	1896.14	1892.74	1895.85	266.0
2008-09-23 00:00:00	YM	Futures	10087.5	10094.7	10082.0	10086.6	97.0
2008-09-23 01:00:00	YM	Futures	10082.9	10091.1	10082.0	10091.1	109.0

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

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