PREVIEW / futures_1hour / 2015-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-05-06.parquet
  size:    52 KB
  rows:    1,591

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-05-06 00:00:00	ES	Futures	2209.61	2210.4	2208.02	2208.82	1841.0
2015-05-06 01:00:00	ES	Futures	2208.82	2209.08	2205.38	2206.18	3009.0
2015-05-06 02:00:00	ES	Futures	2206.18	2206.97	2202.21	2203.27	9358.0
2015-05-06 03:00:00	ES	Futures	2203.27	2205.65	2198.78	2204.06	37144.0
2015-05-06 04:00:00	ES	Futures	2204.33	2209.08	2203.8	2208.55	28786.0
2015-05-06 05:00:00	ES	Futures	2208.55	2210.67	2206.97	2207.5	21562.0
2015-05-06 06:00:00	ES	Futures	2207.76	2209.35	2204.33	2204.86	14845.0
2015-05-06 07:00:00	ES	Futures	2205.12	2210.14	2204.86	2209.08	16786.0
2015-05-06 08:00:00	ES	Futures	2209.08	2209.61	2205.38	2206.7	26066.0
2015-05-06 09:00:00	ES	Futures	2206.44	2211.99	2191.12	2195.35	342807.0
2015-05-06 10:00:00	ES	Futures	2195.08	2201.69	2187.42	2199.57	347319.0
2015-05-06 11:00:00	ES	Futures	2199.84	2200.89	2192.44	2197.2	158834.0
2015-05-06 12:00:00	ES	Futures	2196.93	2197.46	2189.54	2190.86	98950.0
2015-05-06 13:00:00	ES	Futures	2190.86	2192.97	2183.46	2185.84	131788.0
2015-05-06 14:00:00	ES	Futures	2185.84	2187.42	2177.65	2182.41	166159.0
2015-05-06 15:00:00	ES	Futures	2182.14	2192.44	2179.24	2191.65	234453.0
2015-05-06 16:00:00	ES	Futures	2191.65	2193.5	2190.86	2192.44	88645.0
2015-05-06 17:00:00	ES	Futures	2192.44	2192.44	2191.91	2192.18	1307.0
2015-05-06 18:00:00	ES	Futures	2191.91	2194.03	2191.39	2191.39	5348.0
2015-05-06 19:00:00	ES	Futures	2191.65	2191.91	2188.48	2190.06	4053.0
2015-05-06 20:00:00	ES	Futures	2189.8	2193.5	2189.8	2193.23	5192.0
2015-05-06 21:00:00	ES	Futures	2193.23	2194.03	2192.44	2193.76	4068.0
2015-05-06 22:00:00	ES	Futures	2194.03	2194.55	2192.44	2194.29	2075.0
2015-05-06 23:00:00	ES	Futures	2194.03	2194.55	2192.44	2193.5	2423.0
2015-05-06 00:00:00	NQ	Futures	5201.69	5203.16	5197.57	5199.63	372.0
2015-05-06 01:00:00	NQ	Futures	5199.34	5200.22	5190.52	5191.4	923.0
2015-05-06 02:00:00	NQ	Futures	5191.69	5194.34	5186.69	5188.46	1879.0
2015-05-06 03:00:00	NQ	Futures	5188.75	5191.69	5170.23	5181.11	8430.0
2015-05-06 04:00:00	NQ	Futures	5181.69	5193.75	5179.93	5191.4	5657.0
2015-05-06 05:00:00	NQ	Futures	5191.1	5195.22	5186.4	5187.57	3741.0
2015-05-06 06:00:00	NQ	Futures	5187.87	5191.4	5180.22	5182.28	3239.0
2015-05-06 07:00:00	NQ	Futures	5182.28	5193.16	5182.28	5192.57	5050.0
2015-05-06 08:00:00	NQ	Futures	5192.28	5194.34	5184.34	5184.63	4703.0
2015-05-06 09:00:00	NQ	Futures	5185.22	5201.98	5141.7	5150.52	68862.0
2015-05-06 10:00:00	NQ	Futures	5150.52	5166.11	5129.35	5162.58	67864.0
2015-05-06 11:00:00	NQ	Futures	5162.29	5170.81	5148.17	5159.05	32079.0
2015-05-06 12:00:00	NQ	Futures	5159.05	5159.64	5137.88	5142.29	21708.0
2015-05-06 13:00:00	NQ	Futures	5142.58	5146.7	5119.06	5127.29	28485.0
2015-05-06 14:00:00	NQ	Futures	5127.59	5130.23	5106.71	5118.18	32726.0
2015-05-06 15:00:00	NQ	Futures	5118.47	5144.94	5110.53	5143.17	37940.0
2015-05-06 16:00:00	NQ	Futures	5143.17	5146.11	5140.82	5144.05	7673.0
2015-05-06 17:00:00	NQ	Futures	5143.76	5144.64	5142.29	5144.35	104.0
2015-05-06 18:00:00	NQ	Futures	5141.99	5149.35	5141.11	5141.7	1288.0
2015-05-06 19:00:00	NQ	Futures	5141.7	5143.76	5137.29	5140.23	523.0
2015-05-06 20:00:00	NQ	Futures	5139.94	5147.29	5139.94	5147.29	603.0
2015-05-06 21:00:00	NQ	Futures	5146.99	5149.93	5146.11	5149.35	317.0
2015-05-06 22:00:00	NQ	Futures	5149.35	5150.23	5146.7	5149.64	147.0
2015-05-06 23:00:00	NQ	Futures	5149.64	5150.52	5146.7	5148.46	280.0
2015-05-06 00:00:00	YM	Futures	18803.6	18807.8	18785.8	18798.4	449.0
2015-05-06 01:00:00	YM	Futures	18797.3	18797.3	18769.0	18772.2	741.0

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

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