PREVIEW / futures_1hour / 2013-02-06

all futures 1-hour files

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

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-06 00:00:00	ES	Futures	1547.24	1547.76	1546.99	1547.5	6867.0
2013-02-06 01:00:00	ES	Futures	1547.5	1548.78	1547.24	1548.78	4775.0
2013-02-06 02:00:00	ES	Futures	1548.53	1549.55	1545.96	1547.24	14648.0
2013-02-06 03:00:00	ES	Futures	1547.24	1550.07	1545.45	1549.55	36050.0
2013-02-06 04:00:00	ES	Futures	1549.55	1549.81	1547.76	1548.01	21852.0
2013-02-06 05:00:00	ES	Futures	1548.01	1548.53	1545.45	1546.47	25228.0
2013-02-06 06:00:00	ES	Futures	1546.47	1547.76	1545.7	1546.73	21716.0
2013-02-06 07:00:00	ES	Futures	1546.73	1547.24	1542.88	1542.88	64023.0
2013-02-06 08:00:00	ES	Futures	1542.88	1543.14	1538.52	1539.03	114425.0
2013-02-06 09:00:00	ES	Futures	1539.29	1544.68	1538.78	1543.91	278551.0
2013-02-06 10:00:00	ES	Futures	1543.65	1545.7	1541.86	1544.93	271622.0
2013-02-06 11:00:00	ES	Futures	1544.93	1547.5	1544.68	1546.73	174987.0
2013-02-06 12:00:00	ES	Futures	1546.47	1548.53	1545.19	1545.45	116326.0
2013-02-06 13:00:00	ES	Futures	1545.45	1545.7	1541.09	1542.11	157097.0
2013-02-06 14:00:00	ES	Futures	1542.11	1545.19	1541.6	1545.19	96767.0
2013-02-06 15:00:00	ES	Futures	1544.93	1547.5	1544.42	1547.5	223157.0
2013-02-06 16:00:00	ES	Futures	1547.24	1547.5	1545.45	1547.5	76431.0
2013-02-06 17:00:00	ES	Futures	1547.5	1547.5	1545.96	1545.96	2154.0
2013-02-06 18:00:00	ES	Futures	1546.99	1546.99	1545.7	1546.22	4022.0
2013-02-06 19:00:00	ES	Futures	1545.96	1546.99	1545.7	1546.47	3809.0
2013-02-06 20:00:00	ES	Futures	1546.47	1546.99	1545.7	1545.96	3604.0
2013-02-06 21:00:00	ES	Futures	1545.96	1546.73	1544.93	1544.93	6360.0
2013-02-06 22:00:00	ES	Futures	1545.19	1545.19	1544.17	1544.42	3214.0
2013-02-06 23:00:00	ES	Futures	1544.17	1545.45	1544.17	1545.19	1533.0
2013-02-06 00:00:00	NQ	Futures	3205.54	3206.71	3205.25	3205.83	338.0
2013-02-06 01:00:00	NQ	Futures	3205.83	3207.29	3205.54	3207.29	246.0
2013-02-06 02:00:00	NQ	Futures	3207.29	3209.33	3204.09	3205.83	1445.0
2013-02-06 03:00:00	NQ	Futures	3205.54	3209.91	3202.05	3209.04	2398.0
2013-02-06 04:00:00	NQ	Futures	3209.04	3209.91	3204.38	3204.96	2290.0
2013-02-06 05:00:00	NQ	Futures	3204.96	3204.96	3197.68	3200.89	2993.0
2013-02-06 06:00:00	NQ	Futures	3200.89	3202.92	3197.98	3200.89	2349.0
2013-02-06 07:00:00	NQ	Futures	3200.89	3201.47	3191.28	3191.28	4550.0
2013-02-06 08:00:00	NQ	Futures	3191.28	3191.86	3184.59	3189.53	10238.0
2013-02-06 09:00:00	NQ	Futures	3189.83	3200.89	3187.5	3198.27	32446.0
2013-02-06 10:00:00	NQ	Futures	3197.98	3200.3	3185.17	3197.68	42787.0
2013-02-06 11:00:00	NQ	Futures	3197.68	3206.13	3197.39	3202.63	27487.0
2013-02-06 12:00:00	NQ	Futures	3202.34	3203.22	3194.48	3195.07	15670.0
2013-02-06 13:00:00	NQ	Futures	3195.07	3195.65	3181.97	3186.04	23753.0
2013-02-06 14:00:00	NQ	Futures	3186.04	3189.83	3182.84	3188.95	14370.0
2013-02-06 15:00:00	NQ	Futures	3188.95	3192.15	3184.88	3191.57	25497.0
2013-02-06 16:00:00	NQ	Futures	3191.57	3192.45	3187.21	3191.28	6313.0
2013-02-06 17:00:00	NQ	Futures	3191.28	3191.28	3189.24	3190.41	70.0
2013-02-06 18:00:00	NQ	Futures	3189.53	3190.12	3188.08	3188.08	256.0
2013-02-06 19:00:00	NQ	Futures	3188.08	3189.53	3187.21	3188.95	478.0
2013-02-06 20:00:00	NQ	Futures	3188.95	3189.24	3188.08	3188.37	268.0
2013-02-06 21:00:00	NQ	Futures	3188.08	3189.24	3187.79	3188.08	462.0
2013-02-06 22:00:00	NQ	Futures	3187.79	3187.79	3185.46	3185.46	422.0
2013-02-06 23:00:00	NQ	Futures	3185.75	3187.5	3185.46	3187.5	202.0
2013-02-06 00:00:00	YM	Futures	14021.0	14024.0	14018.0	14021.0	303.0
2013-02-06 01:00:00	YM	Futures	14020.0	14030.0	14020.0	14030.0	200.0

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

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