PREVIEW / futures_1hour / 2010-04-26

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-26.parquet
  size:    44 KB
  rows:    1,375

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-04-26 00:00:00	ES	Futures	1186.69	1186.93	1185.47	1185.71	4605.0
2010-04-26 01:00:00	ES	Futures	1185.96	1187.18	1185.47	1186.69	3625.0
2010-04-26 02:00:00	ES	Futures	1186.45	1188.4	1185.96	1186.93	14429.0
2010-04-26 03:00:00	ES	Futures	1186.93	1189.62	1186.69	1188.16	25055.0
2010-04-26 04:00:00	ES	Futures	1188.16	1188.64	1187.42	1187.67	15308.0
2010-04-26 05:00:00	ES	Futures	1187.91	1187.91	1185.47	1185.96	17288.0
2010-04-26 06:00:00	ES	Futures	1185.96	1187.42	1185.22	1187.18	13581.0
2010-04-26 07:00:00	ES	Futures	1187.18	1188.4	1186.45	1187.18	33404.0
2010-04-26 08:00:00	ES	Futures	1187.18	1188.4	1185.71	1187.18	48356.0
2010-04-26 09:00:00	ES	Futures	1187.18	1189.13	1185.22	1185.71	239256.0
2010-04-26 10:00:00	ES	Futures	1185.71	1188.4	1184.49	1187.67	289592.0
2010-04-26 11:00:00	ES	Futures	1187.91	1189.38	1185.22	1185.71	146065.0
2010-04-26 12:00:00	ES	Futures	1185.47	1186.69	1184.49	1186.45	130220.0
2010-04-26 13:00:00	ES	Futures	1186.45	1186.69	1184.25	1185.22	101408.0
2010-04-26 14:00:00	ES	Futures	1184.98	1186.93	1184.0	1184.0	115732.0
2010-04-26 15:00:00	ES	Futures	1184.0	1184.98	1180.58	1181.56	305676.0
2010-04-26 16:00:00	ES	Futures	1181.56	1182.29	1180.33	1181.07	96794.0
2010-04-26 17:00:00	ES	Futures	1181.07	1181.31	1179.6	1180.09	4692.0
2010-04-26 18:00:00	ES	Futures	1180.58	1181.31	1179.6	1180.33	6721.0
2010-04-26 19:00:00	ES	Futures	1180.58	1181.31	1179.85	1180.82	4045.0
2010-04-26 20:00:00	ES	Futures	1180.82	1182.05	1180.58	1182.05	4921.0
2010-04-26 21:00:00	ES	Futures	1181.8	1182.78	1181.8	1182.05	5524.0
2010-04-26 22:00:00	ES	Futures	1182.05	1182.29	1180.58	1180.82	5719.0
2010-04-26 23:00:00	ES	Futures	1180.82	1182.78	1180.82	1182.53	3348.0
2010-04-26 00:00:00	NQ	Futures	2353.7	2353.98	2352.26	2352.26	223.0
2010-04-26 01:00:00	NQ	Futures	2352.26	2355.7	2351.69	2354.56	418.0
2010-04-26 02:00:00	NQ	Futures	2353.7	2357.42	2353.12	2354.56	2276.0
2010-04-26 03:00:00	NQ	Futures	2354.84	2358.28	2354.27	2356.27	2190.0
2010-04-26 04:00:00	NQ	Futures	2356.27	2357.42	2354.84	2355.99	1490.0
2010-04-26 05:00:00	NQ	Futures	2355.99	2355.99	2351.69	2352.26	1251.0
2010-04-26 06:00:00	NQ	Futures	2352.26	2354.56	2350.26	2351.98	1152.0
2010-04-26 07:00:00	NQ	Futures	2351.98	2354.56	2351.69	2353.41	1078.0
2010-04-26 08:00:00	NQ	Futures	2353.41	2354.84	2349.97	2352.84	2992.0
2010-04-26 09:00:00	NQ	Futures	2352.84	2356.56	2344.25	2345.39	39647.0
2010-04-26 10:00:00	NQ	Futures	2345.11	2350.55	2340.24	2348.26	45662.0
2010-04-26 11:00:00	NQ	Futures	2348.54	2351.98	2343.1	2344.25	23780.0
2010-04-26 12:00:00	NQ	Futures	2343.96	2346.82	2341.96	2346.54	16212.0
2010-04-26 13:00:00	NQ	Futures	2346.82	2347.68	2341.96	2344.53	14263.0
2010-04-26 14:00:00	NQ	Futures	2344.82	2351.69	2343.1	2346.82	15991.0
2010-04-26 15:00:00	NQ	Futures	2346.82	2349.11	2340.52	2344.82	32764.0
2010-04-26 16:00:00	NQ	Futures	2344.53	2346.25	2341.96	2344.25	7272.0
2010-04-26 17:00:00	NQ	Futures	2344.82	2345.11	2342.81	2342.81	110.0
2010-04-26 18:00:00	NQ	Futures	2343.39	2344.82	2342.81	2343.96	353.0
2010-04-26 19:00:00	NQ	Futures	2343.96	2344.25	2342.81	2343.1	255.0
2010-04-26 20:00:00	NQ	Futures	2343.39	2345.96	2343.39	2345.39	343.0
2010-04-26 21:00:00	NQ	Futures	2345.39	2346.82	2345.39	2345.39	184.0
2010-04-26 22:00:00	NQ	Futures	2345.68	2346.54	2343.39	2345.68	1107.0
2010-04-26 23:00:00	NQ	Futures	2345.68	2348.83	2345.68	2347.97	267.0
2010-04-26 00:00:00	YM	Futures	10497.6	10499.5	10491.0	10491.9	137.0
2010-04-26 01:00:00	YM	Futures	10492.9	10502.3	10491.9	10498.5	263.0

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

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