PREVIEW / futures_1hour / 2012-02-21

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-21.parquet
  size:    47 KB
  rows:    1,434

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-21 00:00:00	ES	Futures	1375.85	1377.62	1375.35	1377.11	4930.0
2012-02-21 01:00:00	ES	Futures	1376.86	1378.63	1376.86	1378.37	4800.0
2012-02-21 02:00:00	ES	Futures	1378.12	1378.37	1374.59	1377.37	12265.0
2012-02-21 03:00:00	ES	Futures	1377.11	1377.37	1373.33	1375.85	27700.0
2012-02-21 04:00:00	ES	Futures	1375.85	1377.87	1373.59	1374.34	29431.0
2012-02-21 05:00:00	ES	Futures	1374.34	1375.1	1372.58	1373.08	29510.0
2012-02-21 06:00:00	ES	Futures	1373.08	1373.59	1371.32	1372.33	27757.0
2012-02-21 07:00:00	ES	Futures	1372.33	1374.34	1371.57	1372.58	30447.0
2012-02-21 08:00:00	ES	Futures	1372.58	1374.09	1371.07	1374.09	34699.0
2012-02-21 09:00:00	ES	Futures	1374.09	1374.85	1369.3	1370.31	179536.0
2012-02-21 10:00:00	ES	Futures	1370.31	1375.6	1369.55	1375.35	227185.0
2012-02-21 11:00:00	ES	Futures	1375.35	1375.85	1373.84	1374.34	111153.0
2012-02-21 12:00:00	ES	Futures	1374.34	1376.61	1374.09	1374.34	123683.0
2012-02-21 13:00:00	ES	Futures	1374.34	1375.35	1372.58	1373.08	75038.0
2012-02-21 14:00:00	ES	Futures	1373.08	1373.59	1366.53	1367.79	154305.0
2012-02-21 15:00:00	ES	Futures	1367.79	1370.81	1366.53	1370.81	186966.0
2012-02-21 16:00:00	ES	Futures	1370.56	1371.82	1369.81	1371.57	76640.0
2012-02-21 17:00:00	ES	Futures	1371.32	1371.57	1370.81	1371.57	1039.0
2012-02-21 18:00:00	ES	Futures	1371.57	1371.57	1370.31	1370.56	2522.0
2012-02-21 19:00:00	ES	Futures	1370.56	1370.81	1369.81	1370.06	4195.0
2012-02-21 20:00:00	ES	Futures	1370.06	1370.31	1369.05	1369.55	5382.0
2012-02-21 21:00:00	ES	Futures	1369.55	1370.56	1369.3	1369.55	4256.0
2012-02-21 22:00:00	ES	Futures	1369.55	1373.08	1369.3	1372.58	6175.0
2012-02-21 23:00:00	ES	Futures	1372.58	1373.08	1372.07	1372.33	2748.0
2012-02-21 00:00:00	NQ	Futures	2990.22	2993.39	2989.35	2992.53	450.0
2012-02-21 01:00:00	NQ	Futures	2992.82	2995.71	2992.53	2994.26	386.0
2012-02-21 02:00:00	NQ	Futures	2994.55	2995.13	2987.91	2993.68	758.0
2012-02-21 03:00:00	NQ	Futures	2993.39	2993.68	2985.89	2992.82	1481.0
2012-02-21 04:00:00	NQ	Futures	2991.95	2995.42	2987.62	2989.06	1448.0
2012-02-21 05:00:00	NQ	Futures	2988.49	2989.64	2983.29	2984.44	2043.0
2012-02-21 06:00:00	NQ	Futures	2983.58	2984.73	2981.55	2982.42	2300.0
2012-02-21 07:00:00	NQ	Futures	2982.42	2987.62	2982.13	2984.73	2990.0
2012-02-21 08:00:00	NQ	Futures	2984.73	2987.91	2980.69	2987.91	3869.0
2012-02-21 09:00:00	NQ	Futures	2988.2	2996.28	2983.58	2987.04	27393.0
2012-02-21 10:00:00	NQ	Futures	2987.04	3002.35	2987.04	3002.06	23117.0
2012-02-21 11:00:00	NQ	Futures	3002.35	3002.64	2999.75	3001.48	10600.0
2012-02-21 12:00:00	NQ	Futures	3001.48	3005.52	2992.82	2993.39	21253.0
2012-02-21 13:00:00	NQ	Futures	2993.39	2995.99	2986.75	2987.91	12667.0
2012-02-21 14:00:00	NQ	Futures	2987.91	2988.77	2973.76	2977.51	20746.0
2012-02-21 15:00:00	NQ	Futures	2977.51	2992.82	2976.07	2992.82	29533.0
2012-02-21 16:00:00	NQ	Futures	2992.82	2994.55	2991.08	2993.39	6776.0
2012-02-21 17:00:00	NQ	Futures	2993.39	2993.39	2992.82	2993.11	156.0
2012-02-21 18:00:00	NQ	Futures	2993.39	2994.26	2992.53	2993.39	233.0
2012-02-21 19:00:00	NQ	Futures	2993.39	2993.39	2992.53	2992.53	435.0
2012-02-21 20:00:00	NQ	Futures	2992.82	2992.82	2989.93	2991.37	533.0
2012-02-21 21:00:00	NQ	Futures	2991.37	2993.68	2990.8	2991.37	361.0
2012-02-21 22:00:00	NQ	Futures	2991.66	2997.73	2991.66	2997.15	532.0
2012-02-21 23:00:00	NQ	Futures	2997.15	2999.46	2996.28	2998.3	588.0
2012-02-21 00:00:00	YM	Futures	12870.9	12885.8	12867.9	12880.8	345.0
2012-02-21 01:00:00	YM	Futures	12881.8	12891.7	12878.8	12888.7	270.0

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

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