PREVIEW / futures_1hour / 2016-06-27

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-27.parquet
  size:    57 KB
  rows:    1,644

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-06-27 00:00:00	ES	Futures	2181.69	2182.78	2177.63	2182.51	8715.0
2016-06-27 01:00:00	ES	Futures	2182.78	2184.14	2181.15	2183.32	11589.0
2016-06-27 02:00:00	ES	Futures	2183.32	2190.1	2182.78	2187.12	43855.0
2016-06-27 03:00:00	ES	Futures	2186.85	2193.9	2186.03	2189.83	80638.0
2016-06-27 04:00:00	ES	Futures	2189.56	2190.92	2180.07	2184.41	44278.0
2016-06-27 05:00:00	ES	Futures	2184.14	2187.66	2179.53	2181.15	31831.0
2016-06-27 06:00:00	ES	Futures	2180.88	2181.97	2173.02	2174.37	39248.0
2016-06-27 07:00:00	ES	Futures	2174.1	2177.08	2169.76	2170.85	45283.0
2016-06-27 08:00:00	ES	Futures	2170.85	2180.34	2170.58	2178.98	75305.0
2016-06-27 09:00:00	ES	Futures	2178.98	2181.97	2166.78	2168.95	367737.0
2016-06-27 10:00:00	ES	Futures	2168.95	2173.56	2149.97	2151.32	492942.0
2016-06-27 11:00:00	ES	Futures	2151.59	2164.88	2149.42	2161.36	404105.0
2016-06-27 12:00:00	ES	Futures	2161.36	2165.97	2157.02	2161.36	202275.0
2016-06-27 13:00:00	ES	Futures	2161.36	2165.97	2155.12	2157.83	203458.0
2016-06-27 14:00:00	ES	Futures	2157.83	2161.36	2151.59	2153.49	220412.0
2016-06-27 15:00:00	ES	Futures	2153.49	2163.53	2149.42	2159.73	396369.0
2016-06-27 16:00:00	ES	Futures	2159.73	2159.73	2149.42	2149.97	135717.0
2016-06-27 18:00:00	ES	Futures	2150.51	2158.37	2150.24	2157.56	9484.0
2016-06-27 19:00:00	ES	Futures	2157.83	2160.0	2156.2	2158.64	8441.0
2016-06-27 20:00:00	ES	Futures	2158.64	2159.19	2156.2	2157.29	9622.0
2016-06-27 21:00:00	ES	Futures	2157.56	2168.14	2157.02	2167.59	26125.0
2016-06-27 22:00:00	ES	Futures	2167.59	2168.14	2164.88	2166.51	13268.0
2016-06-27 23:00:00	ES	Futures	2166.24	2176.0	2166.24	2171.66	24713.0
2016-06-27 00:00:00	NQ	Futures	5062.7	5065.09	5051.08	5063.6	1370.0
2016-06-27 01:00:00	NQ	Futures	5063.3	5068.37	5059.43	5065.98	1176.0
2016-06-27 02:00:00	NQ	Futures	5065.68	5082.08	5064.49	5070.75	4825.0
2016-06-27 03:00:00	NQ	Futures	5070.45	5088.04	5069.26	5076.41	9788.0
2016-06-27 04:00:00	NQ	Futures	5076.12	5079.69	5052.27	5060.92	6386.0
2016-06-27 05:00:00	NQ	Futures	5060.62	5066.88	5049.89	5053.46	4610.0
2016-06-27 06:00:00	NQ	Futures	5053.46	5058.53	5036.48	5040.65	5262.0
2016-06-27 07:00:00	NQ	Futures	5040.05	5045.71	5028.13	5030.81	5186.0
2016-06-27 08:00:00	NQ	Futures	5030.22	5051.97	5029.92	5048.7	9803.0
2016-06-27 09:00:00	NQ	Futures	5048.7	5059.43	5021.27	5027.53	54415.0
2016-06-27 10:00:00	NQ	Futures	5027.83	5037.97	4972.99	4976.57	69470.0
2016-06-27 11:00:00	NQ	Futures	4976.57	5008.46	4970.01	4997.73	55530.0
2016-06-27 12:00:00	NQ	Futures	4997.43	5014.12	4989.68	5002.5	31813.0
2016-06-27 13:00:00	NQ	Futures	5002.8	5014.12	4984.91	4990.58	32426.0
2016-06-27 14:00:00	NQ	Futures	4989.68	4998.03	4972.99	4977.46	36208.0
2016-06-27 15:00:00	NQ	Futures	4977.76	5003.99	4968.82	4995.05	57994.0
2016-06-27 16:00:00	NQ	Futures	4995.34	4995.34	4975.37	4976.27	10861.0
2016-06-27 18:00:00	NQ	Futures	4978.95	4995.64	4978.65	4994.75	1168.0
2016-06-27 19:00:00	NQ	Futures	4995.05	4999.52	4991.17	4996.24	855.0
2016-06-27 20:00:00	NQ	Futures	4995.94	4998.32	4990.28	4994.45	1210.0
2016-06-27 21:00:00	NQ	Futures	4994.15	5018.89	4991.77	5016.51	3925.0
2016-06-27 22:00:00	NQ	Futures	5016.21	5021.87	5009.65	5018.29	2339.0
2016-06-27 23:00:00	NQ	Futures	5018.0	5039.75	5018.0	5028.73	3734.0
2016-06-27 00:00:00	YM	Futures	18496.7	18507.5	18465.5	18501.0	2347.0
2016-06-27 01:00:00	YM	Futures	18501.0	18521.5	18490.3	18514.0	2098.0
2016-06-27 02:00:00	YM	Futures	18511.8	18567.8	18508.6	18539.8	5788.0
2016-06-27 03:00:00	YM	Futures	18537.6	18592.5	18535.5	18554.9	12506.0

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

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