PREVIEW / futures_1hour / 2016-06-28

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-06-28.parquet
  size:    56 KB
  rows:    1,665

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-28 00:00:00	ES	Futures	2171.39	2172.2	2169.22	2172.2	6812.0
2016-06-28 01:00:00	ES	Futures	2171.93	2172.75	2170.3	2172.47	7451.0
2016-06-28 02:00:00	ES	Futures	2172.75	2173.56	2170.03	2173.56	23582.0
2016-06-28 03:00:00	ES	Futures	2173.29	2177.08	2171.66	2176.27	53149.0
2016-06-28 04:00:00	ES	Futures	2176.0	2178.98	2175.19	2175.73	31894.0
2016-06-28 05:00:00	ES	Futures	2175.73	2177.9	2174.92	2177.36	18702.0
2016-06-28 06:00:00	ES	Futures	2177.36	2177.9	2174.64	2175.46	25807.0
2016-06-28 07:00:00	ES	Futures	2175.46	2176.0	2172.47	2175.73	24688.0
2016-06-28 08:00:00	ES	Futures	2175.73	2182.24	2174.1	2180.34	57140.0
2016-06-28 09:00:00	ES	Futures	2180.34	2189.02	2177.36	2187.12	366943.0
2016-06-28 10:00:00	ES	Futures	2187.12	2189.29	2180.34	2181.42	332176.0
2016-06-28 11:00:00	ES	Futures	2181.42	2184.68	2176.0	2183.59	256864.0
2016-06-28 12:00:00	ES	Futures	2183.59	2186.85	2180.61	2184.68	141898.0
2016-06-28 13:00:00	ES	Futures	2184.68	2185.22	2178.98	2181.69	135992.0
2016-06-28 14:00:00	ES	Futures	2181.69	2196.34	2178.44	2193.9	222152.0
2016-06-28 15:00:00	ES	Futures	2193.9	2198.78	2189.56	2198.51	369467.0
2016-06-28 16:00:00	ES	Futures	2198.51	2201.76	2197.69	2200.14	105596.0
2016-06-28 18:00:00	ES	Futures	2200.14	2200.95	2196.61	2199.59	6182.0
2016-06-28 19:00:00	ES	Futures	2199.59	2199.59	2197.97	2198.51	3381.0
2016-06-28 20:00:00	ES	Futures	2198.51	2198.78	2194.17	2194.17	11574.0
2016-06-28 21:00:00	ES	Futures	2194.17	2205.83	2194.17	2204.47	20450.0
2016-06-28 22:00:00	ES	Futures	2204.47	2205.29	2201.76	2205.29	8305.0
2016-06-28 23:00:00	ES	Futures	2205.02	2208.0	2204.2	2206.1	10857.0
2016-06-28 00:00:00	NQ	Futures	5028.73	5030.51	5021.27	5029.02	1047.0
2016-06-28 01:00:00	NQ	Futures	5028.73	5033.49	5023.96	5032.6	1155.0
2016-06-28 02:00:00	NQ	Futures	5032.0	5033.49	5024.55	5031.41	2390.0
2016-06-28 03:00:00	NQ	Futures	5031.71	5037.37	5023.66	5034.09	4447.0
2016-06-28 04:00:00	NQ	Futures	5034.69	5045.12	5032.9	5033.79	3722.0
2016-06-28 05:00:00	NQ	Futures	5033.49	5040.05	5031.41	5037.97	2024.0
2016-06-28 06:00:00	NQ	Futures	5038.56	5039.75	5031.71	5032.9	2545.0
2016-06-28 07:00:00	NQ	Futures	5032.6	5036.18	5029.02	5034.99	1923.0
2016-06-28 08:00:00	NQ	Futures	5034.69	5048.1	5031.71	5045.42	5206.0
2016-06-28 09:00:00	NQ	Futures	5045.12	5083.87	5040.65	5079.69	46482.0
2016-06-28 10:00:00	NQ	Futures	5079.99	5082.97	5066.28	5069.56	34716.0
2016-06-28 11:00:00	NQ	Futures	5069.56	5073.43	5050.19	5069.26	28205.0
2016-06-28 12:00:00	NQ	Futures	5069.56	5077.01	5060.32	5072.24	14280.0
2016-06-28 13:00:00	NQ	Futures	5072.24	5073.14	5059.13	5065.68	19110.0
2016-06-28 14:00:00	NQ	Futures	5065.68	5096.38	5055.55	5091.02	24141.0
2016-06-28 15:00:00	NQ	Futures	5091.02	5103.83	5083.87	5101.75	44541.0
2016-06-28 16:00:00	NQ	Futures	5101.75	5108.01	5100.26	5104.73	7965.0
2016-06-28 18:00:00	NQ	Futures	5104.13	5104.73	5096.68	5103.24	916.0
2016-06-28 19:00:00	NQ	Futures	5102.94	5103.54	5099.66	5101.45	416.0
2016-06-28 20:00:00	NQ	Futures	5101.75	5101.75	5088.63	5089.23	1177.0
2016-06-28 21:00:00	NQ	Futures	5088.93	5117.84	5088.63	5114.56	2245.0
2016-06-28 22:00:00	NQ	Futures	5114.86	5116.65	5107.71	5115.46	1137.0
2016-06-28 23:00:00	NQ	Futures	5116.35	5120.82	5112.48	5117.25	1437.0
2016-06-28 00:00:00	YM	Futures	18426.8	18432.2	18408.5	18431.1	1164.0
2016-06-28 01:00:00	YM	Futures	18431.1	18436.5	18417.1	18430.0	1099.0
2016-06-28 02:00:00	YM	Futures	18431.1	18440.8	18414.9	18440.8	1778.0
2016-06-28 03:00:00	YM	Futures	18440.8	18501.0	18427.9	18491.4	9876.0

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

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