PREVIEW / futures_1hour / 2016-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-07-04.parquet
  size:    40 KB
  rows:    1,151

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-04 00:00:00	ES	Futures	2276.61	2277.15	2276.07	2276.88	781.0
2016-07-04 01:00:00	ES	Futures	2276.61	2278.78	2275.8	2278.78	2379.0
2016-07-04 02:00:00	ES	Futures	2278.78	2283.12	2278.51	2281.22	12289.0
2016-07-04 03:00:00	ES	Futures	2281.49	2281.49	2277.42	2278.24	16733.0
2016-07-04 04:00:00	ES	Futures	2277.97	2279.59	2274.44	2275.53	15988.0
2016-07-04 05:00:00	ES	Futures	2275.53	2280.14	2275.25	2278.78	10295.0
2016-07-04 06:00:00	ES	Futures	2278.78	2280.41	2278.24	2278.78	5436.0
2016-07-04 07:00:00	ES	Futures	2279.05	2279.32	2276.61	2277.15	7032.0
2016-07-04 08:00:00	ES	Futures	2277.15	2277.42	2274.71	2276.88	8335.0
2016-07-04 09:00:00	ES	Futures	2277.15	2277.69	2275.25	2275.8	11658.0
2016-07-04 10:00:00	ES	Futures	2276.07	2279.32	2275.8	2277.15	11691.0
2016-07-04 11:00:00	ES	Futures	2277.42	2277.97	2272.81	2276.07	14726.0
2016-07-04 12:00:00	ES	Futures	2276.34	2278.51	2276.07	2277.97	5093.0
2016-07-04 18:00:00	ES	Futures	2277.42	2277.69	2275.25	2275.8	2160.0
2016-07-04 19:00:00	ES	Futures	2276.07	2276.61	2273.9	2274.44	2728.0
2016-07-04 20:00:00	ES	Futures	2274.71	2274.71	2270.92	2271.46	6166.0
2016-07-04 21:00:00	ES	Futures	2271.46	2272.54	2267.39	2268.2	9466.0
2016-07-04 22:00:00	ES	Futures	2267.93	2269.56	2267.93	2269.02	3971.0
2016-07-04 23:00:00	ES	Futures	2269.02	2270.37	2268.2	2270.37	2948.0
2016-07-04 00:00:00	NQ	Futures	5291.61	5291.91	5289.52	5291.01	153.0
2016-07-04 01:00:00	NQ	Futures	5290.42	5296.97	5288.33	5296.67	327.0
2016-07-04 02:00:00	NQ	Futures	5296.97	5307.11	5296.97	5304.13	1736.0
2016-07-04 03:00:00	NQ	Futures	5304.42	5304.42	5294.29	5295.78	1903.0
2016-07-04 04:00:00	NQ	Futures	5295.48	5299.65	5287.73	5290.12	1450.0
2016-07-04 05:00:00	NQ	Futures	5290.12	5299.06	5289.52	5295.18	864.0
2016-07-04 06:00:00	NQ	Futures	5295.78	5299.06	5293.1	5293.99	483.0
2016-07-04 07:00:00	NQ	Futures	5294.89	5295.48	5289.22	5290.42	741.0
2016-07-04 08:00:00	NQ	Futures	5290.42	5292.5	5288.03	5291.01	708.0
2016-07-04 09:00:00	NQ	Futures	5291.31	5291.61	5286.24	5286.24	2014.0
2016-07-04 10:00:00	NQ	Futures	5286.24	5294.89	5285.35	5290.12	2078.0
2016-07-04 11:00:00	NQ	Futures	5290.71	5291.31	5280.28	5285.94	2089.0
2016-07-04 12:00:00	NQ	Futures	5285.94	5293.69	5285.35	5293.69	988.0
2016-07-04 18:00:00	NQ	Futures	5291.91	5291.91	5287.14	5289.82	266.0
2016-07-04 19:00:00	NQ	Futures	5289.52	5291.61	5286.84	5287.73	375.0
2016-07-04 20:00:00	NQ	Futures	5287.43	5287.73	5278.2	5278.79	526.0
2016-07-04 21:00:00	NQ	Futures	5278.79	5281.18	5268.06	5270.45	1434.0
2016-07-04 22:00:00	NQ	Futures	5270.74	5275.21	5270.45	5274.32	492.0
2016-07-04 23:00:00	NQ	Futures	5273.72	5278.79	5271.34	5278.79	441.0
2016-07-04 00:00:00	YM	Futures	19241.5	19244.7	19237.2	19243.6	202.0
2016-07-04 01:00:00	YM	Futures	19242.5	19255.5	19236.1	19255.5	432.0
2016-07-04 02:00:00	YM	Futures	19256.5	19289.9	19256.5	19275.9	1793.0
2016-07-04 03:00:00	YM	Futures	19277.0	19279.1	19249.0	19255.5	2064.0
2016-07-04 04:00:00	YM	Futures	19254.4	19264.1	19228.6	19236.1	1792.0
2016-07-04 05:00:00	YM	Futures	19235.0	19266.2	19233.9	19257.6	1061.0
2016-07-04 06:00:00	YM	Futures	19257.6	19269.5	19254.4	19258.7	638.0
2016-07-04 07:00:00	YM	Futures	19258.7	19259.8	19238.2	19242.5	825.0
2016-07-04 08:00:00	YM	Futures	19242.5	19245.8	19228.6	19242.5	857.0
2016-07-04 09:00:00	YM	Futures	19243.6	19253.3	19232.9	19235.0	1872.0
2016-07-04 10:00:00	YM	Futures	19236.1	19256.5	19230.7	19243.6	1866.0
2016-07-04 11:00:00	YM	Futures	19244.7	19245.8	19212.4	19232.9	2346.0

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

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