PREVIEW / futures_1hour / 2015-07-02

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-07-02.parquet
  size:    49 KB
  rows:    1,482

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
2015-07-02 00:00:00	ES	Futures	2203.74	2204.27	2203.2	2204.0	1183.0
2015-07-02 01:00:00	ES	Futures	2204.27	2204.8	2203.2	2204.0	2028.0
2015-07-02 02:00:00	ES	Futures	2204.0	2206.93	2203.74	2206.4	9021.0
2015-07-02 03:00:00	ES	Futures	2206.4	2210.66	2205.33	2209.06	22106.0
2015-07-02 04:00:00	ES	Futures	2209.33	2211.19	2207.2	2208.8	14064.0
2015-07-02 05:00:00	ES	Futures	2208.53	2209.06	2205.6	2208.53	13399.0
2015-07-02 06:00:00	ES	Futures	2208.53	2209.86	2207.73	2209.06	8753.0
2015-07-02 07:00:00	ES	Futures	2209.06	2210.13	2207.2	2209.06	30452.0
2015-07-02 08:00:00	ES	Futures	2209.06	2214.12	2207.46	2211.72	69144.0
2015-07-02 09:00:00	ES	Futures	2211.72	2212.26	2206.93	2207.73	190392.0
2015-07-02 10:00:00	ES	Futures	2207.73	2209.33	2203.47	2205.6	182163.0
2015-07-02 11:00:00	ES	Futures	2205.6	2206.13	2199.21	2201.07	136930.0
2015-07-02 12:00:00	ES	Futures	2200.81	2201.87	2197.08	2198.94	83851.0
2015-07-02 13:00:00	ES	Futures	2198.94	2200.01	2196.55	2197.61	87256.0
2015-07-02 14:00:00	ES	Futures	2197.61	2201.34	2196.28	2200.54	88465.0
2015-07-02 15:00:00	ES	Futures	2200.54	2205.07	2198.94	2201.34	201261.0
2015-07-02 16:00:00	ES	Futures	2201.34	2204.27	2200.54	2203.2	88074.0
2015-07-02 17:00:00	ES	Futures	2203.47	2203.74	2202.67	2203.47	1623.0
2015-07-02 18:00:00	ES	Futures	2202.94	2204.0	2202.67	2202.67	1090.0
2015-07-02 19:00:00	ES	Futures	2202.67	2203.47	2201.34	2202.67	1005.0
2015-07-02 20:00:00	ES	Futures	2202.67	2202.94	2201.34	2202.67	1655.0
2015-07-02 21:00:00	ES	Futures	2202.41	2203.74	2201.61	2201.87	2158.0
2015-07-02 22:00:00	ES	Futures	2201.87	2203.2	2201.61	2201.87	1813.0
2015-07-02 23:00:00	ES	Futures	2201.87	2204.54	2201.87	2203.74	1394.0
2015-07-02 00:00:00	NQ	Futures	5227.78	5229.85	5226.01	5228.97	257.0
2015-07-02 01:00:00	NQ	Futures	5229.26	5230.74	5226.89	5228.67	442.0
2015-07-02 02:00:00	NQ	Futures	5228.97	5234.88	5228.37	5234.59	913.0
2015-07-02 03:00:00	NQ	Futures	5234.88	5245.53	5232.22	5241.39	2580.0
2015-07-02 04:00:00	NQ	Futures	5241.09	5246.71	5237.84	5241.68	1614.0
2015-07-02 05:00:00	NQ	Futures	5242.28	5243.16	5234.88	5241.98	1564.0
2015-07-02 06:00:00	NQ	Futures	5241.98	5244.64	5239.91	5242.57	1193.0
2015-07-02 07:00:00	NQ	Futures	5242.57	5244.64	5238.13	5242.28	10026.0
2015-07-02 08:00:00	NQ	Futures	5241.98	5254.99	5239.32	5249.08	10848.0
2015-07-02 09:00:00	NQ	Futures	5249.37	5250.26	5236.36	5236.95	27924.0
2015-07-02 10:00:00	NQ	Futures	5236.66	5241.09	5226.01	5233.11	23711.0
2015-07-02 11:00:00	NQ	Futures	5233.4	5233.99	5220.39	5223.35	15819.0
2015-07-02 12:00:00	NQ	Futures	5223.94	5226.01	5215.65	5222.16	8508.0
2015-07-02 13:00:00	NQ	Futures	5221.87	5226.01	5215.95	5221.27	9775.0
2015-07-02 14:00:00	NQ	Futures	5221.27	5231.04	5218.32	5229.56	10026.0
2015-07-02 15:00:00	NQ	Futures	5229.85	5241.39	5224.23	5231.92	18943.0
2015-07-02 16:00:00	NQ	Futures	5232.22	5241.39	5230.15	5239.02	6467.0
2015-07-02 17:00:00	NQ	Futures	5239.61	5240.5	5238.73	5238.73	66.0
2015-07-02 18:00:00	NQ	Futures	5238.73	5240.21	5237.84	5238.43	172.0
2015-07-02 19:00:00	NQ	Futures	5238.43	5239.02	5236.66	5237.84	231.0
2015-07-02 20:00:00	NQ	Futures	5237.25	5239.02	5235.77	5237.84	222.0
2015-07-02 21:00:00	NQ	Futures	5238.43	5239.91	5236.66	5237.54	319.0
2015-07-02 22:00:00	NQ	Futures	5237.54	5239.02	5234.88	5235.18	424.0
2015-07-02 23:00:00	NQ	Futures	5235.18	5243.16	5235.18	5239.61	310.0
2015-07-02 00:00:00	YM	Futures	18605.2	18610.4	18602.0	18609.4	130.0
2015-07-02 01:00:00	YM	Futures	18608.3	18613.6	18602.0	18605.2	205.0

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

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