PREVIEW / futures_1hour / 2008-09-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	1129.53	1129.77	1127.87	1129.29	1490.0
2008-09-25 01:00:00	ES	Futures	1129.53	1129.53	1127.4	1128.11	2185.0
2008-09-25 02:00:00	ES	Futures	1128.35	1128.35	1125.51	1126.93	6749.0
2008-09-25 03:00:00	ES	Futures	1126.93	1128.35	1125.03	1127.87	11465.0
2008-09-25 04:00:00	ES	Futures	1128.11	1134.5	1127.4	1133.55	15217.0
2008-09-25 05:00:00	ES	Futures	1133.32	1139.23	1132.61	1135.44	25889.0
2008-09-25 06:00:00	ES	Futures	1135.44	1138.28	1129.77	1129.77	33775.0
2008-09-25 07:00:00	ES	Futures	1129.77	1131.42	1125.03	1130.95	40742.0
2008-09-25 08:00:00	ES	Futures	1130.95	1142.31	1130.95	1134.5	130200.0
2008-09-25 09:00:00	ES	Futures	1134.5	1144.67	1130.0	1141.6	322081.0
2008-09-25 10:00:00	ES	Futures	1141.6	1151.77	1139.47	1143.96	433397.0
2008-09-25 11:00:00	ES	Futures	1144.2	1152.96	1143.02	1148.22	305660.0
2008-09-25 12:00:00	ES	Futures	1148.22	1156.51	1147.51	1153.9	233010.0
2008-09-25 13:00:00	ES	Futures	1154.14	1159.35	1151.77	1156.03	311795.0
2008-09-25 14:00:00	ES	Futures	1155.8	1156.74	1145.62	1152.01	301184.0
2008-09-25 15:00:00	ES	Futures	1152.01	1158.4	1143.73	1151.3	408763.0
2008-09-25 16:00:00	ES	Futures	1151.3	1156.03	1146.33	1147.04	105957.0
2008-09-25 17:00:00	ES	Futures	1147.04	1151.54	1142.54	1150.83	16696.0
2008-09-25 18:00:00	ES	Futures	1147.51	1150.12	1144.67	1146.33	10223.0
2008-09-25 19:00:00	ES	Futures	1146.57	1147.75	1138.28	1138.99	20379.0
2008-09-25 20:00:00	ES	Futures	1138.99	1140.89	1132.84	1136.15	19322.0
2008-09-25 21:00:00	ES	Futures	1136.15	1137.81	1132.84	1136.39	9980.0
2008-09-25 22:00:00	ES	Futures	1136.15	1136.86	1132.13	1133.08	7761.0
2008-09-25 23:00:00	ES	Futures	1133.32	1133.79	1128.11	1130.0	11031.0
2008-09-25 00:00:00	NQ	Futures	1891.61	1892.18	1889.35	1892.18	81.0
2008-09-25 01:00:00	NQ	Futures	1892.18	1892.18	1889.91	1889.91	47.0
2008-09-25 02:00:00	NQ	Futures	1890.2	1890.76	1886.52	1889.06	301.0
2008-09-25 03:00:00	NQ	Futures	1889.63	1892.46	1885.67	1892.18	674.0
2008-09-25 04:00:00	NQ	Futures	1892.18	1907.17	1891.89	1905.76	1755.0
2008-09-25 05:00:00	NQ	Futures	1906.04	1917.36	1905.76	1911.98	1978.0
2008-09-25 06:00:00	NQ	Futures	1912.27	1917.36	1901.51	1904.63	1522.0
2008-09-25 07:00:00	NQ	Futures	1903.49	1907.17	1893.59	1900.1	2008.0
2008-09-25 08:00:00	NQ	Futures	1900.1	1917.08	1899.82	1907.17	13563.0
2008-09-25 09:00:00	NQ	Futures	1907.17	1912.83	1893.31	1907.17	48120.0
2008-09-25 10:00:00	NQ	Futures	1907.46	1931.22	1905.48	1915.38	63737.0
2008-09-25 11:00:00	NQ	Futures	1915.66	1926.13	1912.55	1918.21	37629.0
2008-09-25 12:00:00	NQ	Futures	1918.21	1931.22	1915.1	1928.11	29504.0
2008-09-25 13:00:00	NQ	Futures	1928.4	1940.28	1923.87	1932.92	40534.0
2008-09-25 14:00:00	NQ	Futures	1932.92	1933.21	1909.15	1917.64	43378.0
2008-09-25 15:00:00	NQ	Futures	1917.64	1930.94	1908.59	1914.81	48277.0
2008-09-25 16:00:00	NQ	Futures	1914.81	1917.93	1893.31	1893.59	21837.0
2008-09-25 17:00:00	NQ	Futures	1893.31	1898.97	1891.33	1897.27	1271.0
2008-09-25 18:00:00	NQ	Futures	1893.31	1895.29	1889.91	1894.16	700.0
2008-09-25 19:00:00	NQ	Futures	1893.31	1893.31	1881.14	1881.14	516.0
2008-09-25 20:00:00	NQ	Futures	1882.84	1884.54	1873.22	1879.44	703.0
2008-09-25 21:00:00	NQ	Futures	1878.59	1885.67	1877.74	1881.99	434.0
2008-09-25 22:00:00	NQ	Futures	1881.14	1881.14	1874.35	1876.05	285.0
2008-09-25 23:00:00	NQ	Futures	1876.61	1877.46	1870.95	1873.22	207.0
2008-09-25 00:00:00	YM	Futures	9882.8	9882.8	9868.3	9877.4	113.0
2008-09-25 01:00:00	YM	Futures	9878.3	9880.1	9861.9	9865.6	108.0

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

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