PREVIEW / futures_1hour / 2015-09-02

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-02.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-02 00:00:00	ES	Futures	2062.36	2063.96	2058.63	2062.89	7736.0
2015-09-02 01:00:00	ES	Futures	2062.89	2064.76	2055.44	2057.3	12240.0
2015-09-02 02:00:00	ES	Futures	2057.3	2065.02	2054.11	2054.37	23298.0
2015-09-02 03:00:00	ES	Futures	2054.37	2062.36	2054.11	2058.37	34068.0
2015-09-02 04:00:00	ES	Futures	2058.37	2059.16	2044.25	2048.78	40461.0
2015-09-02 05:00:00	ES	Futures	2048.78	2054.11	2045.85	2053.84	21473.0
2015-09-02 06:00:00	ES	Futures	2053.84	2059.16	2046.92	2049.31	33695.0
2015-09-02 07:00:00	ES	Futures	2049.58	2055.97	2047.98	2055.17	23697.0
2015-09-02 08:00:00	ES	Futures	2055.17	2062.09	2049.05	2061.29	56629.0
2015-09-02 09:00:00	ES	Futures	2061.56	2067.95	2052.24	2053.57	311412.0
2015-09-02 10:00:00	ES	Futures	2053.57	2059.43	2040.79	2046.92	341876.0
2015-09-02 11:00:00	ES	Futures	2047.18	2054.64	2041.59	2045.05	224001.0
2015-09-02 12:00:00	ES	Futures	2045.32	2058.63	2041.59	2057.3	165486.0
2015-09-02 13:00:00	ES	Futures	2057.3	2061.56	2053.84	2056.24	132797.0
2015-09-02 14:00:00	ES	Futures	2056.5	2063.16	2051.18	2058.63	204092.0
2015-09-02 15:00:00	ES	Futures	2058.37	2073.28	2050.91	2073.28	310131.0
2015-09-02 16:00:00	ES	Futures	2073.28	2075.67	2070.08	2074.61	116053.0
2015-09-02 17:00:00	ES	Futures	2074.34	2074.87	2074.07	2074.61	2418.0
2015-09-02 18:00:00	ES	Futures	2074.07	2084.72	2073.81	2080.73	13554.0
2015-09-02 19:00:00	ES	Futures	2080.73	2081.0	2076.74	2079.4	7079.0
2015-09-02 20:00:00	ES	Futures	2079.13	2079.93	2073.28	2075.41	8830.0
2015-09-02 21:00:00	ES	Futures	2075.41	2075.41	2070.61	2073.01	9121.0
2015-09-02 22:00:00	ES	Futures	2072.74	2075.94	2071.94	2074.87	5183.0
2015-09-02 23:00:00	ES	Futures	2074.87	2076.2	2073.28	2073.81	3377.0
2015-09-02 00:00:00	NQ	Futures	4977.54	4979.91	4966.3	4979.02	2018.0
2015-09-02 01:00:00	NQ	Futures	4979.32	4984.64	4954.18	4959.8	2895.0
2015-09-02 02:00:00	NQ	Futures	4960.98	4984.35	4955.36	4955.36	2315.0
2015-09-02 03:00:00	NQ	Futures	4956.54	4979.32	4955.95	4965.12	4905.0
2015-09-02 04:00:00	NQ	Futures	4965.42	4966.9	4931.7	4945.6	5786.0
2015-09-02 05:00:00	NQ	Futures	4945.3	4954.18	4934.95	4952.7	2416.0
2015-09-02 06:00:00	NQ	Futures	4953.29	4968.37	4936.43	4941.75	3987.0
2015-09-02 07:00:00	NQ	Futures	4940.57	4959.5	4939.09	4957.43	3313.0
2015-09-02 08:00:00	NQ	Futures	4957.13	4976.95	4944.71	4973.99	7709.0
2015-09-02 09:00:00	NQ	Futures	4974.59	4984.35	4946.19	4954.18	47557.0
2015-09-02 10:00:00	NQ	Futures	4954.18	4976.95	4924.6	4947.37	51629.0
2015-09-02 11:00:00	NQ	Futures	4947.37	4968.08	4938.2	4947.67	38398.0
2015-09-02 12:00:00	NQ	Futures	4947.97	4979.91	4933.47	4976.66	23954.0
2015-09-02 13:00:00	NQ	Futures	4976.36	4991.45	4967.49	4976.95	21119.0
2015-09-02 14:00:00	NQ	Futures	4977.54	5000.32	4960.68	4984.05	33302.0
2015-09-02 15:00:00	NQ	Futures	4984.35	5031.97	4966.01	5031.38	47734.0
2015-09-02 16:00:00	NQ	Futures	5031.67	5044.69	5026.65	5042.62	15677.0
2015-09-02 17:00:00	NQ	Futures	5042.91	5043.8	5039.66	5042.62	335.0
2015-09-02 18:00:00	NQ	Futures	5040.55	5071.61	5039.66	5058.89	2921.0
2015-09-02 19:00:00	NQ	Futures	5058.89	5058.89	5050.6	5056.22	763.0
2015-09-02 20:00:00	NQ	Futures	5055.93	5058.59	5041.73	5046.76	1605.0
2015-09-02 21:00:00	NQ	Futures	5046.17	5046.17	5033.15	5039.96	1601.0
2015-09-02 22:00:00	NQ	Futures	5039.36	5047.65	5036.7	5042.91	1165.0
2015-09-02 23:00:00	NQ	Futures	5042.91	5047.35	5037.59	5038.77	907.0
2015-09-02 00:00:00	YM	Futures	17116.6	17128.2	17095.6	17122.9	3440.0
2015-09-02 01:00:00	YM	Futures	17126.1	17139.8	17065.0	17081.9	3306.0

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

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