PREVIEW / futures_1hour / 2014-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-09-02.parquet
  size:    48 KB
  rows:    1,525

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-09-02 00:00:00	ES	Futures	2088.04	2088.04	2087.26	2087.26	622.0
2014-09-02 01:00:00	ES	Futures	2087.52	2088.82	2087.26	2088.82	3178.0
2014-09-02 02:00:00	ES	Futures	2088.82	2091.43	2088.04	2089.86	18528.0
2014-09-02 03:00:00	ES	Futures	2089.86	2090.91	2089.34	2089.86	17201.0
2014-09-02 04:00:00	ES	Futures	2089.86	2091.43	2089.6	2090.91	12040.0
2014-09-02 05:00:00	ES	Futures	2090.91	2090.91	2089.86	2089.86	9064.0
2014-09-02 06:00:00	ES	Futures	2090.12	2091.43	2089.6	2090.12	10153.0
2014-09-02 07:00:00	ES	Futures	2090.12	2090.65	2086.48	2088.3	30017.0
2014-09-02 08:00:00	ES	Futures	2088.04	2089.34	2087.26	2087.52	19413.0
2014-09-02 09:00:00	ES	Futures	2087.78	2090.38	2083.61	2085.43	165011.0
2014-09-02 10:00:00	ES	Futures	2085.95	2088.82	2083.61	2088.56	165434.0
2014-09-02 11:00:00	ES	Futures	2088.56	2089.08	2081.0	2081.52	179049.0
2014-09-02 12:00:00	ES	Futures	2081.78	2083.35	2078.14	2078.4	129062.0
2014-09-02 13:00:00	ES	Futures	2078.66	2080.48	2077.35	2079.96	95824.0
2014-09-02 14:00:00	ES	Futures	2079.96	2083.87	2079.7	2083.09	87539.0
2014-09-02 15:00:00	ES	Futures	2083.09	2085.69	2082.05	2084.91	121737.0
2014-09-02 16:00:00	ES	Futures	2085.17	2085.95	2084.39	2085.69	58139.0
2014-09-02 17:00:00	ES	Futures	2085.69	2085.95	2085.43	2085.43	1413.0
2014-09-02 18:00:00	ES	Futures	2085.43	2085.43	2084.13	2084.91	3304.0
2014-09-02 19:00:00	ES	Futures	2084.91	2085.43	2084.91	2085.17	1028.0
2014-09-02 20:00:00	ES	Futures	2085.43	2085.95	2084.65	2084.65	2922.0
2014-09-02 21:00:00	ES	Futures	2084.65	2085.69	2084.65	2085.69	2658.0
2014-09-02 22:00:00	ES	Futures	2085.43	2087.26	2085.43	2087.0	4221.0
2014-09-02 23:00:00	ES	Futures	2087.0	2087.52	2086.48	2087.0	3187.0
2014-09-02 00:00:00	NQ	Futures	4774.44	4774.44	4772.1	4772.1	189.0
2014-09-02 01:00:00	NQ	Futures	4772.4	4775.32	4772.4	4774.44	614.0
2014-09-02 02:00:00	NQ	Futures	4774.73	4778.82	4773.56	4776.48	2271.0
2014-09-02 03:00:00	NQ	Futures	4776.48	4778.24	4775.32	4776.48	2204.0
2014-09-02 04:00:00	NQ	Futures	4776.48	4781.74	4776.48	4780.86	2604.0
2014-09-02 05:00:00	NQ	Futures	4780.57	4782.32	4779.7	4779.99	1324.0
2014-09-02 06:00:00	NQ	Futures	4779.99	4784.37	4779.99	4780.28	2218.0
2014-09-02 07:00:00	NQ	Futures	4780.28	4781.16	4772.4	4775.32	3965.0
2014-09-02 08:00:00	NQ	Futures	4775.32	4778.82	4774.44	4775.02	4726.0
2014-09-02 09:00:00	NQ	Futures	4775.02	4783.78	4769.48	4772.69	34524.0
2014-09-02 10:00:00	NQ	Futures	4773.27	4783.2	4770.35	4782.91	29488.0
2014-09-02 11:00:00	NQ	Futures	4782.91	4783.78	4770.06	4771.23	24419.0
2014-09-02 12:00:00	NQ	Futures	4770.94	4777.07	4764.8	4764.8	19991.0
2014-09-02 13:00:00	NQ	Futures	4765.1	4771.81	4763.05	4771.23	14007.0
2014-09-02 14:00:00	NQ	Futures	4771.23	4775.9	4770.06	4774.15	11559.0
2014-09-02 15:00:00	NQ	Futures	4774.15	4783.49	4772.4	4782.03	18113.0
2014-09-02 16:00:00	NQ	Futures	4781.74	4783.2	4778.82	4783.2	5712.0
2014-09-02 17:00:00	NQ	Futures	4783.2	4783.2	4781.45	4781.74	551.0
2014-09-02 18:00:00	NQ	Futures	4780.57	4781.45	4778.53	4779.99	534.0
2014-09-02 19:00:00	NQ	Futures	4779.99	4781.16	4779.7	4780.28	149.0
2014-09-02 20:00:00	NQ	Futures	4780.57	4782.03	4779.4	4779.99	422.0
2014-09-02 21:00:00	NQ	Futures	4779.99	4781.16	4779.7	4781.16	401.0
2014-09-02 22:00:00	NQ	Futures	4781.45	4784.95	4781.45	4784.08	855.0
2014-09-02 23:00:00	NQ	Futures	4784.08	4784.95	4783.49	4783.78	539.0
2014-09-02 00:00:00	YM	Futures	17692.1	17693.2	17686.9	17688.0	205.0
2014-09-02 01:00:00	YM	Futures	17689.0	17698.3	17688.0	17695.2	801.0

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

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