PREVIEW / futures_1hour / 2008-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-08-14.parquet
  size:    42 KB
  rows:    1,214

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-08-14 00:00:00	ES	Futures	1196.24	1196.47	1195.78	1196.01	600.0
2008-08-14 01:00:00	ES	Futures	1196.01	1196.71	1195.54	1195.54	787.0
2008-08-14 02:00:00	ES	Futures	1195.54	1197.17	1194.15	1196.71	5824.0
2008-08-14 03:00:00	ES	Futures	1196.71	1199.26	1194.38	1198.57	13033.0
2008-08-14 04:00:00	ES	Futures	1198.8	1198.8	1196.47	1196.94	6844.0
2008-08-14 05:00:00	ES	Futures	1197.17	1198.1	1195.08	1196.94	6685.0
2008-08-14 06:00:00	ES	Futures	1196.94	1198.1	1195.08	1197.4	11058.0
2008-08-14 07:00:00	ES	Futures	1197.4	1199.26	1197.17	1197.64	10952.0
2008-08-14 08:00:00	ES	Futures	1197.64	1198.8	1186.71	1187.64	107519.0
2008-08-14 09:00:00	ES	Futures	1187.64	1192.76	1185.55	1192.29	252623.0
2008-08-14 10:00:00	ES	Futures	1192.06	1202.28	1191.13	1200.66	408320.0
2008-08-14 11:00:00	ES	Futures	1200.66	1205.07	1199.5	1202.75	204448.0
2008-08-14 12:00:00	ES	Futures	1202.75	1209.26	1201.59	1206.7	214924.0
2008-08-14 13:00:00	ES	Futures	1206.7	1207.4	1201.59	1203.91	134182.0
2008-08-14 14:00:00	ES	Futures	1204.14	1206.24	1198.8	1200.43	167398.0
2008-08-14 15:00:00	ES	Futures	1200.66	1202.75	1198.1	1202.05	249010.0
2008-08-14 16:00:00	ES	Futures	1202.05	1204.38	1201.12	1204.14	76484.0
2008-08-14 17:00:00	ES	Futures	1203.91	1205.31	1203.91	1204.38	1517.0
2008-08-14 18:00:00	ES	Futures	1204.38	1205.31	1204.38	1205.07	662.0
2008-08-14 19:00:00	ES	Futures	1205.07	1205.31	1204.61	1205.07	756.0
2008-08-14 20:00:00	ES	Futures	1205.07	1208.33	1204.61	1206.7	3918.0
2008-08-14 21:00:00	ES	Futures	1206.7	1206.93	1206.0	1206.24	1869.0
2008-08-14 22:00:00	ES	Futures	1206.24	1206.24	1204.61	1205.31	1963.0
2008-08-14 23:00:00	ES	Futures	1205.54	1206.24	1205.07	1206.0	679.0
2008-08-14 00:00:00	NQ	Futures	2188.43	2189.83	2188.43	2189.27	26.0
2008-08-14 01:00:00	NQ	Futures	2188.99	2189.55	2187.58	2187.58	96.0
2008-08-14 02:00:00	NQ	Futures	2188.15	2190.96	2185.05	2190.4	420.0
2008-08-14 03:00:00	NQ	Futures	2190.4	2193.49	2185.33	2192.93	1588.0
2008-08-14 04:00:00	NQ	Futures	2192.93	2192.93	2186.74	2187.58	1450.0
2008-08-14 05:00:00	NQ	Futures	2188.43	2190.4	2185.33	2188.43	1150.0
2008-08-14 06:00:00	NQ	Futures	2188.43	2190.4	2185.05	2189.55	668.0
2008-08-14 07:00:00	NQ	Futures	2189.55	2192.65	2186.74	2189.83	1311.0
2008-08-14 08:00:00	NQ	Futures	2189.83	2191.52	2175.49	2177.46	13990.0
2008-08-14 09:00:00	NQ	Futures	2178.02	2197.99	2175.49	2197.71	68282.0
2008-08-14 10:00:00	NQ	Futures	2197.71	2212.06	2189.83	2206.43	101367.0
2008-08-14 11:00:00	NQ	Futures	2206.71	2211.21	2204.18	2208.96	47072.0
2008-08-14 12:00:00	NQ	Futures	2208.96	2219.93	2207.55	2215.15	57400.0
2008-08-14 13:00:00	NQ	Futures	2215.15	2219.65	2208.12	2211.77	35932.0
2008-08-14 14:00:00	NQ	Futures	2212.06	2217.96	2205.87	2209.24	38636.0
2008-08-14 15:00:00	NQ	Futures	2208.96	2215.71	2203.62	2212.06	57784.0
2008-08-14 16:00:00	NQ	Futures	2211.77	2214.31	2210.09	2214.31	12399.0
2008-08-14 17:00:00	NQ	Futures	2214.31	2215.71	2213.18	2214.59	536.0
2008-08-14 18:00:00	NQ	Futures	2214.31	2215.15	2213.74	2214.87	139.0
2008-08-14 19:00:00	NQ	Futures	2214.87	2215.43	2214.59	2215.15	54.0
2008-08-14 20:00:00	NQ	Futures	2215.15	2217.96	2214.59	2217.12	579.0
2008-08-14 21:00:00	NQ	Futures	2217.12	2219.09	2216.56	2217.12	222.0
2008-08-14 22:00:00	NQ	Futures	2217.4	2217.4	2214.87	2215.43	132.0
2008-08-14 23:00:00	NQ	Futures	2215.43	2217.68	2215.43	2217.12	396.0
2008-08-14 00:00:00	YM	Futures	10490.2	10491.1	10483.0	10488.4	67.0
2008-08-14 01:00:00	YM	Futures	10487.5	10490.2	10483.9	10486.6	165.0

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

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