PREVIEW / futures_1hour / 2008-07-24

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-07-24.parquet
  size:    43 KB
  rows:    1,241

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-07-24 00:00:00	ES	Futures	1190.9	1192.52	1190.66	1192.29	1000.0
2008-07-24 01:00:00	ES	Futures	1192.06	1193.69	1191.36	1192.06	2878.0
2008-07-24 02:00:00	ES	Futures	1192.06	1194.38	1191.59	1194.15	6536.0
2008-07-24 03:00:00	ES	Futures	1193.92	1194.61	1190.2	1190.2	15216.0
2008-07-24 04:00:00	ES	Futures	1190.43	1190.66	1188.34	1190.43	11995.0
2008-07-24 05:00:00	ES	Futures	1190.43	1190.9	1187.41	1187.64	10900.0
2008-07-24 06:00:00	ES	Futures	1187.64	1189.5	1186.95	1188.11	12756.0
2008-07-24 07:00:00	ES	Futures	1188.34	1190.43	1185.78	1189.27	36838.0
2008-07-24 08:00:00	ES	Futures	1189.27	1190.9	1186.95	1189.97	38800.0
2008-07-24 09:00:00	ES	Futures	1189.97	1193.45	1185.55	1186.95	229246.0
2008-07-24 10:00:00	ES	Futures	1187.18	1187.18	1181.13	1182.06	320154.0
2008-07-24 11:00:00	ES	Futures	1182.06	1183.23	1176.02	1179.28	270997.0
2008-07-24 12:00:00	ES	Futures	1179.28	1180.21	1174.86	1177.42	148617.0
2008-07-24 13:00:00	ES	Futures	1177.42	1178.35	1174.63	1175.79	135440.0
2008-07-24 14:00:00	ES	Futures	1175.79	1176.49	1169.28	1171.84	220360.0
2008-07-24 15:00:00	ES	Futures	1171.61	1174.39	1163.01	1165.33	393782.0
2008-07-24 16:00:00	ES	Futures	1165.56	1166.03	1163.24	1165.33	116486.0
2008-07-24 17:00:00	ES	Futures	1165.33	1167.19	1165.1	1166.96	2725.0
2008-07-24 18:00:00	ES	Futures	1166.73	1167.19	1166.26	1166.26	1398.0
2008-07-24 19:00:00	ES	Futures	1166.26	1167.19	1165.33	1166.26	2569.0
2008-07-24 20:00:00	ES	Futures	1166.03	1166.73	1164.87	1165.33	2798.0
2008-07-24 21:00:00	ES	Futures	1165.33	1165.56	1164.17	1164.63	2221.0
2008-07-24 22:00:00	ES	Futures	1164.63	1165.56	1164.17	1165.56	1795.0
2008-07-24 23:00:00	ES	Futures	1165.33	1166.03	1163.24	1163.24	2963.0
2008-07-24 00:00:00	NQ	Futures	2089.41	2091.94	2087.73	2091.1	256.0
2008-07-24 01:00:00	NQ	Futures	2089.69	2094.76	2089.13	2090.82	907.0
2008-07-24 02:00:00	NQ	Futures	2090.82	2095.6	2090.82	2095.32	725.0
2008-07-24 03:00:00	NQ	Futures	2095.04	2095.6	2086.6	2086.6	2048.0
2008-07-24 04:00:00	NQ	Futures	2086.88	2088.01	2083.51	2087.16	1441.0
2008-07-24 05:00:00	NQ	Futures	2086.88	2087.44	2081.82	2081.82	1152.0
2008-07-24 06:00:00	NQ	Futures	2082.1	2086.88	2081.26	2084.35	986.0
2008-07-24 07:00:00	NQ	Futures	2085.19	2091.38	2080.41	2087.16	6018.0
2008-07-24 08:00:00	NQ	Futures	2087.16	2091.1	2082.66	2091.1	5185.0
2008-07-24 09:00:00	NQ	Futures	2090.82	2094.2	2075.35	2080.69	51451.0
2008-07-24 10:00:00	NQ	Futures	2080.97	2080.97	2064.94	2071.13	65892.0
2008-07-24 11:00:00	NQ	Futures	2071.41	2073.38	2059.03	2069.16	50834.0
2008-07-24 12:00:00	NQ	Futures	2069.16	2071.41	2061.57	2066.35	28372.0
2008-07-24 13:00:00	NQ	Futures	2066.35	2075.35	2059.6	2072.54	53993.0
2008-07-24 14:00:00	NQ	Futures	2072.82	2073.94	2059.32	2067.47	44764.0
2008-07-24 15:00:00	NQ	Futures	2067.47	2073.38	2046.66	2047.78	73583.0
2008-07-24 16:00:00	NQ	Futures	2048.06	2049.19	2038.22	2046.38	18068.0
2008-07-24 17:00:00	NQ	Futures	2046.66	2050.88	2046.09	2050.88	609.0
2008-07-24 18:00:00	NQ	Futures	2050.88	2052.56	2050.6	2051.72	398.0
2008-07-24 19:00:00	NQ	Futures	2050.6	2051.44	2048.34	2048.91	76.0
2008-07-24 20:00:00	NQ	Futures	2049.19	2050.6	2048.34	2050.31	183.0
2008-07-24 21:00:00	NQ	Futures	2050.31	2051.16	2047.22	2048.34	150.0
2008-07-24 22:00:00	NQ	Futures	2047.78	2048.06	2046.66	2046.66	162.0
2008-07-24 23:00:00	NQ	Futures	2047.22	2047.78	2044.97	2045.53	131.0
2008-07-24 00:00:00	YM	Futures	10541.1	10555.7	10540.2	10551.1	105.0
2008-07-24 01:00:00	YM	Futures	10554.8	10561.1	10550.2	10552.9	113.0

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

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