PREVIEW / futures_1hour / 2012-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-13.parquet
  size:    48 KB
  rows:    1,503

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-13 00:00:00	ES	Futures	1397.9	1399.94	1397.64	1399.69	6425.0
2012-11-13 01:00:00	ES	Futures	1399.43	1401.73	1399.43	1401.22	5296.0
2012-11-13 02:00:00	ES	Futures	1401.22	1401.73	1398.41	1399.43	10407.0
2012-11-13 03:00:00	ES	Futures	1399.43	1399.94	1396.11	1397.39	33391.0
2012-11-13 04:00:00	ES	Futures	1397.39	1401.47	1396.88	1400.2	26984.0
2012-11-13 05:00:00	ES	Futures	1400.45	1400.71	1397.39	1397.9	27032.0
2012-11-13 06:00:00	ES	Futures	1398.15	1403.01	1395.6	1402.24	55276.0
2012-11-13 07:00:00	ES	Futures	1402.24	1405.05	1399.94	1400.96	51803.0
2012-11-13 08:00:00	ES	Futures	1401.22	1402.75	1399.17	1399.94	51548.0
2012-11-13 09:00:00	ES	Futures	1399.94	1407.86	1396.88	1406.84	252592.0
2012-11-13 10:00:00	ES	Futures	1407.09	1414.76	1404.28	1414.5	383561.0
2012-11-13 11:00:00	ES	Futures	1414.25	1416.55	1412.2	1414.25	249203.0
2012-11-13 12:00:00	ES	Futures	1414.25	1414.5	1408.63	1409.9	115603.0
2012-11-13 13:00:00	ES	Futures	1410.16	1413.48	1408.63	1412.97	100036.0
2012-11-13 14:00:00	ES	Futures	1412.97	1413.99	1407.86	1409.65	116780.0
2012-11-13 15:00:00	ES	Futures	1409.65	1410.67	1400.71	1401.73	301665.0
2012-11-13 16:00:00	ES	Futures	1401.73	1405.56	1399.69	1404.79	120184.0
2012-11-13 17:00:00	ES	Futures	1404.79	1405.05	1404.03	1404.54	2438.0
2012-11-13 18:00:00	ES	Futures	1404.54	1404.79	1401.98	1403.01	8130.0
2012-11-13 19:00:00	ES	Futures	1403.01	1404.54	1402.5	1404.28	6188.0
2012-11-13 20:00:00	ES	Futures	1404.28	1404.54	1402.5	1404.28	4611.0
2012-11-13 21:00:00	ES	Futures	1404.54	1406.33	1403.52	1406.07	5183.0
2012-11-13 22:00:00	ES	Futures	1406.07	1406.33	1404.79	1406.07	3336.0
2012-11-13 23:00:00	ES	Futures	1406.07	1406.33	1405.05	1405.56	1512.0
2012-11-13 00:00:00	NQ	Futures	2980.15	2983.93	2979.57	2983.64	936.0
2012-11-13 01:00:00	NQ	Futures	2983.64	2987.13	2982.48	2985.96	534.0
2012-11-13 02:00:00	NQ	Futures	2985.96	2986.25	2980.15	2982.19	1334.0
2012-11-13 03:00:00	NQ	Futures	2981.89	2983.64	2976.08	2977.83	3840.0
2012-11-13 04:00:00	NQ	Futures	2978.12	2985.67	2976.08	2983.06	2326.0
2012-11-13 05:00:00	NQ	Futures	2983.06	2983.35	2975.79	2979.57	3320.0
2012-11-13 06:00:00	NQ	Futures	2978.99	2986.83	2975.5	2985.38	4382.0
2012-11-13 07:00:00	NQ	Futures	2985.38	2989.74	2979.57	2979.86	5669.0
2012-11-13 08:00:00	NQ	Futures	2980.15	2982.19	2976.08	2976.66	6224.0
2012-11-13 09:00:00	NQ	Futures	2976.66	2994.1	2967.37	2991.77	58289.0
2012-11-13 10:00:00	NQ	Futures	2992.07	3001.36	2983.93	2999.91	67304.0
2012-11-13 11:00:00	NQ	Futures	2999.91	3005.43	2995.84	3002.82	35100.0
2012-11-13 12:00:00	NQ	Futures	3002.82	3003.98	2989.74	2992.36	26745.0
2012-11-13 13:00:00	NQ	Futures	2992.07	3000.78	2989.45	3000.2	26797.0
2012-11-13 14:00:00	NQ	Futures	2999.91	3001.65	2989.16	2993.52	18145.0
2012-11-13 15:00:00	NQ	Futures	2993.81	2995.84	2974.34	2976.96	40710.0
2012-11-13 16:00:00	NQ	Futures	2977.25	2992.65	2975.21	2991.77	10408.0
2012-11-13 17:00:00	NQ	Futures	2991.77	2993.52	2991.19	2992.07	1001.0
2012-11-13 18:00:00	NQ	Futures	2991.77	2991.77	2987.42	2988.87	506.0
2012-11-13 19:00:00	NQ	Futures	2988.29	2992.36	2988.0	2990.9	498.0
2012-11-13 20:00:00	NQ	Futures	2990.9	2991.77	2988.29	2991.19	499.0
2012-11-13 21:00:00	NQ	Futures	2991.48	2995.26	2989.74	2995.26	591.0
2012-11-13 22:00:00	NQ	Futures	2995.26	2995.84	2992.94	2994.97	458.0
2012-11-13 23:00:00	NQ	Futures	2995.26	2995.84	2993.81	2994.97	184.0
2012-11-13 00:00:00	YM	Futures	12707.5	12725.5	12704.5	12725.5	825.0
2012-11-13 01:00:00	YM	Futures	12723.5	12738.6	12722.5	12732.6	361.0

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

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