PREVIEW / futures_1hour / 2012-07-10

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-10.parquet
  size:    49 KB
  rows:    1,504

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-10 00:00:00	ES	Futures	1366.52	1367.03	1366.26	1366.52	1303.0
2012-07-10 01:00:00	ES	Futures	1366.52	1368.04	1366.26	1367.79	3833.0
2012-07-10 02:00:00	ES	Futures	1367.79	1370.33	1366.52	1369.82	8873.0
2012-07-10 03:00:00	ES	Futures	1369.57	1369.82	1366.52	1367.28	21211.0
2012-07-10 04:00:00	ES	Futures	1367.03	1376.18	1366.01	1374.15	48115.0
2012-07-10 05:00:00	ES	Futures	1374.15	1377.71	1373.89	1376.94	26442.0
2012-07-10 06:00:00	ES	Futures	1376.69	1378.47	1375.93	1377.71	15683.0
2012-07-10 07:00:00	ES	Futures	1377.45	1377.71	1375.42	1376.44	18367.0
2012-07-10 08:00:00	ES	Futures	1376.69	1376.69	1371.6	1376.69	60299.0
2012-07-10 09:00:00	ES	Futures	1376.69	1379.74	1375.42	1375.93	179174.0
2012-07-10 10:00:00	ES	Futures	1376.18	1377.45	1367.03	1368.81	345269.0
2012-07-10 11:00:00	ES	Futures	1368.81	1369.06	1365.25	1368.81	302563.0
2012-07-10 12:00:00	ES	Futures	1368.55	1369.57	1366.77	1367.54	85850.0
2012-07-10 13:00:00	ES	Futures	1367.79	1368.81	1362.45	1363.72	146455.0
2012-07-10 14:00:00	ES	Futures	1363.47	1364.48	1355.84	1356.35	270774.0
2012-07-10 15:00:00	ES	Futures	1356.35	1360.42	1353.3	1358.38	366413.0
2012-07-10 16:00:00	ES	Futures	1358.38	1359.4	1357.11	1358.89	85227.0
2012-07-10 17:00:00	ES	Futures	1359.14	1359.14	1358.13	1358.13	2193.0
2012-07-10 18:00:00	ES	Futures	1358.13	1358.64	1357.62	1358.13	2580.0
2012-07-10 19:00:00	ES	Futures	1358.13	1358.38	1357.62	1358.38	1861.0
2012-07-10 20:00:00	ES	Futures	1358.38	1358.89	1356.09	1356.35	6012.0
2012-07-10 21:00:00	ES	Futures	1356.6	1358.89	1356.35	1358.64	5774.0
2012-07-10 22:00:00	ES	Futures	1358.64	1360.42	1357.87	1359.14	5559.0
2012-07-10 23:00:00	ES	Futures	1359.14	1359.65	1356.6	1357.87	5161.0
2012-07-10 00:00:00	NQ	Futures	3011.04	3012.19	3010.46	3011.32	98.0
2012-07-10 01:00:00	NQ	Futures	3011.32	3013.06	3010.17	3013.06	527.0
2012-07-10 02:00:00	NQ	Futures	3013.06	3017.41	3011.32	3016.54	664.0
2012-07-10 03:00:00	NQ	Futures	3016.25	3016.25	3010.17	3011.04	1793.0
2012-07-10 04:00:00	NQ	Futures	3011.04	3029.88	3008.43	3026.11	5987.0
2012-07-10 05:00:00	NQ	Futures	3026.11	3034.81	3026.11	3031.91	3559.0
2012-07-10 06:00:00	NQ	Futures	3031.62	3036.54	3030.17	3034.52	2277.0
2012-07-10 07:00:00	NQ	Futures	3034.81	3034.81	3030.17	3032.78	2246.0
2012-07-10 08:00:00	NQ	Futures	3032.49	3036.83	3022.92	3036.83	7191.0
2012-07-10 09:00:00	NQ	Futures	3036.54	3044.37	3032.2	3037.12	26874.0
2012-07-10 10:00:00	NQ	Futures	3037.12	3040.31	3006.69	3010.46	44101.0
2012-07-10 11:00:00	NQ	Futures	3010.75	3010.75	2996.25	3007.85	38485.0
2012-07-10 12:00:00	NQ	Futures	3007.85	3012.48	3003.79	3008.14	14342.0
2012-07-10 13:00:00	NQ	Futures	3008.43	3011.32	3000.02	3002.63	16819.0
2012-07-10 14:00:00	NQ	Futures	3002.92	3004.66	2982.05	2983.5	35505.0
2012-07-10 15:00:00	NQ	Futures	2983.21	2994.8	2978.28	2991.03	41275.0
2012-07-10 16:00:00	NQ	Futures	2991.32	2991.61	2987.26	2989.29	5584.0
2012-07-10 17:00:00	NQ	Futures	2989.58	2989.58	2987.26	2987.55	145.0
2012-07-10 18:00:00	NQ	Futures	2988.71	2989.0	2986.39	2986.68	138.0
2012-07-10 19:00:00	NQ	Futures	2986.97	2987.55	2986.1	2987.55	168.0
2012-07-10 20:00:00	NQ	Futures	2987.55	2989.0	2983.21	2984.08	397.0
2012-07-10 21:00:00	NQ	Futures	2984.37	2989.87	2984.08	2988.71	673.0
2012-07-10 22:00:00	NQ	Futures	2988.71	2992.77	2988.42	2991.03	656.0
2012-07-10 23:00:00	NQ	Futures	2990.74	2991.9	2985.82	2988.71	751.0
2012-07-10 00:00:00	YM	Futures	12581.2	12587.1	12581.2	12581.2	110.0
2012-07-10 01:00:00	YM	Futures	12581.2	12588.1	12578.2	12587.1	498.0

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

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