PREVIEW / futures_1hour / 2012-04-02

all futures 1-hour files

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

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-04-02 00:00:00	ES	Futures	1424.81	1425.06	1423.54	1423.8	1990.0
2012-04-02 01:00:00	ES	Futures	1423.8	1424.3	1423.04	1423.8	4188.0
2012-04-02 02:00:00	ES	Futures	1423.8	1424.05	1422.78	1423.8	7579.0
2012-04-02 03:00:00	ES	Futures	1424.05	1426.07	1423.04	1425.06	31348.0
2012-04-02 04:00:00	ES	Futures	1425.06	1425.57	1417.22	1419.75	53030.0
2012-04-02 05:00:00	ES	Futures	1419.75	1421.77	1418.23	1421.27	25602.0
2012-04-02 06:00:00	ES	Futures	1421.27	1421.77	1418.99	1419.24	19463.0
2012-04-02 07:00:00	ES	Futures	1418.99	1420.76	1417.47	1418.99	27334.0
2012-04-02 08:00:00	ES	Futures	1418.99	1420.76	1416.97	1420.0	47199.0
2012-04-02 09:00:00	ES	Futures	1420.0	1420.51	1415.7	1418.48	196701.0
2012-04-02 10:00:00	ES	Futures	1418.74	1425.31	1418.23	1424.81	284697.0
2012-04-02 11:00:00	ES	Futures	1424.81	1431.64	1423.54	1431.13	324355.0
2012-04-02 12:00:00	ES	Futures	1431.13	1433.92	1430.88	1432.9	191225.0
2012-04-02 13:00:00	ES	Futures	1432.9	1433.41	1432.14	1433.16	88726.0
2012-04-02 14:00:00	ES	Futures	1433.16	1434.42	1431.64	1434.17	76750.0
2012-04-02 15:00:00	ES	Futures	1434.42	1434.67	1429.11	1430.12	200926.0
2012-04-02 16:00:00	ES	Futures	1430.37	1430.37	1427.59	1428.1	93681.0
2012-04-02 17:00:00	ES	Futures	1428.35	1428.6	1427.84	1427.84	1601.0
2012-04-02 18:00:00	ES	Futures	1428.1	1429.36	1427.84	1428.6	3003.0
2012-04-02 19:00:00	ES	Futures	1428.6	1429.36	1428.35	1429.11	1197.0
2012-04-02 20:00:00	ES	Futures	1428.86	1429.61	1427.84	1429.61	6009.0
2012-04-02 21:00:00	ES	Futures	1429.36	1430.37	1427.84	1428.1	4997.0
2012-04-02 22:00:00	ES	Futures	1428.35	1428.86	1428.1	1428.86	2057.0
2012-04-02 23:00:00	ES	Futures	1428.86	1429.36	1428.35	1429.11	2488.0
2012-04-02 00:00:00	NQ	Futures	3194.51	3195.67	3193.06	3193.64	174.0
2012-04-02 01:00:00	NQ	Futures	3193.35	3194.51	3191.91	3193.35	281.0
2012-04-02 02:00:00	NQ	Futures	3193.35	3194.22	3191.62	3193.64	911.0
2012-04-02 03:00:00	NQ	Futures	3193.64	3198.27	3191.04	3195.09	3629.0
2012-04-02 04:00:00	NQ	Futures	3195.09	3196.24	3178.02	3180.92	5959.0
2012-04-02 05:00:00	NQ	Futures	3180.92	3185.54	3176.87	3184.68	2812.0
2012-04-02 06:00:00	NQ	Futures	3184.39	3186.41	3180.34	3180.34	2519.0
2012-04-02 07:00:00	NQ	Futures	3180.05	3184.1	3175.42	3178.6	2748.0
2012-04-02 08:00:00	NQ	Futures	3178.6	3183.81	3174.27	3182.07	4963.0
2012-04-02 09:00:00	NQ	Futures	3182.07	3185.83	3173.69	3178.31	32567.0
2012-04-02 10:00:00	NQ	Futures	3177.74	3197.69	3177.45	3197.4	43711.0
2012-04-02 11:00:00	NQ	Futures	3197.11	3213.02	3194.51	3210.99	37706.0
2012-04-02 12:00:00	NQ	Futures	3211.28	3218.51	3211.28	3215.04	18609.0
2012-04-02 13:00:00	NQ	Futures	3215.04	3218.22	3213.31	3218.22	8932.0
2012-04-02 14:00:00	NQ	Futures	3218.22	3220.25	3214.75	3218.51	10516.0
2012-04-02 15:00:00	NQ	Futures	3218.8	3219.96	3212.44	3215.62	23766.0
2012-04-02 16:00:00	NQ	Futures	3215.62	3216.2	3208.68	3211.28	6954.0
2012-04-02 17:00:00	NQ	Futures	3211.28	3212.44	3211.28	3211.86	138.0
2012-04-02 18:00:00	NQ	Futures	3211.57	3214.75	3211.28	3213.89	192.0
2012-04-02 19:00:00	NQ	Futures	3213.89	3214.17	3213.02	3213.6	125.0
2012-04-02 20:00:00	NQ	Futures	3213.89	3214.46	3211.57	3214.46	266.0
2012-04-02 21:00:00	NQ	Futures	3214.46	3216.2	3211.57	3211.86	330.0
2012-04-02 22:00:00	NQ	Futures	3212.15	3213.31	3211.86	3212.44	167.0
2012-04-02 23:00:00	NQ	Futures	3212.73	3213.6	3211.57	3212.44	213.0
2012-04-02 00:00:00	YM	Futures	13128.2	13132.2	13120.3	13121.3	224.0
2012-04-02 01:00:00	YM	Futures	13121.3	13125.3	13115.3	13121.3	271.0

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

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