PREVIEW / futures_1hour / 2011-06-22

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-22.parquet
  size:    49 KB
  rows:    1,478

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
2011-06-22 00:00:00	ES	Futures	1282.69	1283.19	1282.19	1283.19	3250.0
2011-06-22 01:00:00	ES	Futures	1283.19	1283.44	1282.19	1282.19	4198.0
2011-06-22 02:00:00	ES	Futures	1282.44	1284.94	1282.19	1283.69	13660.0
2011-06-22 03:00:00	ES	Futures	1283.69	1283.94	1280.95	1282.19	29138.0
2011-06-22 04:00:00	ES	Futures	1282.19	1283.69	1281.45	1282.44	16628.0
2011-06-22 05:00:00	ES	Futures	1282.69	1282.69	1279.2	1279.7	24289.0
2011-06-22 06:00:00	ES	Futures	1279.7	1281.45	1278.95	1279.95	25753.0
2011-06-22 07:00:00	ES	Futures	1279.95	1284.19	1279.95	1283.94	30989.0
2011-06-22 08:00:00	ES	Futures	1284.19	1284.44	1279.95	1281.2	60852.0
2011-06-22 09:00:00	ES	Futures	1281.2	1287.93	1281.2	1287.43	221083.0
2011-06-22 10:00:00	ES	Futures	1287.18	1290.67	1283.94	1289.68	286459.0
2011-06-22 11:00:00	ES	Futures	1289.43	1289.93	1287.18	1287.18	187492.0
2011-06-22 12:00:00	ES	Futures	1287.18	1289.68	1284.44	1288.93	149579.0
2011-06-22 13:00:00	ES	Futures	1288.93	1289.43	1287.43	1289.18	63089.0
2011-06-22 14:00:00	ES	Futures	1289.43	1290.17	1283.44	1283.94	215882.0
2011-06-22 15:00:00	ES	Futures	1284.19	1286.18	1278.2	1278.95	364591.0
2011-06-22 16:00:00	ES	Futures	1279.2	1279.2	1275.71	1276.46	128163.0
2011-06-22 17:00:00	ES	Futures	1276.46	1276.96	1275.21	1275.46	4795.0
2011-06-22 18:00:00	ES	Futures	1276.21	1276.46	1272.22	1272.47	15308.0
2011-06-22 19:00:00	ES	Futures	1272.72	1273.22	1271.47	1272.97	8392.0
2011-06-22 20:00:00	ES	Futures	1272.72	1274.21	1271.72	1273.71	8885.0
2011-06-22 21:00:00	ES	Futures	1273.46	1274.46	1271.72	1273.22	8435.0
2011-06-22 22:00:00	ES	Futures	1272.97	1273.46	1271.97	1273.22	9374.0
2011-06-22 23:00:00	ES	Futures	1273.22	1273.71	1271.97	1272.22	2840.0
2011-06-22 00:00:00	NQ	Futures	2575.5	2576.94	2574.64	2576.94	377.0
2011-06-22 01:00:00	NQ	Futures	2576.94	2578.09	2574.64	2574.64	335.0
2011-06-22 02:00:00	NQ	Futures	2575.5	2580.39	2575.21	2578.09	624.0
2011-06-22 03:00:00	NQ	Futures	2578.38	2579.24	2576.07	2577.51	2401.0
2011-06-22 04:00:00	NQ	Futures	2577.8	2580.1	2576.07	2577.8	2085.0
2011-06-22 05:00:00	NQ	Futures	2577.51	2577.51	2570.9	2571.47	2561.0
2011-06-22 06:00:00	NQ	Futures	2571.76	2574.92	2570.9	2572.05	1524.0
2011-06-22 07:00:00	NQ	Futures	2572.05	2580.1	2571.76	2580.1	2326.0
2011-06-22 08:00:00	NQ	Futures	2579.53	2581.25	2573.2	2576.65	8889.0
2011-06-22 09:00:00	NQ	Futures	2576.94	2586.15	2574.92	2584.71	41739.0
2011-06-22 10:00:00	NQ	Futures	2584.42	2589.31	2578.95	2586.43	31204.0
2011-06-22 11:00:00	NQ	Futures	2586.43	2587.87	2582.69	2583.27	20139.0
2011-06-22 12:00:00	NQ	Futures	2583.27	2589.02	2579.82	2587.87	19073.0
2011-06-22 13:00:00	NQ	Futures	2587.87	2589.6	2584.71	2588.74	11224.0
2011-06-22 14:00:00	NQ	Futures	2588.74	2590.75	2580.1	2581.83	28502.0
2011-06-22 15:00:00	NQ	Futures	2581.83	2584.13	2567.15	2568.59	40020.0
2011-06-22 16:00:00	NQ	Futures	2568.59	2569.46	2563.41	2564.28	7796.0
2011-06-22 17:00:00	NQ	Futures	2564.28	2564.56	2562.55	2564.28	177.0
2011-06-22 18:00:00	NQ	Futures	2564.85	2565.43	2556.79	2558.52	912.0
2011-06-22 19:00:00	NQ	Futures	2558.52	2558.52	2556.79	2558.23	693.0
2011-06-22 20:00:00	NQ	Futures	2557.95	2561.97	2556.79	2560.82	825.0
2011-06-22 21:00:00	NQ	Futures	2560.54	2561.69	2557.08	2560.25	533.0
2011-06-22 22:00:00	NQ	Futures	2559.96	2560.82	2557.66	2560.54	1002.0
2011-06-22 23:00:00	NQ	Futures	2560.82	2561.4	2556.51	2557.08	458.0
2011-06-22 00:00:00	YM	Futures	11697.3	11701.2	11693.4	11701.2	105.0
2011-06-22 01:00:00	YM	Futures	11702.1	11705.0	11696.3	11698.3	235.0

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

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