PREVIEW / futures_1hour / 2012-03-08

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-08.parquet
  size:    49 KB
  rows:    1,458

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-03-08 00:00:00	ES	Futures	1365.77	1365.77	1364.77	1365.02	2644.0
2012-03-08 01:00:00	ES	Futures	1365.27	1365.52	1364.26	1364.77	2904.0
2012-03-08 02:00:00	ES	Futures	1364.77	1367.29	1364.52	1366.78	14454.0
2012-03-08 03:00:00	ES	Futures	1366.78	1368.55	1366.28	1368.55	29601.0
2012-03-08 04:00:00	ES	Futures	1368.55	1374.09	1367.79	1372.58	63576.0
2012-03-08 05:00:00	ES	Futures	1372.58	1375.35	1372.33	1374.59	31341.0
2012-03-08 06:00:00	ES	Futures	1374.34	1376.61	1374.34	1375.85	30277.0
2012-03-08 07:00:00	ES	Futures	1375.85	1376.61	1373.84	1374.59	43122.0
2012-03-08 08:00:00	ES	Futures	1374.59	1375.35	1371.82	1372.07	59916.0
2012-03-08 09:00:00	ES	Futures	1372.07	1373.59	1370.06	1371.07	185358.0
2012-03-08 10:00:00	ES	Futures	1370.81	1371.82	1368.29	1371.82	188889.0
2012-03-08 11:00:00	ES	Futures	1371.82	1374.09	1371.32	1373.84	163894.0
2012-03-08 12:00:00	ES	Futures	1373.84	1376.36	1373.59	1375.85	99982.0
2012-03-08 13:00:00	ES	Futures	1375.85	1376.11	1374.34	1374.85	52577.0
2012-03-08 14:00:00	ES	Futures	1374.85	1378.63	1373.84	1378.12	103606.0
2012-03-08 15:00:00	ES	Futures	1378.12	1379.38	1375.85	1376.36	138314.0
2012-03-08 16:00:00	ES	Futures	1376.36	1377.87	1375.6	1376.36	67721.0
2012-03-08 17:00:00	ES	Futures	1376.36	1377.11	1376.11	1377.11	1069.0
2012-03-08 18:00:00	ES	Futures	1376.11	1377.11	1376.11	1376.61	2992.0
2012-03-08 19:00:00	ES	Futures	1376.61	1376.86	1374.59	1375.35	5468.0
2012-03-08 20:00:00	ES	Futures	1375.1	1376.11	1374.59	1375.1	3447.0
2012-03-08 21:00:00	ES	Futures	1375.35	1376.86	1375.35	1376.61	2337.0
2012-03-08 22:00:00	ES	Futures	1376.86	1377.11	1376.61	1376.86	1624.0
2012-03-08 23:00:00	ES	Futures	1377.11	1378.37	1376.86	1378.12	2482.0
2012-03-08 00:00:00	NQ	Futures	3016.79	3017.37	3014.19	3015.63	173.0
2012-03-08 01:00:00	NQ	Futures	3015.34	3016.5	3013.61	3013.9	225.0
2012-03-08 02:00:00	NQ	Futures	3013.9	3019.1	3013.61	3018.23	1497.0
2012-03-08 03:00:00	NQ	Futures	3018.23	3021.99	3017.08	3021.99	1982.0
2012-03-08 04:00:00	NQ	Futures	3021.99	3035.56	3020.54	3033.25	4198.0
2012-03-08 05:00:00	NQ	Futures	3033.25	3037.58	3031.81	3035.85	1507.0
2012-03-08 06:00:00	NQ	Futures	3036.14	3041.62	3035.56	3037.29	2023.0
2012-03-08 07:00:00	NQ	Futures	3037.29	3038.16	3032.38	3033.54	5010.0
2012-03-08 08:00:00	NQ	Futures	3033.25	3036.14	3030.36	3030.94	4934.0
2012-03-08 09:00:00	NQ	Futures	3030.94	3034.98	3027.18	3031.52	28547.0
2012-03-08 10:00:00	NQ	Futures	3031.52	3034.98	3024.59	3034.4	23172.0
2012-03-08 11:00:00	NQ	Futures	3034.4	3041.34	3033.83	3040.18	19831.0
2012-03-08 12:00:00	NQ	Futures	3040.47	3047.11	3039.31	3045.38	14513.0
2012-03-08 13:00:00	NQ	Futures	3045.38	3047.98	3043.36	3045.67	9197.0
2012-03-08 14:00:00	NQ	Futures	3045.38	3050.87	3041.62	3049.71	14714.0
2012-03-08 15:00:00	NQ	Futures	3049.71	3054.62	3045.09	3045.67	23311.0
2012-03-08 16:00:00	NQ	Futures	3045.38	3049.13	3044.51	3045.09	4675.0
2012-03-08 17:00:00	NQ	Futures	3044.8	3045.67	3044.22	3045.67	138.0
2012-03-08 18:00:00	NQ	Futures	3045.38	3045.96	3044.51	3045.09	198.0
2012-03-08 19:00:00	NQ	Futures	3045.38	3045.38	3039.89	3040.76	699.0
2012-03-08 20:00:00	NQ	Futures	3040.47	3042.2	3039.89	3040.47	343.0
2012-03-08 21:00:00	NQ	Futures	3041.05	3044.51	3041.05	3044.51	163.0
2012-03-08 22:00:00	NQ	Futures	3044.8	3045.96	3044.8	3045.38	142.0
2012-03-08 23:00:00	NQ	Futures	3045.67	3048.27	3045.67	3047.4	235.0
2012-03-08 00:00:00	YM	Futures	12745.0	12748.0	12739.1	12742.0	309.0
2012-03-08 01:00:00	YM	Futures	12742.0	12743.0	12733.1	12735.1	285.0

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

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