PREVIEW / futures_1hour / 2011-07-28

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-28.parquet
  size:    48 KB
  rows:    1,450

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-07-28 00:00:00	ES	Futures	1299.65	1299.9	1297.41	1297.91	4564.0
2011-07-28 01:00:00	ES	Futures	1297.66	1299.4	1297.41	1298.16	5393.0
2011-07-28 02:00:00	ES	Futures	1298.16	1299.15	1296.16	1297.16	14266.0
2011-07-28 03:00:00	ES	Futures	1297.16	1301.65	1296.91	1301.15	47022.0
2011-07-28 04:00:00	ES	Futures	1301.15	1303.14	1299.9	1300.15	29981.0
2011-07-28 05:00:00	ES	Futures	1300.15	1300.9	1295.41	1295.91	35525.0
2011-07-28 06:00:00	ES	Futures	1295.91	1299.15	1292.67	1298.16	45655.0
2011-07-28 07:00:00	ES	Futures	1298.16	1299.4	1296.41	1297.41	22533.0
2011-07-28 08:00:00	ES	Futures	1297.41	1302.4	1293.92	1298.16	126760.0
2011-07-28 09:00:00	ES	Futures	1297.91	1301.15	1296.41	1300.15	279677.0
2011-07-28 10:00:00	ES	Futures	1300.15	1304.39	1296.91	1303.39	344286.0
2011-07-28 11:00:00	ES	Futures	1303.39	1309.38	1302.4	1308.63	321796.0
2011-07-28 12:00:00	ES	Futures	1308.63	1309.88	1303.89	1306.14	197037.0
2011-07-28 13:00:00	ES	Futures	1306.14	1307.13	1303.39	1305.39	150103.0
2011-07-28 14:00:00	ES	Futures	1305.64	1305.64	1299.4	1301.4	159073.0
2011-07-28 15:00:00	ES	Futures	1301.15	1301.4	1292.17	1294.41	397790.0
2011-07-28 16:00:00	ES	Futures	1294.41	1295.91	1292.67	1295.41	117914.0
2011-07-28 17:00:00	ES	Futures	1295.16	1295.66	1289.18	1291.17	7762.0
2011-07-28 18:00:00	ES	Futures	1294.17	1295.66	1290.17	1292.42	12135.0
2011-07-28 19:00:00	ES	Futures	1292.42	1293.42	1291.17	1292.92	3988.0
2011-07-28 20:00:00	ES	Futures	1292.67	1295.16	1291.92	1294.17	7795.0
2011-07-28 21:00:00	ES	Futures	1294.17	1295.16	1291.92	1292.67	5051.0
2011-07-28 22:00:00	ES	Futures	1292.92	1294.17	1279.95	1282.44	36416.0
2011-07-28 23:00:00	ES	Futures	1282.19	1287.93	1281.2	1285.44	14858.0
2011-07-28 00:00:00	NQ	Futures	2722.55	2722.84	2717.94	2718.81	263.0
2011-07-28 01:00:00	NQ	Futures	2718.52	2721.68	2717.66	2719.38	324.0
2011-07-28 02:00:00	NQ	Futures	2719.38	2721.11	2715.07	2717.66	1382.0
2011-07-28 03:00:00	NQ	Futures	2717.66	2727.44	2716.5	2727.15	5071.0
2011-07-28 04:00:00	NQ	Futures	2727.44	2732.62	2725.14	2726.0	3721.0
2011-07-28 05:00:00	NQ	Futures	2725.71	2726.58	2714.2	2715.07	3292.0
2011-07-28 06:00:00	NQ	Futures	2714.78	2721.4	2711.61	2719.38	3483.0
2011-07-28 07:00:00	NQ	Futures	2719.09	2722.26	2716.5	2719.09	2364.0
2011-07-28 08:00:00	NQ	Futures	2719.09	2732.04	2712.76	2724.27	14510.0
2011-07-28 09:00:00	NQ	Futures	2724.27	2731.47	2712.48	2729.45	40206.0
2011-07-28 10:00:00	NQ	Futures	2730.03	2745.28	2722.84	2743.27	41677.0
2011-07-28 11:00:00	NQ	Futures	2742.98	2759.09	2740.68	2757.65	39509.0
2011-07-28 12:00:00	NQ	Futures	2757.94	2761.11	2749.89	2753.91	32088.0
2011-07-28 13:00:00	NQ	Futures	2753.91	2758.23	2749.6	2752.76	20480.0
2011-07-28 14:00:00	NQ	Futures	2752.76	2753.34	2734.06	2741.54	24957.0
2011-07-28 15:00:00	NQ	Futures	2741.25	2741.54	2723.12	2727.44	42204.0
2011-07-28 16:00:00	NQ	Futures	2727.44	2732.91	2724.27	2731.47	8187.0
2011-07-28 17:00:00	NQ	Futures	2731.18	2732.04	2721.11	2724.56	390.0
2011-07-28 18:00:00	NQ	Futures	2726.86	2731.47	2722.26	2726.29	497.0
2011-07-28 19:00:00	NQ	Futures	2726.29	2728.01	2724.27	2726.58	426.0
2011-07-28 20:00:00	NQ	Futures	2726.58	2731.47	2724.85	2729.74	852.0
2011-07-28 21:00:00	NQ	Futures	2730.03	2730.89	2725.71	2727.15	311.0
2011-07-28 22:00:00	NQ	Futures	2727.73	2731.76	2699.24	2707.3	2966.0
2011-07-28 23:00:00	NQ	Futures	2707.01	2718.81	2704.99	2713.34	1425.0
2011-07-28 00:00:00	YM	Futures	11887.1	11889.0	11871.6	11872.6	273.0
2011-07-28 01:00:00	YM	Futures	11872.6	11881.3	11869.7	11875.5	828.0

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

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