PREVIEW / futures_1hour / 2015-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-08-12.parquet
  size:    54 KB
  rows:    1,587

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-08-12 00:00:00	ES	Futures	2200.01	2200.54	2199.21	2200.28	6706.0
2015-08-12 01:00:00	ES	Futures	2200.28	2204.0	2200.28	2201.87	10160.0
2015-08-12 02:00:00	ES	Futures	2201.61	2202.94	2197.88	2200.81	18696.0
2015-08-12 03:00:00	ES	Futures	2200.81	2201.07	2191.22	2194.68	64463.0
2015-08-12 04:00:00	ES	Futures	2194.95	2196.81	2187.23	2188.56	61161.0
2015-08-12 05:00:00	ES	Futures	2188.56	2192.29	2187.76	2189.09	30413.0
2015-08-12 06:00:00	ES	Futures	2189.36	2198.94	2189.09	2196.28	37398.0
2015-08-12 07:00:00	ES	Futures	2196.55	2199.74	2194.95	2198.68	48482.0
2015-08-12 08:00:00	ES	Futures	2198.68	2201.61	2197.61	2199.74	44002.0
2015-08-12 09:00:00	ES	Futures	2199.48	2200.01	2190.42	2192.82	307285.0
2015-08-12 10:00:00	ES	Futures	2193.09	2193.35	2179.51	2184.03	449227.0
2015-08-12 11:00:00	ES	Futures	2183.77	2190.42	2183.5	2185.1	240610.0
2015-08-12 12:00:00	ES	Futures	2185.1	2198.94	2182.97	2196.02	198525.0
2015-08-12 13:00:00	ES	Futures	2196.02	2209.33	2196.02	2207.2	209689.0
2015-08-12 14:00:00	ES	Futures	2207.46	2213.85	2202.14	2213.32	213844.0
2015-08-12 15:00:00	ES	Futures	2213.59	2220.24	2211.46	2217.32	258809.0
2015-08-12 16:00:00	ES	Futures	2217.32	2220.24	2216.25	2219.18	65398.0
2015-08-12 17:00:00	ES	Futures	2218.91	2219.18	2217.85	2218.11	2742.0
2015-08-12 18:00:00	ES	Futures	2218.11	2218.91	2217.05	2217.32	4273.0
2015-08-12 19:00:00	ES	Futures	2217.32	2217.58	2216.52	2217.32	1970.0
2015-08-12 20:00:00	ES	Futures	2217.58	2221.58	2217.32	2220.78	7983.0
2015-08-12 21:00:00	ES	Futures	2221.04	2221.58	2210.93	2219.71	26089.0
2015-08-12 22:00:00	ES	Futures	2219.71	2223.71	2217.85	2221.04	11868.0
2015-08-12 23:00:00	ES	Futures	2221.31	2224.5	2220.24	2223.44	6375.0
2015-08-12 00:00:00	NQ	Futures	5302.62	5303.21	5299.36	5302.32	1049.0
2015-08-12 01:00:00	NQ	Futures	5302.62	5313.86	5302.62	5307.05	1986.0
2015-08-12 02:00:00	NQ	Futures	5306.17	5313.27	5297.0	5305.87	2863.0
2015-08-12 03:00:00	NQ	Futures	5305.87	5306.46	5279.84	5290.49	8351.0
2015-08-12 04:00:00	NQ	Futures	5290.79	5293.15	5270.08	5273.33	8606.0
2015-08-12 05:00:00	NQ	Futures	5273.33	5284.87	5271.85	5272.74	5481.0
2015-08-12 06:00:00	NQ	Futures	5273.33	5298.48	5273.04	5291.97	5373.0
2015-08-12 07:00:00	NQ	Futures	5291.97	5298.18	5287.24	5296.41	6866.0
2015-08-12 08:00:00	NQ	Futures	5296.41	5303.21	5293.15	5301.14	6834.0
2015-08-12 09:00:00	NQ	Futures	5300.84	5303.5	5263.87	5275.11	53433.0
2015-08-12 10:00:00	NQ	Futures	5274.81	5280.43	5242.87	5252.33	54370.0
2015-08-12 11:00:00	NQ	Futures	5252.63	5286.64	5251.74	5260.02	33779.0
2015-08-12 12:00:00	NQ	Futures	5260.02	5303.5	5254.4	5298.18	33724.0
2015-08-12 13:00:00	NQ	Futures	5298.48	5345.8	5297.88	5339.59	37903.0
2015-08-12 14:00:00	NQ	Futures	5339.29	5353.49	5324.8	5352.01	38437.0
2015-08-12 15:00:00	NQ	Futures	5352.01	5366.21	5345.51	5354.38	32469.0
2015-08-12 16:00:00	NQ	Futures	5354.38	5365.03	5352.61	5362.96	7092.0
2015-08-12 17:00:00	NQ	Futures	5362.37	5362.96	5360.0	5362.66	173.0
2015-08-12 18:00:00	NQ	Futures	5359.41	5361.48	5355.86	5358.23	657.0
2015-08-12 19:00:00	NQ	Futures	5358.23	5359.7	5356.75	5359.7	245.0
2015-08-12 20:00:00	NQ	Futures	5360.0	5373.61	5358.82	5370.35	1588.0
2015-08-12 21:00:00	NQ	Futures	5370.35	5370.35	5343.14	5364.44	5448.0
2015-08-12 22:00:00	NQ	Futures	5363.85	5375.68	5358.82	5369.47	2790.0
2015-08-12 23:00:00	NQ	Futures	5369.47	5380.41	5367.39	5377.75	1426.0
2015-08-12 00:00:00	YM	Futures	18164.8	18172.2	18159.5	18168.0	1271.0
2015-08-12 01:00:00	YM	Futures	18170.1	18198.5	18169.0	18177.5	2040.0

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

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