PREVIEW / futures_1hour / 2010-10-05

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-05.parquet
  size:    48 KB
  rows:    1,447

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-05 00:00:00	ES	Futures	1117.04	1121.48	1116.8	1119.75	14930.0
2010-10-05 01:00:00	ES	Futures	1120.0	1120.99	1118.27	1120.74	7345.0
2010-10-05 02:00:00	ES	Futures	1120.74	1120.99	1118.03	1118.52	10297.0
2010-10-05 03:00:00	ES	Futures	1118.52	1122.96	1117.54	1122.46	34196.0
2010-10-05 04:00:00	ES	Futures	1122.22	1123.7	1120.99	1122.96	26480.0
2010-10-05 05:00:00	ES	Futures	1122.96	1123.7	1121.48	1121.73	12678.0
2010-10-05 06:00:00	ES	Futures	1121.73	1122.96	1120.99	1121.23	12087.0
2010-10-05 07:00:00	ES	Futures	1121.23	1122.22	1120.49	1120.99	21040.0
2010-10-05 08:00:00	ES	Futures	1120.99	1128.13	1120.49	1128.13	89757.0
2010-10-05 09:00:00	ES	Futures	1127.89	1132.32	1125.92	1131.09	261524.0
2010-10-05 10:00:00	ES	Futures	1131.09	1135.28	1128.13	1133.31	499573.0
2010-10-05 11:00:00	ES	Futures	1133.56	1138.49	1133.31	1136.51	304852.0
2010-10-05 12:00:00	ES	Futures	1136.51	1138.73	1136.02	1138.49	108127.0
2010-10-05 13:00:00	ES	Futures	1138.49	1140.21	1137.75	1138.98	163797.0
2010-10-05 14:00:00	ES	Futures	1139.23	1140.7	1138.24	1139.96	141089.0
2010-10-05 15:00:00	ES	Futures	1140.21	1142.43	1139.23	1139.72	333392.0
2010-10-05 16:00:00	ES	Futures	1139.47	1140.21	1137.99	1138.49	133606.0
2010-10-05 17:00:00	ES	Futures	1138.73	1139.23	1138.24	1138.73	3356.0
2010-10-05 18:00:00	ES	Futures	1138.49	1139.47	1138.49	1138.98	4077.0
2010-10-05 19:00:00	ES	Futures	1138.98	1139.96	1138.98	1139.72	2539.0
2010-10-05 20:00:00	ES	Futures	1139.47	1140.21	1139.23	1139.96	3627.0
2010-10-05 21:00:00	ES	Futures	1139.96	1140.95	1139.23	1140.21	9806.0
2010-10-05 22:00:00	ES	Futures	1139.96	1140.21	1139.23	1139.47	2668.0
2010-10-05 23:00:00	ES	Futures	1139.23	1140.95	1139.23	1140.21	4025.0
2010-10-05 00:00:00	NQ	Futures	2268.25	2275.71	2267.1	2272.55	1071.0
2010-10-05 01:00:00	NQ	Futures	2272.55	2274.85	2270.26	2274.56	679.0
2010-10-05 02:00:00	NQ	Futures	2274.85	2274.85	2268.54	2269.97	997.0
2010-10-05 03:00:00	NQ	Futures	2269.69	2279.44	2268.25	2279.15	4671.0
2010-10-05 04:00:00	NQ	Futures	2279.44	2281.16	2277.43	2279.73	4208.0
2010-10-05 05:00:00	NQ	Futures	2279.44	2280.59	2276.57	2276.86	943.0
2010-10-05 06:00:00	NQ	Futures	2276.57	2280.01	2275.42	2276.0	1117.0
2010-10-05 07:00:00	NQ	Futures	2275.71	2277.43	2274.85	2276.0	1624.0
2010-10-05 08:00:00	NQ	Futures	2276.28	2291.78	2274.85	2291.49	12077.0
2010-10-05 09:00:00	NQ	Futures	2291.78	2307.84	2288.05	2304.11	64616.0
2010-10-05 10:00:00	NQ	Futures	2303.54	2314.73	2297.8	2311.0	74830.0
2010-10-05 11:00:00	NQ	Futures	2310.71	2318.75	2308.99	2315.02	44110.0
2010-10-05 12:00:00	NQ	Futures	2315.3	2318.46	2313.29	2316.74	19458.0
2010-10-05 13:00:00	NQ	Futures	2316.74	2321.04	2313.01	2315.88	30893.0
2010-10-05 14:00:00	NQ	Futures	2315.59	2319.89	2314.44	2319.32	22605.0
2010-10-05 15:00:00	NQ	Futures	2319.61	2323.91	2317.89	2319.03	51224.0
2010-10-05 16:00:00	NQ	Futures	2319.03	2321.04	2315.3	2317.31	14233.0
2010-10-05 17:00:00	NQ	Futures	2316.45	2318.17	2316.45	2316.74	125.0
2010-10-05 18:00:00	NQ	Futures	2317.6	2321.04	2317.02	2320.75	1063.0
2010-10-05 19:00:00	NQ	Futures	2320.47	2322.76	2320.47	2321.9	240.0
2010-10-05 20:00:00	NQ	Futures	2321.62	2322.76	2321.04	2322.19	354.0
2010-10-05 21:00:00	NQ	Futures	2322.48	2323.34	2319.89	2321.9	401.0
2010-10-05 22:00:00	NQ	Futures	2321.62	2321.9	2317.89	2318.46	574.0
2010-10-05 23:00:00	NQ	Futures	2318.46	2320.75	2318.46	2319.89	292.0
2010-10-05 00:00:00	YM	Futures	10184.8	10221.0	10184.8	10207.7	616.0
2010-10-05 01:00:00	YM	Futures	10207.7	10219.1	10193.4	10213.4	598.0

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

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