PREVIEW / futures_1hour / 2015-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-15.parquet
  size:    51 KB
  rows:    1,538

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-09-15 00:00:00	ES	Futures	2084.15	2085.22	2082.01	2082.28	2135.0
2015-09-15 01:00:00	ES	Futures	2082.01	2084.15	2080.41	2080.94	2978.0
2015-09-15 02:00:00	ES	Futures	2080.94	2081.21	2076.13	2078.54	9423.0
2015-09-15 03:00:00	ES	Futures	2078.27	2084.69	2077.73	2078.27	21433.0
2015-09-15 04:00:00	ES	Futures	2078.27	2079.34	2073.18	2075.59	20615.0
2015-09-15 05:00:00	ES	Futures	2075.59	2076.39	2071.31	2075.59	19109.0
2015-09-15 06:00:00	ES	Futures	2075.32	2083.35	2073.72	2082.01	18145.0
2015-09-15 07:00:00	ES	Futures	2082.01	2083.89	2079.87	2080.68	13249.0
2015-09-15 08:00:00	ES	Futures	2080.68	2086.03	2079.07	2084.69	33894.0
2015-09-15 09:00:00	ES	Futures	2084.96	2089.24	2080.14	2084.42	153516.0
2015-09-15 10:00:00	ES	Futures	2084.42	2099.14	2082.82	2097.27	223935.0
2015-09-15 11:00:00	ES	Futures	2097.0	2098.07	2093.52	2096.46	104561.0
2015-09-15 12:00:00	ES	Futures	2096.2	2099.94	2095.13	2097.53	88101.0
2015-09-15 13:00:00	ES	Futures	2097.8	2106.9	2096.46	2103.69	122718.0
2015-09-15 14:00:00	ES	Futures	2103.96	2110.11	2102.88	2109.31	124162.0
2015-09-15 15:00:00	ES	Futures	2109.31	2111.71	2105.56	2106.36	201415.0
2015-09-15 16:00:00	ES	Futures	2106.36	2110.11	2105.83	2109.57	73721.0
2015-09-15 17:00:00	ES	Futures	2109.57	2110.11	2108.77	2109.57	2328.0
2015-09-15 18:00:00	ES	Futures	2108.77	2109.57	2108.24	2108.77	2236.0
2015-09-15 19:00:00	ES	Futures	2109.04	2109.31	2107.97	2108.24	2373.0
2015-09-15 20:00:00	ES	Futures	2107.97	2108.24	2105.83	2107.7	7534.0
2015-09-15 21:00:00	ES	Futures	2107.97	2108.77	2105.29	2106.63	6197.0
2015-09-15 22:00:00	ES	Futures	2106.36	2107.17	2102.08	2102.62	7598.0
2015-09-15 23:00:00	ES	Futures	2102.35	2103.15	2100.74	2102.35	5179.0
2015-09-15 00:00:00	NQ	Futures	5107.35	5110.32	5102.31	5102.31	434.0
2015-09-15 01:00:00	NQ	Futures	5102.02	5109.13	5098.16	5098.46	714.0
2015-09-15 02:00:00	NQ	Futures	5099.05	5099.94	5086.6	5092.53	1159.0
2015-09-15 03:00:00	NQ	Futures	5092.23	5110.32	5091.05	5094.9	2883.0
2015-09-15 04:00:00	NQ	Futures	5094.61	5096.98	5080.08	5087.19	2666.0
2015-09-15 05:00:00	NQ	Futures	5086.01	5088.97	5075.93	5086.6	2426.0
2015-09-15 06:00:00	NQ	Futures	5086.3	5105.87	5082.15	5101.72	2754.0
2015-09-15 07:00:00	NQ	Futures	5102.31	5104.98	5096.09	5098.46	2211.0
2015-09-15 08:00:00	NQ	Futures	5098.46	5111.8	5094.01	5109.43	5088.0
2015-09-15 09:00:00	NQ	Futures	5109.73	5118.92	5090.75	5105.58	25836.0
2015-09-15 10:00:00	NQ	Futures	5105.58	5150.05	5105.58	5143.82	37279.0
2015-09-15 11:00:00	NQ	Futures	5143.82	5147.38	5133.45	5139.38	18543.0
2015-09-15 12:00:00	NQ	Futures	5139.38	5148.57	5136.71	5141.75	13922.0
2015-09-15 13:00:00	NQ	Futures	5141.75	5163.98	5139.97	5155.39	20872.0
2015-09-15 14:00:00	NQ	Futures	5155.68	5171.99	5153.01	5169.62	19062.0
2015-09-15 15:00:00	NQ	Futures	5170.21	5175.55	5157.16	5157.76	29561.0
2015-09-15 16:00:00	NQ	Futures	5157.76	5165.76	5156.87	5163.98	6860.0
2015-09-15 17:00:00	NQ	Futures	5163.39	5164.28	5161.32	5162.8	213.0
2015-09-15 18:00:00	NQ	Futures	5161.02	5163.09	5158.94	5162.21	292.0
2015-09-15 19:00:00	NQ	Futures	5162.21	5162.8	5160.13	5160.72	344.0
2015-09-15 20:00:00	NQ	Futures	5159.83	5160.43	5152.42	5158.05	1464.0
2015-09-15 21:00:00	NQ	Futures	5158.35	5160.43	5151.24	5155.39	1358.0
2015-09-15 22:00:00	NQ	Futures	5155.39	5155.98	5143.53	5144.12	1124.0
2015-09-15 23:00:00	NQ	Futures	5144.42	5147.97	5141.15	5147.38	1334.0
2015-09-15 00:00:00	YM	Futures	17274.3	17278.5	17258.4	17258.4	452.0
2015-09-15 01:00:00	YM	Futures	17257.4	17277.5	17244.6	17245.7	675.0

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

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