PREVIEW / futures_1hour / 2016-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-05-12.parquet
  size:    54 KB
  rows:    1,626

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
2016-05-12 00:00:00	ES	Futures	2225.72	2226.79	2225.45	2226.79	2075.0
2016-05-12 01:00:00	ES	Futures	2226.79	2227.6	2225.98	2227.6	4683.0
2016-05-12 02:00:00	ES	Futures	2227.6	2229.22	2225.72	2226.52	12161.0
2016-05-12 03:00:00	ES	Futures	2226.52	2229.49	2222.48	2228.68	39408.0
2016-05-12 04:00:00	ES	Futures	2228.41	2231.92	2227.06	2231.65	23317.0
2016-05-12 05:00:00	ES	Futures	2231.65	2237.05	2230.3	2236.24	34184.0
2016-05-12 06:00:00	ES	Futures	2236.24	2236.51	2233.0	2235.16	22664.0
2016-05-12 07:00:00	ES	Futures	2235.43	2238.4	2233.54	2237.32	31120.0
2016-05-12 08:00:00	ES	Futures	2237.32	2238.13	2233.81	2234.89	37601.0
2016-05-12 09:00:00	ES	Futures	2234.89	2235.16	2225.72	2225.72	222487.0
2016-05-12 10:00:00	ES	Futures	2225.72	2229.76	2220.59	2222.75	272411.0
2016-05-12 11:00:00	ES	Futures	2222.75	2223.29	2213.57	2213.84	236074.0
2016-05-12 12:00:00	ES	Futures	2213.84	2220.05	2212.22	2220.05	153980.0
2016-05-12 13:00:00	ES	Futures	2219.78	2222.48	2215.19	2221.94	139747.0
2016-05-12 14:00:00	ES	Futures	2221.94	2231.65	2221.94	2229.22	211502.0
2016-05-12 15:00:00	ES	Futures	2229.49	2230.3	2221.94	2225.18	239624.0
2016-05-12 16:00:00	ES	Futures	2225.18	2225.72	2222.75	2224.64	70823.0
2016-05-12 18:00:00	ES	Futures	2223.83	2224.1	2222.75	2223.56	2552.0
2016-05-12 19:00:00	ES	Futures	2223.56	2225.45	2223.56	2224.91	3313.0
2016-05-12 20:00:00	ES	Futures	2224.91	2225.18	2219.78	2220.32	7299.0
2016-05-12 21:00:00	ES	Futures	2220.05	2220.32	2216.27	2217.89	12318.0
2016-05-12 22:00:00	ES	Futures	2217.89	2217.89	2215.46	2216.27	7112.0
2016-05-12 23:00:00	ES	Futures	2216.27	2217.62	2215.73	2216.54	3995.0
2016-05-12 00:00:00	NQ	Futures	5184.46	5188.32	5183.86	5188.03	297.0
2016-05-12 01:00:00	NQ	Futures	5188.03	5190.11	5185.94	5189.51	753.0
2016-05-12 02:00:00	NQ	Futures	5189.81	5193.38	5184.16	5186.24	1965.0
2016-05-12 03:00:00	NQ	Futures	5185.94	5198.14	5179.4	5195.76	5655.0
2016-05-12 04:00:00	NQ	Futures	5195.46	5204.69	5191.6	5203.5	2473.0
2016-05-12 05:00:00	NQ	Futures	5203.5	5214.8	5199.33	5212.42	3535.0
2016-05-12 06:00:00	NQ	Futures	5211.83	5213.02	5203.5	5209.15	2812.0
2016-05-12 07:00:00	NQ	Futures	5209.45	5213.02	5205.28	5211.23	2757.0
2016-05-12 08:00:00	NQ	Futures	5210.94	5211.83	5201.71	5204.09	4500.0
2016-05-12 09:00:00	NQ	Futures	5204.09	5204.39	5168.39	5168.69	36756.0
2016-05-12 10:00:00	NQ	Futures	5168.69	5178.8	5149.94	5152.92	43033.0
2016-05-12 11:00:00	NQ	Futures	5152.92	5155.3	5126.73	5130.3	38684.0
2016-05-12 12:00:00	NQ	Futures	5130.3	5146.07	5124.35	5146.07	20194.0
2016-05-12 13:00:00	NQ	Futures	5145.78	5155.59	5131.79	5154.7	19081.0
2016-05-12 14:00:00	NQ	Futures	5154.7	5188.62	5154.7	5181.18	34062.0
2016-05-12 15:00:00	NQ	Futures	5180.88	5182.97	5156.19	5161.84	30424.0
2016-05-12 16:00:00	NQ	Futures	5161.55	5163.63	5156.19	5161.25	6197.0
2016-05-12 18:00:00	NQ	Futures	5161.84	5162.14	5157.68	5158.57	403.0
2016-05-12 19:00:00	NQ	Futures	5158.57	5163.33	5158.57	5161.84	465.0
2016-05-12 20:00:00	NQ	Futures	5162.44	5163.63	5149.64	5151.13	1407.0
2016-05-12 21:00:00	NQ	Futures	5150.83	5150.83	5139.53	5145.48	1908.0
2016-05-12 22:00:00	NQ	Futures	5144.59	5145.48	5138.04	5140.42	1542.0
2016-05-12 23:00:00	NQ	Futures	5140.12	5143.99	5138.64	5141.31	735.0
2016-05-12 00:00:00	YM	Futures	18923.4	18933.1	18922.4	18932.0	296.0
2016-05-12 01:00:00	YM	Futures	18932.0	18938.4	18922.4	18935.2	904.0
2016-05-12 02:00:00	YM	Futures	18936.3	18950.2	18922.4	18926.6	1682.0
2016-05-12 03:00:00	YM	Futures	18926.6	18945.9	18889.2	18936.3	6376.0

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

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