PREVIEW / futures_1hour / 2008-02-06

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-02-06.parquet
  size:    30 KB
  rows:    832

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-02-06 00:00:00	ES	Futures	1249.95	1252.28	1249.95	1250.18	1797.0
2008-02-06 01:00:00	ES	Futures	1250.18	1250.88	1249.02	1249.02	2119.0
2008-02-06 02:00:00	ES	Futures	1249.02	1253.45	1248.55	1250.88	8480.0
2008-02-06 03:00:00	ES	Futures	1251.12	1258.34	1251.12	1257.64	25086.0
2008-02-06 04:00:00	ES	Futures	1257.88	1258.34	1251.35	1252.75	20316.0
2008-02-06 05:00:00	ES	Futures	1252.98	1258.58	1252.98	1256.25	18513.0
2008-02-06 06:00:00	ES	Futures	1256.01	1259.98	1254.85	1256.71	19226.0
2008-02-06 07:00:00	ES	Futures	1256.71	1258.81	1256.01	1257.88	18199.0
2008-02-06 08:00:00	ES	Futures	1257.88	1259.51	1254.61	1257.18	58106.0
2008-02-06 09:00:00	ES	Futures	1257.18	1257.88	1244.82	1249.25	283969.0
2008-02-06 10:00:00	ES	Futures	1249.25	1258.58	1249.25	1256.71	380114.0
2008-02-06 11:00:00	ES	Futures	1256.71	1262.07	1255.55	1259.04	222273.0
2008-02-06 12:00:00	ES	Futures	1259.04	1259.74	1251.82	1253.45	129524.0
2008-02-06 13:00:00	ES	Futures	1253.45	1255.08	1246.22	1247.15	184129.0
2008-02-06 14:00:00	ES	Futures	1247.15	1249.25	1241.56	1246.92	276618.0
2008-02-06 15:00:00	ES	Futures	1246.69	1248.55	1235.49	1238.53	387021.0
2008-02-06 16:00:00	ES	Futures	1238.53	1247.85	1236.19	1236.43	145885.0
2008-02-06 17:00:00	ES	Futures	1236.43	1236.66	1231.53	1232.23	22502.0
2008-02-06 18:00:00	ES	Futures	1232.23	1234.56	1231.53	1234.1	5389.0
2008-02-06 19:00:00	ES	Futures	1234.1	1235.03	1232.7	1232.93	2173.0
2008-02-06 20:00:00	ES	Futures	1232.7	1233.4	1231.76	1232.23	1635.0
2008-02-06 21:00:00	ES	Futures	1232.0	1232.46	1231.53	1232.23	1114.0
2008-02-06 22:00:00	ES	Futures	1232.46	1232.93	1231.53	1232.93	1522.0
2008-02-06 23:00:00	ES	Futures	1232.93	1233.86	1232.0	1233.63	1511.0
2008-02-06 00:00:00	NQ	Futures	2021.53	2026.64	2020.97	2023.24	133.0
2008-02-06 01:00:00	NQ	Futures	2023.24	2023.24	2020.97	2020.97	111.0
2008-02-06 02:00:00	NQ	Futures	2020.97	2028.06	2020.4	2023.81	386.0
2008-02-06 03:00:00	NQ	Futures	2024.66	2034.31	2024.09	2033.74	1377.0
2008-02-06 04:00:00	NQ	Futures	2034.31	2034.59	2023.52	2026.64	946.0
2008-02-06 05:00:00	NQ	Futures	2026.64	2036.29	2026.36	2033.17	1580.0
2008-02-06 06:00:00	NQ	Futures	2032.89	2036.58	2030.05	2031.47	1320.0
2008-02-06 07:00:00	NQ	Futures	2031.75	2037.71	2030.62	2035.44	1890.0
2008-02-06 08:00:00	NQ	Futures	2035.73	2036.58	2028.35	2032.89	5616.0
2008-02-06 09:00:00	NQ	Futures	2033.46	2033.74	2018.98	2027.21	43747.0
2008-02-06 10:00:00	NQ	Futures	2027.21	2041.4	2024.37	2035.44	85554.0
2008-02-06 11:00:00	NQ	Futures	2035.44	2045.09	2032.89	2037.15	44696.0
2008-02-06 12:00:00	NQ	Futures	2037.15	2039.13	2024.94	2028.06	27677.0
2008-02-06 13:00:00	NQ	Futures	2028.06	2028.91	2005.92	2007.63	42920.0
2008-02-06 14:00:00	NQ	Futures	2007.63	2011.03	1993.15	2004.5	64408.0
2008-02-06 15:00:00	NQ	Futures	2005.07	2008.48	1979.53	1982.93	83083.0
2008-02-06 16:00:00	NQ	Futures	1982.93	2004.79	1961.36	1963.35	33754.0
2008-02-06 17:00:00	NQ	Futures	1962.78	1963.35	1950.86	1952.84	5808.0
2008-02-06 18:00:00	NQ	Futures	1954.26	1957.39	1953.98	1957.39	904.0
2008-02-06 19:00:00	NQ	Futures	1957.39	1958.52	1955.4	1955.68	320.0
2008-02-06 20:00:00	NQ	Futures	1955.97	1956.53	1953.98	1954.26	186.0
2008-02-06 21:00:00	NQ	Futures	1955.12	1955.68	1953.7	1955.68	79.0
2008-02-06 22:00:00	NQ	Futures	1955.97	1956.25	1954.55	1954.83	44.0
2008-02-06 23:00:00	NQ	Futures	1956.25	1957.67	1954.83	1957.67	79.0
2008-02-06 00:00:00	YM	Futures	11166.4	11182.7	11162.7	11162.7	193.0
2008-02-06 01:00:00	YM	Futures	11162.7	11172.7	11156.4	11156.4	253.0

> showing 50 of 832 rows — these rows as CSV

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