PREVIEW / futures_1hour / 2014-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-04-16.parquet
  size:    49 KB
  rows:    1,554

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-04-16 00:00:00	ES	Futures	1916.37	1917.67	1916.11	1917.41	2021.0
2014-04-16 01:00:00	ES	Futures	1917.15	1918.71	1915.85	1917.93	5808.0
2014-04-16 02:00:00	ES	Futures	1917.93	1920.79	1917.67	1918.45	20729.0
2014-04-16 03:00:00	ES	Futures	1918.19	1919.49	1917.15	1918.71	47268.0
2014-04-16 04:00:00	ES	Futures	1918.45	1920.27	1917.93	1919.75	18871.0
2014-04-16 05:00:00	ES	Futures	1920.01	1921.31	1919.23	1920.01	17850.0
2014-04-16 06:00:00	ES	Futures	1920.01	1920.79	1918.71	1918.97	17499.0
2014-04-16 07:00:00	ES	Futures	1918.97	1920.79	1918.45	1919.23	39323.0
2014-04-16 08:00:00	ES	Futures	1919.23	1920.53	1917.41	1918.71	46622.0
2014-04-16 09:00:00	ES	Futures	1918.45	1922.61	1913.52	1916.37	288100.0
2014-04-16 10:00:00	ES	Futures	1916.37	1918.71	1912.48	1913.52	264255.0
2014-04-16 11:00:00	ES	Futures	1913.52	1920.79	1911.96	1920.01	161358.0
2014-04-16 12:00:00	ES	Futures	1920.27	1923.9	1918.71	1918.71	162896.0
2014-04-16 13:00:00	ES	Futures	1918.71	1921.83	1916.37	1921.05	123767.0
2014-04-16 14:00:00	ES	Futures	1921.05	1924.68	1917.15	1923.9	117121.0
2014-04-16 15:00:00	ES	Futures	1923.64	1927.8	1921.83	1927.54	162253.0
2014-04-16 16:00:00	ES	Futures	1927.54	1928.84	1922.35	1923.38	105984.0
2014-04-16 17:00:00	ES	Futures	1923.12	1924.68	1923.12	1924.42	3526.0
2014-04-16 18:00:00	ES	Futures	1924.16	1924.42	1918.97	1919.49	10276.0
2014-04-16 19:00:00	ES	Futures	1919.75	1921.05	1919.49	1921.05	3216.0
2014-04-16 20:00:00	ES	Futures	1921.05	1922.09	1920.27	1921.83	3305.0
2014-04-16 21:00:00	ES	Futures	1921.83	1923.38	1921.05	1922.09	3397.0
2014-04-16 22:00:00	ES	Futures	1921.83	1922.09	1920.01	1920.27	5169.0
2014-04-16 23:00:00	ES	Futures	1920.01	1920.79	1919.23	1920.01	2782.0
2014-04-16 00:00:00	NQ	Futures	4083.81	4085.56	4082.06	4084.97	354.0
2014-04-16 01:00:00	NQ	Futures	4085.27	4088.18	4081.77	4087.01	976.0
2014-04-16 02:00:00	NQ	Futures	4087.01	4092.55	4083.81	4085.85	4974.0
2014-04-16 03:00:00	NQ	Futures	4085.85	4088.18	4082.06	4085.27	7343.0
2014-04-16 04:00:00	NQ	Futures	4084.68	4089.93	4083.23	4089.05	2345.0
2014-04-16 05:00:00	NQ	Futures	4089.05	4092.26	4087.89	4090.22	2492.0
2014-04-16 06:00:00	NQ	Futures	4090.22	4092.26	4086.43	4088.47	2802.0
2014-04-16 07:00:00	NQ	Futures	4088.18	4091.67	4084.39	4086.72	4082.0
2014-04-16 08:00:00	NQ	Futures	4087.01	4089.34	4079.73	4083.81	9877.0
2014-04-16 09:00:00	NQ	Futures	4084.1	4092.26	4059.93	4071.87	74274.0
2014-04-16 10:00:00	NQ	Futures	4071.87	4084.97	4054.69	4059.64	68362.0
2014-04-16 11:00:00	NQ	Futures	4059.35	4083.52	4053.23	4083.23	38524.0
2014-04-16 12:00:00	NQ	Futures	4083.52	4098.95	4078.57	4078.57	43564.0
2014-04-16 13:00:00	NQ	Futures	4078.57	4087.01	4070.41	4081.77	47398.0
2014-04-16 14:00:00	NQ	Futures	4081.48	4093.42	4071.29	4090.8	29492.0
2014-04-16 15:00:00	NQ	Futures	4091.09	4105.07	4085.27	4104.49	32315.0
2014-04-16 16:00:00	NQ	Futures	4104.78	4105.65	4072.16	4078.57	22476.0
2014-04-16 17:00:00	NQ	Futures	4078.57	4085.56	4078.57	4085.56	945.0
2014-04-16 18:00:00	NQ	Futures	4083.52	4084.97	4071.87	4074.2	1293.0
2014-04-16 19:00:00	NQ	Futures	4073.91	4077.99	4073.03	4077.69	791.0
2014-04-16 20:00:00	NQ	Futures	4077.99	4081.48	4076.53	4080.9	1622.0
2014-04-16 21:00:00	NQ	Futures	4081.19	4082.35	4075.66	4075.95	969.0
2014-04-16 22:00:00	NQ	Futures	4075.66	4077.11	4071.0	4071.58	1298.0
2014-04-16 23:00:00	NQ	Futures	4071.58	4072.74	4068.38	4070.12	636.0
2014-04-16 00:00:00	YM	Futures	16744.5	16751.7	16741.4	16747.6	281.0
2014-04-16 01:00:00	YM	Futures	16749.6	16758.9	16740.4	16755.8	920.0

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

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