PREVIEW / futures_1hour / 2016-07-07

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-07.parquet
  size:    54 KB
  rows:    1,623

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-07-07 00:00:00	ES	Futures	2269.02	2271.46	2269.02	2271.19	3481.0
2016-07-07 01:00:00	ES	Futures	2270.92	2271.73	2269.83	2270.64	3918.0
2016-07-07 02:00:00	ES	Futures	2270.64	2271.19	2266.58	2268.75	13436.0
2016-07-07 03:00:00	ES	Futures	2269.02	2274.71	2268.75	2273.63	43006.0
2016-07-07 04:00:00	ES	Futures	2273.9	2275.8	2271.46	2273.36	23988.0
2016-07-07 05:00:00	ES	Futures	2273.36	2273.63	2269.02	2271.46	17948.0
2016-07-07 06:00:00	ES	Futures	2271.73	2272.27	2267.93	2267.93	13431.0
2016-07-07 07:00:00	ES	Futures	2267.93	2269.83	2266.85	2267.66	19754.0
2016-07-07 08:00:00	ES	Futures	2267.39	2271.73	2266.85	2270.64	37368.0
2016-07-07 09:00:00	ES	Futures	2270.37	2280.14	2269.29	2279.32	216848.0
2016-07-07 10:00:00	ES	Futures	2279.05	2279.59	2272.0	2272.81	223977.0
2016-07-07 11:00:00	ES	Futures	2273.08	2273.63	2266.3	2269.56	223561.0
2016-07-07 12:00:00	ES	Futures	2269.83	2270.92	2262.78	2263.32	150668.0
2016-07-07 13:00:00	ES	Futures	2263.59	2267.12	2261.69	2264.68	147988.0
2016-07-07 14:00:00	ES	Futures	2264.68	2266.03	2258.44	2259.53	177849.0
2016-07-07 15:00:00	ES	Futures	2259.53	2269.02	2258.17	2267.93	232131.0
2016-07-07 16:00:00	ES	Futures	2267.93	2269.83	2266.85	2269.56	70274.0
2016-07-07 17:00:00	ES	Futures	2269.56	2269.56	2269.56	2269.56	1.0
2016-07-07 18:00:00	ES	Futures	2269.29	2269.56	2267.66	2269.02	3743.0
2016-07-07 19:00:00	ES	Futures	2269.02	2270.37	2268.75	2269.02	2493.0
2016-07-07 20:00:00	ES	Futures	2269.02	2271.46	2268.47	2270.1	4918.0
2016-07-07 21:00:00	ES	Futures	2270.1	2271.46	2269.56	2270.92	3623.0
2016-07-07 22:00:00	ES	Futures	2271.19	2271.19	2266.58	2267.66	5506.0
2016-07-07 23:00:00	ES	Futures	2267.66	2268.47	2265.22	2266.03	3948.0
2016-07-07 00:00:00	NQ	Futures	5286.84	5293.99	5286.84	5292.8	465.0
2016-07-07 01:00:00	NQ	Futures	5293.1	5296.08	5290.71	5293.69	926.0
2016-07-07 02:00:00	NQ	Futures	5293.99	5295.18	5284.75	5288.33	1614.0
2016-07-07 03:00:00	NQ	Futures	5288.63	5308.3	5288.33	5303.53	4092.0
2016-07-07 04:00:00	NQ	Futures	5304.13	5309.49	5298.16	5302.34	2081.0
2016-07-07 05:00:00	NQ	Futures	5302.34	5302.64	5291.31	5298.76	1759.0
2016-07-07 06:00:00	NQ	Futures	5298.16	5300.55	5287.73	5287.73	1823.0
2016-07-07 07:00:00	NQ	Futures	5287.73	5291.61	5283.26	5285.94	2321.0
2016-07-07 08:00:00	NQ	Futures	5285.65	5296.97	5284.45	5294.89	3758.0
2016-07-07 09:00:00	NQ	Futures	5294.89	5318.73	5292.2	5315.15	27220.0
2016-07-07 10:00:00	NQ	Futures	5315.15	5316.35	5296.67	5298.16	24860.0
2016-07-07 11:00:00	NQ	Futures	5298.46	5305.02	5289.52	5296.67	24529.0
2016-07-07 12:00:00	NQ	Futures	5296.97	5304.13	5284.45	5285.35	17987.0
2016-07-07 13:00:00	NQ	Futures	5285.65	5299.36	5281.47	5294.89	14966.0
2016-07-07 14:00:00	NQ	Futures	5294.89	5300.25	5283.56	5285.94	20385.0
2016-07-07 15:00:00	NQ	Futures	5285.94	5310.09	5283.56	5306.51	24475.0
2016-07-07 16:00:00	NQ	Futures	5306.21	5309.49	5304.13	5308.6	4556.0
2016-07-07 18:00:00	NQ	Futures	5307.4	5308.0	5303.83	5306.51	575.0
2016-07-07 19:00:00	NQ	Futures	5306.81	5310.68	5306.51	5306.81	421.0
2016-07-07 20:00:00	NQ	Futures	5306.51	5314.26	5306.51	5311.58	579.0
2016-07-07 21:00:00	NQ	Futures	5310.98	5312.47	5307.11	5311.58	933.0
2016-07-07 22:00:00	NQ	Futures	5310.98	5310.98	5300.25	5303.53	721.0
2016-07-07 23:00:00	NQ	Futures	5303.53	5305.32	5296.38	5297.87	578.0
2016-07-07 00:00:00	YM	Futures	19172.6	19194.1	19172.6	19190.9	452.0
2016-07-07 01:00:00	YM	Futures	19189.8	19195.2	19179.0	19186.6	666.0
2016-07-07 02:00:00	YM	Futures	19185.5	19190.9	19158.6	19170.4	1383.0

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

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