PREVIEW / futures_1hour / 2012-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-09.parquet
  size:    41 KB
  rows:    1,203

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-11-09 00:00:00	ES	Futures	1409.9	1411.44	1409.9	1410.67	6469.0
2012-11-09 01:00:00	ES	Futures	1410.67	1411.95	1409.9	1411.69	5530.0
2012-11-09 02:00:00	ES	Futures	1411.44	1411.95	1409.14	1410.16	11564.0
2012-11-09 03:00:00	ES	Futures	1410.16	1410.42	1404.54	1405.82	53325.0
2012-11-09 04:00:00	ES	Futures	1406.07	1408.12	1404.54	1407.86	35262.0
2012-11-09 05:00:00	ES	Futures	1407.86	1408.37	1401.47	1401.73	47424.0
2012-11-09 06:00:00	ES	Futures	1401.47	1404.28	1400.71	1401.98	34805.0
2012-11-09 07:00:00	ES	Futures	1402.24	1402.5	1396.88	1397.39	81797.0
2012-11-09 08:00:00	ES	Futures	1397.39	1400.2	1393.3	1398.41	146436.0
2012-11-09 09:00:00	ES	Futures	1398.41	1405.31	1398.41	1403.77	340848.0
2012-11-09 10:00:00	ES	Futures	1403.52	1411.95	1403.01	1410.42	364918.0
2012-11-09 11:00:00	ES	Futures	1410.16	1413.74	1408.88	1412.97	268707.0
2012-11-09 12:00:00	ES	Futures	1413.23	1418.33	1412.97	1415.52	206942.0
2012-11-09 13:00:00	ES	Futures	1415.52	1417.06	1404.54	1409.14	333443.0
2012-11-09 14:00:00	ES	Futures	1409.39	1414.76	1406.58	1408.88	176392.0
2012-11-09 15:00:00	ES	Futures	1408.88	1411.69	1404.79	1405.31	297753.0
2012-11-09 16:00:00	ES	Futures	1405.56	1407.35	1404.03	1406.07	84289.0
2012-11-09 00:00:00	NQ	Futures	3002.53	3003.69	3000.49	3001.36	634.0
2012-11-09 01:00:00	NQ	Futures	3001.36	3003.11	2999.91	3002.82	332.0
2012-11-09 02:00:00	NQ	Futures	3002.82	3003.11	2997.88	3001.36	1244.0
2012-11-09 03:00:00	NQ	Futures	3001.36	3001.65	2990.61	2994.97	3832.0
2012-11-09 04:00:00	NQ	Futures	2994.68	2999.62	2992.36	2999.62	3244.0
2012-11-09 05:00:00	NQ	Futures	2999.33	3000.2	2987.42	2987.71	4047.0
2012-11-09 06:00:00	NQ	Futures	2987.42	2992.94	2985.67	2989.45	3089.0
2012-11-09 07:00:00	NQ	Futures	2989.45	2989.45	2978.12	2978.99	7261.0
2012-11-09 08:00:00	NQ	Futures	2978.41	2985.38	2971.14	2982.48	14141.0
2012-11-09 09:00:00	NQ	Futures	2982.48	2999.33	2981.89	2992.65	57355.0
2012-11-09 10:00:00	NQ	Futures	2992.65	3013.28	2991.19	3011.53	66360.0
2012-11-09 11:00:00	NQ	Futures	3011.82	3017.05	3007.47	3013.86	37713.0
2012-11-09 12:00:00	NQ	Futures	3013.86	3030.42	3013.57	3022.87	30750.0
2012-11-09 13:00:00	NQ	Futures	3022.87	3026.64	2997.88	3008.92	51517.0
2012-11-09 14:00:00	NQ	Futures	3009.21	3019.09	3000.49	3005.72	28885.0
2012-11-09 15:00:00	NQ	Futures	3006.01	3010.66	2997.59	2997.88	40979.0
2012-11-09 16:00:00	NQ	Futures	2998.17	3003.4	2996.42	3001.94	9898.0
2012-11-09 00:00:00	YM	Futures	12819.6	12829.6	12817.6	12819.6	519.0
2012-11-09 01:00:00	YM	Futures	12818.6	12827.6	12812.6	12826.6	409.0
2012-11-09 02:00:00	YM	Futures	12826.6	12828.6	12805.6	12813.6	1070.0
2012-11-09 03:00:00	YM	Futures	12813.6	12814.6	12766.6	12778.6	3596.0
2012-11-09 04:00:00	YM	Futures	12779.6	12793.6	12767.6	12793.6	2057.0
2012-11-09 05:00:00	YM	Futures	12792.6	12795.6	12741.6	12741.6	2925.0
2012-11-09 06:00:00	YM	Futures	12741.6	12757.6	12733.6	12746.6	2276.0
2012-11-09 07:00:00	YM	Futures	12745.6	12746.6	12708.5	12715.5	4678.0
2012-11-09 08:00:00	YM	Futures	12714.5	12720.5	12676.5	12710.5	6874.0
2012-11-09 09:00:00	YM	Futures	12709.5	12763.6	12699.5	12744.6	25434.0
2012-11-09 10:00:00	YM	Futures	12744.6	12798.6	12737.6	12787.6	24032.0
2012-11-09 11:00:00	YM	Futures	12788.6	12822.6	12781.6	12818.6	16070.0
2012-11-09 12:00:00	YM	Futures	12820.6	12848.6	12815.6	12832.6	14624.0
2012-11-09 13:00:00	YM	Futures	12831.6	12840.6	12738.6	12777.6	25641.0
2012-11-09 14:00:00	YM	Futures	12777.6	12829.6	12757.6	12781.6	12791.0
2012-11-09 15:00:00	YM	Futures	12783.6	12805.6	12749.6	12766.6	17805.0

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

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