PREVIEW / futures_1hour / 2012-01-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-09.parquet
  size:    46 KB
  rows:    1,434

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
2012-01-09 00:00:00	ES	Futures	1278.59	1279.6	1277.83	1279.09	2946.0
2012-01-09 01:00:00	ES	Futures	1279.09	1280.86	1278.84	1280.35	2674.0
2012-01-09 02:00:00	ES	Futures	1280.1	1284.63	1280.1	1284.38	13906.0
2012-01-09 03:00:00	ES	Futures	1284.38	1287.41	1283.63	1285.89	30808.0
2012-01-09 04:00:00	ES	Futures	1286.15	1286.15	1281.36	1284.13	31857.0
2012-01-09 05:00:00	ES	Futures	1284.13	1285.64	1282.37	1283.63	16223.0
2012-01-09 06:00:00	ES	Futures	1283.63	1285.14	1281.86	1283.63	18067.0
2012-01-09 07:00:00	ES	Futures	1283.63	1287.91	1282.37	1285.64	40008.0
2012-01-09 08:00:00	ES	Futures	1285.64	1287.41	1283.37	1286.9	52764.0
2012-01-09 09:00:00	ES	Futures	1286.9	1287.15	1282.11	1283.63	162931.0
2012-01-09 10:00:00	ES	Futures	1283.37	1287.41	1281.36	1282.87	256015.0
2012-01-09 11:00:00	ES	Futures	1282.87	1283.88	1279.6	1282.37	242475.0
2012-01-09 12:00:00	ES	Futures	1282.37	1284.89	1281.61	1284.13	97058.0
2012-01-09 13:00:00	ES	Futures	1284.13	1285.89	1283.88	1285.14	86451.0
2012-01-09 14:00:00	ES	Futures	1285.39	1287.41	1284.89	1285.39	107292.0
2012-01-09 15:00:00	ES	Futures	1285.14	1287.41	1284.89	1285.39	185371.0
2012-01-09 16:00:00	ES	Futures	1285.64	1286.4	1284.63	1284.89	55901.0
2012-01-09 17:00:00	ES	Futures	1284.89	1285.64	1284.63	1285.64	1426.0
2012-01-09 18:00:00	ES	Futures	1285.89	1287.66	1285.14	1287.41	6039.0
2012-01-09 19:00:00	ES	Futures	1287.41	1289.17	1287.15	1287.66	9639.0
2012-01-09 20:00:00	ES	Futures	1287.66	1289.67	1287.41	1289.42	8209.0
2012-01-09 21:00:00	ES	Futures	1289.42	1289.67	1288.16	1289.42	4217.0
2012-01-09 22:00:00	ES	Futures	1289.17	1290.18	1288.92	1289.67	5255.0
2012-01-09 23:00:00	ES	Futures	1289.42	1291.94	1289.42	1291.69	8320.0
2012-01-09 00:00:00	NQ	Futures	2708.35	2709.79	2706.62	2709.22	109.0
2012-01-09 01:00:00	NQ	Futures	2708.93	2712.68	2708.64	2710.95	212.0
2012-01-09 02:00:00	NQ	Futures	2711.24	2720.77	2711.24	2719.61	758.0
2012-01-09 03:00:00	NQ	Futures	2720.48	2727.12	2719.04	2724.52	1900.0
2012-01-09 04:00:00	NQ	Futures	2724.52	2726.26	2717.01	2723.08	1798.0
2012-01-09 05:00:00	NQ	Futures	2723.08	2725.1	2720.19	2721.06	1084.0
2012-01-09 06:00:00	NQ	Futures	2720.77	2724.81	2718.46	2721.92	1259.0
2012-01-09 07:00:00	NQ	Futures	2722.21	2730.3	2719.33	2725.97	2427.0
2012-01-09 08:00:00	NQ	Futures	2725.97	2729.43	2722.21	2727.99	4435.0
2012-01-09 09:00:00	NQ	Futures	2727.7	2728.57	2713.84	2717.59	22560.0
2012-01-09 10:00:00	NQ	Futures	2717.88	2722.5	2707.2	2710.37	27744.0
2012-01-09 11:00:00	NQ	Futures	2710.37	2714.13	2701.42	2708.35	25232.0
2012-01-09 12:00:00	NQ	Futures	2708.35	2713.84	2704.89	2712.11	11965.0
2012-01-09 13:00:00	NQ	Futures	2712.11	2715.57	2710.37	2713.84	9371.0
2012-01-09 14:00:00	NQ	Futures	2713.84	2719.9	2712.97	2715.28	12907.0
2012-01-09 15:00:00	NQ	Futures	2715.28	2717.59	2710.08	2711.53	19359.0
2012-01-09 16:00:00	NQ	Futures	2711.24	2715.28	2709.51	2712.11	7250.0
2012-01-09 17:00:00	NQ	Futures	2711.82	2713.26	2710.95	2712.68	111.0
2012-01-09 18:00:00	NQ	Futures	2711.82	2717.01	2711.82	2716.73	519.0
2012-01-09 19:00:00	NQ	Futures	2716.73	2720.77	2716.73	2717.59	685.0
2012-01-09 20:00:00	NQ	Futures	2717.3	2721.64	2717.01	2720.77	330.0
2012-01-09 21:00:00	NQ	Futures	2721.06	2721.64	2719.04	2721.06	263.0
2012-01-09 22:00:00	NQ	Futures	2721.35	2723.37	2720.77	2721.92	255.0
2012-01-09 23:00:00	NQ	Futures	2722.21	2725.39	2721.64	2725.39	375.0
2012-01-09 00:00:00	YM	Futures	12158.3	12164.2	12153.3	12162.2	264.0
2012-01-09 01:00:00	YM	Futures	12162.2	12177.1	12160.2	12173.1	356.0

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

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