PREVIEW / futures_1hour / 2016-02-02

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-02.parquet
  size:    55 KB
  rows:    1,619

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-02-02 00:00:00	ES	Futures	2063.15	2064.76	2061.27	2063.95	6579.0
2016-02-02 01:00:00	ES	Futures	2064.22	2069.6	2062.88	2068.52	7336.0
2016-02-02 02:00:00	ES	Futures	2068.52	2069.87	2066.1	2067.98	13982.0
2016-02-02 03:00:00	ES	Futures	2067.72	2068.79	2058.31	2058.58	34999.0
2016-02-02 04:00:00	ES	Futures	2058.58	2061.8	2052.13	2057.51	37370.0
2016-02-02 05:00:00	ES	Futures	2057.24	2061.0	2054.01	2059.12	31785.0
2016-02-02 06:00:00	ES	Futures	2059.39	2063.42	2058.04	2059.39	21860.0
2016-02-02 07:00:00	ES	Futures	2059.39	2063.69	2059.12	2063.15	31404.0
2016-02-02 08:00:00	ES	Futures	2063.42	2064.22	2054.01	2055.09	69973.0
2016-02-02 09:00:00	ES	Futures	2054.82	2057.51	2044.88	2048.64	292510.0
2016-02-02 10:00:00	ES	Futures	2048.64	2052.67	2043.53	2046.49	338783.0
2016-02-02 11:00:00	ES	Futures	2046.49	2054.28	2044.88	2046.22	202691.0
2016-02-02 12:00:00	ES	Futures	2046.22	2047.03	2038.7	2044.34	175238.0
2016-02-02 13:00:00	ES	Futures	2044.34	2045.41	2036.01	2036.55	149350.0
2016-02-02 14:00:00	ES	Futures	2036.55	2042.46	2033.86	2035.2	204323.0
2016-02-02 15:00:00	ES	Futures	2035.47	2041.38	2030.37	2037.08	331266.0
2016-02-02 16:00:00	ES	Futures	2037.08	2041.38	2036.55	2038.7	91032.0
2016-02-02 18:00:00	ES	Futures	2036.81	2038.43	2034.66	2035.74	9225.0
2016-02-02 19:00:00	ES	Futures	2035.74	2037.89	2033.05	2035.2	15826.0
2016-02-02 20:00:00	ES	Futures	2035.47	2035.47	2026.87	2028.48	27692.0
2016-02-02 21:00:00	ES	Futures	2028.22	2030.9	2026.6	2029.56	12527.0
2016-02-02 22:00:00	ES	Futures	2029.56	2036.81	2028.22	2035.74	16368.0
2016-02-02 23:00:00	ES	Futures	2035.74	2037.62	2032.25	2033.05	8738.0
2016-02-02 00:00:00	NQ	Futures	5064.76	5068.62	5060.01	5065.35	1055.0
2016-02-02 01:00:00	NQ	Futures	5065.65	5078.42	5061.49	5075.74	1066.0
2016-02-02 02:00:00	NQ	Futures	5075.45	5079.01	5068.91	5075.74	2068.0
2016-02-02 03:00:00	NQ	Futures	5075.45	5076.93	5045.75	5046.05	6146.0
2016-02-02 04:00:00	NQ	Futures	5046.94	5055.26	5029.13	5041.89	5368.0
2016-02-02 05:00:00	NQ	Futures	5042.19	5054.66	5035.36	5049.32	4915.0
2016-02-02 06:00:00	NQ	Futures	5049.32	5065.65	5046.65	5056.44	4123.0
2016-02-02 07:00:00	NQ	Futures	5056.44	5066.84	5055.26	5066.84	5085.0
2016-02-02 08:00:00	NQ	Futures	5067.13	5069.21	5045.75	5047.54	9445.0
2016-02-02 09:00:00	NQ	Futures	5047.24	5059.12	5019.62	5031.8	46316.0
2016-02-02 10:00:00	NQ	Futures	5032.1	5047.54	5024.67	5030.02	43971.0
2016-02-02 11:00:00	NQ	Futures	5030.31	5044.86	5018.44	5019.62	33146.0
2016-02-02 12:00:00	NQ	Futures	5019.33	5021.7	4996.76	5013.39	31509.0
2016-02-02 13:00:00	NQ	Futures	5013.39	5013.98	4978.65	4979.84	25410.0
2016-02-02 14:00:00	NQ	Futures	4979.84	4987.26	4962.32	4962.32	28592.0
2016-02-02 15:00:00	NQ	Futures	4962.32	4984.59	4953.71	4970.04	43937.0
2016-02-02 16:00:00	NQ	Futures	4969.74	4983.7	4969.15	4974.19	9685.0
2016-02-02 18:00:00	NQ	Futures	4971.82	4977.46	4966.47	4970.93	1369.0
2016-02-02 19:00:00	NQ	Futures	4971.22	4975.68	4960.54	4965.88	2970.0
2016-02-02 20:00:00	NQ	Futures	4965.88	4965.88	4938.27	4942.13	5044.0
2016-02-02 21:00:00	NQ	Futures	4941.83	4950.14	4937.67	4944.5	2088.0
2016-02-02 22:00:00	NQ	Futures	4945.39	4963.8	4941.23	4961.72	3161.0
2016-02-02 23:00:00	NQ	Futures	4961.13	4967.07	4952.81	4954.3	1551.0
2016-02-02 00:00:00	YM	Futures	17297.8	17311.6	17281.8	17303.1	1152.0
2016-02-02 01:00:00	YM	Futures	17306.3	17345.7	17294.6	17343.5	1726.0
2016-02-02 02:00:00	YM	Futures	17342.5	17353.1	17322.3	17334.0	2331.0
2016-02-02 03:00:00	YM	Futures	17332.9	17339.3	17259.5	17260.5	5661.0

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

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