PREVIEW / futures_1hour / 2014-06-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-02.parquet
  size:    46 KB
  rows:    1,495

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
2014-06-02 00:00:00	ES	Futures	1997.91	1997.91	1997.39	1997.39	579.0
2014-06-02 01:00:00	ES	Futures	1997.39	1997.65	1997.13	1997.65	1176.0
2014-06-02 02:00:00	ES	Futures	1997.65	1997.91	1996.87	1997.13	4645.0
2014-06-02 03:00:00	ES	Futures	1997.39	1997.91	1995.83	1997.13	18168.0
2014-06-02 04:00:00	ES	Futures	1997.13	1997.65	1996.09	1996.61	9870.0
2014-06-02 05:00:00	ES	Futures	1996.61	1997.39	1996.61	1997.13	4153.0
2014-06-02 06:00:00	ES	Futures	1996.87	1998.69	1996.87	1996.87	9616.0
2014-06-02 07:00:00	ES	Futures	1997.13	1997.39	1996.09	1996.61	8254.0
2014-06-02 08:00:00	ES	Futures	1996.61	1997.65	1996.35	1996.61	11105.0
2014-06-02 09:00:00	ES	Futures	1996.87	1998.43	1992.98	1993.76	134026.0
2014-06-02 10:00:00	ES	Futures	1993.76	1993.76	1987.78	1991.94	259939.0
2014-06-02 11:00:00	ES	Futures	1991.94	1997.91	1991.16	1997.13	184575.0
2014-06-02 12:00:00	ES	Futures	1996.87	1997.13	1995.31	1996.09	56604.0
2014-06-02 13:00:00	ES	Futures	1996.09	1997.13	1994.79	1996.61	60205.0
2014-06-02 14:00:00	ES	Futures	1996.61	1997.91	1995.31	1997.13	65106.0
2014-06-02 15:00:00	ES	Futures	1997.13	1998.43	1994.79	1997.39	123602.0
2014-06-02 16:00:00	ES	Futures	1997.13	1997.65	1995.83	1996.35	64632.0
2014-06-02 17:00:00	ES	Futures	1996.61	1996.87	1996.35	1996.35	3087.0
2014-06-02 18:00:00	ES	Futures	1995.83	1996.09	1995.05	1995.31	3447.0
2014-06-02 19:00:00	ES	Futures	1995.05	1995.31	1994.79	1995.05	1496.0
2014-06-02 20:00:00	ES	Futures	1995.05	1995.31	1994.27	1995.05	4132.0
2014-06-02 21:00:00	ES	Futures	1995.05	1996.09	1994.02	1994.02	5340.0
2014-06-02 22:00:00	ES	Futures	1994.27	1995.05	1994.27	1994.79	2283.0
2014-06-02 23:00:00	ES	Futures	1994.79	1995.31	1994.79	1995.05	1199.0
2014-06-02 00:00:00	NQ	Futures	4354.06	4354.94	4353.77	4354.06	162.0
2014-06-02 01:00:00	NQ	Futures	4354.36	4354.94	4352.61	4354.65	335.0
2014-06-02 02:00:00	NQ	Futures	4354.36	4356.1	4353.19	4354.65	571.0
2014-06-02 03:00:00	NQ	Futures	4354.94	4355.81	4349.99	4353.48	2495.0
2014-06-02 04:00:00	NQ	Futures	4353.48	4354.94	4351.15	4352.03	1142.0
2014-06-02 05:00:00	NQ	Futures	4352.32	4353.19	4351.15	4352.9	591.0
2014-06-02 06:00:00	NQ	Futures	4353.19	4357.27	4352.9	4353.48	2021.0
2014-06-02 07:00:00	NQ	Futures	4353.77	4354.36	4351.44	4353.19	1251.0
2014-06-02 08:00:00	NQ	Futures	4352.9	4355.81	4351.44	4353.77	2251.0
2014-06-02 09:00:00	NQ	Futures	4353.77	4358.43	4333.1	4334.26	36441.0
2014-06-02 10:00:00	NQ	Futures	4333.97	4338.05	4318.54	4334.84	59174.0
2014-06-02 11:00:00	NQ	Futures	4334.55	4351.44	4331.93	4347.95	34461.0
2014-06-02 12:00:00	NQ	Futures	4348.24	4349.11	4340.67	4341.83	12543.0
2014-06-02 13:00:00	NQ	Futures	4341.83	4343.58	4334.55	4338.92	15433.0
2014-06-02 14:00:00	NQ	Futures	4338.92	4343.29	4329.31	4338.92	18747.0
2014-06-02 15:00:00	NQ	Futures	4338.92	4348.82	4336.01	4346.49	27694.0
2014-06-02 16:00:00	NQ	Futures	4346.49	4346.78	4342.12	4343.58	4546.0
2014-06-02 17:00:00	NQ	Futures	4343.58	4343.87	4343.29	4343.29	156.0
2014-06-02 18:00:00	NQ	Futures	4342.71	4343.0	4339.5	4340.96	563.0
2014-06-02 19:00:00	NQ	Futures	4340.96	4341.54	4340.38	4340.67	220.0
2014-06-02 20:00:00	NQ	Futures	4340.67	4340.96	4338.92	4340.38	398.0
2014-06-02 21:00:00	NQ	Futures	4340.96	4342.42	4337.46	4337.46	538.0
2014-06-02 22:00:00	NQ	Futures	4337.46	4340.67	4337.46	4340.67	294.0
2014-06-02 23:00:00	NQ	Futures	4340.67	4341.54	4340.09	4340.38	210.0
2014-06-02 00:00:00	YM	Futures	17229.6	17230.6	17227.5	17228.5	60.0
2014-06-02 01:00:00	YM	Futures	17228.5	17228.5	17223.4	17226.5	312.0

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

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