PREVIEW / futures_1hour / 2012-02-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-29.parquet
  size:    49 KB
  rows:    1,489

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-02-29 00:00:00	ES	Futures	1383.92	1384.17	1381.4	1381.65	6578.0
2012-02-29 01:00:00	ES	Futures	1381.65	1383.41	1381.4	1383.16	6298.0
2012-02-29 02:00:00	ES	Futures	1383.16	1384.17	1382.41	1383.67	8333.0
2012-02-29 03:00:00	ES	Futures	1383.41	1385.43	1382.66	1383.67	30010.0
2012-02-29 04:00:00	ES	Futures	1383.67	1384.93	1382.66	1384.67	18871.0
2012-02-29 05:00:00	ES	Futures	1384.67	1387.7	1382.15	1385.18	94066.0
2012-02-29 06:00:00	ES	Futures	1384.93	1385.43	1382.15	1384.42	35385.0
2012-02-29 07:00:00	ES	Futures	1384.17	1385.68	1383.16	1383.16	31744.0
2012-02-29 08:00:00	ES	Futures	1383.41	1386.44	1382.66	1382.91	50579.0
2012-02-29 09:00:00	ES	Futures	1382.91	1387.45	1382.91	1387.19	182918.0
2012-02-29 10:00:00	ES	Futures	1387.19	1388.2	1374.59	1378.37	509303.0
2012-02-29 11:00:00	ES	Futures	1378.63	1379.63	1373.84	1378.63	344593.0
2012-02-29 12:00:00	ES	Futures	1378.88	1381.4	1377.62	1379.89	160221.0
2012-02-29 13:00:00	ES	Futures	1380.14	1382.15	1378.37	1381.4	105105.0
2012-02-29 14:00:00	ES	Futures	1381.4	1382.91	1378.63	1378.88	113081.0
2012-02-29 15:00:00	ES	Futures	1379.13	1379.13	1373.08	1374.85	368493.0
2012-02-29 16:00:00	ES	Futures	1374.85	1375.1	1367.54	1371.07	188008.0
2012-02-29 17:00:00	ES	Futures	1371.32	1372.07	1369.55	1370.06	5865.0
2012-02-29 18:00:00	ES	Futures	1370.56	1373.08	1370.56	1372.83	10062.0
2012-02-29 19:00:00	ES	Futures	1372.83	1374.59	1369.81	1374.59	15446.0
2012-02-29 20:00:00	ES	Futures	1374.34	1375.1	1373.59	1374.09	8048.0
2012-02-29 21:00:00	ES	Futures	1374.09	1374.34	1372.07	1372.33	3120.0
2012-02-29 22:00:00	ES	Futures	1372.33	1374.34	1371.82	1372.58	4859.0
2012-02-29 23:00:00	ES	Futures	1372.83	1374.09	1372.33	1373.84	2721.0
2012-02-29 00:00:00	NQ	Futures	3044.22	3044.22	3039.03	3039.31	331.0
2012-02-29 01:00:00	NQ	Futures	3039.31	3042.49	3039.03	3042.49	222.0
2012-02-29 02:00:00	NQ	Futures	3042.78	3044.22	3041.05	3043.07	663.0
2012-02-29 03:00:00	NQ	Futures	3043.07	3046.82	3041.62	3043.36	2591.0
2012-02-29 04:00:00	NQ	Futures	3043.65	3045.67	3041.91	3045.38	1316.0
2012-02-29 05:00:00	NQ	Futures	3045.67	3051.15	3040.47	3045.09	4765.0
2012-02-29 06:00:00	NQ	Futures	3045.09	3045.67	3040.76	3044.8	2410.0
2012-02-29 07:00:00	NQ	Futures	3044.8	3047.4	3043.07	3043.07	2963.0
2012-02-29 08:00:00	NQ	Futures	3042.78	3049.42	3041.91	3043.36	4776.0
2012-02-29 09:00:00	NQ	Futures	3043.07	3055.2	3042.78	3054.33	36536.0
2012-02-29 10:00:00	NQ	Futures	3054.04	3055.78	3031.23	3039.89	58669.0
2012-02-29 11:00:00	NQ	Futures	3040.18	3043.07	3029.21	3039.89	32383.0
2012-02-29 12:00:00	NQ	Futures	3039.89	3044.22	3035.56	3039.89	17329.0
2012-02-29 13:00:00	NQ	Futures	3040.18	3043.36	3034.69	3042.2	15526.0
2012-02-29 14:00:00	NQ	Futures	3042.2	3045.96	3034.4	3036.14	15791.0
2012-02-29 15:00:00	NQ	Futures	3035.56	3037.87	3019.96	3030.07	44102.0
2012-02-29 16:00:00	NQ	Futures	3030.36	3032.38	3024.3	3026.61	16642.0
2012-02-29 17:00:00	NQ	Futures	3026.61	3028.63	3023.14	3024.01	635.0
2012-02-29 18:00:00	NQ	Futures	3024.87	3030.65	3024.87	3029.49	1055.0
2012-02-29 19:00:00	NQ	Futures	3029.78	3032.96	3026.32	3032.96	1057.0
2012-02-29 20:00:00	NQ	Futures	3033.25	3034.69	3031.23	3032.67	666.0
2012-02-29 21:00:00	NQ	Futures	3032.67	3032.96	3028.05	3028.34	460.0
2012-02-29 22:00:00	NQ	Futures	3028.63	3032.09	3027.76	3028.92	518.0
2012-02-29 23:00:00	NQ	Futures	3029.21	3032.09	3028.63	3032.09	182.0
2012-02-29 00:00:00	YM	Futures	12894.7	12894.7	12871.9	12872.9	353.0
2012-02-29 01:00:00	YM	Futures	12872.9	12886.7	12869.9	12885.8	429.0

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

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