PREVIEW / futures_1hour / 2015-09-04

all futures 1-hour files

  file:    by_date/futures_1hour/2015/2015-09-04.parquet
  size:    44 KB
  rows:    1,277

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-04 00:00:00	ES	Futures	2058.9	2059.7	2054.64	2057.03	12507.0
2015-09-04 01:00:00	ES	Futures	2057.3	2059.43	2054.9	2057.57	12054.0
2015-09-04 02:00:00	ES	Futures	2057.83	2067.95	2057.03	2065.55	19990.0
2015-09-04 03:00:00	ES	Futures	2065.82	2066.35	2056.24	2061.03	30711.0
2015-09-04 04:00:00	ES	Futures	2061.03	2061.29	2050.91	2054.11	35598.0
2015-09-04 05:00:00	ES	Futures	2054.37	2058.37	2051.98	2052.77	17780.0
2015-09-04 06:00:00	ES	Futures	2052.77	2056.24	2046.92	2051.44	40297.0
2015-09-04 07:00:00	ES	Futures	2051.44	2054.37	2050.11	2052.51	24246.0
2015-09-04 08:00:00	ES	Futures	2052.51	2061.83	2034.67	2041.86	182561.0
2015-09-04 09:00:00	ES	Futures	2041.86	2055.7	2034.94	2045.85	343771.0
2015-09-04 10:00:00	ES	Futures	2045.59	2056.24	2042.92	2047.45	248294.0
2015-09-04 11:00:00	ES	Futures	2047.45	2050.64	2043.19	2046.12	187358.0
2015-09-04 12:00:00	ES	Futures	2046.12	2046.92	2038.66	2039.73	141030.0
2015-09-04 13:00:00	ES	Futures	2039.73	2041.06	2034.4	2037.6	149190.0
2015-09-04 14:00:00	ES	Futures	2037.6	2041.06	2031.74	2040.79	157159.0
2015-09-04 15:00:00	ES	Futures	2040.53	2054.9	2037.86	2042.39	345951.0
2015-09-04 16:00:00	ES	Futures	2042.39	2047.45	2041.59	2045.05	93188.0
2015-09-04 17:00:00	ES	Futures	2045.05	2045.32	2042.39	2042.66	1997.0
2015-09-04 00:00:00	NQ	Futures	4967.78	4970.74	4956.25	4962.46	2060.0
2015-09-04 01:00:00	NQ	Futures	4963.35	4970.45	4956.25	4962.16	2031.0
2015-09-04 02:00:00	NQ	Futures	4961.57	4985.83	4959.21	4982.28	2977.0
2015-09-04 03:00:00	NQ	Futures	4982.28	4984.05	4958.32	4973.11	4867.0
2015-09-04 04:00:00	NQ	Futures	4972.81	4973.4	4947.37	4955.95	5326.0
2015-09-04 05:00:00	NQ	Futures	4954.47	4969.56	4952.7	4955.06	2720.0
2015-09-04 06:00:00	NQ	Futures	4954.77	4963.64	4941.46	4952.99	5292.0
2015-09-04 07:00:00	NQ	Futures	4952.7	4959.21	4948.85	4954.77	2858.0
2015-09-04 08:00:00	NQ	Futures	4954.77	4978.73	4916.32	4934.65	25803.0
2015-09-04 09:00:00	NQ	Futures	4934.65	4973.4	4916.02	4948.26	65036.0
2015-09-04 10:00:00	NQ	Futures	4948.26	4980.5	4939.68	4955.66	48949.0
2015-09-04 11:00:00	NQ	Futures	4955.95	4966.6	4944.12	4958.02	31771.0
2015-09-04 12:00:00	NQ	Futures	4958.02	4960.39	4933.77	4937.02	22639.0
2015-09-04 13:00:00	NQ	Futures	4937.02	4944.42	4926.67	4932.88	23894.0
2015-09-04 14:00:00	NQ	Futures	4932.58	4945.3	4919.27	4944.42	22709.0
2015-09-04 15:00:00	NQ	Futures	4944.42	4971.04	4934.06	4946.49	49832.0
2015-09-04 16:00:00	NQ	Futures	4946.78	4963.64	4945.01	4956.25	10583.0
2015-09-04 17:00:00	NQ	Futures	4956.25	4956.84	4951.22	4951.22	124.0
2015-09-04 00:00:00	YM	Futures	17105.0	17108.2	17072.4	17092.4	2060.0
2015-09-04 01:00:00	YM	Futures	17093.4	17110.3	17075.5	17091.3	1613.0
2015-09-04 02:00:00	YM	Futures	17091.3	17165.1	17084.0	17152.4	2395.0
2015-09-04 03:00:00	YM	Futures	17151.4	17158.8	17074.5	17113.5	4518.0
2015-09-04 04:00:00	YM	Futures	17112.4	17114.5	17032.3	17055.5	4387.0
2015-09-04 05:00:00	YM	Futures	17055.5	17088.2	17038.7	17045.0	2121.0
2015-09-04 06:00:00	YM	Futures	17043.9	17074.5	17006.0	17035.5	4210.0
2015-09-04 07:00:00	YM	Futures	17036.6	17058.7	17021.8	17037.6	2073.0
2015-09-04 08:00:00	YM	Futures	17040.8	17111.4	16910.1	16955.4	17979.0
2015-09-04 09:00:00	YM	Futures	16955.4	17047.1	16905.9	16964.9	37353.0
2015-09-04 10:00:00	YM	Futures	16963.9	17035.5	16941.7	16976.5	27507.0
2015-09-04 11:00:00	YM	Futures	16977.6	17000.7	16942.8	16963.9	20671.0
2015-09-04 12:00:00	YM	Futures	16963.9	16973.3	16905.9	16917.5	16175.0
2015-09-04 13:00:00	YM	Futures	16919.6	16928.1	16876.4	16902.8	16378.0

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

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