PREVIEW / futures_1hour / 2008-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-02.parquet
  size:    41 KB
  rows:    1,196

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
2008-06-02 00:00:00	ES	Futures	1302.06	1302.53	1301.6	1301.83	446.0
2008-06-02 01:00:00	ES	Futures	1301.83	1302.76	1301.6	1302.53	1207.0
2008-06-02 02:00:00	ES	Futures	1302.29	1302.76	1300.9	1301.83	2173.0
2008-06-02 03:00:00	ES	Futures	1302.06	1302.29	1297.87	1298.34	14434.0
2008-06-02 04:00:00	ES	Futures	1298.57	1298.8	1295.54	1296.94	16803.0
2008-06-02 05:00:00	ES	Futures	1296.94	1297.87	1296.24	1297.64	6179.0
2008-06-02 06:00:00	ES	Futures	1297.64	1298.57	1297.41	1297.64	5584.0
2008-06-02 07:00:00	ES	Futures	1297.41	1298.8	1296.71	1298.34	10175.0
2008-06-02 08:00:00	ES	Futures	1298.34	1299.04	1297.41	1298.34	21316.0
2008-06-02 09:00:00	ES	Futures	1298.34	1300.2	1293.68	1294.61	175218.0
2008-06-02 10:00:00	ES	Futures	1294.61	1296.47	1289.02	1291.82	336609.0
2008-06-02 11:00:00	ES	Futures	1291.82	1292.98	1288.56	1291.58	214203.0
2008-06-02 12:00:00	ES	Futures	1291.35	1292.28	1283.2	1283.43	264226.0
2008-06-02 13:00:00	ES	Futures	1283.43	1286.93	1282.97	1286.93	142298.0
2008-06-02 14:00:00	ES	Futures	1286.69	1288.09	1285.53	1286.0	142840.0
2008-06-02 15:00:00	ES	Futures	1285.76	1292.28	1284.6	1290.19	250756.0
2008-06-02 16:00:00	ES	Futures	1290.42	1291.58	1289.49	1290.42	71468.0
2008-06-02 17:00:00	ES	Futures	1290.42	1290.89	1290.42	1290.89	712.0
2008-06-02 18:00:00	ES	Futures	1290.42	1290.65	1289.95	1290.42	899.0
2008-06-02 19:00:00	ES	Futures	1290.19	1290.65	1289.72	1290.19	1606.0
2008-06-02 20:00:00	ES	Futures	1290.19	1290.89	1289.95	1290.42	1310.0
2008-06-02 21:00:00	ES	Futures	1290.42	1291.35	1290.19	1291.12	1242.0
2008-06-02 22:00:00	ES	Futures	1291.35	1291.58	1290.19	1290.19	1128.0
2008-06-02 23:00:00	ES	Futures	1290.19	1291.35	1290.19	1290.42	785.0
2008-06-02 00:00:00	NQ	Futures	2300.53	2300.53	2300.25	2300.53	22.0
2008-06-02 01:00:00	NQ	Futures	2299.96	2301.09	2299.4	2300.53	106.0
2008-06-02 02:00:00	NQ	Futures	2300.81	2301.38	2298.27	2299.68	453.0
2008-06-02 03:00:00	NQ	Futures	2299.96	2300.53	2293.17	2294.59	1614.0
2008-06-02 04:00:00	NQ	Futures	2294.02	2294.31	2288.65	2292.04	1624.0
2008-06-02 05:00:00	NQ	Futures	2291.76	2293.74	2290.91	2293.17	635.0
2008-06-02 06:00:00	NQ	Futures	2293.17	2294.02	2292.33	2292.89	383.0
2008-06-02 07:00:00	NQ	Futures	2292.89	2296.29	2291.19	2295.15	1304.0
2008-06-02 08:00:00	NQ	Futures	2295.15	2296.29	2293.17	2294.87	2460.0
2008-06-02 09:00:00	NQ	Futures	2294.87	2297.42	2284.12	2288.65	38988.0
2008-06-02 10:00:00	NQ	Futures	2287.8	2290.35	2273.94	2275.36	71699.0
2008-06-02 11:00:00	NQ	Futures	2275.36	2276.49	2265.46	2271.4	54153.0
2008-06-02 12:00:00	NQ	Futures	2271.4	2273.09	2254.43	2254.43	57731.0
2008-06-02 13:00:00	NQ	Futures	2254.43	2262.35	2252.45	2262.35	38067.0
2008-06-02 14:00:00	NQ	Futures	2262.35	2264.61	2258.1	2259.52	30361.0
2008-06-02 15:00:00	NQ	Futures	2259.52	2273.66	2255.28	2273.38	57407.0
2008-06-02 16:00:00	NQ	Futures	2273.38	2277.9	2272.53	2276.2	12921.0
2008-06-02 17:00:00	NQ	Futures	2275.92	2276.49	2275.36	2276.2	207.0
2008-06-02 18:00:00	NQ	Futures	2275.92	2275.92	2274.51	2275.36	125.0
2008-06-02 19:00:00	NQ	Futures	2274.51	2275.07	2274.22	2274.79	96.0
2008-06-02 20:00:00	NQ	Futures	2274.79	2276.49	2274.51	2275.92	181.0
2008-06-02 21:00:00	NQ	Futures	2275.92	2277.34	2275.64	2277.34	86.0
2008-06-02 22:00:00	NQ	Futures	2277.34	2277.34	2275.64	2275.64	24.0
2008-06-02 23:00:00	NQ	Futures	2275.64	2277.62	2275.36	2275.64	45.0
2008-06-02 00:00:00	YM	Futures	11461.7	11466.3	11458.1	11459.9	124.0
2008-06-02 01:00:00	YM	Futures	11459.0	11467.2	11458.1	11466.3	105.0

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

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