PREVIEW / futures_1hour / 2012-11-20

all futures 1-hour files

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

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-20 00:00:00	ES	Futures	1411.18	1412.2	1410.67	1411.95	3742.0
2012-11-20 01:00:00	ES	Futures	1411.69	1411.95	1409.9	1410.42	4997.0
2012-11-20 02:00:00	ES	Futures	1410.42	1411.44	1408.63	1409.14	11931.0
2012-11-20 03:00:00	ES	Futures	1409.39	1412.97	1408.12	1410.16	32742.0
2012-11-20 04:00:00	ES	Futures	1409.9	1412.97	1409.65	1410.67	22806.0
2012-11-20 05:00:00	ES	Futures	1410.67	1414.5	1409.9	1413.99	22617.0
2012-11-20 06:00:00	ES	Futures	1413.74	1413.99	1412.46	1412.97	10605.0
2012-11-20 07:00:00	ES	Futures	1412.97	1414.5	1409.65	1410.67	29347.0
2012-11-20 08:00:00	ES	Futures	1410.67	1415.27	1410.67	1413.23	57382.0
2012-11-20 09:00:00	ES	Futures	1413.48	1413.74	1408.37	1412.2	174952.0
2012-11-20 10:00:00	ES	Futures	1412.46	1416.29	1410.67	1412.97	200819.0
2012-11-20 11:00:00	ES	Futures	1413.23	1417.57	1411.69	1416.8	183810.0
2012-11-20 12:00:00	ES	Futures	1416.8	1417.82	1413.48	1414.76	136628.0
2012-11-20 13:00:00	ES	Futures	1415.01	1415.27	1404.03	1409.65	241449.0
2012-11-20 14:00:00	ES	Futures	1409.65	1412.46	1408.63	1411.69	105762.0
2012-11-20 15:00:00	ES	Futures	1411.69	1416.29	1411.18	1415.78	175971.0
2012-11-20 16:00:00	ES	Futures	1416.04	1417.31	1415.52	1416.29	74738.0
2012-11-20 17:00:00	ES	Futures	1416.04	1416.55	1416.04	1416.29	1711.0
2012-11-20 18:00:00	ES	Futures	1416.29	1416.55	1415.52	1416.04	3871.0
2012-11-20 19:00:00	ES	Futures	1415.78	1419.61	1415.27	1417.82	12017.0
2012-11-20 20:00:00	ES	Futures	1417.82	1419.61	1417.31	1419.1	9268.0
2012-11-20 21:00:00	ES	Futures	1419.1	1419.61	1416.8	1417.31	4412.0
2012-11-20 22:00:00	ES	Futures	1417.31	1417.82	1411.18	1411.44	19870.0
2012-11-20 23:00:00	ES	Futures	1411.69	1411.69	1407.09	1408.12	16818.0
2012-11-20 00:00:00	NQ	Futures	3003.4	3005.14	3003.11	3005.14	715.0
2012-11-20 01:00:00	NQ	Futures	3004.56	3004.56	3001.65	3002.24	425.0
2012-11-20 02:00:00	NQ	Futures	3002.24	3004.85	3000.2	3001.65	1070.0
2012-11-20 03:00:00	NQ	Futures	3001.36	3007.47	2998.75	3000.49	3338.0
2012-11-20 04:00:00	NQ	Futures	3000.2	3007.47	2999.62	3003.4	2008.0
2012-11-20 05:00:00	NQ	Futures	3003.4	3010.95	3001.36	3010.08	2738.0
2012-11-20 06:00:00	NQ	Futures	3010.37	3011.24	3007.47	3008.63	1330.0
2012-11-20 07:00:00	NQ	Futures	3008.63	3010.95	3002.24	3003.4	2010.0
2012-11-20 08:00:00	NQ	Futures	3003.4	3013.86	3003.4	3012.7	7043.0
2012-11-20 09:00:00	NQ	Futures	3012.7	3015.6	3000.78	3008.63	35067.0
2012-11-20 10:00:00	NQ	Futures	3008.63	3015.6	3006.3	3006.88	35439.0
2012-11-20 11:00:00	NQ	Futures	3007.18	3017.93	3003.69	3017.05	26547.0
2012-11-20 12:00:00	NQ	Futures	3017.35	3018.22	3006.3	3009.79	19702.0
2012-11-20 13:00:00	NQ	Futures	3009.79	3010.37	2984.8	2999.91	39104.0
2012-11-20 14:00:00	NQ	Futures	2999.91	3006.59	2997.0	3003.69	17037.0
2012-11-20 15:00:00	NQ	Futures	3003.98	3013.86	3002.24	3013.57	24549.0
2012-11-20 16:00:00	NQ	Futures	3013.57	3015.89	3011.82	3012.7	5811.0
2012-11-20 17:00:00	NQ	Futures	3013.57	3014.15	3012.41	3013.28	68.0
2012-11-20 18:00:00	NQ	Futures	3012.7	3013.86	3011.53	3012.7	421.0
2012-11-20 19:00:00	NQ	Futures	3012.41	3017.64	3011.53	3015.02	1251.0
2012-11-20 20:00:00	NQ	Futures	3015.02	3018.51	3014.15	3017.64	836.0
2012-11-20 21:00:00	NQ	Futures	3017.93	3018.51	3012.7	3013.57	549.0
2012-11-20 22:00:00	NQ	Futures	3012.99	3014.73	3004.27	3004.56	2593.0
2012-11-20 23:00:00	NQ	Futures	3004.56	3004.56	2996.71	2998.17	2216.0
2012-11-20 00:00:00	YM	Futures	12733.6	12740.6	12731.6	12738.6	416.0
2012-11-20 01:00:00	YM	Futures	12737.6	12738.6	12723.5	12735.6	949.0

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

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