PREVIEW / futures_1hour / 2013-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-20.parquet
  size:    51 KB
  rows:    1,547

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
2013-02-20 00:00:00	ES	Futures	1569.31	1569.57	1568.8	1568.8	3027.0
2013-02-20 01:00:00	ES	Futures	1568.8	1569.05	1567.77	1568.03	5642.0
2013-02-20 02:00:00	ES	Futures	1568.03	1568.54	1567.51	1567.77	7195.0
2013-02-20 03:00:00	ES	Futures	1567.77	1570.34	1567.51	1570.34	27301.0
2013-02-20 04:00:00	ES	Futures	1570.34	1570.34	1569.31	1569.57	18082.0
2013-02-20 05:00:00	ES	Futures	1569.82	1569.82	1568.54	1568.8	22319.0
2013-02-20 06:00:00	ES	Futures	1568.8	1569.05	1567.77	1568.28	16424.0
2013-02-20 07:00:00	ES	Futures	1568.03	1568.54	1566.75	1568.03	27567.0
2013-02-20 08:00:00	ES	Futures	1567.77	1568.8	1566.23	1568.54	41022.0
2013-02-20 09:00:00	ES	Futures	1568.54	1569.31	1564.95	1565.21	192394.0
2013-02-20 10:00:00	ES	Futures	1565.21	1567.77	1564.44	1564.44	198988.0
2013-02-20 11:00:00	ES	Futures	1564.44	1564.69	1559.82	1561.36	263751.0
2013-02-20 12:00:00	ES	Futures	1561.1	1563.67	1560.84	1562.9	127278.0
2013-02-20 13:00:00	ES	Futures	1562.64	1563.15	1560.59	1561.1	84340.0
2013-02-20 14:00:00	ES	Futures	1561.36	1563.41	1554.43	1555.2	365839.0
2013-02-20 15:00:00	ES	Futures	1555.46	1555.46	1548.53	1548.78	444426.0
2013-02-20 16:00:00	ES	Futures	1548.78	1549.3	1546.22	1547.76	140371.0
2013-02-20 17:00:00	ES	Futures	1547.5	1548.01	1546.73	1546.73	3286.0
2013-02-20 18:00:00	ES	Futures	1547.5	1548.53	1546.99	1548.27	9386.0
2013-02-20 19:00:00	ES	Futures	1548.27	1549.04	1548.01	1548.78	6952.0
2013-02-20 20:00:00	ES	Futures	1549.04	1549.55	1547.76	1548.01	7597.0
2013-02-20 21:00:00	ES	Futures	1548.01	1548.01	1546.99	1547.76	5461.0
2013-02-20 22:00:00	ES	Futures	1547.76	1548.01	1545.19	1545.45	10679.0
2013-02-20 23:00:00	ES	Futures	1545.45	1546.22	1545.19	1545.19	9059.0
2013-02-20 00:00:00	NQ	Futures	3244.26	3244.26	3242.51	3242.51	131.0
2013-02-20 01:00:00	NQ	Futures	3242.51	3242.8	3240.18	3240.18	406.0
2013-02-20 02:00:00	NQ	Futures	3240.18	3241.64	3239.89	3240.47	278.0
2013-02-20 03:00:00	NQ	Futures	3240.47	3243.38	3239.31	3243.09	1613.0
2013-02-20 04:00:00	NQ	Futures	3242.8	3244.26	3241.05	3242.51	1707.0
2013-02-20 05:00:00	NQ	Futures	3242.8	3243.67	3240.47	3242.51	1481.0
2013-02-20 06:00:00	NQ	Futures	3242.51	3242.51	3237.27	3237.85	2829.0
2013-02-20 07:00:00	NQ	Futures	3237.85	3238.43	3232.61	3237.27	5623.0
2013-02-20 08:00:00	NQ	Futures	3236.98	3238.73	3234.94	3238.14	5282.0
2013-02-20 09:00:00	NQ	Futures	3238.14	3240.47	3229.99	3230.28	22045.0
2013-02-20 10:00:00	NQ	Futures	3230.28	3236.11	3228.83	3228.83	21681.0
2013-02-20 11:00:00	NQ	Futures	3228.54	3229.12	3210.78	3216.6	41238.0
2013-02-20 12:00:00	NQ	Futures	3216.6	3221.55	3214.86	3218.35	13256.0
2013-02-20 13:00:00	NQ	Futures	3218.06	3218.35	3212.53	3215.15	11491.0
2013-02-20 14:00:00	NQ	Futures	3215.15	3220.97	3198.56	3202.05	43887.0
2013-02-20 15:00:00	NQ	Futures	3202.05	3202.34	3188.95	3189.83	43410.0
2013-02-20 16:00:00	NQ	Futures	3189.83	3190.12	3172.65	3185.46	11810.0
2013-02-20 17:00:00	NQ	Futures	3185.46	3186.92	3185.17	3185.46	305.0
2013-02-20 18:00:00	NQ	Futures	3185.46	3188.08	3185.46	3187.79	565.0
2013-02-20 19:00:00	NQ	Futures	3187.79	3190.7	3187.5	3190.7	665.0
2013-02-20 20:00:00	NQ	Futures	3190.7	3191.28	3187.79	3187.79	404.0
2013-02-20 21:00:00	NQ	Futures	3187.79	3188.37	3186.33	3187.79	447.0
2013-02-20 22:00:00	NQ	Futures	3188.08	3188.37	3183.13	3183.13	640.0
2013-02-20 23:00:00	NQ	Futures	3183.13	3185.75	3183.13	3183.71	846.0
2013-02-20 00:00:00	YM	Futures	14099.4	14099.4	14091.4	14091.4	211.0
2013-02-20 01:00:00	YM	Futures	14093.4	14094.4	14086.4	14087.4	237.0

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

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