PREVIEW / futures_1hour / 2010-09-21

all futures 1-hour files

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

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-21 00:00:00	ES	Futures	1118.77	1118.77	1116.3	1116.55	8042.0
2010-09-21 01:00:00	ES	Futures	1116.8	1118.52	1116.55	1118.03	7934.0
2010-09-21 02:00:00	ES	Futures	1118.27	1118.52	1116.8	1116.8	8252.0
2010-09-21 03:00:00	ES	Futures	1117.04	1119.51	1116.55	1119.01	22014.0
2010-09-21 04:00:00	ES	Futures	1119.26	1120.99	1119.01	1120.0	16816.0
2010-09-21 05:00:00	ES	Futures	1120.0	1122.71	1119.51	1120.74	20574.0
2010-09-21 06:00:00	ES	Futures	1120.74	1120.99	1118.27	1120.0	14858.0
2010-09-21 07:00:00	ES	Futures	1119.75	1121.73	1119.26	1120.99	15736.0
2010-09-21 08:00:00	ES	Futures	1120.99	1123.2	1118.27	1122.22	71321.0
2010-09-21 09:00:00	ES	Futures	1122.46	1123.7	1119.51	1120.49	198421.0
2010-09-21 10:00:00	ES	Futures	1120.49	1121.97	1119.51	1120.25	216317.0
2010-09-21 11:00:00	ES	Futures	1120.25	1121.23	1117.54	1119.01	155475.0
2010-09-21 12:00:00	ES	Futures	1119.01	1120.0	1117.78	1119.01	60665.0
2010-09-21 13:00:00	ES	Futures	1119.01	1119.01	1116.55	1118.27	94750.0
2010-09-21 14:00:00	ES	Futures	1118.03	1127.89	1114.33	1123.94	579435.0
2010-09-21 15:00:00	ES	Futures	1123.7	1123.94	1115.32	1119.26	475249.0
2010-09-21 16:00:00	ES	Futures	1119.51	1119.75	1117.29	1118.03	91222.0
2010-09-21 17:00:00	ES	Futures	1117.78	1118.03	1116.8	1117.54	2203.0
2010-09-21 18:00:00	ES	Futures	1117.54	1119.01	1116.8	1118.03	3196.0
2010-09-21 19:00:00	ES	Futures	1118.03	1119.51	1117.04	1118.27	4590.0
2010-09-21 20:00:00	ES	Futures	1118.27	1122.46	1118.27	1121.97	11831.0
2010-09-21 21:00:00	ES	Futures	1121.97	1123.45	1121.73	1122.96	5786.0
2010-09-21 22:00:00	ES	Futures	1123.2	1123.2	1122.22	1122.46	3521.0
2010-09-21 23:00:00	ES	Futures	1122.46	1123.45	1121.97	1123.2	3009.0
2010-09-21 00:00:00	NQ	Futures	2273.13	2273.13	2269.97	2270.55	496.0
2010-09-21 01:00:00	NQ	Futures	2270.55	2272.55	2269.97	2272.27	293.0
2010-09-21 02:00:00	NQ	Futures	2272.55	2273.42	2269.11	2269.4	743.0
2010-09-21 03:00:00	NQ	Futures	2269.4	2277.43	2268.83	2276.57	3352.0
2010-09-21 04:00:00	NQ	Futures	2276.28	2278.58	2275.42	2277.15	1333.0
2010-09-21 05:00:00	NQ	Futures	2277.15	2281.45	2276.0	2277.43	1076.0
2010-09-21 06:00:00	NQ	Futures	2277.43	2277.43	2273.42	2276.86	830.0
2010-09-21 07:00:00	NQ	Futures	2276.57	2280.01	2276.57	2278.58	1000.0
2010-09-21 08:00:00	NQ	Futures	2278.87	2280.87	2272.27	2279.73	8360.0
2010-09-21 09:00:00	NQ	Futures	2280.01	2282.02	2273.42	2277.15	37307.0
2010-09-21 10:00:00	NQ	Futures	2277.15	2283.46	2276.0	2278.29	40633.0
2010-09-21 11:00:00	NQ	Futures	2278.01	2281.45	2274.56	2276.86	24634.0
2010-09-21 12:00:00	NQ	Futures	2276.57	2280.01	2275.14	2279.44	15964.0
2010-09-21 13:00:00	NQ	Futures	2279.44	2279.44	2274.28	2277.43	18683.0
2010-09-21 14:00:00	NQ	Futures	2277.43	2295.51	2271.98	2286.61	78164.0
2010-09-21 15:00:00	NQ	Futures	2286.61	2287.47	2269.97	2278.29	74372.0
2010-09-21 16:00:00	NQ	Futures	2278.58	2281.16	2275.71	2276.0	10133.0
2010-09-21 17:00:00	NQ	Futures	2276.28	2276.86	2274.28	2275.42	231.0
2010-09-21 18:00:00	NQ	Futures	2274.85	2276.86	2273.7	2274.85	490.0
2010-09-21 19:00:00	NQ	Futures	2275.14	2278.29	2273.7	2276.0	676.0
2010-09-21 20:00:00	NQ	Futures	2276.28	2284.32	2276.28	2283.74	791.0
2010-09-21 21:00:00	NQ	Futures	2283.46	2286.33	2282.88	2285.47	668.0
2010-09-21 22:00:00	NQ	Futures	2285.47	2285.47	2283.46	2284.32	294.0
2010-09-21 23:00:00	NQ	Futures	2284.03	2285.18	2283.17	2284.89	205.0
2010-09-21 00:00:00	YM	Futures	10154.3	10154.3	10135.3	10136.2	302.0
2010-09-21 01:00:00	YM	Futures	10137.2	10152.4	10136.2	10150.5	529.0

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

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