PREVIEW / futures_1hour / 2012-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-27.parquet
  size:    43 KB
  rows:    1,194

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-07-27 00:00:00	ES	Futures	1381.27	1381.78	1381.01	1381.52	1074.0
2012-07-27 01:00:00	ES	Futures	1381.27	1385.34	1380.25	1384.06	9728.0
2012-07-27 02:00:00	ES	Futures	1384.06	1385.59	1382.79	1383.81	13826.0
2012-07-27 03:00:00	ES	Futures	1384.06	1384.83	1379.74	1380.5	35010.0
2012-07-27 04:00:00	ES	Futures	1380.5	1381.01	1376.94	1377.45	33647.0
2012-07-27 05:00:00	ES	Futures	1377.45	1382.79	1375.93	1378.98	57359.0
2012-07-27 06:00:00	ES	Futures	1379.23	1383.3	1378.47	1383.05	30875.0
2012-07-27 07:00:00	ES	Futures	1383.05	1385.08	1381.52	1381.78	40179.0
2012-07-27 08:00:00	ES	Futures	1381.78	1387.88	1381.52	1384.83	108871.0
2012-07-27 09:00:00	ES	Futures	1384.57	1389.15	1383.81	1388.9	267389.0
2012-07-27 10:00:00	ES	Futures	1388.9	1393.73	1387.62	1392.96	350080.0
2012-07-27 11:00:00	ES	Futures	1393.22	1395.0	1392.71	1393.98	269734.0
2012-07-27 12:00:00	ES	Futures	1393.98	1396.78	1393.22	1395.76	103833.0
2012-07-27 13:00:00	ES	Futures	1395.76	1407.97	1395.25	1404.41	420896.0
2012-07-27 14:00:00	ES	Futures	1404.41	1405.68	1401.61	1404.92	228618.0
2012-07-27 15:00:00	ES	Futures	1404.92	1408.73	1403.39	1404.66	390442.0
2012-07-27 16:00:00	ES	Futures	1404.66	1406.7	1404.41	1406.19	99676.0
2012-07-27 00:00:00	NQ	Futures	2993.35	2994.22	2992.48	2993.93	262.0
2012-07-27 01:00:00	NQ	Futures	2993.35	3000.31	2991.61	2999.73	1136.0
2012-07-27 02:00:00	NQ	Futures	3000.02	3004.37	2997.12	3000.89	1181.0
2012-07-27 03:00:00	NQ	Futures	3000.89	3003.21	2993.06	2993.93	2761.0
2012-07-27 04:00:00	NQ	Futures	2994.22	2996.25	2984.66	2985.24	2601.0
2012-07-27 05:00:00	NQ	Futures	2985.24	2995.96	2982.92	2987.84	4196.0
2012-07-27 06:00:00	NQ	Futures	2987.84	2995.96	2987.26	2995.67	2090.0
2012-07-27 07:00:00	NQ	Futures	2995.38	3000.02	2992.77	2993.64	3828.0
2012-07-27 08:00:00	NQ	Futures	2993.93	3006.69	2992.77	3002.34	8041.0
2012-07-27 09:00:00	NQ	Futures	3002.05	3015.38	3000.89	3014.22	38463.0
2012-07-27 10:00:00	NQ	Futures	3014.22	3028.14	3010.17	3026.11	41697.0
2012-07-27 11:00:00	NQ	Futures	3026.11	3033.65	3025.24	3032.2	29696.0
2012-07-27 12:00:00	NQ	Futures	3032.49	3040.02	3029.88	3037.7	17469.0
2012-07-27 13:00:00	NQ	Futures	3037.7	3063.5	3036.54	3054.23	46280.0
2012-07-27 14:00:00	NQ	Futures	3054.52	3058.87	3048.72	3057.42	24982.0
2012-07-27 15:00:00	NQ	Futures	3057.13	3066.4	3055.68	3063.21	44474.0
2012-07-27 16:00:00	NQ	Futures	3063.5	3068.14	3062.34	3063.5	11572.0
2012-07-27 00:00:00	YM	Futures	12781.1	12781.1	12777.1	12780.1	191.0
2012-07-27 01:00:00	YM	Futures	12778.1	12807.9	12771.1	12804.9	923.0
2012-07-27 02:00:00	YM	Futures	12804.9	12818.8	12794.0	12804.9	1030.0
2012-07-27 03:00:00	YM	Futures	12804.9	12806.9	12771.1	12774.1	1726.0
2012-07-27 04:00:00	YM	Futures	12774.1	12782.1	12749.2	12754.2	1857.0
2012-07-27 05:00:00	YM	Futures	12754.2	12797.0	12745.3	12765.1	2860.0
2012-07-27 06:00:00	YM	Futures	12766.1	12796.0	12765.1	12795.0	1674.0
2012-07-27 07:00:00	YM	Futures	12795.0	12805.9	12783.0	12785.0	2189.0
2012-07-27 08:00:00	YM	Futures	12786.0	12822.8	12768.1	12791.0	10090.0
2012-07-27 09:00:00	YM	Futures	12792.0	12840.7	12790.0	12833.8	18472.0
2012-07-27 10:00:00	YM	Futures	12833.8	12862.6	12813.9	12858.6	23249.0
2012-07-27 11:00:00	YM	Futures	12859.6	12870.6	12847.7	12862.6	15253.0
2012-07-27 12:00:00	YM	Futures	12862.6	12886.5	12855.6	12877.5	7503.0
2012-07-27 13:00:00	YM	Futures	12877.5	12987.9	12874.5	12960.0	25615.0
2012-07-27 14:00:00	YM	Futures	12961.0	12967.0	12933.2	12955.1	13519.0
2012-07-27 15:00:00	YM	Futures	12955.1	12981.9	12935.2	12951.1	20088.0

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

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