PREVIEW / futures_1hour / 2010-10-07

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-07.parquet
  size:    47 KB
  rows:    1,432

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-07 00:00:00	ES	Futures	1138.49	1138.98	1137.99	1138.73	2290.0
2010-10-07 01:00:00	ES	Futures	1138.24	1138.98	1138.24	1138.73	1980.0
2010-10-07 02:00:00	ES	Futures	1138.49	1141.2	1138.49	1140.95	7692.0
2010-10-07 03:00:00	ES	Futures	1140.7	1140.95	1136.27	1138.98	32222.0
2010-10-07 04:00:00	ES	Futures	1139.23	1140.95	1138.49	1138.98	20314.0
2010-10-07 05:00:00	ES	Futures	1138.98	1140.21	1137.25	1139.47	14418.0
2010-10-07 06:00:00	ES	Futures	1139.47	1141.2	1139.47	1140.7	12842.0
2010-10-07 07:00:00	ES	Futures	1140.7	1141.44	1138.98	1139.23	21867.0
2010-10-07 08:00:00	ES	Futures	1139.23	1147.36	1138.49	1146.13	136030.0
2010-10-07 09:00:00	ES	Futures	1145.88	1147.11	1136.27	1136.76	317953.0
2010-10-07 10:00:00	ES	Futures	1136.76	1141.69	1135.77	1138.98	401334.0
2010-10-07 11:00:00	ES	Futures	1138.73	1138.98	1136.02	1137.25	198910.0
2010-10-07 12:00:00	ES	Futures	1137.25	1137.75	1131.09	1133.06	238438.0
2010-10-07 13:00:00	ES	Futures	1133.06	1137.25	1132.32	1136.51	152113.0
2010-10-07 14:00:00	ES	Futures	1136.51	1138.73	1135.53	1137.75	144357.0
2010-10-07 15:00:00	ES	Futures	1137.99	1139.23	1136.02	1137.75	167316.0
2010-10-07 16:00:00	ES	Futures	1137.75	1140.95	1137.75	1139.72	95155.0
2010-10-07 17:00:00	ES	Futures	1139.72	1140.46	1139.23	1140.21	2609.0
2010-10-07 18:00:00	ES	Futures	1139.96	1140.7	1139.96	1140.46	1614.0
2010-10-07 19:00:00	ES	Futures	1140.46	1140.95	1139.96	1140.7	2250.0
2010-10-07 20:00:00	ES	Futures	1140.95	1141.69	1140.46	1140.95	5376.0
2010-10-07 21:00:00	ES	Futures	1140.95	1141.69	1140.21	1140.7	4616.0
2010-10-07 22:00:00	ES	Futures	1140.46	1142.92	1140.46	1142.68	6328.0
2010-10-07 23:00:00	ES	Futures	1142.43	1143.17	1141.44	1142.18	3781.0
2010-10-07 00:00:00	NQ	Futures	2299.24	2300.67	2298.66	2298.95	62.0
2010-10-07 01:00:00	NQ	Futures	2298.95	2299.52	2298.66	2299.24	41.0
2010-10-07 02:00:00	NQ	Futures	2299.24	2304.11	2298.66	2303.83	858.0
2010-10-07 03:00:00	NQ	Futures	2303.54	2303.83	2291.49	2296.94	2915.0
2010-10-07 04:00:00	NQ	Futures	2296.94	2300.67	2295.22	2296.37	1443.0
2010-10-07 05:00:00	NQ	Futures	2296.65	2298.95	2292.64	2297.23	919.0
2010-10-07 06:00:00	NQ	Futures	2297.23	2301.82	2296.94	2300.38	1668.0
2010-10-07 07:00:00	NQ	Futures	2300.38	2302.11	2296.65	2296.65	1437.0
2010-10-07 08:00:00	NQ	Futures	2297.23	2316.16	2295.51	2314.73	15165.0
2010-10-07 09:00:00	NQ	Futures	2314.44	2317.89	2290.06	2291.49	50226.0
2010-10-07 10:00:00	NQ	Futures	2291.49	2313.29	2288.05	2306.7	62832.0
2010-10-07 11:00:00	NQ	Futures	2306.41	2307.84	2300.67	2302.97	32061.0
2010-10-07 12:00:00	NQ	Futures	2302.97	2303.83	2289.2	2293.79	30201.0
2010-10-07 13:00:00	NQ	Futures	2293.5	2304.4	2292.06	2302.39	26203.0
2010-10-07 14:00:00	NQ	Futures	2302.68	2306.7	2298.66	2304.97	20938.0
2010-10-07 15:00:00	NQ	Futures	2304.69	2309.57	2301.82	2306.12	27242.0
2010-10-07 16:00:00	NQ	Futures	2306.41	2313.01	2306.12	2311.29	9271.0
2010-10-07 17:00:00	NQ	Futures	2311.0	2311.57	2310.43	2311.29	249.0
2010-10-07 18:00:00	NQ	Futures	2311.29	2312.15	2310.43	2311.57	150.0
2010-10-07 19:00:00	NQ	Futures	2311.57	2312.43	2311.0	2312.43	156.0
2010-10-07 20:00:00	NQ	Futures	2312.43	2314.44	2312.43	2312.72	226.0
2010-10-07 21:00:00	NQ	Futures	2312.72	2314.16	2310.43	2311.0	199.0
2010-10-07 22:00:00	NQ	Futures	2311.0	2315.59	2310.71	2314.73	296.0
2010-10-07 23:00:00	NQ	Futures	2314.44	2317.6	2313.87	2316.16	417.0
2010-10-07 00:00:00	YM	Futures	10382.0	10384.9	10378.2	10381.0	96.0
2010-10-07 01:00:00	YM	Futures	10382.0	10384.9	10380.1	10383.9	112.0

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

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