PREVIEW / futures_1hour / 2008-09-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	1102.79	1105.63	1101.13	1105.63	4192.0
2008-09-18 01:00:00	ES	Futures	1105.63	1107.52	1103.73	1107.28	5149.0
2008-09-18 02:00:00	ES	Futures	1107.28	1109.41	1102.31	1104.68	16191.0
2008-09-18 03:00:00	ES	Futures	1104.92	1117.93	1103.26	1116.99	89728.0
2008-09-18 04:00:00	ES	Futures	1116.51	1118.17	1111.07	1116.04	46383.0
2008-09-18 05:00:00	ES	Futures	1115.8	1116.28	1111.54	1114.15	30499.0
2008-09-18 06:00:00	ES	Futures	1113.91	1119.35	1111.07	1118.41	36343.0
2008-09-18 07:00:00	ES	Futures	1118.64	1119.59	1112.49	1113.67	42533.0
2008-09-18 08:00:00	ES	Futures	1113.67	1115.09	1104.21	1108.94	122444.0
2008-09-18 09:00:00	ES	Futures	1108.94	1120.77	1105.39	1118.88	535987.0
2008-09-18 10:00:00	ES	Futures	1119.12	1124.09	1104.44	1105.15	532269.0
2008-09-18 11:00:00	ES	Futures	1105.15	1107.28	1090.48	1099.24	616358.0
2008-09-18 12:00:00	ES	Futures	1099.24	1100.42	1075.57	1076.05	643121.0
2008-09-18 13:00:00	ES	Futures	1075.81	1115.57	1075.81	1109.41	824492.0
2008-09-18 14:00:00	ES	Futures	1109.41	1111.78	1095.92	1109.89	583052.0
2008-09-18 15:00:00	ES	Futures	1109.89	1153.67	1108.7	1141.6	1193431.0
2008-09-18 16:00:00	ES	Futures	1141.36	1143.49	1137.81	1139.23	218175.0
2008-09-18 17:00:00	ES	Futures	1139.47	1141.12	1138.99	1140.89	6106.0
2008-09-18 18:00:00	ES	Futures	1141.6	1155.56	1139.94	1154.14	39737.0
2008-09-18 19:00:00	ES	Futures	1154.14	1166.92	1151.77	1163.61	40923.0
2008-09-18 20:00:00	ES	Futures	1163.61	1174.26	1156.51	1171.42	59636.0
2008-09-18 21:00:00	ES	Futures	1171.18	1173.55	1167.39	1170.0	33268.0
2008-09-18 22:00:00	ES	Futures	1169.52	1170.0	1163.37	1164.32	19914.0
2008-09-18 23:00:00	ES	Futures	1164.08	1168.58	1163.84	1167.87	6417.0
2008-09-18 00:00:00	NQ	Futures	1863.03	1867.56	1860.48	1867.56	284.0
2008-09-18 01:00:00	NQ	Futures	1867.56	1868.69	1865.86	1868.69	604.0
2008-09-18 02:00:00	NQ	Futures	1867.28	1869.82	1859.35	1863.6	1206.0
2008-09-18 03:00:00	NQ	Futures	1863.6	1882.84	1861.9	1881.42	4935.0
2008-09-18 04:00:00	NQ	Futures	1881.71	1886.8	1875.48	1885.67	2978.0
2008-09-18 05:00:00	NQ	Futures	1885.95	1886.8	1879.44	1881.99	2142.0
2008-09-18 06:00:00	NQ	Futures	1881.71	1891.33	1878.59	1890.2	3041.0
2008-09-18 07:00:00	NQ	Futures	1890.2	1891.33	1881.42	1887.37	3151.0
2008-09-18 08:00:00	NQ	Futures	1887.37	1890.48	1876.9	1883.97	11895.0
2008-09-18 09:00:00	NQ	Futures	1883.69	1905.76	1869.26	1888.78	115725.0
2008-09-18 10:00:00	NQ	Futures	1888.78	1903.49	1859.35	1860.2	86740.0
2008-09-18 11:00:00	NQ	Futures	1860.2	1866.71	1837.28	1851.43	109550.0
2008-09-18 12:00:00	NQ	Futures	1851.15	1856.81	1825.11	1828.51	96938.0
2008-09-18 13:00:00	NQ	Futures	1828.51	1867.56	1824.83	1855.39	147338.0
2008-09-18 14:00:00	NQ	Futures	1855.39	1859.92	1840.68	1852.84	100289.0
2008-09-18 15:00:00	NQ	Futures	1853.41	1938.58	1851.15	1920.47	235389.0
2008-09-18 16:00:00	NQ	Futures	1920.76	1937.17	1919.62	1932.07	34926.0
2008-09-18 17:00:00	NQ	Futures	1931.79	1932.64	1928.68	1931.79	566.0
2008-09-18 18:00:00	NQ	Futures	1931.79	1949.62	1931.22	1947.92	2375.0
2008-09-18 19:00:00	NQ	Futures	1948.2	1970.56	1946.79	1966.03	2733.0
2008-09-18 20:00:00	NQ	Futures	1964.9	1986.97	1953.01	1975.37	4275.0
2008-09-18 21:00:00	NQ	Futures	1975.08	1980.74	1970.84	1974.52	1758.0
2008-09-18 22:00:00	NQ	Futures	1973.95	1974.8	1964.05	1969.14	680.0
2008-09-18 23:00:00	NQ	Futures	1969.43	1977.91	1969.14	1977.91	1004.0
2008-09-18 00:00:00	YM	Futures	9708.2	9720.9	9686.4	9720.9	325.0
2008-09-18 01:00:00	YM	Futures	9721.8	9738.2	9709.1	9738.2	325.0

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

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