PREVIEW / futures_1hour / 2011-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-31.parquet
  size:    47 KB
  rows:    1,401

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-08-31 00:00:00	ES	Futures	1203.88	1204.88	1203.13	1203.63	3051.0
2011-08-31 01:00:00	ES	Futures	1203.88	1205.13	1203.38	1204.63	4112.0
2011-08-31 02:00:00	ES	Futures	1204.63	1207.12	1204.38	1206.87	17288.0
2011-08-31 03:00:00	ES	Futures	1206.62	1211.11	1204.38	1210.86	52310.0
2011-08-31 04:00:00	ES	Futures	1210.86	1215.35	1210.12	1213.86	44844.0
2011-08-31 05:00:00	ES	Futures	1213.61	1215.1	1211.86	1212.61	19699.0
2011-08-31 06:00:00	ES	Futures	1212.61	1214.11	1211.11	1211.86	21049.0
2011-08-31 07:00:00	ES	Futures	1211.86	1214.6	1211.36	1212.61	28118.0
2011-08-31 08:00:00	ES	Futures	1212.36	1215.85	1210.61	1215.35	79680.0
2011-08-31 09:00:00	ES	Futures	1215.1	1224.33	1214.85	1222.34	402513.0
2011-08-31 10:00:00	ES	Futures	1222.09	1226.83	1219.84	1220.59	477841.0
2011-08-31 11:00:00	ES	Futures	1220.59	1222.09	1214.36	1214.6	444707.0
2011-08-31 12:00:00	ES	Futures	1214.6	1222.09	1214.36	1222.09	213453.0
2011-08-31 13:00:00	ES	Futures	1222.09	1223.08	1214.11	1214.85	178803.0
2011-08-31 14:00:00	ES	Futures	1214.6	1215.85	1206.87	1210.37	262594.0
2011-08-31 15:00:00	ES	Futures	1210.12	1218.35	1204.63	1214.36	718900.0
2011-08-31 16:00:00	ES	Futures	1214.36	1216.35	1212.11	1215.6	145514.0
2011-08-31 17:00:00	ES	Futures	1215.6	1215.6	1214.36	1214.85	2677.0
2011-08-31 18:00:00	ES	Futures	1214.85	1215.85	1214.11	1215.35	3839.0
2011-08-31 19:00:00	ES	Futures	1215.1	1215.6	1214.11	1214.11	2600.0
2011-08-31 20:00:00	ES	Futures	1214.11	1217.35	1213.61	1215.85	8958.0
2011-08-31 21:00:00	ES	Futures	1215.85	1221.09	1215.6	1220.34	12042.0
2011-08-31 22:00:00	ES	Futures	1220.59	1221.59	1219.09	1220.84	4377.0
2011-08-31 23:00:00	ES	Futures	1221.09	1221.59	1218.1	1218.1	6215.0
2011-08-31 00:00:00	NQ	Futures	2565.72	2568.02	2564.28	2566.0	374.0
2011-08-31 01:00:00	NQ	Futures	2566.58	2570.03	2565.72	2569.17	540.0
2011-08-31 02:00:00	NQ	Futures	2569.17	2575.21	2568.02	2574.06	1163.0
2011-08-31 03:00:00	NQ	Futures	2574.64	2582.69	2569.46	2582.69	5444.0
2011-08-31 04:00:00	NQ	Futures	2582.41	2589.89	2579.82	2587.59	4445.0
2011-08-31 05:00:00	NQ	Futures	2587.59	2589.6	2583.27	2585.0	1914.0
2011-08-31 06:00:00	NQ	Futures	2584.71	2587.3	2582.12	2585.0	2140.0
2011-08-31 07:00:00	NQ	Futures	2584.42	2587.87	2582.98	2585.28	2547.0
2011-08-31 08:00:00	NQ	Futures	2585.28	2589.02	2581.54	2587.3	6065.0
2011-08-31 09:00:00	NQ	Futures	2587.59	2603.12	2582.41	2598.23	46988.0
2011-08-31 10:00:00	NQ	Futures	2597.66	2611.18	2596.22	2597.94	42824.0
2011-08-31 11:00:00	NQ	Futures	2597.94	2601.11	2576.07	2576.07	36768.0
2011-08-31 12:00:00	NQ	Futures	2576.07	2594.2	2575.79	2593.05	20988.0
2011-08-31 13:00:00	NQ	Futures	2593.05	2595.64	2573.77	2574.06	17391.0
2011-08-31 14:00:00	NQ	Futures	2574.35	2576.94	2558.81	2566.58	24763.0
2011-08-31 15:00:00	NQ	Futures	2566.29	2583.84	2556.79	2582.12	54522.0
2011-08-31 16:00:00	NQ	Futures	2581.25	2585.86	2576.65	2583.27	13276.0
2011-08-31 17:00:00	NQ	Futures	2583.84	2584.13	2581.83	2582.41	59.0
2011-08-31 18:00:00	NQ	Futures	2583.56	2584.13	2580.97	2583.56	287.0
2011-08-31 19:00:00	NQ	Futures	2582.69	2583.84	2581.54	2581.83	162.0
2011-08-31 20:00:00	NQ	Futures	2581.83	2587.59	2580.68	2584.71	845.0
2011-08-31 21:00:00	NQ	Futures	2584.13	2594.78	2584.13	2593.63	1085.0
2011-08-31 22:00:00	NQ	Futures	2593.92	2595.36	2591.04	2594.2	549.0
2011-08-31 23:00:00	NQ	Futures	2594.49	2595.93	2589.89	2589.89	769.0
2011-08-31 00:00:00	YM	Futures	11149.2	11154.0	11145.3	11146.3	249.0
2011-08-31 01:00:00	YM	Futures	11147.2	11156.0	11143.4	11153.1	93.0

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

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