PREVIEW / futures_1hour / 2010-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-23.parquet
  size:    46 KB
  rows:    1,385

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-09-23 00:00:00	ES	Futures	1117.04	1117.54	1116.55	1117.54	1260.0
2010-09-23 01:00:00	ES	Futures	1117.54	1117.78	1117.04	1117.54	1204.0
2010-09-23 02:00:00	ES	Futures	1117.78	1118.27	1117.29	1118.03	4933.0
2010-09-23 03:00:00	ES	Futures	1117.78	1118.52	1113.59	1114.82	32293.0
2010-09-23 04:00:00	ES	Futures	1114.82	1116.06	1107.18	1108.66	55245.0
2010-09-23 05:00:00	ES	Futures	1108.91	1109.65	1106.69	1109.15	28866.0
2010-09-23 06:00:00	ES	Futures	1109.15	1109.65	1105.7	1106.94	26064.0
2010-09-23 07:00:00	ES	Futures	1106.69	1107.43	1105.21	1106.44	37695.0
2010-09-23 08:00:00	ES	Futures	1106.44	1106.94	1101.76	1103.24	139253.0
2010-09-23 09:00:00	ES	Futures	1102.99	1106.94	1102.25	1105.21	244796.0
2010-09-23 10:00:00	ES	Futures	1105.21	1113.84	1105.21	1111.37	429924.0
2010-09-23 11:00:00	ES	Futures	1111.13	1116.3	1110.63	1114.08	257418.0
2010-09-23 12:00:00	ES	Futures	1113.84	1114.82	1111.87	1112.85	111523.0
2010-09-23 13:00:00	ES	Futures	1112.85	1113.84	1110.88	1111.87	87139.0
2010-09-23 14:00:00	ES	Futures	1111.87	1113.35	1107.43	1107.92	186998.0
2010-09-23 15:00:00	ES	Futures	1107.92	1108.66	1101.51	1104.47	425234.0
2010-09-23 16:00:00	ES	Futures	1104.47	1105.46	1103.49	1104.23	100268.0
2010-09-23 17:00:00	ES	Futures	1104.23	1104.96	1103.98	1104.72	1403.0
2010-09-23 18:00:00	ES	Futures	1104.47	1105.46	1103.49	1103.73	2894.0
2010-09-23 19:00:00	ES	Futures	1103.73	1103.98	1102.75	1102.75	2361.0
2010-09-23 20:00:00	ES	Futures	1102.99	1106.69	1102.75	1106.44	6450.0
2010-09-23 21:00:00	ES	Futures	1106.2	1106.94	1105.46	1106.2	4414.0
2010-09-23 22:00:00	ES	Futures	1105.95	1107.18	1105.95	1106.94	3438.0
2010-09-23 23:00:00	ES	Futures	1106.94	1107.43	1105.95	1105.95	2569.0
2010-09-23 00:00:00	NQ	Futures	2278.87	2279.73	2278.29	2279.44	43.0
2010-09-23 01:00:00	NQ	Futures	2279.44	2280.3	2279.15	2280.3	62.0
2010-09-23 02:00:00	NQ	Futures	2280.59	2282.88	2280.3	2282.31	775.0
2010-09-23 03:00:00	NQ	Futures	2282.31	2283.17	2274.85	2277.15	2185.0
2010-09-23 04:00:00	NQ	Futures	2277.15	2279.44	2263.37	2265.1	4371.0
2010-09-23 05:00:00	NQ	Futures	2265.67	2267.96	2263.09	2267.96	2170.0
2010-09-23 06:00:00	NQ	Futures	2267.96	2268.83	2262.23	2263.37	1525.0
2010-09-23 07:00:00	NQ	Futures	2263.66	2264.81	2258.78	2260.79	3887.0
2010-09-23 08:00:00	NQ	Futures	2260.79	2263.66	2252.18	2255.63	15885.0
2010-09-23 09:00:00	NQ	Futures	2255.05	2271.98	2254.48	2268.83	54525.0
2010-09-23 10:00:00	NQ	Futures	2269.11	2287.47	2268.83	2283.46	74097.0
2010-09-23 11:00:00	NQ	Futures	2283.46	2295.51	2281.45	2291.49	46778.0
2010-09-23 12:00:00	NQ	Futures	2291.49	2293.79	2288.05	2289.48	24969.0
2010-09-23 13:00:00	NQ	Futures	2289.2	2292.64	2286.9	2288.33	21050.0
2010-09-23 14:00:00	NQ	Futures	2288.33	2291.78	2275.14	2277.15	37376.0
2010-09-23 15:00:00	NQ	Futures	2276.86	2278.01	2264.23	2272.27	77022.0
2010-09-23 16:00:00	NQ	Futures	2272.55	2276.57	2272.27	2275.14	10523.0
2010-09-23 17:00:00	NQ	Futures	2274.56	2276.28	2274.28	2275.42	306.0
2010-09-23 18:00:00	NQ	Futures	2275.71	2276.57	2272.84	2273.42	795.0
2010-09-23 19:00:00	NQ	Futures	2273.13	2273.13	2270.83	2270.83	923.0
2010-09-23 20:00:00	NQ	Futures	2271.41	2278.87	2271.41	2278.87	541.0
2010-09-23 21:00:00	NQ	Futures	2278.87	2280.01	2276.86	2278.29	261.0
2010-09-23 22:00:00	NQ	Futures	2278.01	2280.3	2277.43	2279.73	207.0
2010-09-23 23:00:00	NQ	Futures	2279.73	2280.59	2277.43	2278.01	232.0
2010-09-23 00:00:00	YM	Futures	10186.7	10192.4	10183.9	10190.5	71.0
2010-09-23 01:00:00	YM	Futures	10189.6	10196.3	10188.6	10192.4	95.0

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

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