PREVIEW / futures_1hour / 2016-02-25

all futures 1-hour files

  file:    by_date/futures_1hour/2016/2016-02-25.parquet
  size:    53 KB
  rows:    1,604

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-25 00:00:00	ES	Futures	2076.85	2077.66	2074.16	2076.58	6107.0
2016-02-25 01:00:00	ES	Futures	2076.58	2076.58	2068.25	2069.33	11380.0
2016-02-25 02:00:00	ES	Futures	2069.33	2069.6	2064.76	2069.33	28368.0
2016-02-25 03:00:00	ES	Futures	2069.33	2073.09	2063.95	2066.1	52079.0
2016-02-25 04:00:00	ES	Futures	2065.84	2073.63	2065.84	2071.48	30622.0
2016-02-25 05:00:00	ES	Futures	2071.21	2076.05	2067.45	2075.24	28701.0
2016-02-25 06:00:00	ES	Futures	2074.97	2079.0	2072.28	2078.2	20634.0
2016-02-25 07:00:00	ES	Futures	2078.2	2081.69	2076.05	2076.05	35798.0
2016-02-25 08:00:00	ES	Futures	2076.05	2078.73	2073.63	2076.85	56600.0
2016-02-25 09:00:00	ES	Futures	2076.58	2081.69	2070.67	2072.02	250791.0
2016-02-25 10:00:00	ES	Futures	2071.75	2076.58	2065.84	2070.4	277317.0
2016-02-25 11:00:00	ES	Futures	2070.67	2077.39	2067.98	2076.58	189484.0
2016-02-25 12:00:00	ES	Futures	2076.58	2077.93	2071.48	2074.7	108583.0
2016-02-25 13:00:00	ES	Futures	2074.7	2085.99	2073.9	2085.45	163820.0
2016-02-25 14:00:00	ES	Futures	2085.45	2087.6	2082.23	2083.3	137609.0
2016-02-25 15:00:00	ES	Futures	2083.57	2095.39	2082.76	2095.39	259192.0
2016-02-25 16:00:00	ES	Futures	2095.12	2097.54	2094.05	2095.66	91327.0
2016-02-25 18:00:00	ES	Futures	2094.86	2097.27	2093.78	2096.74	8407.0
2016-02-25 19:00:00	ES	Futures	2096.47	2098.62	2095.66	2097.27	10835.0
2016-02-25 20:00:00	ES	Futures	2097.27	2097.54	2094.86	2095.12	7555.0
2016-02-25 21:00:00	ES	Futures	2095.12	2099.42	2094.32	2098.35	6634.0
2016-02-25 22:00:00	ES	Futures	2098.35	2099.96	2096.47	2096.47	7546.0
2016-02-25 23:00:00	ES	Futures	2096.74	2098.08	2095.66	2097.54	3056.0
2016-02-25 00:00:00	NQ	Futures	5007.45	5010.12	5000.03	5008.04	704.0
2016-02-25 01:00:00	NQ	Futures	5007.75	5008.34	4981.62	4983.7	2812.0
2016-02-25 02:00:00	NQ	Futures	4983.99	4988.15	4972.41	4988.15	4079.0
2016-02-25 03:00:00	NQ	Futures	4987.85	4997.65	4973.3	4977.16	6298.0
2016-02-25 04:00:00	NQ	Futures	4977.16	4995.57	4976.87	4988.74	4101.0
2016-02-25 05:00:00	NQ	Futures	4989.04	5001.81	4977.76	5000.03	3099.0
2016-02-25 06:00:00	NQ	Futures	4999.43	5008.93	4990.53	5006.26	2448.0
2016-02-25 07:00:00	NQ	Futures	5006.26	5014.58	5000.62	5001.51	3797.0
2016-02-25 08:00:00	NQ	Futures	5001.21	5005.67	4993.49	5000.92	8331.0
2016-02-25 09:00:00	NQ	Futures	5001.21	5009.83	4962.91	4965.88	44627.0
2016-02-25 10:00:00	NQ	Futures	4965.58	4992.31	4953.11	4975.38	41111.0
2016-02-25 11:00:00	NQ	Futures	4975.38	4991.71	4968.26	4989.34	26136.0
2016-02-25 12:00:00	NQ	Futures	4989.34	4990.82	4969.74	4979.24	21871.0
2016-02-25 13:00:00	NQ	Futures	4979.24	5009.53	4977.16	5006.56	21132.0
2016-02-25 14:00:00	NQ	Futures	5006.56	5009.23	4991.12	4997.95	18743.0
2016-02-25 15:00:00	NQ	Futures	4997.65	5035.96	4996.76	5035.66	34858.0
2016-02-25 16:00:00	NQ	Futures	5035.66	5045.16	5034.17	5043.38	8043.0
2016-02-25 18:00:00	NQ	Futures	5039.52	5044.86	5036.85	5043.08	1003.0
2016-02-25 19:00:00	NQ	Futures	5043.08	5048.43	5040.11	5045.75	1467.0
2016-02-25 20:00:00	NQ	Futures	5046.05	5046.35	5040.11	5040.41	717.0
2016-02-25 21:00:00	NQ	Futures	5040.11	5051.1	5038.03	5049.91	1096.0
2016-02-25 22:00:00	NQ	Futures	5049.32	5050.21	5044.57	5045.75	1195.0
2016-02-25 23:00:00	NQ	Futures	5045.16	5049.02	5043.38	5047.54	459.0
2016-02-25 00:00:00	YM	Futures	17556.4	17558.6	17533.0	17553.2	1081.0
2016-02-25 01:00:00	YM	Futures	17551.1	17552.2	17484.1	17493.6	2041.0
2016-02-25 02:00:00	YM	Futures	17491.5	17499.0	17458.5	17497.9	3082.0
2016-02-25 03:00:00	YM	Futures	17496.8	17525.6	17453.2	17466.0	8341.0

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

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