PREVIEW / futures_1hour / 2011-06-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-06-03.parquet
  size:    40 KB
  rows:    1,167

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-03 00:00:00	ES	Futures	1301.53	1302.77	1300.78	1302.77	5682.0
2011-06-03 01:00:00	ES	Futures	1302.77	1303.76	1301.53	1301.78	6985.0
2011-06-03 02:00:00	ES	Futures	1301.53	1303.27	1301.28	1301.53	8491.0
2011-06-03 03:00:00	ES	Futures	1301.53	1301.78	1299.04	1301.03	31253.0
2011-06-03 04:00:00	ES	Futures	1301.03	1302.27	1300.29	1301.53	17581.0
2011-06-03 05:00:00	ES	Futures	1301.53	1301.78	1299.29	1299.79	18351.0
2011-06-03 06:00:00	ES	Futures	1299.79	1300.04	1297.55	1299.29	26012.0
2011-06-03 07:00:00	ES	Futures	1299.04	1301.03	1299.04	1300.53	22745.0
2011-06-03 08:00:00	ES	Futures	1300.53	1302.77	1286.37	1289.11	272910.0
2011-06-03 09:00:00	ES	Futures	1288.86	1292.83	1286.87	1291.84	375047.0
2011-06-03 10:00:00	ES	Futures	1291.84	1299.29	1291.34	1296.81	561914.0
2011-06-03 11:00:00	ES	Futures	1296.81	1298.05	1292.83	1296.31	300669.0
2011-06-03 12:00:00	ES	Futures	1296.56	1300.78	1295.32	1298.55	186708.0
2011-06-03 13:00:00	ES	Futures	1298.79	1299.29	1295.81	1296.06	99708.0
2011-06-03 14:00:00	ES	Futures	1295.81	1296.31	1292.34	1292.83	155366.0
2011-06-03 15:00:00	ES	Futures	1292.58	1294.57	1289.11	1290.85	402310.0
2011-06-03 16:00:00	ES	Futures	1290.6	1290.85	1287.37	1287.62	129540.0
2011-06-03 00:00:00	NQ	Futures	2668.87	2671.17	2668.29	2670.3	260.0
2011-06-03 01:00:00	NQ	Futures	2670.3	2672.31	2667.43	2668.01	383.0
2011-06-03 02:00:00	NQ	Futures	2668.29	2671.17	2667.72	2668.29	486.0
2011-06-03 03:00:00	NQ	Futures	2668.29	2668.58	2663.12	2666.57	2679.0
2011-06-03 04:00:00	NQ	Futures	2666.28	2668.58	2665.13	2667.72	1455.0
2011-06-03 05:00:00	NQ	Futures	2667.43	2667.43	2662.55	2663.98	1162.0
2011-06-03 06:00:00	NQ	Futures	2663.7	2664.27	2658.52	2661.11	2400.0
2011-06-03 07:00:00	NQ	Futures	2661.11	2665.42	2661.11	2664.84	2309.0
2011-06-03 08:00:00	NQ	Futures	2664.84	2670.59	2639.85	2646.17	19518.0
2011-06-03 09:00:00	NQ	Futures	2646.17	2655.36	2642.15	2650.48	42712.0
2011-06-03 10:00:00	NQ	Futures	2650.48	2663.98	2648.76	2661.11	48800.0
2011-06-03 11:00:00	NQ	Futures	2661.4	2662.26	2649.9	2655.36	30969.0
2011-06-03 12:00:00	NQ	Futures	2655.36	2659.1	2654.21	2655.36	20125.0
2011-06-03 13:00:00	NQ	Futures	2655.65	2657.37	2650.19	2650.48	17249.0
2011-06-03 14:00:00	NQ	Futures	2650.48	2650.77	2641.28	2641.86	20805.0
2011-06-03 15:00:00	NQ	Futures	2641.57	2643.01	2630.37	2633.81	62694.0
2011-06-03 16:00:00	NQ	Futures	2633.81	2633.81	2625.77	2628.36	11242.0
2011-06-03 00:00:00	YM	Futures	11767.3	11774.0	11763.4	11773.0	192.0
2011-06-03 01:00:00	YM	Futures	11773.0	11782.7	11769.2	11770.2	254.0
2011-06-03 02:00:00	YM	Futures	11770.2	11783.6	11768.2	11770.2	490.0
2011-06-03 03:00:00	YM	Futures	11769.2	11771.1	11749.0	11765.3	2609.0
2011-06-03 04:00:00	YM	Futures	11765.3	11772.1	11759.6	11768.2	1286.0
2011-06-03 05:00:00	YM	Futures	11767.3	11767.3	11749.0	11751.9	1527.0
2011-06-03 06:00:00	YM	Futures	11751.9	11753.8	11732.6	11745.1	1463.0
2011-06-03 07:00:00	YM	Futures	11746.1	11761.5	11745.1	11758.6	1372.0
2011-06-03 08:00:00	YM	Futures	11759.6	11761.5	11637.2	11659.4	13989.0
2011-06-03 09:00:00	YM	Futures	11658.4	11692.1	11643.0	11682.5	19977.0
2011-06-03 10:00:00	YM	Futures	11683.5	11736.4	11673.8	11716.2	24851.0
2011-06-03 11:00:00	YM	Futures	11716.2	11728.7	11682.5	11721.0	13404.0
2011-06-03 12:00:00	YM	Futures	11722.0	11757.6	11711.4	11741.3	7873.0
2011-06-03 13:00:00	YM	Futures	11742.2	11748.0	11723.9	11726.8	4552.0
2011-06-03 14:00:00	YM	Futures	11725.8	11726.8	11697.0	11699.8	6652.0
2011-06-03 15:00:00	YM	Futures	11699.8	11713.3	11672.9	11693.1	18693.0

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

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