PREVIEW / futures_1hour / 2012-02-23

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-23.parquet
  size:    48 KB
  rows:    1,486

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-23 00:00:00	ES	Futures	1365.77	1366.78	1365.52	1365.77	2845.0
2012-02-23 01:00:00	ES	Futures	1366.03	1367.29	1365.77	1367.29	1904.0
2012-02-23 02:00:00	ES	Futures	1367.03	1368.04	1366.28	1366.53	6982.0
2012-02-23 03:00:00	ES	Futures	1366.53	1371.57	1366.03	1371.32	39492.0
2012-02-23 04:00:00	ES	Futures	1371.32	1373.08	1369.55	1370.31	42840.0
2012-02-23 05:00:00	ES	Futures	1370.06	1371.07	1366.03	1367.29	42653.0
2012-02-23 06:00:00	ES	Futures	1367.03	1368.55	1366.53	1366.78	17469.0
2012-02-23 07:00:00	ES	Futures	1367.03	1368.04	1365.77	1366.78	25398.0
2012-02-23 08:00:00	ES	Futures	1367.03	1369.55	1366.53	1368.55	46887.0
2012-02-23 09:00:00	ES	Futures	1368.55	1368.8	1360.99	1362.5	222616.0
2012-02-23 10:00:00	ES	Futures	1362.5	1369.81	1362.25	1369.3	288947.0
2012-02-23 11:00:00	ES	Futures	1369.55	1371.32	1368.55	1369.81	227392.0
2012-02-23 12:00:00	ES	Futures	1369.81	1371.57	1369.05	1370.06	107035.0
2012-02-23 13:00:00	ES	Futures	1370.06	1370.31	1368.04	1370.06	108397.0
2012-02-23 14:00:00	ES	Futures	1370.06	1371.32	1368.8	1370.31	86702.0
2012-02-23 15:00:00	ES	Futures	1370.31	1373.59	1369.81	1372.58	194522.0
2012-02-23 16:00:00	ES	Futures	1372.58	1374.59	1372.07	1373.84	103905.0
2012-02-23 17:00:00	ES	Futures	1373.84	1375.35	1373.84	1374.85	3315.0
2012-02-23 18:00:00	ES	Futures	1375.1	1376.61	1374.85	1375.85	7558.0
2012-02-23 19:00:00	ES	Futures	1375.85	1376.61	1375.35	1376.61	4478.0
2012-02-23 20:00:00	ES	Futures	1376.36	1377.87	1376.11	1376.61	8336.0
2012-02-23 21:00:00	ES	Futures	1376.61	1377.37	1376.11	1376.11	2419.0
2012-02-23 22:00:00	ES	Futures	1376.36	1377.62	1376.11	1377.37	2987.0
2012-02-23 23:00:00	ES	Futures	1377.37	1377.37	1376.36	1376.36	1800.0
2012-02-23 00:00:00	NQ	Futures	2980.4	2981.55	2979.82	2980.69	112.0
2012-02-23 01:00:00	NQ	Futures	2980.4	2983.0	2980.11	2982.71	100.0
2012-02-23 02:00:00	NQ	Futures	2983.0	2985.02	2982.13	2982.71	602.0
2012-02-23 03:00:00	NQ	Futures	2982.71	2993.39	2981.84	2992.24	2523.0
2012-02-23 04:00:00	NQ	Futures	2992.24	2995.42	2989.64	2990.8	2972.0
2012-02-23 05:00:00	NQ	Futures	2990.51	2991.66	2982.42	2984.73	1927.0
2012-02-23 06:00:00	NQ	Futures	2984.73	2987.62	2983.58	2984.15	974.0
2012-02-23 07:00:00	NQ	Futures	2983.86	2985.02	2981.27	2983.29	2244.0
2012-02-23 08:00:00	NQ	Futures	2983.29	2989.35	2982.42	2987.33	3500.0
2012-02-23 09:00:00	NQ	Futures	2987.33	2987.62	2967.98	2976.36	33575.0
2012-02-23 10:00:00	NQ	Futures	2976.07	2995.13	2975.78	2994.26	42086.0
2012-02-23 11:00:00	NQ	Futures	2994.55	3001.77	2992.82	2996.57	31966.0
2012-02-23 12:00:00	NQ	Futures	2996.57	2998.88	2988.49	2990.8	23685.0
2012-02-23 13:00:00	NQ	Futures	2990.8	2993.39	2982.13	2988.77	27382.0
2012-02-23 14:00:00	NQ	Futures	2988.77	2995.13	2984.73	2990.8	16468.0
2012-02-23 15:00:00	NQ	Futures	2991.08	3002.06	2988.77	2998.02	25617.0
2012-02-23 16:00:00	NQ	Futures	2998.59	3005.81	2998.02	3004.66	12990.0
2012-02-23 17:00:00	NQ	Futures	3004.66	3008.41	3004.66	3006.97	580.0
2012-02-23 18:00:00	NQ	Futures	3006.68	3009.28	3006.39	3008.41	571.0
2012-02-23 19:00:00	NQ	Futures	3008.7	3009.57	3007.55	3009.57	364.0
2012-02-23 20:00:00	NQ	Futures	3008.99	3012.46	3008.99	3009.57	705.0
2012-02-23 21:00:00	NQ	Futures	3009.86	3011.59	3009.57	3009.86	250.0
2012-02-23 22:00:00	NQ	Futures	3010.15	3011.59	3009.57	3011.3	145.0
2012-02-23 23:00:00	NQ	Futures	3011.3	3011.3	3009.86	3010.72	151.0
2012-02-23 00:00:00	YM	Futures	12800.5	12806.5	12796.5	12801.5	106.0
2012-02-23 01:00:00	YM	Futures	12801.5	12812.4	12800.5	12812.4	157.0

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

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