PREVIEW / futures_1hour / 2015-10-14

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-10-14.parquet
  size:    53 KB
  rows:    1,602

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-10-14 00:00:00	ES	Futures	2134.46	2135.26	2133.66	2133.92	1920.0
2015-10-14 01:00:00	ES	Futures	2134.19	2134.19	2131.52	2132.85	4345.0
2015-10-14 02:00:00	ES	Futures	2133.12	2135.8	2132.59	2133.92	8616.0
2015-10-14 03:00:00	ES	Futures	2133.92	2134.99	2129.11	2132.59	22456.0
2015-10-14 04:00:00	ES	Futures	2132.85	2136.87	2129.64	2131.52	19618.0
2015-10-14 05:00:00	ES	Futures	2131.25	2134.46	2130.45	2132.59	8869.0
2015-10-14 06:00:00	ES	Futures	2132.59	2134.73	2131.78	2133.12	10901.0
2015-10-14 07:00:00	ES	Futures	2133.39	2136.87	2132.32	2135.8	21051.0
2015-10-14 08:00:00	ES	Futures	2135.8	2139.01	2132.85	2133.39	76245.0
2015-10-14 09:00:00	ES	Futures	2133.39	2142.49	2132.05	2140.88	220969.0
2015-10-14 10:00:00	ES	Futures	2141.15	2141.68	2126.16	2128.57	326148.0
2015-10-14 11:00:00	ES	Futures	2128.3	2131.52	2124.83	2130.45	218754.0
2015-10-14 12:00:00	ES	Futures	2130.45	2139.01	2126.16	2136.06	164586.0
2015-10-14 13:00:00	ES	Futures	2136.06	2137.4	2131.25	2133.39	104967.0
2015-10-14 14:00:00	ES	Futures	2133.39	2136.06	2122.15	2124.29	204717.0
2015-10-14 15:00:00	ES	Futures	2124.02	2129.64	2121.88	2125.36	226695.0
2015-10-14 16:00:00	ES	Futures	2125.36	2126.7	2121.88	2124.83	74550.0
2015-10-14 18:00:00	ES	Futures	2125.36	2129.11	2124.56	2127.77	5473.0
2015-10-14 19:00:00	ES	Futures	2127.77	2128.04	2126.97	2127.5	2508.0
2015-10-14 20:00:00	ES	Futures	2127.5	2129.91	2126.7	2129.37	8799.0
2015-10-14 21:00:00	ES	Futures	2129.37	2134.46	2129.37	2131.78	14535.0
2015-10-14 22:00:00	ES	Futures	2131.78	2136.6	2131.78	2133.39	9865.0
2015-10-14 23:00:00	ES	Futures	2133.12	2137.13	2133.12	2137.13	6299.0
2015-10-14 00:00:00	NQ	Futures	5142.64	5145.01	5141.15	5142.04	434.0
2015-10-14 01:00:00	NQ	Futures	5141.75	5142.34	5133.74	5138.49	830.0
2015-10-14 02:00:00	NQ	Futures	5138.49	5143.23	5136.71	5139.08	1566.0
2015-10-14 03:00:00	NQ	Futures	5139.08	5141.15	5124.55	5135.22	4406.0
2015-10-14 04:00:00	NQ	Futures	5135.22	5148.57	5128.7	5133.15	3277.0
2015-10-14 05:00:00	NQ	Futures	5133.45	5142.34	5130.78	5138.78	2121.0
2015-10-14 06:00:00	NQ	Futures	5138.49	5143.82	5137.0	5140.56	1399.0
2015-10-14 07:00:00	NQ	Futures	5140.56	5148.57	5139.08	5146.79	2592.0
2015-10-14 08:00:00	NQ	Futures	5146.79	5159.54	5145.31	5145.6	10788.0
2015-10-14 09:00:00	NQ	Futures	5145.6	5176.73	5142.34	5171.1	35924.0
2015-10-14 10:00:00	NQ	Futures	5171.1	5172.29	5120.4	5131.67	55547.0
2015-10-14 11:00:00	NQ	Futures	5131.67	5143.82	5126.03	5142.04	30607.0
2015-10-14 12:00:00	NQ	Futures	5142.34	5177.03	5131.07	5169.91	29044.0
2015-10-14 13:00:00	NQ	Futures	5170.21	5174.36	5157.76	5164.28	19757.0
2015-10-14 14:00:00	NQ	Futures	5164.28	5171.99	5135.52	5140.86	32436.0
2015-10-14 15:00:00	NQ	Futures	5141.15	5155.98	5131.37	5143.23	36035.0
2015-10-14 16:00:00	NQ	Futures	5142.93	5146.79	5126.33	5136.41	10003.0
2015-10-14 18:00:00	NQ	Futures	5141.45	5150.35	5138.19	5145.9	928.0
2015-10-14 19:00:00	NQ	Futures	5145.6	5152.12	5145.31	5151.24	867.0
2015-10-14 20:00:00	NQ	Futures	5150.94	5157.76	5146.49	5156.28	1715.0
2015-10-14 21:00:00	NQ	Futures	5156.57	5167.54	5156.28	5161.32	2186.0
2015-10-14 22:00:00	NQ	Futures	5161.61	5171.4	5161.02	5163.98	1767.0
2015-10-14 23:00:00	NQ	Futures	5163.69	5170.51	5163.39	5169.91	1756.0
2015-10-14 00:00:00	YM	Futures	17986.1	17989.3	17977.6	17981.9	468.0
2015-10-14 01:00:00	YM	Futures	17982.9	17982.9	17959.6	17972.4	844.0
2015-10-14 02:00:00	YM	Futures	17971.3	17991.4	17967.1	17977.6	1317.0
2015-10-14 03:00:00	YM	Futures	17978.7	17985.1	17942.7	17967.1	3035.0

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

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