PREVIEW / futures_1hour / 2010-08-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-09.parquet
  size:    43 KB
  rows:    1,327

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-09 00:00:00	ES	Futures	1098.32	1098.56	1097.34	1098.07	1609.0
2010-08-09 01:00:00	ES	Futures	1098.07	1100.77	1097.83	1100.53	4625.0
2010-08-09 02:00:00	ES	Futures	1100.77	1101.75	1099.3	1100.77	8107.0
2010-08-09 03:00:00	ES	Futures	1100.77	1103.72	1099.79	1102.98	28417.0
2010-08-09 04:00:00	ES	Futures	1102.98	1103.47	1101.26	1102.98	14344.0
2010-08-09 05:00:00	ES	Futures	1102.98	1103.47	1101.51	1103.47	10607.0
2010-08-09 06:00:00	ES	Futures	1103.47	1103.47	1102.0	1102.74	7166.0
2010-08-09 07:00:00	ES	Futures	1102.49	1104.21	1101.75	1103.47	30205.0
2010-08-09 08:00:00	ES	Futures	1103.72	1104.7	1102.98	1103.47	23026.0
2010-08-09 09:00:00	ES	Futures	1103.47	1103.72	1097.34	1098.81	189353.0
2010-08-09 10:00:00	ES	Futures	1098.81	1101.51	1097.83	1101.02	148782.0
2010-08-09 11:00:00	ES	Futures	1101.02	1103.72	1100.53	1102.0	110821.0
2010-08-09 12:00:00	ES	Futures	1102.0	1103.23	1101.26	1101.75	49527.0
2010-08-09 13:00:00	ES	Futures	1101.75	1103.23	1101.26	1102.49	52731.0
2010-08-09 14:00:00	ES	Futures	1102.24	1105.93	1102.24	1105.93	94878.0
2010-08-09 15:00:00	ES	Futures	1105.93	1105.93	1102.98	1103.72	145597.0
2010-08-09 16:00:00	ES	Futures	1103.72	1104.94	1103.72	1104.45	54415.0
2010-08-09 17:00:00	ES	Futures	1104.45	1104.45	1103.96	1104.21	598.0
2010-08-09 18:00:00	ES	Futures	1104.21	1104.94	1103.96	1104.94	889.0
2010-08-09 19:00:00	ES	Futures	1104.7	1104.7	1103.72	1103.96	1228.0
2010-08-09 20:00:00	ES	Futures	1103.96	1104.21	1102.24	1102.24	5324.0
2010-08-09 21:00:00	ES	Futures	1102.24	1102.49	1101.51	1101.75	4257.0
2010-08-09 22:00:00	ES	Futures	1102.0	1102.49	1100.53	1100.77	4582.0
2010-08-09 23:00:00	ES	Futures	1100.77	1101.02	1099.05	1100.28	8082.0
2010-08-09 00:00:00	NQ	Futures	2180.48	2181.63	2179.91	2181.63	109.0
2010-08-09 01:00:00	NQ	Futures	2181.34	2185.35	2180.77	2185.35	249.0
2010-08-09 02:00:00	NQ	Futures	2185.64	2187.93	2183.35	2185.07	607.0
2010-08-09 03:00:00	NQ	Futures	2184.78	2189.65	2183.35	2189.08	1836.0
2010-08-09 04:00:00	NQ	Futures	2189.36	2189.65	2185.93	2188.22	1136.0
2010-08-09 05:00:00	NQ	Futures	2188.22	2189.08	2185.93	2188.79	663.0
2010-08-09 06:00:00	NQ	Futures	2188.79	2188.79	2186.5	2187.93	385.0
2010-08-09 07:00:00	NQ	Futures	2187.93	2189.65	2186.79	2189.36	1361.0
2010-08-09 08:00:00	NQ	Futures	2189.08	2189.94	2187.93	2188.5	3385.0
2010-08-09 09:00:00	NQ	Futures	2188.5	2193.09	2179.91	2183.92	40534.0
2010-08-09 10:00:00	NQ	Futures	2183.63	2190.8	2183.06	2187.36	27983.0
2010-08-09 11:00:00	NQ	Futures	2187.36	2191.94	2185.35	2188.22	20572.0
2010-08-09 12:00:00	NQ	Futures	2188.22	2191.08	2186.21	2189.08	12458.0
2010-08-09 13:00:00	NQ	Futures	2188.79	2191.66	2187.07	2190.22	13014.0
2010-08-09 14:00:00	NQ	Futures	2190.22	2198.53	2190.22	2198.25	20844.0
2010-08-09 15:00:00	NQ	Futures	2198.25	2198.53	2192.52	2192.8	30631.0
2010-08-09 16:00:00	NQ	Futures	2193.09	2195.67	2191.66	2192.52	6945.0
2010-08-09 17:00:00	NQ	Futures	2193.09	2193.66	2192.52	2192.8	25.0
2010-08-09 18:00:00	NQ	Futures	2192.8	2193.95	2192.8	2193.66	32.0
2010-08-09 19:00:00	NQ	Futures	2193.95	2193.95	2192.52	2192.8	50.0
2010-08-09 20:00:00	NQ	Futures	2192.8	2193.66	2189.94	2190.22	556.0
2010-08-09 21:00:00	NQ	Futures	2190.22	2190.8	2189.08	2189.94	348.0
2010-08-09 22:00:00	NQ	Futures	2189.94	2190.8	2187.93	2188.22	440.0
2010-08-09 23:00:00	NQ	Futures	2187.93	2188.79	2185.93	2187.65	1327.0
2010-08-09 00:00:00	YM	Futures	10039.7	10043.5	10035.0	10041.6	199.0
2010-08-09 01:00:00	YM	Futures	10040.7	10062.4	10038.8	10061.5	285.0

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

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