PREVIEW / futures_1hour / 2012-05-11

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-11.parquet
  size:    40 KB
  rows:    1,197

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-05-11 00:00:00	ES	Futures	1363.59	1364.6	1362.57	1364.6	3151.0
2012-05-11 01:00:00	ES	Futures	1364.6	1366.37	1362.83	1363.84	9736.0
2012-05-11 02:00:00	ES	Futures	1363.59	1366.12	1361.31	1366.12	15262.0
2012-05-11 03:00:00	ES	Futures	1366.12	1366.62	1362.32	1364.85	36181.0
2012-05-11 04:00:00	ES	Futures	1364.85	1369.91	1363.84	1367.89	33349.0
2012-05-11 05:00:00	ES	Futures	1367.89	1368.65	1364.85	1366.12	22887.0
2012-05-11 06:00:00	ES	Futures	1365.86	1368.9	1365.36	1365.36	24337.0
2012-05-11 07:00:00	ES	Futures	1365.61	1368.39	1364.09	1367.38	40615.0
2012-05-11 08:00:00	ES	Futures	1367.38	1367.63	1362.07	1363.59	80454.0
2012-05-11 09:00:00	ES	Futures	1363.33	1369.66	1361.56	1367.38	246651.0
2012-05-11 10:00:00	ES	Futures	1367.38	1378.01	1367.38	1375.48	393334.0
2012-05-11 11:00:00	ES	Futures	1375.22	1379.52	1373.96	1376.49	195226.0
2012-05-11 12:00:00	ES	Futures	1376.49	1376.99	1373.96	1374.72	82103.0
2012-05-11 13:00:00	ES	Futures	1374.72	1374.72	1371.43	1372.44	114709.0
2012-05-11 14:00:00	ES	Futures	1372.69	1373.2	1369.4	1370.16	101139.0
2012-05-11 15:00:00	ES	Futures	1370.42	1371.18	1365.61	1366.12	225975.0
2012-05-11 16:00:00	ES	Futures	1366.37	1366.87	1365.1	1366.12	86618.0
2012-05-11 00:00:00	NQ	Futures	3012.6	3014.92	3011.45	3014.63	210.0
2012-05-11 01:00:00	NQ	Futures	3015.2	3018.1	3012.89	3014.92	742.0
2012-05-11 02:00:00	NQ	Futures	3014.92	3018.96	3010.0	3018.39	1665.0
2012-05-11 03:00:00	NQ	Futures	3018.39	3021.28	3013.18	3017.81	3426.0
2012-05-11 04:00:00	NQ	Futures	3017.23	3027.64	3015.49	3023.3	2827.0
2012-05-11 05:00:00	NQ	Futures	3023.3	3025.91	3017.52	3020.7	1839.0
2012-05-11 06:00:00	NQ	Futures	3020.12	3026.19	3016.94	3018.68	2605.0
2012-05-11 07:00:00	NQ	Futures	3018.39	3025.62	3016.65	3023.3	3372.0
2012-05-11 08:00:00	NQ	Futures	3023.01	3023.88	3007.4	3010.29	9537.0
2012-05-11 09:00:00	NQ	Futures	3010.29	3033.71	3004.79	3029.38	41833.0
2012-05-11 10:00:00	NQ	Futures	3029.66	3054.25	3029.09	3047.88	72975.0
2012-05-11 11:00:00	NQ	Futures	3047.6	3053.67	3043.84	3046.73	24331.0
2012-05-11 12:00:00	NQ	Futures	3046.73	3047.31	3039.21	3041.52	14437.0
2012-05-11 13:00:00	NQ	Futures	3041.52	3044.7	3036.32	3041.81	18873.0
2012-05-11 14:00:00	NQ	Futures	3041.81	3042.68	3032.56	3034.29	17102.0
2012-05-11 15:00:00	NQ	Futures	3034.29	3036.61	3020.12	3020.7	35974.0
2012-05-11 16:00:00	NQ	Futures	3020.41	3023.88	3018.39	3022.15	6725.0
2012-05-11 00:00:00	YM	Futures	12707.8	12713.8	12700.8	12713.8	194.0
2012-05-11 01:00:00	YM	Futures	12713.8	12724.7	12697.8	12707.8	657.0
2012-05-11 02:00:00	YM	Futures	12707.8	12721.7	12689.9	12720.8	1207.0
2012-05-11 03:00:00	YM	Futures	12720.8	12726.7	12692.9	12712.8	3275.0
2012-05-11 04:00:00	YM	Futures	12710.8	12752.6	12705.8	12734.7	2359.0
2012-05-11 05:00:00	YM	Futures	12734.7	12740.7	12712.8	12721.7	1799.0
2012-05-11 06:00:00	YM	Futures	12721.7	12743.7	12714.8	12716.8	1670.0
2012-05-11 07:00:00	YM	Futures	12714.8	12736.7	12705.8	12730.7	2583.0
2012-05-11 08:00:00	YM	Futures	12730.7	12732.7	12690.9	12702.8	4561.0
2012-05-11 09:00:00	YM	Futures	12702.8	12744.7	12690.9	12731.7	18514.0
2012-05-11 10:00:00	YM	Futures	12731.7	12819.4	12730.7	12802.4	29230.0
2012-05-11 11:00:00	YM	Futures	12802.4	12835.3	12792.5	12813.4	15692.0
2012-05-11 12:00:00	YM	Futures	12813.4	12818.4	12791.5	12796.5	6656.0
2012-05-11 13:00:00	YM	Futures	12796.5	12796.5	12766.6	12772.6	9701.0
2012-05-11 14:00:00	YM	Futures	12773.6	12780.5	12750.6	12756.6	9174.0
2012-05-11 15:00:00	YM	Futures	12757.6	12764.6	12726.7	12734.7	13186.0

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

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