PREVIEW / futures_1hour / 2010-09-30

all futures 1-hour files

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

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-30 00:00:00	ES	Futures	1122.96	1122.96	1121.48	1122.71	2628.0
2010-09-30 01:00:00	ES	Futures	1122.71	1122.71	1120.25	1120.99	9325.0
2010-09-30 02:00:00	ES	Futures	1121.23	1122.46	1118.27	1121.73	24278.0
2010-09-30 03:00:00	ES	Futures	1121.97	1125.18	1120.0	1124.44	40201.0
2010-09-30 04:00:00	ES	Futures	1124.68	1124.93	1120.74	1122.22	22568.0
2010-09-30 05:00:00	ES	Futures	1122.46	1124.93	1120.49	1123.94	18274.0
2010-09-30 06:00:00	ES	Futures	1123.7	1124.44	1121.73	1122.46	12139.0
2010-09-30 07:00:00	ES	Futures	1122.22	1122.96	1121.73	1122.46	8080.0
2010-09-30 08:00:00	ES	Futures	1122.46	1128.63	1121.73	1127.89	111049.0
2010-09-30 09:00:00	ES	Futures	1127.89	1137.25	1127.89	1133.31	440147.0
2010-09-30 10:00:00	ES	Futures	1133.06	1133.56	1126.16	1126.41	375850.0
2010-09-30 11:00:00	ES	Futures	1126.41	1127.15	1117.29	1119.51	560468.0
2010-09-30 12:00:00	ES	Futures	1119.51	1122.96	1115.32	1122.22	284666.0
2010-09-30 13:00:00	ES	Futures	1122.22	1123.7	1120.99	1122.71	139204.0
2010-09-30 14:00:00	ES	Futures	1122.71	1125.67	1119.26	1123.94	176656.0
2010-09-30 15:00:00	ES	Futures	1123.94	1125.18	1120.0	1120.49	392094.0
2010-09-30 16:00:00	ES	Futures	1120.25	1121.97	1119.01	1120.0	183551.0
2010-09-30 17:00:00	ES	Futures	1120.0	1120.25	1119.26	1120.0	2812.0
2010-09-30 18:00:00	ES	Futures	1120.0	1120.49	1119.51	1119.75	2866.0
2010-09-30 19:00:00	ES	Futures	1120.0	1121.73	1119.75	1121.48	3082.0
2010-09-30 20:00:00	ES	Futures	1121.73	1123.94	1121.23	1123.94	8631.0
2010-09-30 21:00:00	ES	Futures	1123.94	1124.93	1123.2	1124.19	10824.0
2010-09-30 22:00:00	ES	Futures	1124.44	1125.18	1123.94	1124.44	2212.0
2010-09-30 23:00:00	ES	Futures	1124.44	1124.44	1121.73	1121.97	2723.0
2010-09-30 00:00:00	NQ	Futures	2301.24	2301.82	2299.81	2300.96	185.0
2010-09-30 01:00:00	NQ	Futures	2300.67	2301.24	2297.52	2298.38	560.0
2010-09-30 02:00:00	NQ	Futures	2298.66	2302.11	2292.92	2300.38	1466.0
2010-09-30 03:00:00	NQ	Futures	2300.38	2306.41	2296.65	2305.55	2762.0
2010-09-30 04:00:00	NQ	Futures	2305.84	2306.7	2298.38	2300.96	1085.0
2010-09-30 05:00:00	NQ	Futures	2300.67	2306.41	2297.8	2304.69	1288.0
2010-09-30 06:00:00	NQ	Futures	2304.97	2306.12	2300.96	2301.53	785.0
2010-09-30 07:00:00	NQ	Futures	2301.53	2303.54	2300.38	2301.82	1481.0
2010-09-30 08:00:00	NQ	Futures	2301.82	2314.16	2300.67	2312.72	15289.0
2010-09-30 09:00:00	NQ	Futures	2313.01	2327.64	2311.29	2315.88	65995.0
2010-09-30 10:00:00	NQ	Futures	2315.88	2316.45	2298.66	2298.66	68016.0
2010-09-30 11:00:00	NQ	Futures	2298.66	2299.24	2276.57	2284.32	97275.0
2010-09-30 12:00:00	NQ	Futures	2284.03	2294.07	2276.0	2291.49	49962.0
2010-09-30 13:00:00	NQ	Futures	2291.78	2299.52	2289.77	2295.79	33364.0
2010-09-30 14:00:00	NQ	Futures	2296.08	2307.27	2289.77	2302.39	38423.0
2010-09-30 15:00:00	NQ	Futures	2302.39	2303.25	2290.92	2291.49	50315.0
2010-09-30 16:00:00	NQ	Futures	2291.2	2295.22	2289.48	2290.63	15559.0
2010-09-30 17:00:00	NQ	Futures	2290.34	2291.2	2289.48	2290.34	88.0
2010-09-30 18:00:00	NQ	Futures	2290.63	2291.49	2290.06	2290.63	142.0
2010-09-30 19:00:00	NQ	Futures	2290.63	2294.07	2290.63	2293.21	359.0
2010-09-30 20:00:00	NQ	Futures	2293.5	2298.38	2293.21	2297.8	423.0
2010-09-30 21:00:00	NQ	Futures	2297.8	2300.96	2297.52	2299.52	548.0
2010-09-30 22:00:00	NQ	Futures	2298.95	2301.24	2298.66	2298.95	261.0
2010-09-30 23:00:00	NQ	Futures	2298.95	2299.24	2294.65	2294.93	214.0
2010-09-30 00:00:00	YM	Futures	10251.5	10251.5	10239.1	10248.6	251.0
2010-09-30 01:00:00	YM	Futures	10248.6	10248.6	10228.6	10236.3	419.0

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

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