PREVIEW / futures_1hour / 2010-08-05

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-05.parquet
  size:    45 KB
  rows:    1,359

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
2010-08-05 00:00:00	ES	Futures	1101.75	1102.98	1101.75	1102.74	2201.0
2010-08-05 01:00:00	ES	Futures	1102.49	1104.21	1102.49	1103.96	3391.0
2010-08-05 02:00:00	ES	Futures	1103.96	1104.21	1101.75	1102.0	7677.0
2010-08-05 03:00:00	ES	Futures	1102.0	1102.74	1101.26	1102.24	19146.0
2010-08-05 04:00:00	ES	Futures	1102.24	1104.21	1101.26	1103.47	15346.0
2010-08-05 05:00:00	ES	Futures	1103.47	1104.7	1103.23	1103.96	10960.0
2010-08-05 06:00:00	ES	Futures	1103.96	1106.66	1103.72	1106.17	20156.0
2010-08-05 07:00:00	ES	Futures	1106.17	1106.91	1103.47	1103.96	25188.0
2010-08-05 08:00:00	ES	Futures	1103.96	1104.7	1097.58	1098.81	111881.0
2010-08-05 09:00:00	ES	Futures	1098.56	1100.53	1094.88	1099.3	255569.0
2010-08-05 10:00:00	ES	Futures	1099.3	1102.0	1096.85	1097.09	218586.0
2010-08-05 11:00:00	ES	Futures	1097.34	1100.04	1095.86	1098.56	162111.0
2010-08-05 12:00:00	ES	Futures	1098.32	1100.28	1097.83	1098.81	67626.0
2010-08-05 13:00:00	ES	Futures	1098.81	1101.51	1097.09	1100.53	81864.0
2010-08-05 14:00:00	ES	Futures	1100.77	1101.26	1099.79	1100.53	72322.0
2010-08-05 15:00:00	ES	Futures	1100.77	1103.23	1100.04	1102.49	168915.0
2010-08-05 16:00:00	ES	Futures	1102.49	1103.96	1102.24	1103.47	63322.0
2010-08-05 17:00:00	ES	Futures	1103.47	1103.72	1103.47	1103.47	833.0
2010-08-05 18:00:00	ES	Futures	1103.47	1103.96	1102.98	1102.98	869.0
2010-08-05 19:00:00	ES	Futures	1102.98	1103.23	1102.49	1102.74	1481.0
2010-08-05 20:00:00	ES	Futures	1102.74	1102.98	1102.0	1102.24	4765.0
2010-08-05 21:00:00	ES	Futures	1102.24	1103.47	1102.24	1103.23	2700.0
2010-08-05 22:00:00	ES	Futures	1103.23	1103.47	1102.0	1102.49	2801.0
2010-08-05 23:00:00	ES	Futures	1102.24	1104.7	1102.0	1104.45	4534.0
2010-08-05 00:00:00	NQ	Futures	2182.2	2183.63	2181.63	2183.63	102.0
2010-08-05 01:00:00	NQ	Futures	2183.06	2185.93	2183.06	2185.93	85.0
2010-08-05 02:00:00	NQ	Futures	2185.64	2186.21	2181.63	2182.49	472.0
2010-08-05 03:00:00	NQ	Futures	2182.2	2183.92	2181.05	2183.06	1116.0
2010-08-05 04:00:00	NQ	Futures	2183.06	2187.36	2181.05	2185.35	1074.0
2010-08-05 05:00:00	NQ	Futures	2185.64	2187.36	2185.35	2186.5	882.0
2010-08-05 06:00:00	NQ	Futures	2186.79	2192.52	2186.21	2191.08	1832.0
2010-08-05 07:00:00	NQ	Futures	2191.08	2191.94	2184.21	2185.07	1771.0
2010-08-05 08:00:00	NQ	Futures	2185.07	2186.5	2177.33	2179.05	10184.0
2010-08-05 09:00:00	NQ	Futures	2179.05	2185.35	2173.32	2181.05	42855.0
2010-08-05 10:00:00	NQ	Futures	2181.05	2186.21	2172.46	2173.03	36067.0
2010-08-05 11:00:00	NQ	Futures	2173.03	2179.33	2167.59	2176.18	37404.0
2010-08-05 12:00:00	NQ	Futures	2176.47	2180.19	2175.32	2177.62	16570.0
2010-08-05 13:00:00	NQ	Futures	2177.33	2184.78	2173.89	2183.35	16354.0
2010-08-05 14:00:00	NQ	Futures	2183.63	2184.21	2180.48	2181.34	16949.0
2010-08-05 15:00:00	NQ	Futures	2181.34	2185.93	2178.19	2182.2	30966.0
2010-08-05 16:00:00	NQ	Futures	2182.2	2182.49	2179.91	2181.63	7793.0
2010-08-05 17:00:00	NQ	Futures	2181.91	2182.2	2181.91	2181.91	15.0
2010-08-05 18:00:00	NQ	Futures	2182.2	2182.49	2180.19	2181.34	69.0
2010-08-05 19:00:00	NQ	Futures	2181.34	2181.34	2180.19	2180.19	62.0
2010-08-05 20:00:00	NQ	Futures	2179.91	2181.05	2179.62	2180.19	146.0
2010-08-05 21:00:00	NQ	Futures	2180.19	2181.91	2179.62	2181.34	139.0
2010-08-05 22:00:00	NQ	Futures	2181.34	2181.63	2179.05	2179.91	134.0
2010-08-05 23:00:00	NQ	Futures	2179.62	2183.92	2179.62	2183.92	144.0
2010-08-05 00:00:00	YM	Futures	10053.0	10061.5	10053.0	10060.5	116.0
2010-08-05 01:00:00	YM	Futures	10058.6	10071.9	10058.6	10070.9	167.0

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

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