PREVIEW / futures_1hour / 2016-02-17

all futures 1-hour files

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

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-17 00:00:00	ES	Futures	2025.53	2028.48	2024.72	2027.95	7875.0
2016-02-17 01:00:00	ES	Futures	2027.95	2028.48	2024.45	2025.53	6356.0
2016-02-17 02:00:00	ES	Futures	2025.53	2026.07	2022.3	2025.8	16846.0
2016-02-17 03:00:00	ES	Futures	2025.8	2033.59	2024.19	2031.71	35437.0
2016-02-17 04:00:00	ES	Futures	2031.71	2040.31	2030.9	2040.31	38108.0
2016-02-17 05:00:00	ES	Futures	2040.31	2046.49	2039.23	2043.26	42262.0
2016-02-17 06:00:00	ES	Futures	2043.53	2045.68	2042.46	2044.07	20390.0
2016-02-17 07:00:00	ES	Futures	2044.07	2048.37	2042.73	2047.83	30957.0
2016-02-17 08:00:00	ES	Futures	2047.56	2048.37	2043.8	2046.49	43111.0
2016-02-17 09:00:00	ES	Futures	2046.49	2054.82	2045.95	2051.59	308644.0
2016-02-17 10:00:00	ES	Futures	2051.59	2064.49	2051.59	2063.15	299766.0
2016-02-17 11:00:00	ES	Futures	2063.15	2064.76	2060.19	2062.61	198078.0
2016-02-17 12:00:00	ES	Futures	2062.61	2068.52	2061.8	2066.64	140561.0
2016-02-17 13:00:00	ES	Futures	2066.64	2068.25	2062.88	2063.95	94591.0
2016-02-17 14:00:00	ES	Futures	2063.69	2071.48	2062.34	2065.03	173843.0
2016-02-17 15:00:00	ES	Futures	2065.3	2068.52	2062.88	2066.91	222346.0
2016-02-17 16:00:00	ES	Futures	2066.91	2072.28	2065.03	2072.02	85212.0
2016-02-17 18:00:00	ES	Futures	2070.94	2071.75	2069.6	2071.48	6852.0
2016-02-17 19:00:00	ES	Futures	2071.48	2072.82	2069.33	2069.33	10059.0
2016-02-17 20:00:00	ES	Futures	2069.6	2072.28	2068.52	2069.6	9172.0
2016-02-17 21:00:00	ES	Futures	2069.6	2070.94	2068.52	2069.6	4083.0
2016-02-17 22:00:00	ES	Futures	2069.6	2070.94	2068.79	2070.4	4456.0
2016-02-17 23:00:00	ES	Futures	2070.4	2071.48	2069.87	2071.48	2960.0
2016-02-17 00:00:00	NQ	Futures	4842.95	4849.48	4839.98	4848.29	1340.0
2016-02-17 01:00:00	NQ	Futures	4847.7	4848.89	4837.9	4839.98	1767.0
2016-02-17 02:00:00	NQ	Futures	4840.28	4842.06	4831.96	4839.39	2821.0
2016-02-17 03:00:00	NQ	Futures	4839.39	4859.58	4835.53	4854.83	4824.0
2016-02-17 04:00:00	NQ	Futures	4855.12	4883.63	4853.34	4883.04	6163.0
2016-02-17 05:00:00	NQ	Futures	4883.33	4903.52	4880.96	4894.32	6162.0
2016-02-17 06:00:00	NQ	Futures	4894.62	4901.15	4892.24	4896.99	2632.0
2016-02-17 07:00:00	NQ	Futures	4896.99	4919.26	4893.73	4917.78	5509.0
2016-02-17 08:00:00	NQ	Futures	4917.78	4918.67	4904.12	4910.65	6445.0
2016-02-17 09:00:00	NQ	Futures	4910.35	4922.53	4896.99	4919.26	56964.0
2016-02-17 10:00:00	NQ	Futures	4919.26	4958.46	4918.07	4955.78	50223.0
2016-02-17 11:00:00	NQ	Futures	4955.78	4961.43	4946.28	4955.49	26908.0
2016-02-17 12:00:00	NQ	Futures	4955.49	4983.99	4953.41	4975.68	28130.0
2016-02-17 13:00:00	NQ	Futures	4975.38	4986.66	4969.15	4970.93	14212.0
2016-02-17 14:00:00	NQ	Futures	4971.52	4993.2	4967.07	4977.16	26394.0
2016-02-17 15:00:00	NQ	Futures	4977.46	4986.96	4968.55	4984.59	29694.0
2016-02-17 16:00:00	NQ	Futures	4984.59	5002.11	4976.57	5001.51	9724.0
2016-02-17 18:00:00	NQ	Futures	4998.25	4999.73	4993.49	4997.06	1077.0
2016-02-17 19:00:00	NQ	Futures	4997.65	5000.03	4992.6	4993.2	1192.0
2016-02-17 20:00:00	NQ	Futures	4993.49	5002.11	4989.63	4995.28	1138.0
2016-02-17 21:00:00	NQ	Futures	4994.68	4997.65	4990.53	4994.39	725.0
2016-02-17 22:00:00	NQ	Futures	4993.79	4998.54	4992.01	4997.65	659.0
2016-02-17 23:00:00	NQ	Futures	4997.06	5000.62	4995.87	5000.32	458.0
2016-02-17 00:00:00	YM	Futures	17133.8	17157.3	17128.5	17150.9	1474.0
2016-02-17 01:00:00	YM	Futures	17151.9	17154.1	17126.4	17138.1	1242.0
2016-02-17 02:00:00	YM	Futures	17140.2	17142.4	17111.5	17140.2	2135.0
2016-02-17 03:00:00	YM	Futures	17138.1	17196.6	17129.6	17184.9	6647.0

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

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