PREVIEW / futures_1hour / 2010-10-04

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-04.parquet
  size:    45 KB
  rows:    1,381

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-10-04 00:00:00	ES	Futures	1124.19	1126.41	1124.19	1125.18	3593.0
2010-10-04 01:00:00	ES	Futures	1125.18	1125.18	1122.71	1124.44	5981.0
2010-10-04 02:00:00	ES	Futures	1124.19	1126.16	1123.45	1125.18	7646.0
2010-10-04 03:00:00	ES	Futures	1125.18	1125.18	1117.29	1120.25	47493.0
2010-10-04 04:00:00	ES	Futures	1120.25	1121.23	1118.27	1119.75	27910.0
2010-10-04 05:00:00	ES	Futures	1119.51	1120.74	1118.27	1120.0	18918.0
2010-10-04 06:00:00	ES	Futures	1120.0	1121.97	1119.51	1120.0	11586.0
2010-10-04 07:00:00	ES	Futures	1120.0	1123.7	1120.0	1123.45	21059.0
2010-10-04 08:00:00	ES	Futures	1123.45	1123.94	1120.74	1121.97	41975.0
2010-10-04 09:00:00	ES	Futures	1122.22	1127.89	1121.97	1123.94	231648.0
2010-10-04 10:00:00	ES	Futures	1123.7	1126.41	1120.25	1121.48	248516.0
2010-10-04 11:00:00	ES	Futures	1121.48	1121.48	1113.35	1113.84	301296.0
2010-10-04 12:00:00	ES	Futures	1113.59	1114.58	1111.13	1114.08	209815.0
2010-10-04 13:00:00	ES	Futures	1114.08	1115.56	1112.85	1114.82	117900.0
2010-10-04 14:00:00	ES	Futures	1114.82	1115.56	1111.62	1113.84	150542.0
2010-10-04 15:00:00	ES	Futures	1113.59	1117.04	1113.1	1116.8	266421.0
2010-10-04 16:00:00	ES	Futures	1116.8	1119.51	1116.55	1119.26	111528.0
2010-10-04 17:00:00	ES	Futures	1119.01	1119.26	1118.52	1118.77	1900.0
2010-10-04 18:00:00	ES	Futures	1118.77	1119.01	1118.27	1118.77	3192.0
2010-10-04 19:00:00	ES	Futures	1118.77	1119.01	1117.78	1119.01	4168.0
2010-10-04 20:00:00	ES	Futures	1119.01	1119.51	1118.52	1118.77	4086.0
2010-10-04 21:00:00	ES	Futures	1119.01	1119.51	1118.03	1119.51	4757.0
2010-10-04 22:00:00	ES	Futures	1119.26	1119.51	1118.03	1118.77	3626.0
2010-10-04 23:00:00	ES	Futures	1118.52	1119.01	1117.04	1117.04	6954.0
2010-10-04 00:00:00	NQ	Futures	2285.75	2288.05	2285.47	2287.19	140.0
2010-10-04 01:00:00	NQ	Futures	2286.9	2286.9	2282.6	2285.47	397.0
2010-10-04 02:00:00	NQ	Futures	2286.04	2288.91	2283.46	2286.9	939.0
2010-10-04 03:00:00	NQ	Futures	2286.61	2286.61	2271.12	2276.86	3755.0
2010-10-04 04:00:00	NQ	Futures	2276.86	2278.58	2272.84	2275.71	1492.0
2010-10-04 05:00:00	NQ	Futures	2275.71	2277.72	2273.42	2276.28	881.0
2010-10-04 06:00:00	NQ	Futures	2276.28	2280.59	2276.0	2277.43	955.0
2010-10-04 07:00:00	NQ	Futures	2277.72	2284.6	2277.72	2283.17	2313.0
2010-10-04 08:00:00	NQ	Futures	2282.88	2283.74	2277.43	2280.01	4130.0
2010-10-04 09:00:00	NQ	Futures	2280.3	2290.63	2278.01	2280.59	45099.0
2010-10-04 10:00:00	NQ	Futures	2279.44	2286.61	2273.7	2277.72	43107.0
2010-10-04 11:00:00	NQ	Futures	2277.43	2277.43	2254.77	2255.34	58375.0
2010-10-04 12:00:00	NQ	Futures	2255.34	2257.92	2250.46	2256.78	34381.0
2010-10-04 13:00:00	NQ	Futures	2256.78	2262.8	2255.63	2260.22	25470.0
2010-10-04 14:00:00	NQ	Futures	2260.22	2264.23	2255.63	2261.94	24284.0
2010-10-04 15:00:00	NQ	Futures	2261.94	2267.68	2260.5	2263.66	40907.0
2010-10-04 16:00:00	NQ	Futures	2263.66	2271.69	2263.66	2270.26	12070.0
2010-10-04 17:00:00	NQ	Futures	2270.83	2271.41	2269.4	2269.4	89.0
2010-10-04 18:00:00	NQ	Futures	2269.69	2269.97	2269.4	2269.69	54.0
2010-10-04 19:00:00	NQ	Futures	2269.4	2270.83	2267.68	2269.69	272.0
2010-10-04 20:00:00	NQ	Futures	2270.26	2271.41	2269.4	2270.26	350.0
2010-10-04 21:00:00	NQ	Futures	2269.97	2271.12	2267.96	2270.83	278.0
2010-10-04 22:00:00	NQ	Futures	2271.12	2271.69	2268.25	2269.97	230.0
2010-10-04 23:00:00	NQ	Futures	2269.97	2270.83	2267.39	2267.68	572.0
2010-10-04 00:00:00	YM	Futures	10245.8	10262.0	10245.8	10252.5	127.0
2010-10-04 01:00:00	YM	Futures	10252.5	10252.5	10232.4	10244.8	381.0

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

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