PREVIEW / futures_1hour / 2010-09-28

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-28.parquet
  size:    47 KB
  rows:    1,422

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-28 00:00:00	ES	Futures	1122.96	1123.7	1122.96	1123.2	1105.0
2010-09-28 01:00:00	ES	Futures	1123.2	1123.45	1121.23	1122.71	5533.0
2010-09-28 02:00:00	ES	Futures	1122.96	1122.96	1119.75	1120.25	14836.0
2010-09-28 03:00:00	ES	Futures	1120.49	1120.74	1115.56	1117.04	51250.0
2010-09-28 04:00:00	ES	Futures	1117.04	1118.03	1116.3	1117.04	19375.0
2010-09-28 05:00:00	ES	Futures	1117.29	1125.92	1116.06	1124.44	46690.0
2010-09-28 06:00:00	ES	Futures	1124.44	1126.16	1121.97	1122.46	27700.0
2010-09-28 07:00:00	ES	Futures	1122.46	1123.45	1121.23	1121.73	18932.0
2010-09-28 08:00:00	ES	Futures	1121.48	1125.18	1121.48	1123.7	58789.0
2010-09-28 09:00:00	ES	Futures	1123.94	1125.67	1115.32	1115.81	313648.0
2010-09-28 10:00:00	ES	Futures	1115.56	1120.0	1111.37	1119.51	479447.0
2010-09-28 11:00:00	ES	Futures	1119.75	1125.67	1118.77	1122.96	317921.0
2010-09-28 12:00:00	ES	Futures	1122.96	1125.18	1121.48	1124.44	136608.0
2010-09-28 13:00:00	ES	Futures	1124.44	1127.39	1121.48	1126.9	152144.0
2010-09-28 14:00:00	ES	Futures	1127.15	1127.39	1120.49	1121.73	201896.0
2010-09-28 15:00:00	ES	Futures	1121.73	1129.86	1120.99	1126.65	339019.0
2010-09-28 16:00:00	ES	Futures	1126.41	1126.9	1125.18	1126.41	94765.0
2010-09-28 17:00:00	ES	Futures	1126.41	1126.65	1126.16	1126.41	1601.0
2010-09-28 18:00:00	ES	Futures	1126.41	1126.9	1125.67	1126.41	2713.0
2010-09-28 19:00:00	ES	Futures	1126.16	1126.65	1125.42	1126.16	1161.0
2010-09-28 20:00:00	ES	Futures	1126.41	1128.87	1125.92	1128.13	8913.0
2010-09-28 21:00:00	ES	Futures	1128.13	1128.38	1125.18	1126.41	9482.0
2010-09-28 22:00:00	ES	Futures	1126.41	1127.64	1126.41	1127.15	2698.0
2010-09-28 23:00:00	ES	Futures	1127.39	1128.38	1127.15	1127.64	2814.0
2010-09-28 00:00:00	NQ	Futures	2307.56	2308.13	2306.98	2307.56	42.0
2010-09-28 01:00:00	NQ	Futures	2307.56	2307.56	2304.11	2306.41	132.0
2010-09-28 02:00:00	NQ	Futures	2306.98	2307.27	2302.68	2303.83	1715.0
2010-09-28 03:00:00	NQ	Futures	2304.11	2304.97	2296.94	2299.52	5673.0
2010-09-28 04:00:00	NQ	Futures	2299.52	2301.82	2298.38	2300.1	2339.0
2010-09-28 05:00:00	NQ	Futures	2300.1	2323.34	2298.09	2315.3	5837.0
2010-09-28 06:00:00	NQ	Futures	2315.3	2318.46	2309.28	2311.0	3161.0
2010-09-28 07:00:00	NQ	Futures	2310.71	2312.43	2308.7	2309.28	1235.0
2010-09-28 08:00:00	NQ	Futures	2309.28	2316.16	2309.28	2313.58	6920.0
2010-09-28 09:00:00	NQ	Futures	2313.87	2317.02	2282.6	2282.6	88546.0
2010-09-28 10:00:00	NQ	Futures	2282.6	2299.81	2269.11	2298.66	91028.0
2010-09-28 11:00:00	NQ	Futures	2298.66	2309.28	2294.07	2301.82	58171.0
2010-09-28 12:00:00	NQ	Futures	2301.53	2305.55	2293.5	2304.97	35277.0
2010-09-28 13:00:00	NQ	Futures	2304.69	2313.58	2299.24	2312.72	35628.0
2010-09-28 14:00:00	NQ	Futures	2313.01	2313.29	2296.94	2300.67	39337.0
2010-09-28 15:00:00	NQ	Futures	2300.38	2313.01	2298.09	2306.7	55453.0
2010-09-28 16:00:00	NQ	Futures	2306.7	2307.84	2305.26	2307.56	8039.0
2010-09-28 17:00:00	NQ	Futures	2307.56	2308.13	2306.98	2307.84	120.0
2010-09-28 18:00:00	NQ	Futures	2307.56	2308.13	2306.12	2306.7	100.0
2010-09-28 19:00:00	NQ	Futures	2307.56	2307.84	2306.41	2307.56	56.0
2010-09-28 20:00:00	NQ	Futures	2307.84	2312.72	2307.27	2311.86	668.0
2010-09-28 21:00:00	NQ	Futures	2311.57	2311.57	2305.84	2308.7	417.0
2010-09-28 22:00:00	NQ	Futures	2308.7	2310.71	2308.13	2309.85	206.0
2010-09-28 23:00:00	NQ	Futures	2309.85	2311.57	2309.85	2310.43	157.0
2010-09-28 00:00:00	YM	Futures	10251.5	10258.2	10251.5	10254.4	55.0
2010-09-28 01:00:00	YM	Futures	10254.4	10256.3	10240.1	10250.5	194.0

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

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