PREVIEW / futures_1hour / 2012-01-17

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-17.parquet
  size:    47 KB
  rows:    1,445

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-17 00:00:00	ES	Futures	1306.56	1308.32	1306.31	1308.07	4818.0
2012-01-17 01:00:00	ES	Futures	1307.82	1309.58	1307.82	1308.57	10021.0
2012-01-17 02:00:00	ES	Futures	1308.57	1311.09	1308.32	1310.34	24757.0
2012-01-17 03:00:00	ES	Futures	1310.59	1311.09	1307.57	1309.58	30932.0
2012-01-17 04:00:00	ES	Futures	1309.58	1312.35	1308.57	1312.1	25845.0
2012-01-17 05:00:00	ES	Futures	1312.1	1312.86	1309.58	1309.58	24262.0
2012-01-17 06:00:00	ES	Futures	1309.58	1310.84	1308.57	1309.33	18177.0
2012-01-17 07:00:00	ES	Futures	1309.33	1311.35	1308.57	1309.33	28905.0
2012-01-17 08:00:00	ES	Futures	1309.58	1311.35	1306.81	1307.06	64596.0
2012-01-17 09:00:00	ES	Futures	1307.31	1309.33	1305.55	1306.31	223714.0
2012-01-17 10:00:00	ES	Futures	1306.56	1306.56	1303.03	1304.29	294737.0
2012-01-17 11:00:00	ES	Futures	1304.29	1306.81	1304.29	1305.8	186846.0
2012-01-17 12:00:00	ES	Futures	1306.05	1307.31	1302.78	1304.29	142039.0
2012-01-17 13:00:00	ES	Futures	1304.54	1305.3	1303.28	1304.29	73441.0
2012-01-17 14:00:00	ES	Futures	1304.29	1305.05	1298.75	1299.75	138040.0
2012-01-17 15:00:00	ES	Futures	1299.5	1300.26	1296.23	1299.0	265569.0
2012-01-17 16:00:00	ES	Futures	1299.25	1301.27	1298.49	1300.76	60811.0
2012-01-17 17:00:00	ES	Futures	1300.76	1301.52	1300.01	1300.76	3153.0
2012-01-17 18:00:00	ES	Futures	1300.51	1301.77	1300.26	1301.77	3898.0
2012-01-17 19:00:00	ES	Futures	1301.52	1302.02	1300.51	1300.51	5756.0
2012-01-17 20:00:00	ES	Futures	1300.51	1301.52	1300.01	1300.26	6222.0
2012-01-17 21:00:00	ES	Futures	1300.26	1300.76	1299.75	1300.76	4380.0
2012-01-17 22:00:00	ES	Futures	1300.76	1303.28	1300.26	1302.78	6657.0
2012-01-17 23:00:00	ES	Futures	1302.78	1304.29	1302.78	1303.79	4381.0
2012-01-17 00:00:00	NQ	Futures	2763.22	2764.67	2763.22	2764.67	161.0
2012-01-17 01:00:00	NQ	Futures	2764.96	2767.55	2764.96	2766.98	601.0
2012-01-17 02:00:00	NQ	Futures	2767.27	2771.89	2766.69	2771.02	866.0
2012-01-17 03:00:00	NQ	Futures	2771.02	2772.75	2762.07	2766.69	4019.0
2012-01-17 04:00:00	NQ	Futures	2766.69	2771.89	2764.38	2771.02	1311.0
2012-01-17 05:00:00	NQ	Futures	2771.6	2773.33	2766.4	2767.27	1736.0
2012-01-17 06:00:00	NQ	Futures	2766.98	2768.71	2764.38	2765.82	1003.0
2012-01-17 07:00:00	NQ	Futures	2765.82	2770.73	2763.51	2767.27	1654.0
2012-01-17 08:00:00	NQ	Futures	2767.55	2770.73	2760.91	2761.78	5000.0
2012-01-17 09:00:00	NQ	Futures	2762.07	2767.84	2759.18	2765.53	29809.0
2012-01-17 10:00:00	NQ	Futures	2765.53	2770.15	2761.2	2768.71	29972.0
2012-01-17 11:00:00	NQ	Futures	2769.0	2773.62	2767.84	2770.44	18075.0
2012-01-17 12:00:00	NQ	Futures	2770.44	2773.33	2765.53	2767.84	14497.0
2012-01-17 13:00:00	NQ	Futures	2767.84	2770.44	2764.38	2768.13	12184.0
2012-01-17 14:00:00	NQ	Futures	2768.13	2769.29	2760.05	2762.07	12989.0
2012-01-17 15:00:00	NQ	Futures	2761.78	2762.65	2751.38	2760.33	33283.0
2012-01-17 16:00:00	NQ	Futures	2760.33	2763.22	2760.05	2763.22	6465.0
2012-01-17 17:00:00	NQ	Futures	2763.51	2765.24	2762.65	2762.93	212.0
2012-01-17 18:00:00	NQ	Futures	2762.65	2764.96	2762.36	2764.96	320.0
2012-01-17 19:00:00	NQ	Futures	2764.67	2765.82	2763.22	2763.8	221.0
2012-01-17 20:00:00	NQ	Futures	2763.8	2764.96	2762.07	2763.22	271.0
2012-01-17 21:00:00	NQ	Futures	2762.93	2765.24	2762.07	2765.24	321.0
2012-01-17 22:00:00	NQ	Futures	2765.53	2769.86	2764.67	2769.58	678.0
2012-01-17 23:00:00	NQ	Futures	2769.58	2771.89	2769.29	2771.31	342.0
2012-01-17 00:00:00	YM	Futures	12350.5	12359.5	12348.6	12359.5	219.0
2012-01-17 01:00:00	YM	Futures	12357.5	12372.3	12357.5	12368.4	869.0

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

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